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

The dedicated dashboard presents the information in a multi-dimensional manner, featuring Time selection, Time zooming, and Tag filtering options.

Datasentinel lets you explore individual queries in depth, with access to historical metrics and execution plans, helping you proactively monitor performance and pinpoint database bottlenecks.

Explore execution plans

Execution Plans