Using Azure Query Store to Understand PostgreSQL Performance

on YouTube ↗26m

" summary

Query Store for Azure Database for PostgreSQL records aggregated query stats, wait stats and multiple explain plans into one‑hour segments (default retention 7 days) so you get true before/after comparisons instead of guessing. It stores data in the azure_sys database, surfaces a query that ran 500000 executions in an hour, and offers knobs like max_plan_size, text length and capture mode ALL/TOP/NONE. Microsoft also layers Query Performance Insights and Intelligent Tuning on top for automated analysis.

AI-written summary · about

" chapters (6)

1. 0:00Intro
2. 0:49Query Tuning Process
3. 6:57Query Metrics
4. 8:13Query Store
5. 14:12Demo
6. 23:35More to Learn

" related talks

• 49mPerformance Features in SQL Server and Azure SQLJavier Villegas · SQL Server Virtual Conference 2021
• 22mA Beginners guide to Query StoreKevin Kline · SQLBits 2022
• 48mQuery Store: A RetrospectiveConor Cunningham · SQLBits 2023
• 22mA Beginners guide to Query StorePeter Kruis · SQLBits 2024
• 28mDear Azure Database for PostgreSQL, can you automate my index?Nacho Alonso Portillo · POSETTE: An Event for Postgres 2025
• 50mQuery Store Best PracticesErin Stellato · SQLBits 2019
• 51mPerformance Tuning Azure SQL DatabaseMonica Rathbun · SQLBits 2023
• 50mQuery Store Best PracticesErin Stellato · SQLBits 2022