๐Ÿ“Š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.

Last updated