Back to browse
GitHub Repository
119 starsPerl

Pg_stat_ch, a Postgres extension to export every metric to ClickHouse

by saisrirampur·Jul 26, 2026·2 points·0 comments

AI Analysis

●●●BangerBig BrainSolve My Problem

Shared memory queue design eliminates network I/O on the critical query path.

Strengths
  • Exports raw events instead of aggregates, leveraging ClickHouse for flexible analysis.
  • Background worker architecture ensures zero blocking on the foreground query path.
  • Official ClickHouse repo backing suggests long-term maintenance and integration.
Weaknesses
  • Adds operational complexity by requiring a running ClickHouse instance alongside Postgres.
  • Niche appeal limited to teams already invested in the Postgres-ClickHouse ecosystem.
Target Audience

Database engineers and SREs managing high-scale Postgres

Similar To

pg_stat_statements · Datadog Database Monitoring · New Relic

Similar Projects