 Galaxy Monitoring with GX Admin What is GX Admin? What can it do? How to write a query? Learn GX Admin basics. See some queries and learn how they help debug production issues. Admins often need to run database queries. Debugging the live application in production is difficult, but running queries is easy. Additionally running SQL queries is commonly used for debugging and reporting and analytics. The community collects queries we commonly use in a program called GX Admin. We often get requests like how many jobs were run in a time period, and did they finish successfully, so we write some SQL like this. As an admin, you'll want to understand SQL. Here is the output of such a query. SQL is very powerful for extracting data and graphs for reporting. We often rerun the same queries. GX Admin makes it easier by storing the useful queries. Everyone is welcome to contribute to it. However, some of these queries we run over and over, and those we include in GX Admin, this way every admin has access to all of the interesting queries we run, and we don't get repetitive strain injury typing SQL. Example output from the previous query. Another extremely common query is, what is the status of this job? There is a GX Admin command which aggregates information about jobs. This can help you debug job failure to run issues. Another common query, who has recently joined our server, this is an easy command to write, but it is also included in GX Admin. Example output of the previous query, with SQL you can choose just the columns or data that is relevant to you. This may not be so easily available in the interface. However, to reuse this data in other applications, the post reformat is not convenient. There is special syntax you can use to output CSV. GX Admin includes query variants to do this as well. For monitoring, many Galaxy sites use influx db. GX Admin supports exporting influx compatible format. This makes it easy to add new data and graphs to your monitoring. GX Admin is a tool to run common database queries useful for Galaxy admins. New queries are welcome and easy to contribute. Thank you for watching.