Public Preview of query performance insight for Azure Database for PostgreSQL- Flexible Server
Published date: April 12, 2023
We are thrilled to announce the much-anticipated Public Preview of query performance insight in Azure Database for PostgreSQL - Flexible Server.
This new feature provides detailed insights into the performance of queries executed against your Azure Database for PostgreSQL - Flexible Server, helping you identify and optimize slow-running queries to improve the overall performance of your database. With query performance insights, you can visually inspect your database workloads in the Azure portal to identify long-running queries, inspect wait statistics associated with queries, and detect changes in query performance. Query performance insights is enabled by a related feature, query store, which collects and stores query execution statistics and wait event information. Besides long running queries and wait statistics, it also exposes high memory, IOPS, temporary file usage, and top queries by calls.
Query performance insight dashboard is part of Azure Portal UI and has a user-friendly interface allowing you to quickly explore and analyze their data without needing extensive technical knowledge.