PostgresAI

New episode: "Long-running transactions" Nik and Michael discuss long-running transactions, including when they're harmless, when they cause issues, and how to mitigate those issues. 🎧 postgres.fm/episodes/long-… 📺 youtu.be/uSUpbUJM5Kk

PG18 preserves planner statistics on upgrade — even from PG14 postgres.ai/blog/20260324-…

For fun, I rewrote psql in Rust and integrated it with AI meet "rpg" -- an experimental CLI maybe, at some point, it will bring ideas to psql itself thoughts? link in the 1st comment

pg_ash v1.3 released -- Active Session History for Postgres, pure SQL. New in 1.3: - pg_cron now optional -- works with external schedulers - set_debug_logging() -- RAISE LOG per sampled session - pgss-dependent functions fail fast with clear errors - Azure Flexible Server compatibility - PG14-18 tested Install: \i sql/ash-install.sql No extensions, no restart. Works on RDS, Cloud SQL, AlloyDB, Supabase, etc.

it was a fun session -- prototyped command tag customization at protocol level: github.com/NikolayS/postg…

How moving one word can speed up a query 10–50x postgres.ai/blog/20260311-…

pg_ash is out 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.

Release notes: github.com/postgres-ai/po…

postgresai 0.14 is out! Express health checks via `postgresai checkup`, Claude Code plugin, Supabase support, MCP tools, Bun for performance, query texts in Top-N charts, version/build timestamps, updated index analysis panels, and much more start here: npx postgresai@latest

finally in @postgres_ai's Grafana -- query texts everywhere in query analysis, not only queryids with smart truncation

Check your DB for unused/redundant indexes now, keep your index set lean: npm i -g postgresai postgresai checkup <DBURL> --json --check-id H002 # unused indexes postgresai checkup <DBURL> --json --check-id H004 # redundant indexes -- then feed it to your AI dev tool 🪄

This is awesome – one more observability gap is closed in Postgres 19devel! after Metronome's Postgres MultiXact member space exhaustion incidents in 2025 (postgres.fm/episodes/multi…), we had a couple of more cases, when customers came with the very same problem So for quite some time @postgres_ai monitoring covers it already – we see it as a mission to cover all cases we've learned so all customers and users have tooling to avoid various cliffs and in case shit happens – how to escape ASAP. So we added it, but only for self-hosted Postgres and RDS (they expose it with special functions) – monitoring of pg_multixact/members subdir size. Great to see that this kind of monitoring will be possible for all Postgres users when 19 is out – already planned to ship it – gitlab.com/postgres-ai/po…

The hidden cost of invalid indexes in Postgres (yes, even on Supabase/RDS/Neon) postgres.ai/blog/20260106-…

New episode: "Postgres year in review 2025" Nik and Michael discuss the events and trends they thought were most important in the Postgres ecosystem in 2025. 🎧 postgres.fm/episodes/postg… 📺 youtu.be/CQ5Fr5uHEp0

PostgresAI demo 2 - automated database health What if you clicked "Resolve" and got a PR What if index bloat just... fixed itself? Now it does.

New episode: "max_connections vs migrations" Nik and Michael discuss max_connections, especially in the context of increasing it to solve problems like migrations intermittently failing(!) 🎧 postgres.fm/episodes/max_c… 📺 youtu.be/KFRK8PiIvTg

postgres_ai monitoring v0.13: k8s support, new dashboard "13. lock contention", passwordless login from Console.Postgres.ai (Oauth with org verification), many fixes and improvements GitHub: github.com/postgres-ai/po… GitLab: gitlab.com/postgres-ai/po…

Added a new diagram to the postgres.ai front page showing how @postgres_ai copilot works: Your Postgres (located anywhere) → postgres_ai monitoring → Health check & Issues → GitHub PRs / AI tools → deployed back to your Postgres (continuous loop) (Inspired by turbopuffer's clean design; it rotates 90° on mobile.)

New episode: "Tens of TB per hour" Nik talks Michael through a recent benchmark he worked with Maxim Boguk on, to see how quickly they could provision a replica. 🎧 postgres.fm/episodes/tens-… 📺 youtu.be/ff-goIbd-Zk

I like how easy it is now to get the new @postgres_ai copilot for any @PostgreSQL database: One-click deployment in three modes – PaaS, BYOC, BYOM Easy access to dashboards at xxxxxx.pgai.watch by default – in case you need to dive into all the details "Resolve in Cursor" for issues that can be solved via code changes (or you can use Claude Code, Codex, etc.)