Provides monitoring views and functions for PostgreSQL activity, storage, locks, replication, WAL, vacuum, and query statistics.
pgext.cloud · Source code · Website · Documentation · Control file · PGXN
| Package | pg-telemetry |
|---|---|
| Version | 1.7 |
| PostgreSQL versions | 10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 |
| Repository | Unspecified |
| Extension type | SQL only |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Schema | pgtelemetry |
| Stars | 27 |
| Latest commit | 2025-06-26 |
| Latest release | 2023-11-21 |
| Catalogue updated | 2026-08-30 |
| pg_stat_statements | track planning and execution statistics of all SQL statements executed |
| plpgsql | PL/pgSQL procedural language |
| gbdchecks | Database health-check functions and views for bloat, locks, query statistics, and privileges. |
| pgfr_record | Server-side PostgreSQL performance flight recorder |
| pg_stat_statements | track planning and execution statistics of all SQL statements executed |
| pgmonitor | Collector-friendly metric views and background refresh worker |
| pg_dbwa | Analyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots. |
| pg_grab_statement | Record detailed SQL statements from successfully committed transactions. |
| pg_sessions | Tracks per-session SQL execution metrics and optional Linux process resource statistics in shared memory. |
| pg_repack | Reorganize tables in PostgreSQL databases with minimal locks |
| pgfr_control | Vacuum diagnostics, autovacuum scale-factor recommendations, and table bloat analysis for pgfr_record. |
| tencentdb_wal_stat | TencentDB proprietary WAL diagnostics extension that scans recent WAL files and attributes record counts, bytes, resource-manager types, and full-page images by database, schema, and relation. |