Skip to content

Instantly share code, notes, and snippets.

/gist:0941a6da15bcb4ef1abecfcbf70654b8 Secret

Created March 14, 2017 16:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/0941a6da15bcb4ef1abecfcbf70654b8 to your computer and use it in GitHub Desktop.
Save anonymous/0941a6da15bcb4ef1abecfcbf70654b8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Update on minion_jobs j (cost=0.42..19006580.36 rows=293839 width=1215) (actual time=3151.574..3151.574 rows=0 loops=1)
-> Index Scan using minion_jobs_state_priority_id_idx on minion_jobs j (cost=0.42..19006580.36 rows=293839 width=1215) (actual time=3151.572..3151.572 rows=0 loops=1)
Index Cond: (state = 'inactive'::minion_state)
Filter: ((parents <> '{}'::bigint[]) AND (cardinality(parents) <> (SubPlan 1)))
Rows Removed by Filter: 320245
SubPlan 1
-> Aggregate (cost=58.06..58.07 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=312758)
-> Index Only Scan using minion_jobs_pkey on minion_jobs (cost=0.42..58.04 rows=10 width=0) (actual time=0.003..0.005 rows=2 loops=312758)
Index Cond: (id = ANY (j.parents))
Heap Fetches: 613877
Planning time: 0.385 ms
Execution time: 3151.692 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment