stats.pl

$self->pg->db->query(
    "with queues as (select distinct queue from minion_jobs),
          states as (
            select unnest(array['active', 'failed', 'finished', 'inactive'])
            as state
          )
     select json_object_agg(queue, (
       select jsonb_object_agg(state || '_jobs', (
         select count(*) from minion_jobs where state::text = states.state and queue = queues.queue
       ))
       from states
     )) from queues"
  )->expand->array->[0];