CREATE TABLE tst_ratings (
    player varchar PRIMARY KEY,
    level integer,
    last_updated timestamp
);

SELECT *
FROM tst_ratings
ORDER BY level desc, last_updated asc
LIMIT 100;

SELECT count(*)
FROM tst_ratings
WHERE level > 164 or (level = 164 and last_updated < '2018-02-25 02:40:04.028757';

CREATE MATERIALIZED VIEW v_tst_ratings AS
SELECT player, level, last_updated, ROW_NUMBER() OVER(ORDER BY level desc, last_updated asc) AS rnk
FROM tst_ratings;

CREATE UNIQUE INDEX v_tst_ratings_idx ON v_tst_ratings(player);

SELECT player, rnk
FROM  v_tst_ratings
LIMIT 100;

SELECT rnk
FROM v_tst_ratings
WHERE player = 'some_id';