pg-stat-statements

PostgreSQL extension to normalize SQL statements

postgresql pg_stat_statements and pg_statio_tables metric exporter

Read-only PostgreSQL diagnostic collector. No AI, no cloud, no write operations. Collects statistics from pg_stat views and packages them as portable snapshots.

pg stat for replecated servers

Historize pg_stat_statements

Top Postgresql Monitoring (Opensource) 🌟 Star if you like it! 🌟

Workload-aware blast radius forecaster for PostgreSQL migrations. Blocked query forecasting, duration ranges, rollout recipes, confidence accounting.

Find the Postgres queries that cost the most time, the index that fixes each, and whether it really did. Self-hosted, read-only, Postgres 16–18.

Evidence-first PostgreSQL plan analysis with deterministic diagnostics, workload regression checks, and grounded AI/RAG

AST-level fingerprint and cluster of PostgreSQL queries from pg_stat_statements

Production-like PostgreSQL monitoring stack with pg_exporter, Prometheus, Grafana, custom metrics, automated provisioning, workload scenarios, and verification.

Postgres docker image with hypopg, pg_stat_statements, pg_qualstats and supabase index_advisor pre installed

Read-only CLI that ranks, explains, and reports slow PostgreSQL queries from pg_stat_statements.

Detect PostgreSQL upgrade/change regressions with pg_stat_statements evidence, causal isolation, plan variants, and explicit unknowns.

Dies ist ein kleines, aber leistungsfähiges Demo-Projekt für Knowledge Management (KM) und Analytics mit PostgreSQL. Es beinhaltet komplexe SQL-Abfragen, Performance-Optimierung (Indizes und EXPLAIN ANALYZE) und Docker-Unterstützung für eine schnelle Bereitstellung. Ideal für Interview-Demos oder CI/CD-Tests.

Production Postgres tuning patterns: query cost ranking, autovacuum monitoring, index bloat detection. CLI + tests, no live DB needed.

Missing-index advisor for PostgreSQL that proves every recommendation against the planner before you create it. Read-only, throttled to ~1% of server time, works across replicas, with a live web UI.

top for Postgres and MySQL. Point it at a DSN and watch active queries, locks, and the costliest queries live.

Analyzes PostgreSQL slow queries via pg_stat_statements ranks by mean execution time, generates optimization hints, and delivers HTML reports via email

Analyses PostgreSQL query workloads and PostGIS table statistics, then recommends spatial indexes — GiST, SP-GiST, BRIN, partial, composite — plus clustering, index drops and query rewrites. Reads pg_stat_statements exports, CSV logs or plain SQL, ranks findings by a documented heuristic cost model, and emits ready-to-review DDL.