select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Monitoring

pg_stat_ch

Export PostgreSQL query telemetry to ClickHouse

pgext.cloud · Source code · Website · Documentation · License text · Control file · PGXN

Overview

Packagepg_stat_ch
Version0.4
PostgreSQL versions16 · 17 · 18
RepositoryPIGSTY
Extension typePreloaded
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariespg_stat_ch
Stars123
Latest commit2026-08-30
Latest release2026-08-12
Catalogue updated2026-08-30

Related extensions

See also

pg_clickhouseInterfaces to query ClickHouse databases from PostgreSQL
pg_stat_monitorThe pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.
pgmonitorCollector-friendly metric views and background refresh worker
pg_datasentinelObservability and activity monitoring extension for PostgreSQL
duckdb_fdwDuckDB Foreign Data Wrapper
pgsentinelactive session history
pgnodemxCapture node OS metrics via SQL queries
pg_duckdbDuckDB Embedded in Postgres
system_statsEnterpriseDB system statistics for PostgreSQL
pg_profilePostgreSQL load profile repository and report builder