Observable Graphics

Heaven's movement, all-seeing view, perceiving details to master the whole!

Monitoring Infra: Built-in Observability Stack

Ready-to-use Prometheus & Grafana observability tech stack

Automatic target discovery. Enterprise-grade monitoring without configure

  • Time-series database: Prometheus / AlertManager / X Exporters
  • Visualization: Grafana, Echarts, plus ten extra panels/data sources
  • Log collection: Loki / Promtail, or VictoriaMetrics / Vector
Monitoring Infrastructure

Data-Driven Design: Measure what you Manage

Monitoring built with data analytics and BI principles, turn metrics into insights

From macro overview to micro details, solid data support for administration

  • 3000+ metrics, 666 pre-agg rules, collecting all possible observation points
  • Unified labels for cross correlation, multi-level dashboard with nav links
  • Laying solid data context for intelligent AIOPS — D-Bot LLM as DBA
Metrics and Data

SOTA Experience: The Definitive PG Monitoring

Five years of refinement for the ultimate PG monitoring experience.

Dig into tables, indexes, func, and query objects details

  • Global/cluster/instance/database/object 5-levels, roll-up / drill-down easily
  • Historical metrics of tables, indexes, functions, queries and other DB objects
  • pg_exporter for postgres/pgbouncer metrics, fully customizable with YAML
Monitoring Hierarchy

Universal Monitoring: RDS or Compat Kernels

Monitoring cloud RDS PG or existing PG-compatible kernels

Monitoring nodes, dbms, apps, LB with correlation analysis

  • Monitoring cloud vendors&aops; RDS and PG-compatible kernel like Aurora
  • Built-in support for: Node, Infra, MinIO, Etcd, Redis, Haproxy, Nginx
  • General monitoring solution for servers
Universal Compatibility

Automatic Alerts: No More Manual Checks

Production-tested preset alert rule sets with automatic event notification

Integrated with popular IM systems like Slack, Discord, DingTalk, etc...

  • 56 preset rules: Common issues covered out-of-box
  • Smart thresholds: Adaptive alerting based on baselines
  • Alert routing: Intelligent notification delivery
  • Escalation policies: Tiered response management
Alert Management

Performance Tuning: Slow-Query Optimize

Deep integration with pg_stat_statements and auto_explain provides

Actionable insights for query optimization

  • pg_stat_statements: Query performance statistics
  • auto_explain: Automatic query plan capture
  • Query advisor: Optimization recommendations
  • Index suggestions: Missing index detection
Query Analysis

Logging Analysis: Fast Root-Cause Detection

Comprehensive log analysis capabilities with pattern recognition help

Identify and resolve issues in minutes, not hours

  • Centralized logging: All logs in one place
  • Pattern recognition: Automatic anomaly detection
  • Log correlation: Cross-service log analysis
  • Search and filter: Powerful query capabilities
Log Analysis

Custom Dashboards: Low-Code Visualization

Flexible dashboard creation and customization empowers teams

To build their own monitoring views without coding expertise

  • Drag-and-drop: Visual dashboard builder
  • Template library: Pre-built dashboard collection
  • Sharing capabilities: Team collaboration features
  • Export options: PDF, PNG, and data export
Custom Dashboards

PostgreSQL In Great STYle

Copyright © 2020-2025
Ruohang Feng (Vonng)
All rights reserved

PIGSTY