Back to browse
GitHub Repository
113 starsPerl

Pg_stat_ch, a Postgres extension to export every metric to ClickHouse

by saisrirampur·Feb 13, 2026·4 points·0 comments

AI Analysis

●●●BangerWizardrySolve My Problem

pg_stat_statements alternative exporting raw events, zero network I/O overhead per query.

Strengths
  • Zero-copy ring buffer design keeps ~5μs p99 overhead off query path, proven architecture.
  • Raw events to ClickHouse enables flexible aggregation that pg_stat_statements can't match.
  • Production-ready: quickstart, error capture, JIT instrumentation, tested on PG15+.
Weaknesses
  • Requires ClickHouse deployment, not a drop-in replacement for simpler observability needs.
  • Documentation focuses on features, not troubleshooting adoption in existing stacks.
Target Audience

Database administrators, data engineers, backend teams running PostgreSQL at scale

Similar To

pg_stat_statements · Datadog APM for Postgres · pgAdmin query monitoring

Similar Projects