PostgresAI 💙💛 reposted this
pg_ash is out github.com/NikolayS/pg_ash Postgres has no session history. When something was slow an hour ago, there's nothing to look at. pg_ash fixes that -- pure SQL, one file install, works on RDS/Cloud SQL/Supabase/self-hosted, anywhere where you have pg_stat_statements and pg_cron. No extension, no restarts, no provider approval. Just \i one file. 1s sampling, ~100-200 bytes per second,~20-30 MiB of raw data written per day, with bloat-free partition rotation (tribute to Skype's PGQ). AND: 32 functions designed to perform RCA -- friendly both to humans and AI. Check out an LLM-assisted investigation example here: https://lnkd.in/gzEUCASB // self-driving Postgres is the future of Postgres