pgsql-announce
❮
pg_ash v1 - Active Session History for PostgreSQL
- Jump to comment-1PostgresAI via PostgreSQL Announce<announce-noreply@postgresql.org>Apr 3, 2026, 9:08 AM UTCpgash samples `pgstatactivity` once per second via `pgcron`, stores encoded snapshots in partitioned tables, and provides 32 SQL functions for wait event analysis.
Pure SQL + PL/pgSQL. No C extension, no `sharedpreloadlibraries`, no restart required. Works anywhere `pg_cron` runs — managed providers (RDS, Cloud SQL, AlloyDB, Azure Database for PostgreSQL, Supabase, etc.), self-managed, Kubernetes, or any other deployment.
Storage: ~100-200 bytes per sample, ~30 MiB/day with `TRUNCATE`-based partition rotation (zero bloat).
Analysis functions include top waits, per-query wait profiles, wait event drill-down, time-range investigation, and timeline visualization. Functions are designed to chain naturally for iterative root cause analysis — by a human in psql or by AI tools such as Claude Code, OpenCode, or Codex.
PostgreSQL 14-18. Apache 2.0. CI tested.
https://github.com/NikolayS/pg_ash