---
title: "pg_statviz 1.2 released with PostgreSQL 19 support and new features"
url: https://daily.dev/posts/pg-statviz-1-2-released-with-postgresql-19-support-and-new-features-fpdmzjkzs
source_url: https://www.postgresql.org/about/news/pg_statviz-12-released-with-postgresql-19-support-and-new-features-3369
type: article
source: "PostgreSQL"
published: 2026-08-25T07:38:07.313Z
updated: 2026-08-25T07:39:01.782Z
tags: ["postgresql", "observability"]
reading_time: 2
upvotes: 0
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# pg_statviz 1.2 released with PostgreSQL 19 support and new features

**[PostgreSQL](https://daily.dev/sources/postgres)** · 2 min read · 0 upvotes · 0 comments

## Summary

pg_statviz 1.2 adds support for the upcoming PostgreSQL 19, capturing the new wal_fpi_bytes counter from pg_stat_wal. The release introduces a blocking locks analysis module that tracks lock wait types and soft blocks via pg_blocking_pids(), plus a new OpenAI-compatible AI provider option (--ai openai) that works with OpenAI or any compatible local/remote server. Default AI models are updated to claude-sonnet-5 and gemini-3.7-flash. The AI analysis stays fully optional, opt-in, and dependency-free unless explicitly enabled.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.postgresql.org/about/news/pg_statviz-12-released-with-postgresql-19-support-and-new-features-3369>

## Questions this post answers

### What's new in pg_statviz 1.2 for PostgreSQL 19 support?

pg_statviz 1.2 adds support for the upcoming PostgreSQL 19 by capturing the new wal_fpi_bytes counter from pg_stat_wal in its snapshot_conf. This release also introduces a blocking locks analysis module that tracks lock types like relation, transactionid, and tuple, and counts soft blocks using pg_blocking_pids(), not just hard conflicts.

_Track PostgreSQL monitoring tool releases like this on daily.dev before upgrading your database stack._

### How do I use a custom AI provider like a local LLM server with pg_statviz?

pg_statviz 1.2 adds an openai AI provider accessible via the --ai openai flag, which works with the OpenAI API itself or any other service or local server implementing that API. Configuration uses the OPENAI_BASE_URL and OPENAI_MODEL environment variables, and the openai package is added only to the [ai] extras, so zero-dependency installs remain unaffected.

_daily.dev helps engineers evaluating optional AI integrations in database tooling stay current._

### What default AI models does pg_statviz 1.2 use for Claude and Gemini?

pg_statviz 1.2 updates its default AI models to claude-sonnet-5 for Claude and gemini-3.7-flash for Gemini. This applies only when the optional AI analysis feature is explicitly enabled with the --ai flag; without it, pg_statviz behaves exactly as before with no extra dependencies or external calls.

_Developers choosing default AI models for their tooling can follow updates like this via daily.dev._

## Similar posts on daily.dev

- [pg\_ai\_query v0.1.0 — First stable release with multi-model AI for PostgreSQL](https://daily.dev/posts/pg-ai-query-v0-1-0-first-stable-release-with-multi-model-ai-for-postgresql-w8k83thlo) · PostgreSQL · 16 upvotes · 1 comments

---

Tags: [#postgresql](https://daily.dev/tags/postgresql), [#observability](https://daily.dev/tags/observability)

[View this post on daily.dev](https://daily.dev/posts/pg-statviz-1-2-released-with-postgresql-19-support-and-new-features-fpdmzjkzs)