Skip to content

Instantly share code, notes, and snippets.

@jberger

jberger/queues.sql

Last active April 23, 2016 16:19
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 jberger/350cde8b608466c142c39364c9306257 to your computer and use it in GitHub Desktop.
Save jberger/350cde8b608466c142c39364c9306257 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
queues.sql
select
queues.queue,
states.state,
(select count(*) from minion_jobs where queue = queues.queue and state::text = states.state) as c
from (select distinct queue from minion_jobs) as queues
cross join (values ('active'), ('failed'), ('finished'), ('inactive')) as states(state);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment