PostgreSQL Query Performance Insights

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

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.

Watch Video Here

Link: https://youtu.be/km_JeUGHGXw

Transcript

Speakers

Hamid Akhtar

Senior Software Engineer, Percona

See all talks by Hamid Akhtar »

Did you like this post? Why not read more?

Percona Community Live June 21 - Day 1

You are invited to participate in the first day of the Percona Community Live stream! Learn about VictoriaMetrics, flexible Indexing with Postgres, PostgreSQL backups, database resiliency, and many other things on June 21st. Join us on June 22nd and June 23d for more amazing content!

Percona University Istanbul 2024

Percona University is an ongoing series of community-driven database meetups, bringing together open-source enthusiasts from around the world. On September 7th, we landed in Istanbul, the vibrant cultural and economic hub of Türkiye, for a day of learning, networking, and meaningful connections.

Percona University Limassol 2024

On April 20th, 2024, people who love working with databases came together in Cyprus for something special - the Percona University Limassol. Percona put on this event to help folks dive deep into the latest database tech.