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
  • Installation
  • Monitored metrics
  1. Getting started
  2. PostgreSQL clusters
  3. Extensions

system_stats

system_stats is a PostgreSQL extension that provides functions to access system level statistics that can be used for monitoring

Previouspg_store_plansNextpg_buffercache

Last updated 7 months ago

This extension is OPTIONAL and should be considered solely when you decide to employ the for monitoring your PostgreSQL instances.

Installation

To be installed in the internal database named postgres

For detailed installation instructions of the extension, please consult the GitHub repository

You need to grant the role monitor_system_stats to the monitoring user.

// example
GRANT monitor_system_stats to datasentinel;

Monitored metrics

When the system_stats extension is installed, Datasentinel (using the ) starts gathering system metrics directly from PostgreSQL clusters at regular intervals. This is achieved by running SQL queries, which enables Datasentinel to collect detailed system metrics without needing a local agent on each server.

With this setup, you can browse and analyze these metrics with the same level of precision and granularity as you would expect if a local agent were installed. Refer to for more details.

Metrics:

  • System information

  • CPU load

  • CPU usage

  • Memory usage

  • Network usage

  • Swap usage

  • I/Os statistics

  • File-systems usage

🔌
🔌
Agentless approach
https://github.com/EnterpriseDB/system_stats
agentless method
Cluster & System Metrics