📊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).

It also displays the run-time statistics globally, by call, or by second.

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.