Skip to main content
TipRanks
Go Ultimate75% OFF

ClickHouse Open-Sources PostgreSQL Observability Extension pg_stat_ch

ClickHouse Open-Sources PostgreSQL Observability Extension pg_stat_ch

According to a recent LinkedIn post from ClickHouse, the company is open-sourcing pg_stat_ch, a PostgreSQL extension designed to stream detailed per-query execution events into ClickHouse. The post indicates this tool was developed to support observability needs for its Postgres managed by ClickHouse service, launched in January.

The LinkedIn post explains that, unlike aggregate-focused tools such as pg_stat_statements, pg_stat_ch captures raw per-query events, including timing, buffer I.O., WAL statistics, CPU, JIT, errors, and client context, with 45 structured fields. This granularity is presented as enabling analysis of historical performance patterns, such as time-bound changes and p99 latency trends over extended periods.

The post suggests that events are streamed into ClickHouse and can be queried similarly to an application performance monitoring system, potentially strengthening the company’s positioning in performance analytics for Postgres workloads. By open-sourcing the extension, ClickHouse may be aiming to drive developer adoption, increase data ingestion into its platform, and reinforce the value proposition of its managed Postgres offering.

The content also notes that this release coincides with “Postgres Week at ClickHouse,” during which the company plans to share daily PostgreSQL-related news through February 20. For investors, this focus on Postgres tooling and ecosystem engagement could signal a strategic push to deepen relevance in operational analytics and broaden the addressable market for its cloud and managed database services.

Disclaimer & DisclosureReport an Issue

Related Articles