pg_stat_kcache

内核统计信息收集

概览

扩展包名	版本	分类	许可证	语言
`pg_stat_kcache`	`2.3.2`	STAT	BSD-3-Clause	C

ID	扩展名	Bin	Lib	Load	Create	Trust	Reloc	模式
6220	`pg_stat_kcache`	否	是	是	是	否	是	-

相关扩展	`pg_stat_statements` `pgnodemx` `system_stats` `pgmeminfo` `pgmonitor` `pg_stat_ch` `pg_datasentinel` `pgsentinel`

版本

类型	仓库	版本	PG 大版本	包名	依赖
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

安装

您可以直接安装 pg_stat_kcache 扩展包的预置二进制包，首先确保 PGDG 仓库已经添加并启用：

BASH

pig repo add pgdg -u          # 添加 PGDG 仓库并更新缓存

使用 pig 或者是 apt/yum/dnf 安装扩展：

安装

BASH

pig install pg_stat_kcache;          # 当前活跃 PG 版本安装

pig

BASH

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

BASH

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

BASH

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

预加载配置：

BASH

shared_preload_libraries = 'pg_stat_statements, pg_stat_kcache';

创建扩展：

SQL

CREATE EXTENSION pg_stat_kcache CASCADE;  -- 依赖: pg_stat_statements

用法

pg_stat_kcache: PostgreSQL 内核缓存统计

pg_stat_kcache 收集文件系统层实际读写的统计信息，以及每个查询的 CPU 使用情况。它依赖 pg_stat_statements。

视图

pg_stat_kcache – 按数据库汇总的统计信息：

列名	类型	描述
`datname`	name	数据库名称
`exec_user_time`	double precision	执行语句的用户 CPU 时间（秒）
`exec_system_time`	double precision	执行语句的系统 CPU 时间（秒）
`exec_reads`	bigint	文件系统层读取的字节数
`exec_reads_blks`	bigint	文件系统层读取的 8K 块数
`exec_writes`	bigint	文件系统层写入的字节数
`exec_writes_blks`	bigint	文件系统层写入的 8K 块数
`plan_user_time`	double precision	规划阶段的用户 CPU 时间（启用追踪时）
`plan_system_time`	double precision	规划阶段的系统 CPU 时间（启用追踪时）

pg_stat_kcache_detail – 按查询的统计信息，包含查询文本、角色和数据库。

函数

SQL

-- 重置所有已收集的统计信息
SELECT pg_stat_kcache_reset();

配置

参数	默认值	描述
`pg_stat_kcache.linux_hz`	-1	Linux CONFIG_HZ（自动检测）
`pg_stat_kcache.track`	`top`	追踪级别：`top`、`all` 或 `none`
`pg_stat_kcache.track_planning`	`off`	追踪规划统计信息（PG 13+）

示例

SQL

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;

意见反馈

这个页面对您有帮助吗？

感谢反馈！请告诉我们如何改进。

抱歉给您带来不便。请告诉我们如何改进。