How can I see the backlog in our Queues for On-premises deployments
Example output:
| Queue | Description |
|---|---|
| aa | Analyze Application (A group of Jars) |
| ahb | Add Hit Batch - A queue for new coming events - hits |
| aj | Analyze Jar |
| brt | Some internal Backend processing unit - when it is high for a long time it is not good |
| eaa | Internal - hard to explain - shouldn’t be high |
| eahb | Internal - hard to explain - shouldn’t be high |
| oss | Service Stats - A queue for new coming statistics from the Collectors - eventually turn into a SQLI |
| sqli | Internal Backend task that insert the statistics into the stats DB |
For MySQL
use qsql;SELECT (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_AA) AS aa, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_AHB) AS ahb, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_AJ) AS aj, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_BRT) AS brt, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_EAA) AS eaa, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_EAHB) AS eahb, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_OSS) AS oss, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_SQLI) AS sqli, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_TSK_HITS) AS tsk_hits, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_TSK_SERVICE) AS tsk_service, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_TSK_TAILOR) AS tsk_tailor FROM dual
For H2
java -cp lib/h2.jar org.h2.tools.Shell -driver org.h2.Driver -url jdbc:h2:tcp://localhost:5002/qsql -sql "SELECT (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_AA) AS aa, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_AHB) AS ahb, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_AJ) AS aj, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_BRT) AS brt, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_EAA) AS eaa, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_EAHB) AS eahb, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_OSS) AS oss, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_SQLI) AS sqli, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_TSK_HITS) AS tsk_hits, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_TSK_SERVICE) AS tsk_service, (SELECT COUNT(*) FROM QUEUE_onprem_taskforce_TSK_TAILOR) AS tsk_tailor FROM dual;"