Skip to content

Releases: postgres-ai/postgresai

postgresai 0.14.0

23 Jan 01:14
@NikolayS NikolayS
0.14.0
eac6799

Choose a tag to compare

View all tags
postgresai 0.14.0 Latest
Latest

AI-native PostgreSQL observability — monitoring, health checks, and root cause analysis for engineers and AI agents.

Highlights

0.14 brings direct PostgreSQL health checks via postgresai checkup, Claude Code plugin (/pgai), first-class Supabase support, and MCP tools for AI-assisted database management. The CLI was migrated to Bun for faster performance. Grafana dashboards now display query texts in Top-N charts (Dashboard 2), version/build timestamps, and new index analysis panels showing size, reads/hits in bytes. This release also delivers dozens of fixes and improvements.

Summary

This release includes 72 changes.

🚀 New Features and optimizations

  • dashboard: add query texts to TopN charts and table with smart truncation (!162)
  • CLI: add markdown output and improve checkup UX (!188)
  • CLI: embed checkup dictionary from API at build time (!179)
  • add unprepare-db command and pg_stat_statements to prepare-db (!177)
  • add databaseUrl to prepare-db --supabase JSON output (!175)
  • add MCP tools for action items (!172)
  • CLI: add Supabase mode and JSON output for prepare-db command (!173)
  • H001: add decision tree recommendations for invalid indexes (!166)
  • monitoring: Display version and build timestamp in Grafana Self-monitoring dashboard (!146)
  • MCP: add create_issue tool for issue creation via MCP (!127)
  • dashboards: unify panel titles and units across Grafana dashboards (!131)
  • reporter: add index_definition to H001 invalid indexes report (!134)
  • CLI: add express checkup command with direct PostgreSQL health checks + fix H004 and A003 (!115)
  • Add new single-index panels for size, reads/hits (bytes), add 50 and 100 options for Top-N of table and index analysis (!110)
  • prepare-db: add helper functions for generic plan collection, with optional HypoPG index; wrap each prepare-db step in begin/commit block; introduce "postgres_ai" schema (!117)
  • Add JSON schemas for checkup report outputs + tests (!98)
  • CLI: implement postgresai init to create DB role and grant permissions (!100)
  • Add Postgres version to report data (!96)
  • reporter: add database exclusion support (!95)
  • Support Amazon Managed Prometheus (!167)
  • adjust table&index dashboards: panel widths and bloat ordering (!143)
  • Hourly monitoring reports improvements + new K008 check (!124)
  • Daily JSON reports with hourly snapshots of pgss and ASH data (!97)
  • ignore estimated bloat for relations < 1 MiB (!106)
  • Embed index_pilot component (!102)

Fixes and optimizations

  • support pg_stat_statements in extensions schema (Supabase) (!190)
  • CLI: recognize --no-upload option, decouple --json from upload (!183)
  • CLI: append Supabase project ref to pooler username (!176)
  • use postgres_ai schema for pg_statistic + add --provider flag for Supabase (!174)
  • deps: update gunicorn and requests to address security vulnerabilities (!159)
  • CLI: use CLI version instead of stale .env tag (!153)
  • pgai: resolve postgresai/cli export instead of package.json (!151)
  • grafana: enable stacking for top-N index panels (!150)
  • CLI: macOS compatibility, cleanup, and image tag handling (!147)
  • CLI: mon clean now properly removes containers and volumes (!144)
  • CLI: pass Grafana password directly to Docker during local-install (!140)
  • docker: macOS compatibility for monitoring containers (!138)
  • CLI: resolve --api-key option being ignored in mon local-install (!137)
  • prepare-db: add SQL injection protection to explain_generic (!121)
  • CLI: resolve SQL directory at runtime for bundled CLI (!133)
  • CLI: pass api_url to UI for OAuth to ensure same backend is used (!129)
  • clean up HTTP error messages for CLI commands (!123)
  • replace Bun.serve with Node.js http module in auth-server (!122)
  • Get true lock_timeout and statement_timeout (!105)
  • CLI sslmode=prefer behavior, CI publish improvements, and schema fixes (!108)
  • Add resource limits and rename self-monitoring components (!178)
  • Reduce pgwatch log verbosity to error level (!185)

Refactoring

  • migrate CLI from Node.js to Bun (!118)
  • move auth-related commands under auth group (!119)
  • improve CLI commands and authentication flow (!113)
  • Restructure README with SaaS-first onboarding flow (!192)
  • modernize README with AI-native positioning, demos, and Claude Code plugin /pgai (!187)

Contributors

Thank you to all who contributed to this release!

  • Thomas Cave
  • Dmitry Fomin
  • Denis Morozov
  • Dementii Priadko
  • Nikolay Samokhvalov
  • Bogdan Tsechoev

Ideas and proposed changes are accepted on both GitLab and GitHub:

Getting Started

  • SaaS (recommended): sign up at console.postgres.ai and connect your database in minutes.
  • Self-hosted: install the CLI with npm install -g postgresai and run postgresai checkup <connection-string> for instant health checks, or postgresai mon local-install --demo for the full monitoring stack.
Assets 2
Loading

0.13

04 Dec 23:37
@NikolayS NikolayS
0.13
c77f012

Choose a tag to compare

View all tags
0.13

postgres_ai monitoring v0.13 - release notes

What's new

Kubernetes support (Helm charts)

Complete Kubernetes deployment support via Helm charts, including: (!72)

  • Full monitoring stack deployment (PGWatch, VictoriaMetrics, Grafana)
  • CronJob-based reporter for automated health checks
  • Configurable ingress with TLS support
  • Persistent storage via StatefulSets
  • Helm chart: postgres-ai-monitoring-0.13.tgz

New dashboard: "13. Lock contention"

New metric and dedicated dashboard for detailed lock contention analysis: (!82, !84, !86)

  • Blocked and blocking process identification
  • Lock modes and types visualization
  • Affected tables and queries
  • Wait duration and transaction time tracking
  • "Database: All" filter option

OAuth support for Grafana

Added OAuth authentication support for Grafana with configurable providers, enabling SSO integration; allows authentication using PostgresAI account (limited to members of specific organization that owns monitoring instance) (!79)

Issue generation API

New issue_generation flag in report file API for automated issue creation workflows. (!69)

Dashboard improvements

  • Dashboard 2 (Aggregated Query Analysis): Added 'per second' to titles and proper XXX/s units; added "Database: All" filter option (!88, !87)
  • Dashboard 3 (Single Query Analysis): Show detailed wait events in Active Session History panel (!76)
  • Dashboard 4 (Wait Sampling): Added "DB name: All" filter, now default selection (!78)
  • Dashboard 12 (SLRU): Renamed title to '12. SLRU cache stats' for consistency (!89)

Performance improvements

  • Reduced VictoriaMetrics load: Metrics now filter queries by current_database() to reduce cardinality and improve query performance (!80)

Fixes

  • Reporter queries: Fixed and improved metric queries for better data reliability (!73)
  • Database discovery: Made DB discovery source-agnostic for better compatibility (!70)
  • H004 report: Now includes index_definition field (consistent with H002) (!71)

Code quality

  • Added pgwatch_generated comment to all SQL queries for traceability (!75)
  • Added checkTitle field to all report JSONs for better organization (!74)
  • Comprehensive test suite for Postgres reporter (!77, !81)
Loading

0.12

11 Nov 19:01
@dementii-priadko dementii-priadko
0.12
9bf3925

Choose a tag to compare

View all tags
0.12

Release Date: November 10, 2025
GitLab Issue: #48

Overview

Version 0.12.0 adds SLRU monitoring, multixact member space exhaustion detection, enhanced dashboard usability, and improved automated reporting for production Postgres databases.

New features

SLRU monitoring dashboard (!65)

New dedicated dashboard for monitoring Simple Least Recently Used (SLRU) caches through pg_stat_slru metrics. Provides visibility into CLOG, subtransaction cache, multixact offset and member cache performance. SLRU contention can cause severe performance degradation that is difficult to diagnose without proper monitoring.

MultiXact member space exhaustion (!66)

Added early warning metric for multixact member space exhaustion by monitoring pg_multixact/members directory size. Provides advance notice before emergency autovacuum triggers. Documentation updated with required permissions for RDS/Aurora and self-managed instances.

High-level troubleshooting metrics (!67)

Redesigned Dashboard 1 to use high-level system metrics instead of granular pg_stat_statements aggregations. Provides faster dashboard load times (2-3x improvement), more intuitive top-down troubleshooting workflow, and better alignment with Four Golden Signals methodology.

Enhanced unused indexes report (!64)

  • Index definitions included for one-command UNDO operations
  • Improved statistics age calculation using database uptime when stats_reset is NULL
  • Enhanced metadata for safer index cleanup decisions

Other minor improvements

  • Active Session History (Dashboard 4) legibility improvements
  • Aggregated table statistics table on Dashboard 8
  • Got rid of hard-coded inner passwords for sink-postgres

Bug fixes

  • Corrected grant statements in documentation
  • Multi-value tooltips on Dashboard 1 enable time-synchronized analysis across all metrics

Linked merge requests

  • !68 — Dashboard improvements (shared tooltips, ASH)
  • !67 — High-level metrics on Dashboard 1
  • !66 — Multixact folder size monitoring
  • !65 — SLRU metrics and dashboard
  • !64 — Unused indexes report improvements

References

Loading

0.11

30 Oct 15:54
@dementii-priadko dementii-priadko
0.11
c9e9531

Choose a tag to compare

View all tags
0.11

Major changes

Victoria Metrics integration (bbe4c8d)

Replaced standard Prometheus with Victoria Metrics for time-series data storage, delivering substantial performance and efficiency improvements:

  • Better compression: Reduced storage footprint for long-term metric retention (from 2 GiB/day to >0.4 GiB/day/instance)
  • Lower memory usage: More efficient resource utilization for large-scale deployments
  • Enhanced performance: Faster query execution for dashboard rendering and analysis
  • Full compatibility: Maintains complete Prometheus query language compatibility
  • Increased capacity: Supports higher cardinality metrics without performance degradation

The migration is seamless with no changes required to existing Grafana dashboards or queries.

Optimized query analysis

  • Improved pg_stat_statements metric collection for more accurate and useful query performance data:

    • Query-level aggregation: Metrics now aggregate by queryid across all users and databases
    • Simplified analysis: Removed per-user ranking in favor of database-wide query patterns
    • Consistent metrics: Unified view of query performance regardless of executing user
    • Better trending: More reliable historical data for query performance analysis

  • Added stats_reset metric which allows to check the last time statistics were reset

New metrics (6a76444)

Added StatIO metric for indexes

Made retention period 2 weeks instead of 8 days (72c65cd)

Bug Fixes

  • Fixed bug of redundant/unused indexes metrics by adding a clause of granting pg_index to monitoring user (e59fbbd)
  • Fixed incorrect display of blk_write_time on the 1st dashboard (b958fa0, 444343e)
  • Fixed a bug of not filtering top_k for aggregated table stats (6a76444)
  • statement_timeout_seconds is now set to 15 seconds for all metrics (6a76444)
Loading