# pg_stat_ch

## Docs

- [Installation](https://pg-stat-ch.clickhouse.com/get-started/installation.md): Install pg_stat_ch from prebuilt binaries or build from source
- [Introduction](https://pg-stat-ch.clickhouse.com/get-started/introduction.md): Per-query telemetry for PostgreSQL, stored and analyzed in ClickHouse
- [Quick start](https://pg-stat-ch.clickhouse.com/get-started/quick-start.md): From zero to querying per-execution telemetry in 5 minutes
- [ClickHouse setup](https://pg-stat-ch.clickhouse.com/guides/clickhouse.md): Set up the ClickHouse backend for pg_stat_ch
- [Monitoring queries](https://pg-stat-ch.clickhouse.com/guides/monitoring-queries.md): Practical query recipes for common performance monitoring use cases
- [OpenTelemetry export](https://pg-stat-ch.clickhouse.com/guides/opentelemetry.md): Send query telemetry to an OpenTelemetry collector instead of ClickHouse
- [Testing Guide](https://pg-stat-ch.clickhouse.com/guides/testing.md): Running regression, TAP, isolation, and stress tests
- [Configuration](https://pg-stat-ch.clickhouse.com/reference/configuration.md): All pg_stat_ch GUC parameters with defaults, ranges, and reload behavior
- [Events schema](https://pg-stat-ch.clickhouse.com/reference/events-schema.md): Complete field reference for the events_raw ClickHouse table
- [SQL functions](https://pg-stat-ch.clickhouse.com/reference/functions.md): pg_stat_ch SQL functions for monitoring, diagnostics, and control
- [PostgreSQL Hooks Architecture](https://pg-stat-ch.clickhouse.com/reference/hooks.md): How pg_stat_ch hooks into the query lifecycle to capture telemetry
- [Materialized views](https://pg-stat-ch.clickhouse.com/reference/materialized-views.md): Pre-built ClickHouse materialized views for common analytics patterns
- [Troubleshooting](https://pg-stat-ch.clickhouse.com/reference/troubleshooting.md): Common issues and diagnostic steps for pg_stat_ch
- [Version compatibility](https://pg-stat-ch.clickhouse.com/reference/version-compatibility.md): Feature matrix and version-specific behavior for PostgreSQL 16, 17, and 18

## Optional

- [Release post](https://clickhouse.com/blog/pg_stat_ch-postgres-extension-stats-to-clickhouse)
- [ClickHouse Docs](https://clickhouse.com/docs)