public inbox for [email protected]
help / color / mirror / Atom feedFrom: PostgresAI via PostgreSQL Announce <[email protected]>
To: PostgreSQL Announce <[email protected]>
Subject: pg_ash v1 - Active Session History for PostgreSQL
Date: Fri, 03 Apr 2026 09:06:09 +0000
Message-ID: <[email protected]> (raw)
pg_ash samples `pg_stat_activity` once per second via `pg_cron`, stores encoded snapshots in partitioned tables, and provides 32 SQL functions for wait event analysis.
Pure SQL + PL/pgSQL. No C extension, no `shared_preload_libraries`, 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](https://github.com/NikolayS/pg_ash)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pg_ash v1 - Active Session History for PostgreSQL
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox