The good folks over at Galaxy Europe have developed a cool bit of code to help out Galaxy systems administrators. It's called gxadmin, it's available on GitHub
and includes many small SQL queries that administrators run every day.
As a Galaxy administrator, you can use it to do things like viewing the queue:
$ gxadmin query queue
tool_id | state | count
-------------------------------------------------------------------+---------+-------
toolshed.g2.bx.psu.edu/repos/iuc/unicycler/unicycler/0.4.6.0 | queued | 9
toolshed.g2.bx.psu.edu/repos/iuc/dexseq/dexseq_count/1.24.0.0 | running | 7
toolshed.g2.bx.psu.edu/repos/nml/spades/spades/1.2 | queued | 6
ebi_sra_main | running | 6
toolshed.g2.bx.psu.edu/repos/iuc/trinity/trinity/2.8.3 | queued | 5
amongst many more queries. We hope that other administrators will find this utility useful and can contribute queries that they run often.