Skip to content

Instantly share code, notes, and snippets.

@matthewpoer
Created March 20, 2015 15:03
Show Gist options
  • Save matthewpoer/51187c8cb11bb4a2c851 to your computer and use it in GitHub Desktop.
Save matthewpoer/51187c8cb11bb4a2c851 to your computer and use it in GitHub Desktop.
Show the number of job_queue records in various status for each name/type of job
+----------+---------+--------------------------------------+
| count(*) | status | name |
+----------+---------+--------------------------------------+
| 12708 | done | tcx_job_account_set_teams |
| 84856 | queued | tcx_job_account_set_teams |
| 10 | running | tcx_job_account_set_teams |
| 12688 | queued | tcx_job_account_trigger_team_changes |
+----------+---------+--------------------------------------+
4 rows in set (0.74 sec)
select count(*), status, name from job_queue group by name, status;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment