pg_stat_kcache

Kernel statistics gathering

Overview

Package	Version	Category	License	Language
`pg_stat_kcache`	`2.3.2`	STAT	BSD-3-Clause	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
6220	`pg_stat_kcache`	No	Yes	Yes	Yes	No	Yes	-

Related	`pg_stat_statements` `pgnodemx` `system_stats` `pgmeminfo` `pgmonitor` `pg_stat_ch` `pg_datasentinel` `pgsentinel`

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	PGDG	`2.3.2`	1817161514	`pg_stat_kcache`	`pg_stat_statements`
RPM	PGDG	`2.3.1`	1817161514	`pg_stat_kcache_$v`	-
DEB	PGDG	`2.3.2`	1817161514	`postgresql-$v-pg-stat-kcache`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PGDG 2.3.1 el8.x86_64.pg18 : pg_stat_kcache_18 pg_stat_kcache_18-2.3.1-1PGDG.rhel8.x86_64.rpm PGDG · 2.3.1 · 27.8KiB	PGDG 2.3.1 el8.x86_64.pg17 : pg_stat_kcache_17 pg_stat_kcache_17-2.3.1-1PGDG.rhel8.x86_64.rpm PGDG · 2.3.1 · 27.8KiB pg_stat_kcache_17-2.3.0-1PGDG.rhel8.x86_64.rpm PGDG · 2.3.0 · 27.3KiB	PGDG 2.3.1 el8.x86_64.pg16 : pg_stat_kcache_16 pg_stat_kcache_16-2.3.1-1PGDG.rhel8.x86_64.rpm PGDG · 2.3.1 · 27.8KiB pg_stat_kcache_16-2.3.0-1PGDG.rhel8.x86_64.rpm PGDG · 2.3.0 · 27.3KiB pg_stat_kcache_16-2.2.3-1PGDG.rhel8.x86_64.rpm PGDG · 2.2.3 · 26.6KiB pg_stat_kcache_16-2.2.2-1PGDG.rhel8.x86_64.rpm PGDG · 2.2.2 · 26.3KiB	PGDG 2.3.1 el8.x86_64.pg15 : pg_stat_kcache_15 pg_stat_kcache_15-2.3.1-1PGDG.rhel8.x86_64.rpm PGDG · 2.3.1 · 27.8KiB pg_stat_kcache_15-2.3.0-1PGDG.rhel8.x86_64.rpm PGDG · 2.3.0 · 27.4KiB pg_stat_kcache_15-2.2.3-1PGDG.rhel8.x86_64.rpm PGDG · 2.2.3 · 26.7KiB pg_stat_kcache_15-2.2.2-1PGDG.rhel8.x86_64.rpm PGDG · 2.2.2 · 26.3KiB pg_stat_kcache_15-2.2.1-2.rhel8.x86_64.rpm PGDG · 2.2.1 · 47.2KiB	PGDG 2.3.1 el8.x86_64.pg14 : pg_stat_kcache_14 pg_stat_kcache_14-2.3.1-1PGDG.rhel8.x86_64.rpm PGDG · 2.3.1 · 27.8KiB pg_stat_kcache_14-2.3.0-1PGDG.rhel8.x86_64.rpm PGDG · 2.3.0 · 27.4KiB pg_stat_kcache_14-2.2.3-1PGDG.rhel8.x86_64.rpm PGDG · 2.2.3 · 26.7KiB pg_stat_kcache_14-2.2.2-1PGDG.rhel8.x86_64.rpm PGDG · 2.2.2 · 26.3KiB pg_stat_kcache_14-2.2.1-2.rhel8.x86_64.rpm PGDG · 2.2.1 · 47.0KiB pg_stat_kcache_14-2.2.0-2.rhel8.x86_64.rpm PGDG · 2.2.0 · 46.6KiB
el8.aarch64	PGDG 2.3.1 el8.aarch64.pg18 : pg_stat_kcache_18 pg_stat_kcache_18-2.3.1-1PGDG.rhel8.aarch64.rpm PGDG · 2.3.1 · 27.7KiB	PGDG 2.3.1 el8.aarch64.pg17 : pg_stat_kcache_17 pg_stat_kcache_17-2.3.1-1PGDG.rhel8.aarch64.rpm PGDG · 2.3.1 · 27.7KiB pg_stat_kcache_17-2.3.0-1PGDG.rhel8.aarch64.rpm PGDG · 2.3.0 · 27.2KiB	PGDG 2.3.1 el8.aarch64.pg16 : pg_stat_kcache_16 pg_stat_kcache_16-2.3.1-1PGDG.rhel8.aarch64.rpm PGDG · 2.3.1 · 27.7KiB pg_stat_kcache_16-2.3.0-1PGDG.rhel8.aarch64.rpm PGDG · 2.3.0 · 27.2KiB pg_stat_kcache_16-2.2.3-1PGDG.rhel8.aarch64.rpm PGDG · 2.2.3 · 26.6KiB pg_stat_kcache_16-2.2.2-1PGDG.rhel8.aarch64.rpm PGDG · 2.2.2 · 26.3KiB	PGDG 2.3.1 el8.aarch64.pg15 : pg_stat_kcache_15 pg_stat_kcache_15-2.3.1-1PGDG.rhel8.aarch64.rpm PGDG · 2.3.1 · 27.8KiB pg_stat_kcache_15-2.3.0-1PGDG.rhel8.aarch64.rpm PGDG · 2.3.0 · 27.3KiB pg_stat_kcache_15-2.2.3-1PGDG.rhel8.aarch64.rpm PGDG · 2.2.3 · 26.6KiB pg_stat_kcache_15-2.2.2-1PGDG.rhel8.aarch64.rpm PGDG · 2.2.2 · 26.3KiB pg_stat_kcache_15-2.2.1-2.rhel8.aarch64.rpm PGDG · 2.2.1 · 46.4KiB	PGDG 2.3.1 el8.aarch64.pg14 : pg_stat_kcache_14 pg_stat_kcache_14-2.3.1-1PGDG.rhel8.aarch64.rpm PGDG · 2.3.1 · 27.7KiB pg_stat_kcache_14-2.3.0-1PGDG.rhel8.aarch64.rpm PGDG · 2.3.0 · 27.3KiB pg_stat_kcache_14-2.2.3-1PGDG.rhel8.aarch64.rpm PGDG · 2.2.3 · 26.6KiB pg_stat_kcache_14-2.2.2-1PGDG.rhel8.aarch64.rpm PGDG · 2.2.2 · 26.3KiB pg_stat_kcache_14-2.2.1-2.rhel8.aarch64.rpm PGDG · 2.2.1 · 46.2KiB
el9.x86_64	PGDG 2.3.1 el9.x86_64.pg18 : pg_stat_kcache_18 pg_stat_kcache_18-2.3.1-3PGDG.rhel9.8.x86_64.rpm PGDG · 2.3.1 · 26.7KiB pg_stat_kcache_18-2.3.1-1PGDG.rhel9.x86_64.rpm PGDG · 2.3.1 · 26.5KiB	PGDG 2.3.1 el9.x86_64.pg17 : pg_stat_kcache_17 pg_stat_kcache_17-2.3.1-3PGDG.rhel9.8.x86_64.rpm PGDG · 2.3.1 · 26.7KiB pg_stat_kcache_17-2.3.1-1PGDG.rhel9.x86_64.rpm PGDG · 2.3.1 · 26.5KiB pg_stat_kcache_17-2.3.0-1PGDG.rhel9.x86_64.rpm PGDG · 2.3.0 · 26.4KiB	PGDG 2.3.1 el9.x86_64.pg16 : pg_stat_kcache_16 pg_stat_kcache_16-2.3.1-3PGDG.rhel9.8.x86_64.rpm PGDG · 2.3.1 · 26.7KiB pg_stat_kcache_16-2.3.1-1PGDG.rhel9.x86_64.rpm PGDG · 2.3.1 · 26.5KiB pg_stat_kcache_16-2.3.0-1PGDG.rhel9.x86_64.rpm PGDG · 2.3.0 · 26.4KiB pg_stat_kcache_16-2.2.3-1PGDG.rhel9.x86_64.rpm PGDG · 2.2.3 · 25.6KiB pg_stat_kcache_16-2.2.2-1PGDG.rhel9.x86_64.rpm PGDG · 2.2.2 · 25.2KiB	PGDG 2.3.1 el9.x86_64.pg15 : pg_stat_kcache_15 pg_stat_kcache_15-2.3.1-3PGDG.rhel9.8.x86_64.rpm PGDG · 2.3.1 · 26.7KiB pg_stat_kcache_15-2.3.1-1PGDG.rhel9.x86_64.rpm PGDG · 2.3.1 · 26.6KiB pg_stat_kcache_15-2.3.0-1PGDG.rhel9.x86_64.rpm PGDG · 2.3.0 · 26.5KiB pg_stat_kcache_15-2.2.3-1PGDG.rhel9.x86_64.rpm PGDG · 2.2.3 · 25.7KiB pg_stat_kcache_15-2.2.2-1PGDG.rhel9.x86_64.rpm PGDG · 2.2.2 · 25.3KiB pg_stat_kcache_15-2.2.1-2.rhel9.x86_64.rpm PGDG · 2.2.1 · 47.4KiB	PGDG 2.3.1 el9.x86_64.pg14 : pg_stat_kcache_14 pg_stat_kcache_14-2.3.1-3PGDG.rhel9.8.x86_64.rpm PGDG · 2.3.1 · 26.8KiB pg_stat_kcache_14-2.3.1-1PGDG.rhel9.x86_64.rpm PGDG · 2.3.1 · 26.6KiB pg_stat_kcache_14-2.3.0-1PGDG.rhel9.x86_64.rpm PGDG · 2.3.0 · 26.4KiB pg_stat_kcache_14-2.2.3-1PGDG.rhel9.x86_64.rpm PGDG · 2.2.3 · 25.7KiB pg_stat_kcache_14-2.2.2-1PGDG.rhel9.x86_64.rpm PGDG · 2.2.2 · 25.3KiB pg_stat_kcache_14-2.2.1-2.rhel9.x86_64.rpm PGDG · 2.2.1 · 47.2KiB
el9.aarch64	PGDG 2.3.1 el9.aarch64.pg18 : pg_stat_kcache_18 pg_stat_kcache_18-2.3.1-3PGDG.rhel9.8.aarch64.rpm PGDG · 2.3.1 · 26.9KiB pg_stat_kcache_18-2.3.1-1PGDG.rhel9.aarch64.rpm PGDG · 2.3.1 · 26.6KiB	PGDG 2.3.1 el9.aarch64.pg17 : pg_stat_kcache_17 pg_stat_kcache_17-2.3.1-3PGDG.rhel9.8.aarch64.rpm PGDG · 2.3.1 · 26.9KiB pg_stat_kcache_17-2.3.1-1PGDG.rhel9.aarch64.rpm PGDG · 2.3.1 · 26.5KiB pg_stat_kcache_17-2.3.0-1PGDG.rhel9.aarch64.rpm PGDG · 2.3.0 · 26.5KiB	PGDG 2.3.1 el9.aarch64.pg16 : pg_stat_kcache_16 pg_stat_kcache_16-2.3.1-3PGDG.rhel9.8.aarch64.rpm PGDG · 2.3.1 · 26.9KiB pg_stat_kcache_16-2.3.1-1PGDG.rhel9.aarch64.rpm PGDG · 2.3.1 · 26.6KiB pg_stat_kcache_16-2.3.0-1PGDG.rhel9.aarch64.rpm PGDG · 2.3.0 · 26.5KiB pg_stat_kcache_16-2.2.3-1PGDG.rhel9.aarch64.rpm PGDG · 2.2.3 · 25.8KiB pg_stat_kcache_16-2.2.2-1PGDG.rhel9.aarch64.rpm PGDG · 2.2.2 · 25.3KiB	PGDG 2.3.1 el9.aarch64.pg15 : pg_stat_kcache_15 pg_stat_kcache_15-2.3.1-3PGDG.rhel9.8.aarch64.rpm PGDG · 2.3.1 · 26.9KiB pg_stat_kcache_15-2.3.1-1PGDG.rhel9.aarch64.rpm PGDG · 2.3.1 · 26.6KiB pg_stat_kcache_15-2.3.0-1PGDG.rhel9.aarch64.rpm PGDG · 2.3.0 · 26.6KiB pg_stat_kcache_15-2.2.3-1PGDG.rhel9.aarch64.rpm PGDG · 2.2.3 · 25.9KiB pg_stat_kcache_15-2.2.2-1PGDG.rhel9.aarch64.rpm PGDG · 2.2.2 · 25.4KiB pg_stat_kcache_15-2.2.1-2.rhel9.aarch64.rpm PGDG · 2.2.1 · 46.6KiB	PGDG 2.3.1 el9.aarch64.pg14 : pg_stat_kcache_14 pg_stat_kcache_14-2.3.1-3PGDG.rhel9.8.aarch64.rpm PGDG · 2.3.1 · 26.9KiB pg_stat_kcache_14-2.3.1-1PGDG.rhel9.aarch64.rpm PGDG · 2.3.1 · 26.6KiB pg_stat_kcache_14-2.3.0-1PGDG.rhel9.aarch64.rpm PGDG · 2.3.0 · 26.6KiB pg_stat_kcache_14-2.2.3-1PGDG.rhel9.aarch64.rpm PGDG · 2.2.3 · 25.9KiB pg_stat_kcache_14-2.2.2-1PGDG.rhel9.aarch64.rpm PGDG · 2.2.2 · 25.4KiB pg_stat_kcache_14-2.2.1-2.rhel9.aarch64.rpm PGDG · 2.2.1 · 46.5KiB
el10.x86_64	PGDG 2.3.1 el10.x86_64.pg18 : pg_stat_kcache_18 pg_stat_kcache_18-2.3.1-3PGDG.rhel10.2.x86_64.rpm PGDG · 2.3.1 · 26.9KiB pg_stat_kcache_18-2.3.1-1PGDG.rhel10.x86_64.rpm PGDG · 2.3.1 · 26.9KiB	PGDG 2.3.1 el10.x86_64.pg17 : pg_stat_kcache_17 pg_stat_kcache_17-2.3.1-3PGDG.rhel10.2.x86_64.rpm PGDG · 2.3.1 · 26.9KiB pg_stat_kcache_17-2.3.1-1PGDG.rhel10.x86_64.rpm PGDG · 2.3.1 · 27.0KiB pg_stat_kcache_17-2.3.0-2PGDG.rhel10.x86_64.rpm PGDG · 2.3.0 · 26.7KiB	PGDG 2.3.1 el10.x86_64.pg16 : pg_stat_kcache_16 pg_stat_kcache_16-2.3.1-3PGDG.rhel10.2.x86_64.rpm PGDG · 2.3.1 · 26.9KiB pg_stat_kcache_16-2.3.1-1PGDG.rhel10.x86_64.rpm PGDG · 2.3.1 · 27.0KiB pg_stat_kcache_16-2.3.0-2PGDG.rhel10.x86_64.rpm PGDG · 2.3.0 · 26.7KiB	PGDG 2.3.1 el10.x86_64.pg15 : pg_stat_kcache_15 pg_stat_kcache_15-2.3.1-3PGDG.rhel10.2.x86_64.rpm PGDG · 2.3.1 · 27.1KiB pg_stat_kcache_15-2.3.1-1PGDG.rhel10.x86_64.rpm PGDG · 2.3.1 · 27.2KiB pg_stat_kcache_15-2.3.0-2PGDG.rhel10.x86_64.rpm PGDG · 2.3.0 · 26.9KiB	PGDG 2.3.1 el10.x86_64.pg14 : pg_stat_kcache_14 pg_stat_kcache_14-2.3.1-3PGDG.rhel10.2.x86_64.rpm PGDG · 2.3.1 · 27.1KiB pg_stat_kcache_14-2.3.1-1PGDG.rhel10.x86_64.rpm PGDG · 2.3.1 · 27.2KiB pg_stat_kcache_14-2.3.0-2PGDG.rhel10.x86_64.rpm PGDG · 2.3.0 · 26.9KiB
el10.aarch64	PGDG 2.3.1 el10.aarch64.pg18 : pg_stat_kcache_18 pg_stat_kcache_18-2.3.1-3PGDG.rhel10.2.aarch64.rpm PGDG · 2.3.1 · 27.4KiB pg_stat_kcache_18-2.3.1-1PGDG.rhel10.aarch64.rpm PGDG · 2.3.1 · 27.5KiB	PGDG 2.3.1 el10.aarch64.pg17 : pg_stat_kcache_17 pg_stat_kcache_17-2.3.1-3PGDG.rhel10.2.aarch64.rpm PGDG · 2.3.1 · 27.4KiB pg_stat_kcache_17-2.3.1-1PGDG.rhel10.aarch64.rpm PGDG · 2.3.1 · 27.5KiB pg_stat_kcache_17-2.3.0-2PGDG.rhel10.aarch64.rpm PGDG · 2.3.0 · 27.2KiB	PGDG 2.3.1 el10.aarch64.pg16 : pg_stat_kcache_16 pg_stat_kcache_16-2.3.1-3PGDG.rhel10.2.aarch64.rpm PGDG · 2.3.1 · 27.4KiB pg_stat_kcache_16-2.3.1-1PGDG.rhel10.aarch64.rpm PGDG · 2.3.1 · 27.5KiB pg_stat_kcache_16-2.3.0-2PGDG.rhel10.aarch64.rpm PGDG · 2.3.0 · 27.2KiB	PGDG 2.3.1 el10.aarch64.pg15 : pg_stat_kcache_15 pg_stat_kcache_15-2.3.1-3PGDG.rhel10.2.aarch64.rpm PGDG · 2.3.1 · 27.5KiB pg_stat_kcache_15-2.3.1-1PGDG.rhel10.aarch64.rpm PGDG · 2.3.1 · 27.6KiB pg_stat_kcache_15-2.3.0-2PGDG.rhel10.aarch64.rpm PGDG · 2.3.0 · 27.3KiB	PGDG 2.3.1 el10.aarch64.pg14 : pg_stat_kcache_14 pg_stat_kcache_14-2.3.1-3PGDG.rhel10.2.aarch64.rpm PGDG · 2.3.1 · 27.5KiB pg_stat_kcache_14-2.3.1-1PGDG.rhel10.aarch64.rpm PGDG · 2.3.1 · 27.5KiB pg_stat_kcache_14-2.3.0-2PGDG.rhel10.aarch64.rpm PGDG · 2.3.0 · 27.2KiB
d12.x86_64	PGDG 2.3.2 d12.x86_64.pg18 : postgresql-18-pg-stat-kcache postgresql-18-pg-stat-kcache_2.3.2-1.pgdg12+1_amd64.deb PGDG · 2.3.2 · 37.0KiB postgresql-18-pg-stat-kcache_2.3.1-1.pgdg12+1_amd64.deb PGDG · 2.3.1 · 36.9KiB	PGDG 2.3.2 d12.x86_64.pg17 : postgresql-17-pg-stat-kcache postgresql-17-pg-stat-kcache_2.3.2-1.pgdg12+1_amd64.deb PGDG · 2.3.2 · 37.0KiB postgresql-17-pg-stat-kcache_2.3.1-1.pgdg12+1_amd64.deb PGDG · 2.3.1 · 37.0KiB	PGDG 2.3.2 d12.x86_64.pg16 : postgresql-16-pg-stat-kcache postgresql-16-pg-stat-kcache_2.3.2-1.pgdg12+1_amd64.deb PGDG · 2.3.2 · 37.1KiB postgresql-16-pg-stat-kcache_2.3.1-1.pgdg12+1_amd64.deb PGDG · 2.3.1 · 37.0KiB	PGDG 2.3.2 d12.x86_64.pg15 : postgresql-15-pg-stat-kcache postgresql-15-pg-stat-kcache_2.3.2-1.pgdg12+1_amd64.deb PGDG · 2.3.2 · 37.1KiB postgresql-15-pg-stat-kcache_2.3.1-1.pgdg12+1_amd64.deb PGDG · 2.3.1 · 37.0KiB	PGDG 2.3.2 d12.x86_64.pg14 : postgresql-14-pg-stat-kcache postgresql-14-pg-stat-kcache_2.3.2-1.pgdg12+1_amd64.deb PGDG · 2.3.2 · 37.1KiB postgresql-14-pg-stat-kcache_2.3.1-1.pgdg12+1_amd64.deb PGDG · 2.3.1 · 36.9KiB
d12.aarch64	PGDG 2.3.2 d12.aarch64.pg18 : postgresql-18-pg-stat-kcache postgresql-18-pg-stat-kcache_2.3.2-1.pgdg12+1_arm64.deb PGDG · 2.3.2 · 36.7KiB postgresql-18-pg-stat-kcache_2.3.1-1.pgdg12+1_arm64.deb PGDG · 2.3.1 · 36.7KiB	PGDG 2.3.2 d12.aarch64.pg17 : postgresql-17-pg-stat-kcache postgresql-17-pg-stat-kcache_2.3.2-1.pgdg12+1_arm64.deb PGDG · 2.3.2 · 36.7KiB postgresql-17-pg-stat-kcache_2.3.1-1.pgdg12+1_arm64.deb PGDG · 2.3.1 · 36.6KiB	PGDG 2.3.2 d12.aarch64.pg16 : postgresql-16-pg-stat-kcache postgresql-16-pg-stat-kcache_2.3.2-1.pgdg12+1_arm64.deb PGDG · 2.3.2 · 36.7KiB postgresql-16-pg-stat-kcache_2.3.1-1.pgdg12+1_arm64.deb PGDG · 2.3.1 · 36.6KiB	PGDG 2.3.2 d12.aarch64.pg15 : postgresql-15-pg-stat-kcache postgresql-15-pg-stat-kcache_2.3.2-1.pgdg12+1_arm64.deb PGDG · 2.3.2 · 36.7KiB postgresql-15-pg-stat-kcache_2.3.1-1.pgdg12+1_arm64.deb PGDG · 2.3.1 · 36.6KiB	PGDG 2.3.2 d12.aarch64.pg14 : postgresql-14-pg-stat-kcache postgresql-14-pg-stat-kcache_2.3.2-1.pgdg12+1_arm64.deb PGDG · 2.3.2 · 36.7KiB postgresql-14-pg-stat-kcache_2.3.1-1.pgdg12+1_arm64.deb PGDG · 2.3.1 · 36.6KiB
d13.x86_64	PGDG 2.3.2 d13.x86_64.pg18 : postgresql-18-pg-stat-kcache postgresql-18-pg-stat-kcache_2.3.2-1.pgdg13+1_amd64.deb PGDG · 2.3.2 · 37.0KiB postgresql-18-pg-stat-kcache_2.3.1-1.pgdg13+1_amd64.deb PGDG · 2.3.1 · 36.9KiB	PGDG 2.3.2 d13.x86_64.pg17 : postgresql-17-pg-stat-kcache postgresql-17-pg-stat-kcache_2.3.2-1.pgdg13+1_amd64.deb PGDG · 2.3.2 · 36.9KiB postgresql-17-pg-stat-kcache_2.3.1-1.pgdg13+1_amd64.deb PGDG · 2.3.1 · 36.9KiB	PGDG 2.3.2 d13.x86_64.pg16 : postgresql-16-pg-stat-kcache postgresql-16-pg-stat-kcache_2.3.2-1.pgdg13+1_amd64.deb PGDG · 2.3.2 · 36.9KiB postgresql-16-pg-stat-kcache_2.3.1-1.pgdg13+1_amd64.deb PGDG · 2.3.1 · 36.8KiB	PGDG 2.3.2 d13.x86_64.pg15 : postgresql-15-pg-stat-kcache postgresql-15-pg-stat-kcache_2.3.2-1.pgdg13+1_amd64.deb PGDG · 2.3.2 · 36.9KiB postgresql-15-pg-stat-kcache_2.3.1-1.pgdg13+1_amd64.deb PGDG · 2.3.1 · 36.9KiB	PGDG 2.3.2 d13.x86_64.pg14 : postgresql-14-pg-stat-kcache postgresql-14-pg-stat-kcache_2.3.2-1.pgdg13+1_amd64.deb PGDG · 2.3.2 · 37.0KiB postgresql-14-pg-stat-kcache_2.3.1-1.pgdg13+1_amd64.deb PGDG · 2.3.1 · 36.9KiB
d13.aarch64	PGDG 2.3.2 d13.aarch64.pg18 : postgresql-18-pg-stat-kcache postgresql-18-pg-stat-kcache_2.3.2-1.pgdg13+1_arm64.deb PGDG · 2.3.2 · 36.9KiB postgresql-18-pg-stat-kcache_2.3.1-1.pgdg13+1_arm64.deb PGDG · 2.3.1 · 36.8KiB	PGDG 2.3.2 d13.aarch64.pg17 : postgresql-17-pg-stat-kcache postgresql-17-pg-stat-kcache_2.3.2-1.pgdg13+1_arm64.deb PGDG · 2.3.2 · 36.9KiB postgresql-17-pg-stat-kcache_2.3.1-1.pgdg13+1_arm64.deb PGDG · 2.3.1 · 36.7KiB	PGDG 2.3.2 d13.aarch64.pg16 : postgresql-16-pg-stat-kcache postgresql-16-pg-stat-kcache_2.3.2-1.pgdg13+1_arm64.deb PGDG · 2.3.2 · 36.9KiB postgresql-16-pg-stat-kcache_2.3.1-1.pgdg13+1_arm64.deb PGDG · 2.3.1 · 36.8KiB	PGDG 2.3.2 d13.aarch64.pg15 : postgresql-15-pg-stat-kcache postgresql-15-pg-stat-kcache_2.3.2-1.pgdg13+1_arm64.deb PGDG · 2.3.2 · 36.9KiB postgresql-15-pg-stat-kcache_2.3.1-1.pgdg13+1_arm64.deb PGDG · 2.3.1 · 36.8KiB	PGDG 2.3.2 d13.aarch64.pg14 : postgresql-14-pg-stat-kcache postgresql-14-pg-stat-kcache_2.3.2-1.pgdg13+1_arm64.deb PGDG · 2.3.2 · 36.9KiB postgresql-14-pg-stat-kcache_2.3.1-1.pgdg13+1_arm64.deb PGDG · 2.3.1 · 36.8KiB
u22.x86_64	PGDG 2.3.2 u22.x86_64.pg18 : postgresql-18-pg-stat-kcache postgresql-18-pg-stat-kcache_2.3.2-1.pgdg22.04+1_amd64.deb PGDG · 2.3.2 · 35.8KiB postgresql-18-pg-stat-kcache_2.3.1-1.pgdg22.04+1_amd64.deb PGDG · 2.3.1 · 35.8KiB	PGDG 2.3.2 u22.x86_64.pg17 : postgresql-17-pg-stat-kcache postgresql-17-pg-stat-kcache_2.3.2-1.pgdg22.04+1_amd64.deb PGDG · 2.3.2 · 39.2KiB postgresql-17-pg-stat-kcache_2.3.1-1.pgdg22.04+1_amd64.deb PGDG · 2.3.1 · 39.1KiB	PGDG 2.3.2 u22.x86_64.pg16 : postgresql-16-pg-stat-kcache postgresql-16-pg-stat-kcache_2.3.2-1.pgdg22.04+1_amd64.deb PGDG · 2.3.2 · 39.1KiB postgresql-16-pg-stat-kcache_2.3.1-1.pgdg22.04+1_amd64.deb PGDG · 2.3.1 · 39.1KiB	PGDG 2.3.2 u22.x86_64.pg15 : postgresql-15-pg-stat-kcache postgresql-15-pg-stat-kcache_2.3.2-1.pgdg22.04+1_amd64.deb PGDG · 2.3.2 · 39.2KiB postgresql-15-pg-stat-kcache_2.3.1-1.pgdg22.04+1_amd64.deb PGDG · 2.3.1 · 39.1KiB	PGDG 2.3.2 u22.x86_64.pg14 : postgresql-14-pg-stat-kcache postgresql-14-pg-stat-kcache_2.3.2-1.pgdg22.04+1_amd64.deb PGDG · 2.3.2 · 39.0KiB postgresql-14-pg-stat-kcache_2.3.1-1.pgdg22.04+1_amd64.deb PGDG · 2.3.1 · 38.9KiB
u22.aarch64	PGDG 2.3.2 u22.aarch64.pg18 : postgresql-18-pg-stat-kcache postgresql-18-pg-stat-kcache_2.3.2-1.pgdg22.04+1_arm64.deb PGDG · 2.3.2 · 35.3KiB postgresql-18-pg-stat-kcache_2.3.1-1.pgdg22.04+1_arm64.deb PGDG · 2.3.1 · 35.2KiB	PGDG 2.3.2 u22.aarch64.pg17 : postgresql-17-pg-stat-kcache postgresql-17-pg-stat-kcache_2.3.2-1.pgdg22.04+1_arm64.deb PGDG · 2.3.2 · 38.6KiB postgresql-17-pg-stat-kcache_2.3.1-1.pgdg22.04+1_arm64.deb PGDG · 2.3.1 · 38.6KiB	PGDG 2.3.2 u22.aarch64.pg16 : postgresql-16-pg-stat-kcache postgresql-16-pg-stat-kcache_2.3.2-1.pgdg22.04+1_arm64.deb PGDG · 2.3.2 · 38.6KiB postgresql-16-pg-stat-kcache_2.3.1-1.pgdg22.04+1_arm64.deb PGDG · 2.3.1 · 38.5KiB	PGDG 2.3.2 u22.aarch64.pg15 : postgresql-15-pg-stat-kcache postgresql-15-pg-stat-kcache_2.3.2-1.pgdg22.04+1_arm64.deb PGDG · 2.3.2 · 38.6KiB postgresql-15-pg-stat-kcache_2.3.1-1.pgdg22.04+1_arm64.deb PGDG · 2.3.1 · 38.6KiB	PGDG 2.3.2 u22.aarch64.pg14 : postgresql-14-pg-stat-kcache postgresql-14-pg-stat-kcache_2.3.2-1.pgdg22.04+1_arm64.deb PGDG · 2.3.2 · 38.5KiB postgresql-14-pg-stat-kcache_2.3.1-1.pgdg22.04+1_arm64.deb PGDG · 2.3.1 · 38.4KiB
u24.x86_64	PGDG 2.3.2 u24.x86_64.pg18 : postgresql-18-pg-stat-kcache postgresql-18-pg-stat-kcache_2.3.2-1.pgdg24.04+1_amd64.deb PGDG · 2.3.2 · 35.2KiB postgresql-18-pg-stat-kcache_2.3.1-1.pgdg24.04+1_amd64.deb PGDG · 2.3.1 · 35.2KiB	PGDG 2.3.2 u24.x86_64.pg17 : postgresql-17-pg-stat-kcache postgresql-17-pg-stat-kcache_2.3.2-1.pgdg24.04+1_amd64.deb PGDG · 2.3.2 · 35.3KiB postgresql-17-pg-stat-kcache_2.3.1-1.pgdg24.04+1_amd64.deb PGDG · 2.3.1 · 35.2KiB	PGDG 2.3.2 u24.x86_64.pg16 : postgresql-16-pg-stat-kcache postgresql-16-pg-stat-kcache_2.3.2-1.pgdg24.04+1_amd64.deb PGDG · 2.3.2 · 35.3KiB postgresql-16-pg-stat-kcache_2.3.1-1.pgdg24.04+1_amd64.deb PGDG · 2.3.1 · 35.2KiB	PGDG 2.3.2 u24.x86_64.pg15 : postgresql-15-pg-stat-kcache postgresql-15-pg-stat-kcache_2.3.2-1.pgdg24.04+1_amd64.deb PGDG · 2.3.2 · 35.3KiB postgresql-15-pg-stat-kcache_2.3.1-1.pgdg24.04+1_amd64.deb PGDG · 2.3.1 · 35.3KiB	PGDG 2.3.2 u24.x86_64.pg14 : postgresql-14-pg-stat-kcache postgresql-14-pg-stat-kcache_2.3.2-1.pgdg24.04+1_amd64.deb PGDG · 2.3.2 · 35.3KiB postgresql-14-pg-stat-kcache_2.3.1-1.pgdg24.04+1_amd64.deb PGDG · 2.3.1 · 35.3KiB
u24.aarch64	PGDG 2.3.2 u24.aarch64.pg18 : postgresql-18-pg-stat-kcache postgresql-18-pg-stat-kcache_2.3.2-1.pgdg24.04+1_arm64.deb PGDG · 2.3.2 · 34.8KiB postgresql-18-pg-stat-kcache_2.3.1-1.pgdg24.04+1_arm64.deb PGDG · 2.3.1 · 34.8KiB	PGDG 2.3.2 u24.aarch64.pg17 : postgresql-17-pg-stat-kcache postgresql-17-pg-stat-kcache_2.3.2-1.pgdg24.04+1_arm64.deb PGDG · 2.3.2 · 34.8KiB postgresql-17-pg-stat-kcache_2.3.1-1.pgdg24.04+1_arm64.deb PGDG · 2.3.1 · 34.8KiB	PGDG 2.3.2 u24.aarch64.pg16 : postgresql-16-pg-stat-kcache postgresql-16-pg-stat-kcache_2.3.2-1.pgdg24.04+1_arm64.deb PGDG · 2.3.2 · 34.8KiB postgresql-16-pg-stat-kcache_2.3.1-1.pgdg24.04+1_arm64.deb PGDG · 2.3.1 · 34.7KiB	PGDG 2.3.2 u24.aarch64.pg15 : postgresql-15-pg-stat-kcache postgresql-15-pg-stat-kcache_2.3.2-1.pgdg24.04+1_arm64.deb PGDG · 2.3.2 · 34.9KiB postgresql-15-pg-stat-kcache_2.3.1-1.pgdg24.04+1_arm64.deb PGDG · 2.3.1 · 34.8KiB	PGDG 2.3.2 u24.aarch64.pg14 : postgresql-14-pg-stat-kcache postgresql-14-pg-stat-kcache_2.3.2-1.pgdg24.04+1_arm64.deb PGDG · 2.3.2 · 34.9KiB postgresql-14-pg-stat-kcache_2.3.1-1.pgdg24.04+1_arm64.deb PGDG · 2.3.1 · 34.8KiB
u26.x86_64	PGDG 2.3.2 u26.x86_64.pg18 : postgresql-18-pg-stat-kcache postgresql-18-pg-stat-kcache_2.3.2-1.pgdg26.04+1_amd64.deb PGDG · 2.3.2 · 34.9KiB postgresql-18-pg-stat-kcache_2.3.1-1.pgdg26.04+1_amd64.deb PGDG · 2.3.1 · 35.1KiB	PGDG 2.3.2 u26.x86_64.pg17 : postgresql-17-pg-stat-kcache postgresql-17-pg-stat-kcache_2.3.2-1.pgdg26.04+1_amd64.deb PGDG · 2.3.2 · 34.9KiB postgresql-17-pg-stat-kcache_2.3.1-1.pgdg26.04+1_amd64.deb PGDG · 2.3.1 · 35.1KiB	PGDG 2.3.2 u26.x86_64.pg16 : postgresql-16-pg-stat-kcache postgresql-16-pg-stat-kcache_2.3.2-1.pgdg26.04+1_amd64.deb PGDG · 2.3.2 · 35.0KiB postgresql-16-pg-stat-kcache_2.3.1-1.pgdg26.04+1_amd64.deb PGDG · 2.3.1 · 35.1KiB	PGDG 2.3.2 u26.x86_64.pg15 : postgresql-15-pg-stat-kcache postgresql-15-pg-stat-kcache_2.3.2-1.pgdg26.04+1_amd64.deb PGDG · 2.3.2 · 35.1KiB postgresql-15-pg-stat-kcache_2.3.1-1.pgdg26.04+1_amd64.deb PGDG · 2.3.1 · 35.3KiB	PGDG 2.3.2 u26.x86_64.pg14 : postgresql-14-pg-stat-kcache postgresql-14-pg-stat-kcache_2.3.2-1.pgdg26.04+1_amd64.deb PGDG · 2.3.2 · 35.1KiB postgresql-14-pg-stat-kcache_2.3.1-1.pgdg26.04+1_amd64.deb PGDG · 2.3.1 · 35.3KiB
u26.aarch64	PGDG 2.3.2 u26.aarch64.pg18 : postgresql-18-pg-stat-kcache postgresql-18-pg-stat-kcache_2.3.2-1.pgdg26.04+1_arm64.deb PGDG · 2.3.2 · 34.4KiB postgresql-18-pg-stat-kcache_2.3.1-1.pgdg26.04+1_arm64.deb PGDG · 2.3.1 · 34.5KiB	PGDG 2.3.2 u26.aarch64.pg17 : postgresql-17-pg-stat-kcache postgresql-17-pg-stat-kcache_2.3.2-1.pgdg26.04+1_arm64.deb PGDG · 2.3.2 · 34.4KiB postgresql-17-pg-stat-kcache_2.3.1-1.pgdg26.04+1_arm64.deb PGDG · 2.3.1 · 34.6KiB	PGDG 2.3.2 u26.aarch64.pg16 : postgresql-16-pg-stat-kcache postgresql-16-pg-stat-kcache_2.3.2-1.pgdg26.04+1_arm64.deb PGDG · 2.3.2 · 34.4KiB postgresql-16-pg-stat-kcache_2.3.1-1.pgdg26.04+1_arm64.deb PGDG · 2.3.1 · 34.5KiB	PGDG 2.3.2 u26.aarch64.pg15 : postgresql-15-pg-stat-kcache postgresql-15-pg-stat-kcache_2.3.2-1.pgdg26.04+1_arm64.deb PGDG · 2.3.2 · 34.4KiB postgresql-15-pg-stat-kcache_2.3.1-1.pgdg26.04+1_arm64.deb PGDG · 2.3.1 · 34.6KiB	PGDG 2.3.2 u26.aarch64.pg14 : postgresql-14-pg-stat-kcache postgresql-14-pg-stat-kcache_2.3.2-1.pgdg26.04+1_arm64.deb PGDG · 2.3.2 · 34.3KiB postgresql-14-pg-stat-kcache_2.3.1-1.pgdg26.04+1_arm64.deb PGDG · 2.3.1 · 34.5KiB

Install

You can install pg_stat_kcache directly. First, make sure the PGDG repository is added and enabled:

pig repo add pgdg -u          # Add PGDG repo and update cache

Install the extension using pig or apt/yum/dnf:

Install

pig install pg_stat_kcache;          # Install for current active PG version

pig

pig ext install -y pg_stat_kcache -v 18  # PG 18
pig ext install -y pg_stat_kcache -v 17  # PG 17
pig ext install -y pg_stat_kcache -v 16  # PG 16
pig ext install -y pg_stat_kcache -v 15  # PG 15
pig ext install -y pg_stat_kcache -v 14  # PG 14

dnf

dnf install -y pg_stat_kcache_18       # PG 18
dnf install -y pg_stat_kcache_17       # PG 17
dnf install -y pg_stat_kcache_16       # PG 16
dnf install -y pg_stat_kcache_15       # PG 15
dnf install -y pg_stat_kcache_14       # PG 14

apt

apt install -y postgresql-18-pg-stat-kcache   # PG 18
apt install -y postgresql-17-pg-stat-kcache   # PG 17
apt install -y postgresql-16-pg-stat-kcache   # PG 16
apt install -y postgresql-15-pg-stat-kcache   # PG 15
apt install -y postgresql-14-pg-stat-kcache   # PG 14

Preload:

shared_preload_libraries = 'pg_stat_statements, pg_stat_kcache';

Create Extension:

CREATE EXTENSION pg_stat_kcache CASCADE;  -- requires: pg_stat_statements

Usage

pg_stat_kcache: kernel cache statistics for PostgreSQL

pg_stat_kcache gathers statistics about real reads and writes done by the filesystem layer, as well as CPU usage per query. It requires pg_stat_statements.

Views

pg_stat_kcache – aggregated per-database statistics:

Column	Type	Description
`datname`	name	Database name
`exec_user_time`	double precision	User CPU time executing statements (seconds)
`exec_system_time`	double precision	System CPU time executing statements (seconds)
`exec_reads`	bigint	Bytes read by filesystem layer
`exec_reads_blks`	bigint	8K blocks read by filesystem layer
`exec_writes`	bigint	Bytes written by filesystem layer
`exec_writes_blks`	bigint	8K blocks written by filesystem layer
`plan_user_time`	double precision	User CPU time planning (if tracking enabled)
`plan_system_time`	double precision	System CPU time planning (if tracking enabled)

pg_stat_kcache_detail – per-query statistics including query text, role, and database.

Functions

-- Reset all collected statistics
SELECT pg_stat_kcache_reset();

Configuration

Parameter	Default	Description
`pg_stat_kcache.linux_hz`	-1	Linux CONFIG_HZ (auto-detected)
`pg_stat_kcache.track`	`top`	Track: `top`, `all`, or `none`
`pg_stat_kcache.track_planning`	`off`	Track planning statistics (PG 13+)

Example

SELECT datname, exec_user_time, exec_system_time, exec_reads, exec_writes
FROM pg_stat_kcache;

SELECT query, exec_user_time, exec_system_time, exec_reads
FROM pg_stat_kcache_detail
ORDER BY exec_user_time DESC
LIMIT 10;

pg_stat_kcache

Overview

Version

Install

Usage

Views

Functions

Configuration

Example

Was this page helpful?