Skip to content

Instantly share code, notes, and snippets.

/gist:9b249c0c9529388bd19c

Created April 3, 2015 18:05
Show Gist options
  • Save anonymous/9b249c0c9529388bd19c to your computer and use it in GitHub Desktop.
Save anonymous/9b249c0c9529388bd19c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
GroupAggregate (cost=20016.16..20289.64 rows=252 width=41)
-> GroupAggregate (cost=20016.16..20223.62 rows=2515 width=59)
-> Sort (cost=20016.16..20028.73 rows=5029 width=59)
Sort Key: dispatch_slr_task_result.slr_id, dispatch_slr_task_result.start_time, dispatch_slr_task_result.key, dispatch_slr.min_checked, dispatch_slr.min_failure_pct
-> Nested Loop (cost=0.56..19706.97 rows=5029 width=59)
-> Seq Scan on dispatch_slr (cost=0.00..1.11 rows=11 width=8)
-> Index Scan using dispatch_slr_task_result_slr_id_start_time_idx on dispatch_slr_task_result (cost=0.56..1786.87 rows=457 width=55)
Index Cond: ((slr_id = dispatch_slr.id) AND (start_time > '2015-04-01 00:00:00+00'::timestamp with time zone))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment