Database Issues

For slow queries, start with EXPLAIN ANALYZE

• Example of the “jobs ready to run” query

However it can be useful to dig into the queries with the Postgres EXPLAIN Visualizer (PEV) to get a more visual and clear representation. (Try it with this demo data)

You can set some options in the Galaxy configuration or database that will help debugging this:

• database_engine_option_echo (but warning, extremely verbose)
• slow_query_log_threshold logs to Galaxy log file
• sentry_sloreq_threshold if using Sentry

Additionally check that your database is running VACUUM regularly enough and look at VACUUM ANALYZE

There are some gxadmin query pg-* commands which can help you monitor and track this information.

Lastly, check your database settings! It might not have enough resources allocated. Check PGTune for some suggestions of optimised parameters.

Still have questions?

Want to embed this snippet (FAQ) in your GTN Tutorial?

{% snippet  topics/admin/faqs/database-slow-query.md %}

Persistent URL