Just in time for the PostgreSQL 19 betas, I'm excited to announce release 1.2 of pg_statviz
, the minimalist extension and utility pair for time series analysis and visualization of PostgreSQL internal statistics.
This release adds support for the upcoming PostgreSQL 19:
pg_statviz
now captures the new wal_fpi_bytes
counter from pg_stat_wal
.snapshot_conf
.It also introduces a new blocking locks analysis module:
relation
, transactionid
, tuple
, and so on).pg_blocking_pids()
, so even soft blocks (sessions that are just ahead in the lock wait queue) are counted, not just hard conflicts.Also new is the openai
AI provider:
--ai openai
uses the OpenAI API, so the same flag works with OpenAI itself and with any other service or local server that implements that API.OPENAI_BASE_URL
and OPENAI_MODEL
environment variables. openai
package has been added to the [ai]
extras, and zero-dependency installs remain unchanged.Finally, this release also updates the default AI models to claude-sonnet-5
for Claude and gemini-3.7-flash
for Gemini.
pg_statviz
takes the view that everything should be light and minimal. Unlike commercial monitoring platforms, it doesn't require invasive agents or open connections to the database: it all lives inside your database.
The extension is plain SQL and PL/pgSQL and doesn't require modules to be loaded, the visualization utility is separate and can be run from anywhere, and your data is free and easy to export. The AI analysis remains fully optional and opt-in: if you don't pass --ai
, pg_statviz
behaves exactly as before, with no extra dependencies and no calls to anything outside your machine.
pg_statviz
from the PostgreSQL repositories or PGXN.pip install pg_statviz[ai]
.