List of main features

  • Non-invasive setup on PostgreSQL side - no extensions nor superuser rights are required for the base functionality so that even unprivileged users like developers can get a good overview of database activities without any hassle

  • Lots of preset metric configurations covering all performance critical PostgreSQL internal Statistics Collector data

  • Intuitive metrics presentation using a set of predefined dashboards for the very popular Grafana dashboarding engine with optional alerting support

  • Easy extensibility of metrics which are defined in pure SQL, thus they could also be from the business domain

  • Many metric data storage options - PostgreSQL, PostgreSQL with the compression enabled TimescaleDB extension, InfluxDB, Graphite or Prometheus scraping

  • Multiple deployment options - PostgreSQL configuration DB, YAML or ENV configuration, supporting both “push” and “pull” models

  • Possible to monitoring all, single or a subset (list or regex) of databases of a PostgreSQL instance

  • Global or per DB configuration of metrics and metric fetching intervals and optionally also times / days

  • Kubernetes/OpenShift ready with sample templates and a Helm chart

  • PgBouncer, Pgpool2, AWS RDS and Patroni support with automatic member discovery

  • Internal health-check API (port 8081 by default) to monitor metrics gathering status / progress remotely

  • Built-in security with SSL connections support for all components and passwords encryption for connect strings

  • Very low resource requirements for the collector even when monitoring hundreds of instances

  • Capabilities to go beyond PostgreSQL metrics gathering with built-in log parsing for error detection and OS level metrics collection via PL/Python “helper” stored procedures

  • A Ping mode to test connectivity to all databases under monitoring