odota/web

DataExplorer: this request timeouts

Closed this issue · 1 comments

Before it worked and returned data even for 8 hours. Now it cant return event for one second (3600 * 1 is one hour)

Request in data explorer

SELECT
    match_id,
    start_time,
    avg_rank_tier,
    radiant_win,
    duration,
    radiant_team,
    dire_team
FROM
    public_matches
WHERE
    TRUE
    AND avg_rank_tier >= 70
    AND start_time >= ((extract(epoch from now()) - 3600 * 1))
    AND lobby_type = 7
    AND (game_mode = 22 OR game_mode = 2)

How I can fix it or whats the problem with the server?

Try ordering and limiting the results, e.g.

order by start_time desc
limit 1