v0.3.11

Installation

Download the tarball for your PostgreSQL version and architecture, then:

tar -xzf pg_stat_ch-*.tar.gz
cd pg_stat_ch-*/
sudo cp pg_stat_ch.so $(pg_config --pkglibdir)/
sudo cp pg_stat_ch.control pg_stat_ch--*.sql $(pg_config --sharedir)/extension/

See INSTALL.md in the tarball for full instructions.

Debug Symbols

Debug symbol packages (*-debuginfo.tar.gz) are provided for crash analysis.
To use them with a core dump:

tar -xzf pg_stat_ch-*-debuginfo.tar.gz
gdb -ex "set debug-file-directory $(pwd)" -ex "bt" pg_stat_ch.so core

What's Changed

• feat(arrow): add read_replica_type resource attribute column by @amogiska in #107
• schema: unify pg_stat_ch events_raw with prod Arrow path, move into Goose layout by @JoshDreamland in #99
• fix: prevent emit_log_hook OOM recursion from escalating to PANIC/SIGABRT by @iskakaushik in #109
• docs(readme): replace dashboard screenshot with query insights screenshots by @amogiska in #110
• ci(release): install libkrb5-dev for libpq-be.h gssapi dependency by @heavycrystal in #111
• docs(readme): fix image rendering on PGXN and external sites by @amogiska in #112
• chore(release): bump META.json version to 0.3.11 by @amogiska in #113

Full Changelog: v0.3.10...v0.3.11

v0.3.10

Installation

Download the tarball for your PostgreSQL version and architecture, then:

tar -xzf pg_stat_ch-*.tar.gz
cd pg_stat_ch-*/
sudo cp pg_stat_ch.so $(pg_config --pkglibdir)/
sudo cp pg_stat_ch.control pg_stat_ch--*.sql $(pg_config --sharedir)/extension/

See INSTALL.md in the tarball for full instructions.

Debug Symbols

Debug symbol packages (*-debuginfo.tar.gz) are provided for crash analysis.
To use them with a core dump:

tar -xzf pg_stat_ch-*-debuginfo.tar.gz
gdb -ex "set debug-file-directory $(pwd)" -ex "bt" pg_stat_ch.so core

What's Changed

• fix(ci): pin vcpkg checkout to tag 2026.04.27 so the binary cache actually hits by @JoshDreamland in #102
• fix(vcpkg): update overlay to use correct cityhash on the wire by @JoshDreamland in #103
• ci(tap): enable ClickHouse tests on TAP suite by @JoshDreamland in #101
• ci: declare workflow-level contents: read on 3 workflows by @arpitjain099 in #98
• Clear pid in shmem when process exits by @serprex in #100
• Intern queued query text in shared HTAB to bound DSA usage by @iskakaushik in #92
• Replace clickhouse-cpp with clickhouse-c by @serprex in #104
• interner: release on every valid ref; gitignore local dev clutter by @JoshDreamland in #105
• chore: bump META.json to 0.3.10 by @JoshDreamland in #106

New Contributors

• @arpitjain099 made their first contribution in #98

Full Changelog: v0.3.9...v0.3.10

v0.3.9

Installation

Download the tarball for your PostgreSQL version and architecture, then:

tar -xzf pg_stat_ch-*.tar.gz
cd pg_stat_ch-*/
sudo cp pg_stat_ch.so $(pg_config --pkglibdir)/
sudo cp pg_stat_ch.control pg_stat_ch--*.sql $(pg_config --sharedir)/extension/

See INSTALL.md in the tarball for full instructions.

Debug Symbols

Debug symbol packages (*-debuginfo.tar.gz) are provided for crash analysis.
To use them with a core dump:

tar -xzf pg_stat_ch-*-debuginfo.tar.gz
gdb -ex "set debug-file-directory $(pwd)" -ex "bt" pg_stat_ch.so core

What's Changed

• convert C++ files to C where simple by @serprex in #88
• build: forbid C++ sources outside src/export/ by @JoshDreamland in #68
• C++ exception barriers: remaining C-ABI getters by @JoshDreamland in #94
• chore: bump META.json to 0.3.9 by @amogiska in #97

New Contributors

• @serprex made their first contribution in #88

Full Changelog: v0.3.8...v0.3.9

v0.3.8

Installation

Download the tarball for your PostgreSQL version and architecture, then:

tar -xzf pg_stat_ch-*.tar.gz
cd pg_stat_ch-*/
sudo cp pg_stat_ch.so $(pg_config --pkglibdir)/
sudo cp pg_stat_ch.control pg_stat_ch--*.sql $(pg_config --sharedir)/extension/

See INSTALL.md in the tarball for full instructions.

Debug Symbols

Debug symbol packages (*-debuginfo.tar.gz) are provided for crash analysis.
To use them with a core dump:

tar -xzf pg_stat_ch-*-debuginfo.tar.gz
gdb -ex "set debug-file-directory $(pwd)" -ex "bt" pg_stat_ch.so core

What's Changed

• Contain std::bad_alloc on OTel and OTel+Arrow export paths by @iskakaushik in #86
• chore: add pg_stat_ch.block_format as a resource level attribute too by @iamKunalGupta in #89
• chore: prepare for release 0.3.8 by @iamKunalGupta in #90

New Contributors

• @iamKunalGupta made their first contribution in #89

Full Changelog: v0.3.7...v0.3.8

v0.3.7

Installation

Download the tarball for your PostgreSQL version and architecture, then:

tar -xzf pg_stat_ch-*.tar.gz
cd pg_stat_ch-*/
sudo cp pg_stat_ch.so $(pg_config --pkglibdir)/
sudo cp pg_stat_ch.control pg_stat_ch--*.sql $(pg_config --sharedir)/extension/

See INSTALL.md in the tarball for full instructions.

Debug Symbols

Debug symbol packages (*-debuginfo.tar.gz) are provided for crash analysis.
To use them with a core dump:

tar -xzf pg_stat_ch-*-debuginfo.tar.gz
gdb -ex "set debug-file-directory $(pwd)" -ex "bt" pg_stat_ch.so core

What's Changed

• Migrate from git submodules to vcpkg manifest mode by @iskakaushik in #75
• Optimize gRPC channel: gzip compression + keepalive + arena tuning by @iskakaushik in #76
• Add Arrow IPC dependency, GUCs, and SendArrowBatch interface by @iskakaushik in #77
• Add Arrow IPC batch builder and export path by @iskakaushik in #78
• chore: reduce LOC by ~20% — drop dead benchmark/perf/unit-test infra by @iskakaushik in #80
• chore(meta): align extension version with distribution (0.3) by @amogiska in #84

Full Changelog: v0.3.6...v0.3.7

v0.3.6

Installation

Download the tarball for your PostgreSQL version and architecture, then:

tar -xzf pg_stat_ch-*.tar.gz
cd pg_stat_ch-*/
sudo cp pg_stat_ch.so $(pg_config --pkglibdir)/
sudo cp pg_stat_ch.control pg_stat_ch--*.sql $(pg_config --sharedir)/extension/

See INSTALL.md in the tarball for full instructions.

Debug Symbols

Debug symbol packages (*-debuginfo.tar.gz) are provided for crash analysis.
To use them with a core dump:

tar -xzf pg_stat_ch-*-debuginfo.tar.gz
gdb -ex "set debug-file-directory $(pwd)" -ex "bt" pg_stat_ch.so core

What's Changed

• Replace normalize cache with queryId-keyed LRU by @iskakaushik in #70
• Replace OTel SDK with direct-proto exporter, add sampling by @iskakaushik in #72
• chore(meta): bump version to 0.3.6 by @amogiska in #73

Full Changelog: v0.3.5...v0.3.6

v0.3.5

Installation

Download the tarball for your PostgreSQL version and architecture, then:

tar -xzf pg_stat_ch-*.tar.gz
cd pg_stat_ch-*/
sudo cp pg_stat_ch.so $(pg_config --pkglibdir)/
sudo cp pg_stat_ch.control pg_stat_ch--*.sql $(pg_config --sharedir)/extension/

See INSTALL.md in the tarball for full instructions.

Debug Symbols

Debug symbol packages (*-debuginfo.tar.gz) are provided for crash analysis.
To use them with a core dump:

tar -xzf pg_stat_ch-*-debuginfo.tar.gz
gdb -ex "set debug-file-directory $(pwd)" -ex "bt" pg_stat_ch.so core

What's Changed

• Docs: setup Mintlify docs for pg_stat_ch by @Blargian in #47
• Docs: move docs out from under pages directory + add rewrites by @Blargian in #59
• Docs: fix broken links by @Blargian in #60
• Docs: comprehensive rewrite with new reference pages by @iskakaushik in #63
• Move query and error text to DSA for variable-length storage by @iskakaushik in #62
• Docs: lead install page with prebuilt binaries by @iskakaushik in #64
• ci: migrate all GitHub Actions runners to 16-core Depot by @iskakaushik in #66
• chore(meta): bump version to 0.3.5 by @amogiska in #69

New Contributors

• @Blargian made their first contribution in #47

Full Changelog: v0.3.4...v0.3.5

v0.3.4

Installation

Download the tarball for your PostgreSQL version and architecture, then:

tar -xzf pg_stat_ch-*.tar.gz
cd pg_stat_ch-*/
sudo cp pg_stat_ch.so $(pg_config --pkglibdir)/
sudo cp pg_stat_ch.control pg_stat_ch--*.sql $(pg_config --sharedir)/extension/

See INSTALL.md in the tarball for full instructions.

Debug Symbols

Debug symbol packages (*-debuginfo.tar.gz) are provided for crash analysis.
To use them with a core dump:

tar -xzf pg_stat_ch-*-debuginfo.tar.gz
gdb -ex "set debug-file-directory $(pwd)" -ex "bt" pg_stat_ch.so core

What's Changed

• feat: allow bgworker to start on standbys by @amogiska in #56
• chore: bump META.json version to 0.3.4 for release by @amogiska in #58

Full Changelog: v0.3.3...v0.3.4

customer-test

Rolling pre-release for customer-test. Updated on every push.

v0.3.3

Installation

Download the tarball for your PostgreSQL version and architecture, then:

tar -xzf pg_stat_ch-*.tar.gz
cd pg_stat_ch-*/
sudo cp pg_stat_ch.so $(pg_config --pkglibdir)/
sudo cp pg_stat_ch.control pg_stat_ch--*.sql $(pg_config --sharedir)/extension/

See INSTALL.md in the tarball for full instructions.

Debug Symbols

Debug symbol packages (*-debuginfo.tar.gz) are provided for crash analysis.
To use them with a core dump:

tar -xzf pg_stat_ch-*-debuginfo.tar.gz
gdb -ex "set debug-file-directory $(pwd)" -ex "bt" pg_stat_ch.so core

What's Changed

• fix(ci): remove jq version rewrite from PGXN workflow by @amogiska in #52
• Normalize executor and utility query text with $N placeholders by @iskakaushik in #51
• Refactor exporter files: reduce noise and improve structure by @iskakaushik in #54
• chore: bump META.json version to 0.3.3 by @amogiska in #55

Full Changelog: v0.3.2...v0.3.3