Identifying Slow Queries and Fixing Them in PostgreSQL

Explore PostgreSQL query optimization techniques in this 47-minute conference talk from PGConf NYC 2021. Dive into configuration options for logging and basic tuning parameters in postgresql.conf. Learn to monitor time-consuming queries using pg_stat_statements. Analyze EXPLAIN and EXPLAIN ANALYZE output for select queries, including the auto_explain module. Understand how EXPLAIN output relates to query execution. Discover methods to enhance query performance through index creation, query rewriting for improved execution plans, and parameter tuning for specific queries. Gain valuable insights to identify and resolve slow queries in PostgreSQL databases.