Using Query Store in Azure PostgreSQL to Understand Query Performance

Microsoft has added an excellent new extension in PostgreSQL on their Azure Platform. This session, presented at Posette 2024, covers what Query Store is and the types of information you can get out of it.

1. USING QUERY STORE
TO UNDERSTAND
POSTGRESQL PERFORMANCE

2. Grant Fritchey
DevOps Advocate
Microsoft Data Platform MVP
AWS Community Builder
[email protected]
scarydba.com
@gfritchey
linkedin.com/in/grant-fritchey

3. QUERY TUNING
PROCESSIdentify Poorly
Performing
Queries
Examine Code
and Execution
Plans
Implement
Potential Solution
Validate
Improvement
Deploy To
Production

4. NOTES ON QUERY METRICS





5. CAPTURING QUERY
METRICS




6. QUERY STORE
•
•
•

7. YOU CONTROL…






8. ACCESS THE DATA




9. DEMO

10. MORE TO LEARN

