DataExplorer: this request timeouts
Closed this issue · 1 comments
TheGP commented
Before it worked and returned data even for 8 hours. Now it cant return event for one second (3600 * 1 is one hour)
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?
howardchung commented
Try ordering and limiting the results, e.g.
order by start_time desc
limit 1