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

Support

For questions, issues, or commercial support, contact admin@pgelephant.com