pg_stat_insights 1.0.0 Release Announcement

Download v1.0.0 · Source Code · Documentation

Executive Summary

We are releasing pg_stat_insights 1.0.0, a PostgreSQL performance monitoring extension with 52 metrics across 11 views. It is a drop-in enhancement to standard PostgreSQL statistics. It helps you identify slow queries, understand cache behavior, track WAL generation, and make tuning decisions.

• PostgreSQL 16, 17, and 18 compatibility
• Build artifacts for Ubuntu, Rocky Linux, and macOS
• Install with packages or build-from-source

What’s in this release

• 52 execution, I/O, WAL, JIT, parallelism, and metadata metrics
• 11 pre-built views including: top by time, top by calls, I/O heavy, cache misses, slow queries, errors, histogram summaries, and replication
• Response-time categories for practical SLA monitoring (<1ms to >10s)
• Works alongside (and beyond) pg_stat_statements

Build Artifacts

• PostgreSQL versions: 16, 17, 18
• Platforms: Ubuntu (.so), Rocky Linux (.so), macOS (.dylib)
• Get them here: Release Assets

Quick Install

Binary install (example):

# On Ubuntu/Rocky: install the package that matches your PG version
# Then enable the extension in your database
psql -d yourdb -c "CREATE EXTENSION pg_stat_insights;"

Build from source:

make PG_CONFIG=/path/to/pg_config
sudo make install

Documentation

• Quick Start: https://pgelephant.github.io/pg_stat_insights/quick-start/
• Full Docs: https://pgelephant.github.io/pg_stat_insights/

Verify Download

We publish checksums for all artifacts. After downloading, verify with:

sha256sum -c SHA256SUMS

Thank You

Huge thanks to the PostgreSQL community and early users who helped shape this release with feedback and testing.

pgElephant Team