--- title: pg_statviz 1.2 released with PostgreSQL 19 support and... description: pg_statviz, the minimalist PostgreSQL statistics visualization extension, has released version 1.2 with support for the upcoming PostgreSQL 19, including... canonical: https://daily.dev/posts/pg-statviz-1-2-released-with-postgresql-19-support-and-new-features-t6zmpf46w twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: pg_statviz 1.2 released with PostgreSQL 19 support and new features | daily.dev og:description: pg_statviz, the minimalist PostgreSQL statistics visualization extension, has released version 1.2 with support for the upcoming PostgreSQL 19, including... og:url: https://daily.dev/posts/pg-statviz-1-2-released-with-postgresql-19-support-and-new-features-t6zmpf46w og:image: https://api.daily.dev/og/posts/t6ZMPf46W.png og:image:alt: pg_statviz 1.2 released with PostgreSQL 19 support and new features og:image:width: 1200 og:image:height: 630 og:locale: 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 **[Planet PostgreSQL](https://daily.dev/sources/planet-postgresql)** · 3 min read · 1 upvotes · 0 comments ## Summary pg_statviz, the minimalist PostgreSQL statistics visualization extension, has released version 1.2 with support for the upcoming PostgreSQL 19, including capture of the new wal_fpi_bytes counter and PG18/19 I/O worker, WAL level, and autovacuum scoring settings. The release adds a new blocking locks analysis module that tracks blocked and blocking sessions by lock type using pg_blocking_pids(), with a deterministic severity floor ensuring sustained blocking is never reported as healthy. It also introduces an OpenAI-compatible AI provider configurable via OPENAI_BASE_URL and OPENAI_MODEL, and updates default AI models to claude-sonnet-5 and gemini-3.7-flash. AI analysis remains fully optional and opt-in, with zero-dependency installs unchanged. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### What's new in pg_statviz 1.2 for PostgreSQL 19 support? Version 1.2 of pg_statviz captures the new wal_fpi_bytes counter from pg_stat_wal and records the PG18/19 I/O worker, effective WAL level, and autovacuum scoring settings in snapshot_conf. It has been tested against PostgreSQL 19 beta3 as well as the full PostgreSQL 13 to 19 range. _Track PostgreSQL 19 compatible tooling releases like this on daily.dev as the beta cycle progresses._ ### How does pg_statviz detect blocking sessions in PostgreSQL? The new blocking locks module in pg_statviz 1.2 uses pg_blocking_pids() to detect blocking, so it counts soft blocks (sessions merely ahead in the lock wait queue) in addition to hard conflicts. Each snapshot records blocked and blocking session counts broken down by lock type such as relation, transactionid, and tuple, with a deterministic severity floor that never reports sustained blocking as healthy. _Database administrators debugging lock contention can follow monitoring tool updates like this via daily.dev._ ### How do I configure the OpenAI provider in pg_statviz? Pass --ai openai to use the OpenAI API compatible provider, which works with OpenAI itself or any other service or local server implementing that API. Select the endpoint and model with the OPENAI_BASE_URL and OPENAI_MODEL environment variables; the openai package is included in the [ai] extras, and zero-dependency installs remain unaffected if --ai is not passed. _daily.dev helps developers wiring AI providers into database tooling keep up with configuration changes like these._ ## Similar posts on daily.dev - [PostgreSQL RPM repository meets AI with pg\_statviz](https://daily.dev/posts/postgresql-rpm-repository-meets-ai-with-pg-statviz-83jowgcjd) · Planet PostgreSQL · 0 upvotes · 0 comments - [Comparing stats\! PostgreSQL 18 against 17](https://daily.dev/posts/comparing-stats-postgresql-18-against-17-4buaypt4l) · CYBERTEC PostgreSQL · 42 upvotes · 0 comments - [pg\_qualstats 2.1.3 is out\!](https://daily.dev/posts/pg-qualstats-2-1-3-is-out--ziqsx017h) · PostgreSQL · 1 upvotes · 0 comments --- Tags: [#database](https://daily.dev/tags/database), [#llm](https://daily.dev/tags/llm), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/pg-statviz-1-2-released-with-postgresql-19-support-and-new-features-t6zmpf46w) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"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-t6zmpf46w","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/pg-statviz-1-2-released-with-postgresql-19-support-and-new-features-t6zmpf46w"},"datePublished":"2026-08-20T18:04:33.553Z","dateModified":"2026-10-14T02:26:38.888Z","description":"pg_statviz, the minimalist PostgreSQL statistics visualization extension, has released version 1.2 with support for the upcoming PostgreSQL 19, including...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/3b097f05ef584d1ad739c2d020f6d519?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/3b097f05ef584d1ad739c2d020f6d519?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Planet PostgreSQL","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Planet PostgreSQL","logo":"https://media.daily.dev/image/upload/logos/placeholder.jpg","url":"https://daily.dev/sources/planet-postgresql"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/pg-statviz-1-2-released-with-postgresql-19-support-and-new-features-t6zmpf46w","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"database,llm,postgresql","timeRequired":"PT3M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Planet PostgreSQL","item":"https://daily.dev/sources/planet-postgresql"},{"@type":"ListItem","position":3,"name":"pg_statviz 1.2 released with PostgreSQL 19 support and new features"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/pg-statviz-1-2-released-with-postgresql-19-support-and-new-features-t6zmpf46w#faq","mainEntity":[{"@type":"Question","name":"What's new in pg_statviz 1.2 for PostgreSQL 19 support?","acceptedAnswer":{"@type":"Answer","text":"Version 1.2 of pg_statviz captures the new wal_fpi_bytes counter from pg_stat_wal and records the PG18/19 I/O worker, effective WAL level, and autovacuum scoring settings in snapshot_conf. It has been tested against PostgreSQL 19 beta3 as well as the full PostgreSQL 13 to 19 range. Track PostgreSQL 19 compatible tooling releases like this on daily.dev as the beta cycle progresses."}},{"@type":"Question","name":"How does pg_statviz detect blocking sessions in PostgreSQL?","acceptedAnswer":{"@type":"Answer","text":"The new blocking locks module in pg_statviz 1.2 uses pg_blocking_pids() to detect blocking, so it counts soft blocks (sessions merely ahead in the lock wait queue) in addition to hard conflicts. Each snapshot records blocked and blocking session counts broken down by lock type such as relation, transactionid, and tuple, with a deterministic severity floor that never reports sustained blocking as healthy. Database administrators debugging lock contention can follow monitoring tool updates like this via daily.dev."}},{"@type":"Question","name":"How do I configure the OpenAI provider in pg_statviz?","acceptedAnswer":{"@type":"Answer","text":"Pass --ai openai to use the OpenAI API compatible provider, which works with OpenAI itself or any other service or local server implementing that API. Select the endpoint and model with the OPENAI_BASE_URL and OPENAI_MODEL environment variables; the openai package is included in the [ai] extras, and zero-dependency installs remain unaffected if --ai is not passed. daily.dev helps developers wiring AI providers into database tooling keep up with configuration changes like these."}}]} ```