Skip to content

Instantly share code, notes, and snippets.

/gist:9dae230bb9a9da0c831c9cb078233729 Secret

Created March 16, 2017 14:56
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/9dae230bb9a9da0c831c9cb078233729 to your computer and use it in GitHub Desktop.
Save anonymous/9dae230bb9a9da0c831c9cb078233729 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Delete on minion_jobs j (cost=0.00..13706492.78 rows=7 width=12)
-> Nested Loop Anti Join (cost=0.00..13706492.78 rows=7 width=12)
Join Filter: (j.id = ANY (minion_jobs.parents))
-> Seq Scan on minion_jobs j (cost=0.00..97048.52 rows=6678 width=14)
Filter: ((state = 'finished'::minion_state) AND (finished <= (now() - '48:00:00'::interval)))
-> Materialize (cost=0.00..94574.49 rows=86807 width=37)
-> Seq Scan on minion_jobs (cost=0.00..93461.45 rows=86807 width=37)
Filter: (state <> 'finished'::minion_state)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment