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
  • Table Dimensions
  • Interactive Demo
  • Index Dimensions
  1. Features
  2. Key Features

Top Tables

Datasentinel facilitates hourly collection of relations, supporting a Dimension-Based Analysis approach

By default, Datasentinel deactivates collection for PostgreSQL instances with over 1000 tables. You have the flexibility to control this collection behavior by adjusting the limit number.

Table Dimensions

Finely analyze your tables among the following dimensions:

  • Tuples

  • Size

  • Sequential scans

  • Index scans

  • Seq. scans rows fetched

  • Index scans rows fetched

  • Heap buffer blocks hit

  • Heap disk blocks read

  • Index disk blocks read

  • Index buffer blocks hit

  • Inserts

  • HOT updates

  • Updates

  • Deletes

  • Dead tuples

  • Live tuples

  • Tuples modified since analyze

  • Frozen xid

  • Age frozen xid

  • TOAST buffer blocks hit

  • TOAST disk blocks read

  • TOAST buffer index blocks hit

  • TOAST disk index blocks read

Explore deeper by drilling down into a chosen table to access both historical and index statistics.

Interactive Demo

Index Dimensions

Finely analyze your indexes among the following dimensions

  • Index scans

  • Index buffer blocks hit

  • Index disk blocks read

  • Index scans rows fetched

  • Index scans rows read

  • Size

  • Drill-down into a selected index to view its historical statistics.

PreviousTop QueriesNextLock Explorer

Last updated 1 year ago

Within the dashboard, three small charts are prominently displayed, allowing you to select for correlation. Refer to section for more details

📂
Cluster or System Metrics
Metric Correlation
🔀Metric Correlation