📊Top Queries
The Top Queries feature allows you to identify the most consuming queries according to a chosen dimension.
Datasentinel collects incremental execution statistics for all queries every minute.
This makes it easy to identify the top-performing queries over a specific period and on specific metrics, such as those generating the most Disk Access, Temporary Disk I/O or taking the most Execution Time.
The dashboard comprises three parts:
The upper graph provides a visual representation of the queries impact over time.
The small intermediate graphs help correlate these statistics with Cluster or System Metrics. Refer to Metric Correlation for more details.
The lower part provides details on a query-by-query basis for all the execution statistics
This feature allows for in-depth analysis of top queries across various dimensions, including:
total time
calls
rows
shared blocks hit
shared blocks read
shared blocks dirtied
shared blocks written
temporary blocks read
temporary blocks written
read time
write time
local blocks hit
local blocks read
local blocks dirtied
local blocks written
WAL size (since Postgres 13).
Interactive Demo
Moreover, Datasentinel enables users to drill down into a specific query to view its historical statistics and execution plans. This allows for better monitoring and analysis of the queries’ performance, enabling users to identify and address any bottlenecks in their database.
The dedicated dashboard presents the information in a multi-dimensional manner, featuring Time selection, Time zooming, and Tag filtering options.
Last updated