Skip to content

Instantly share code, notes, and snippets.

@richardartoul
Last active December 10, 2017 20:54
Show Gist options
  • Save richardartoul/6b2baa75536df576f960ab3f553745e5 to your computer and use it in GitHub Desktop.
Save richardartoul/6b2baa75536df576f960ab3f553745e5 to your computer and use it in GitHub Desktop.
hyperdash_free=> explain analyze SELECT sdk_run_uuid FROM heartbeats WHERE last_seen_at < NOW() - INTERVAL '30 seconds' AND eligible_for_disconnect_scan = true AND run_completed = false LIMIT 10;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=0.43..2.64 rows=10 width=16) (actual time=191.810..191.810 rows=0 loops=1)
-> Index Scan using heartbeats_last_seen_at_idx on heartbeats (cost=0.43..15066.99 rows=68307 width=16) (actual time=191.809..191.809 rows=0 loops=1)
Index Cond: (last_seen_at < (now() - '00:00:30'::interval))
Planning time: 0.089 ms
Execution time: 191.837 ms
(5 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment