pg_ash
A pure SQL Active Session History extension for PostgreSQL that samples wait events every second with zero storage bloat.
What is pg_ash?
pg_ash is a pure SQL Active Session History implementation for PostgreSQL that samples database wait events and query activity at regular intervals. It solves the problem of historical performance visibility in PostgreSQL by capturing snapshots of `pg_stat_activity` and storing them in an efficient, queryable format. This allows database administrators to investigate past performance issues and analyze wait event patterns long after they occurred.
PostgreSQL database administrators, DevOps engineers, and SREs who need historical performance monitoring on managed PostgreSQL services or any PostgreSQL 14+ instance. It's particularly valuable for teams using RDS, Cloud SQL, Supabase, or other managed providers where traditional monitoring extensions aren't supported.
Developers choose pg_ash because it provides enterprise-grade session history functionality without the complexity of C extensions or external monitoring systems. Its pure SQL implementation means it works everywhere PostgreSQL runs, its zero-bloat storage design ensures predictable performance, and its rich analytical functions enable deep performance investigation with simple SQL queries.
Overview
Active Session History for PostgreSQL — wait event sampling with zero bloat (pg_cron + PGQ-style partition rotation)
Use Cases
Best For
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
