Database Issues
For slow queries, start with EXPLAIN ANALYZE
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 filesentry_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.
Persistent URL
Resource purlPURL: https://gxy.io/GTN:F00195Still have questions?
Gitter Chat Support
Galaxy Help Forum