PostgreSQL Query Performance Insights

This session is presented on Percona Community Live Online June 21-23, 2022. Check out the full schedule here.

Watch This Talk Here

The talk will be live-streamed on several platforms. No registration is required. Feel free to ask your questions in chat. Follow the links now and subscribe to notifications not to miss anything!

Understanding query performance patterns are essentially the foundation for query performance tuning. It, in many ways, dictates how a database cluster evolves. And then there are obviously direct and indirect cost connotations as well.

With improved observability, using the right tools, you can get the best out of your existing setup and ensure that it is able to handle not only the average load profile but peak load as well. We’ll see how different tools like pg_stat_activity, pg_stat_statements, auto_explain, pgBadger, and pg_stat_monitor can deliver a complete picture to help measure, analyze and optimize your queries and database system.

PostgreSQL Query Performance Insights

Check out the full schedule of Percona Community Live Online June 21-23, 2022

Hamid Akhtar

Senior Software Engineer, Percona

See all talks by Hamid Akhtar »

Comments

✎ Edit this page on GitHub