Database-agnostic Query Analytics
Zoom in and drill down on query performance. Quickly locate and fix bottlenecks and slow-running queries.
The Query Analytics dashboard shows how queries are executed. It helps you analyze database queries against many parameters and optimize database performance.
Features overview
Assess query performance and load distribution
Query Analytics calculates your query profile, which ranks queries by load for easy identification of the heaviest queries impacting your database.
Identify and investigate query anomalies
Based on your query profile, you can identify any irregularities such as spikes or increasing patterns in your queries. With Query Analytics, you can determine which queries are adding unnecessary load to the database, and which ones are consuming the most resources.
Customize query dashboards to your needs
Slice your query performance by different parameters, view explain plans – everything you need to get to the root of query performance issues.
More query insights for PostgreSQL
Specific to PostgreSQL monitoring, Query Analytics provides IT teams with:
- end-to-end traceability
- aggregated performance stats across configurable time windows without limits
- actionable histograms of query-wise execution time
Note: pg_stat_monitor extension should be enabled to use this additional functionality.
Featured Resources
Query Analytics documentation
The Query Analytics dashboard shows how queries are executed and where they spend their time.
How to Find Query Slowdowns Using Percona Monitoring and Management
Visibility is a blessing, and with databases, visibility is a must.
BLOG POST
RECOMMENDED ARTICLES
PMM Dump GUI in Percona Monitoring and Management 2.41.0
January 3, 2024
Blog
MOST POPULAR ARTICLES
Auditing login attempts in MySQL
December 28, 2012
Blog
Deploy Django on Kubernetes With Percona Operator for PostgreSQL
June 20, 2023
Blog
MySQL “Got an error reading communication packet”
May 16, 2016
Blog