Datasentinel Docs
Visit our websiteBlogRelease Notes
  • 👋Welcome
  • 🆓Free Trial
  • 📣Release Notes
  • Getting started
    • Architecture
    • Installation
      • 🌐Platform
      • 🕶️Agent
    • PostgreSQL clusters
      • 🔌Extensions
        • 🔌pg_stat_statements
        • 🔌pg_store_plans
        • 🔌system_stats
        • 🔌pg_buffercache
      • 🕶️Monitoring User
      • ➕Adding Connection
    • FAQs
      • ❓Platform FAQ
      • ❓Agent FAQ
  • Features
    • Key Features
      • 📊Session History
      • 📊Top Queries
      • 📂Top Tables
      • 🔓Lock Explorer
      • 📈Cluster & System Metrics
      • ⌚Live360
      • 📰Reporting
      • 🔔Alerting
        • Settings
        • Templates
        • Silences
        • Manager
    • Other Features
      • 📡Agentless Monitoring
      • 🛡️Role Based Access
      • 🔂Changed Parameters
    • Tips & Hints
      • 🖥️User Interface
      • 🏷️Tags
      • 🔀Metric Correlation
      • 👁️‍🗨️Consolidated View
      • ❗Graphical Annotations
      • ☁️Predefined Providers
      • ❓Wait Event Description
      • ®️Read Replicas
      • 👁️‍🗨️Agentless & System Metrics
      • ☑️Simplified pg_instance Display
  • implementation
    • Platform Usage
      • ⚙️Configuration
        • 🔑License
        • 📓LDAP
        • ✉️SMTP
        • 📋Audit
        • 👨‍🏭Users & Roles
      • 🧩API
        • 🔗Access Token
        • 🧩Connection API
        • 🧩Role API
        • 🧩User API
        • 🧩Reporting API
        • 🧩Workload API
        • 🧩Alerting API
      • 🛠️Tooling
    • Agent Usage
      • 📣Release Notes
      • ⌨️CLI
      • 🧩API
      • 🗃️Collection Level
      • 🔬Internals
    • Upgrade
      • 🔄Platform
      • 🔄Agent
    • Troubleshooting
      • 🩺Error message: “502 Bad Gateway”
      • 🩺The UI is not displaying any metrics for my new instance.
      • 🩺UI dashboard is encountering loading errors
      • 🩺InfluxDB
  • Support
    • How to Contact Us
  • GitHub Toolkit
Powered by GitBook
On this page
  1. Features
  2. Key Features

Top Queries

The Top Queries feature allows you to identify the most consuming queries according to a chosen dimension.

PreviousSession HistoryNextTop Tables

Last updated 1 year ago

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 . Refer to 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.

📊
Cluster or System Metrics
Metric Correlation