Skip to content

Instantly share code, notes, and snippets.

Created March 14, 2017 15:46
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/00ff1b7629599607f16efb2021e5c13c to your computer and use it in GitHub Desktop.
Save anonymous/00ff1b7629599607f16efb2021e5c13c to your computer and use it in GitHub Desktop.
Update on minion_jobs j (cost=0.42..20601590869.34 rows=293839 width=1215)
-> Index Scan using minion_jobs_state_priority_id_idx on minion_jobs j (cost=0.42..20601590869.34 rows=293839 width=1215)
Index Cond: (state = 'inactive'::minion_state)
Filter: ((parents <> '{}'::bigint[]) AND (cardinality(parents) <> (SubPlan 1)))
SubPlan 1
-> Aggregate (cost=63691.40..63691.41 rows=1 width=8)
-> Seq Scan on minion_jobs (cost=0.00..63686.82 rows=1830 width=0)
Filter: (j.parents @> ARRAY[id])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment