Last active
December 10, 2017 20:54
-
-
Save richardartoul/6b2baa75536df576f960ab3f553745e5 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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