Главная
Study mode:
on
1
PGConf NYC 2021 - Identifying Slow Queries and Fixing Them! by Stephen Frost
Description:
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it 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.

Identifying Slow Queries and Fixing Them in PostgreSQL

Confreaks
Add to list
0:00 / 0:00