pg_statviz 1.2 adds PostgreSQL 19 support with new features

34 A- A+

pg_statviz 1.2 introduces compatibility with PostgreSQL 19 beta, offering a new WAL counter, lock analysis, and OpenAI integration to enhance database observability.

28 Ağustos 2026 Cuma - 16:02 (3 Gün önce) 2 dk okuma

pg_statviz 1.2 adds PostgreSQL 19 support with new features

With PostgreSQL 19 in beta, the pg_statviz extension has released version 1.2. The new update introduces an additional wal_fpi_bytes counter via pg_stat_wal, enabling finer-grained measurement of WAL (Write-Ahead Log) activity. This enhancement can play a critical role in performance analysis, especially in high-transaction environments.

Enhanced I/O and autovacuum monitoring

pg_statviz 1.2 stores separate I/O worker statistics for PG18 and PG19 within snapshot_conf. The same file also includes the active WAL level and autovacuum scoring settings. This allows administrators to view both disk I/O load and the effectiveness of autovacuum processes in a single snapshot.

Blocking lock analysis module

The newly added blocking lock analysis provides a detailed report on lock conflicts between database sessions. Each snapshot displays the number of blocking and blocked sessions along with the distribution by lock type (e.g., RowShareLock, ExclusiveLock). This information helps in early detection of long-running queries or deadlock situations.

OpenAI-based AI integration

pg_statviz 1.2 now supports OpenAI, allowing users to select endpoints and models via environment variables. Users can query statistical data in natural language, automatically summarize reports, and receive AI-driven optimization suggestions. This feature aims to streamline routine reporting tasks for database administrators.

Practical benefits of the new release

In large data centers and cloud-based PostgreSQL services, the following advantages stand out:

Detailed WAL measurement: The wal_fpi_bytes counter enables byte-level tracking of log writes, helping optimize disk usage.
Lock conflict visibility: The lock analysis module quickly identifies blocking sources, reducing intervention time.
Autovacuum control: Storing autovacuum scoring in snapshot_conf allows tracking changes in settings over time.
AI-powered reporting: OpenAI integration summarizes technical reports in natural language, improving team communication.

These combined features elevate pg_statviz from a mere statistics collection tool to a comprehensive observability and analysis platform. Since PostgreSQL 19 is still in beta, early integration of such extensions allows the community to refine them through feedback. Organizations adopting these tools early can leverage new metrics and AI-driven insights for safer performance management during production rollouts.

The combination of the new counter, lock analysis module, and AI integration in pg_statviz 1.2 acts as an "observability enhancer" for database administrators. In high-traffic applications, these insights enable early detection of bottlenecks and more dynamic resource allocation. Ultimately, pg_statviz strengthens the PostgreSQL monitoring ecosystem by aligning with PostgreSQL 19’s upcoming features.

Source: PostgreSQL News

Kaynak: PostgreSQL Haberleri

Alakalı İçerikler

Red Hat, Kurumsal AI’yı Dört Katmanda Sunuyor 5 Saat önce
Red Hat, dört katmanlı kurumsal AI mimarisini ve bu katmanların yönetim sorumluluklarını, dağıtım kalıplarını ve Gün 2 operasyonlarını detaylandırıyor.
Redis Patches Critical TLS Memory Vulnerability 2 Gün önce
Redis has patched a memory management vulnerability discovered during TLS data handling. Updating is essential due to remote code execution risks.
- tr
- az
- de
- en
- es
- fr
Kubernetes 1.37 Enhances Infrastructure Management Flexibility 4 Gün önce
Kubernetes 1.37 introduces 67 new improvements, emphasizing stability and collaboration in cloud and container management.
- tr
- az
- de
- en
- es
- fr
- ar
Docker Ends Minimus, Moves to Secure Infrastructure 5 Gün önce
Docker announced it will shut down the Minimus registry. Users will transition to new Docker images hardened for security by October 22.
- tr
- az
- de
- en
- es
- fr
- ar
Linux Kernel 7.1.9 Stable Release Now Available 6 Gün önce
The Linux kernel's 7.1.9 stable release has been made available to users. This update includes key improvements to enhance performance and system stability.
- tr
- az
- de
- en
- es
- fr
Reducing Human Dependence in Enterprise Data Analysis 6 Gün önce
Red Hat offers an approach that automates analysis processes with enterprise data agents, saving time. Details in the article.
- tr
- az
- en
- es
- fr
- ar