Request a Demo
Home   >   mailing lists

pg_ash v1 - Active Session History for PostgreSQL - Mailing list pgsql-announce

From PostgresAI via PostgreSQL Announce
Subject pg_ash v1 - Active Session History for PostgreSQL
Date
Msg-id 177520716916.3221089.1804726113216120208@wrigleys.postgresql.org
Whole thread Raw
List pgsql-announce
Tree view
 

pg_ash v1 - Active Session History for PostgreSQL

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

This email was sent to you from PostgresAI. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message should be sent to PostgresAI.

You were sent this email as a subscriber of the pgsql-announce mailinglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click the personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 

pgsql-announce by date:

Previous
From: "Gavin M. Roy via PostgreSQL Announce"
Date:
Subject: tree-sitter-postgres, libpgfmt, pgfmt, and libpgdump