pg_stat_log

Extensions

pg_stat_log

pg_stat_log : Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE.

Overview

ID	Extension	Package	Version	Category	License	Language
6040	pg_stat_log	pg_stat_log	`0.1`	STAT	PostgreSQL	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--sLd-r	No	Yes	Yes	Yes	yes	no

Relationships
See Also	pg_stat_statements pg_stat_monitor pg_stat_plans

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	PGDG	`0.1`	18 17 16 15 14	`pg_stat_log`	-
RPM	PGDG	`0.1`	18 17 16 15 14	`pg_stat_log_$v`	-
DEB	PGDG	`0.1`	18 17 16 15 14	`postgresql-$v-stat-log`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PGDG 0.1	MISS	MISS	MISS	MISS
el8.aarch64	PGDG 0.1	MISS	MISS	MISS	MISS
el9.x86_64	PGDG 0.1	MISS	MISS	MISS	MISS
el9.aarch64	PGDG 0.1	MISS	MISS	MISS	MISS
el10.x86_64	PGDG 0.1	MISS	MISS	MISS	MISS
el10.aarch64	PGDG 0.1	MISS	MISS	MISS	MISS
d12.x86_64	PGDG 0.1	MISS	MISS	MISS	MISS
d12.aarch64	PGDG 0.1	MISS	MISS	MISS	MISS
d13.x86_64	PGDG 0.1	MISS	MISS	MISS	MISS
d13.aarch64	PGDG 0.1	MISS	MISS	MISS	MISS
u22.x86_64	PGDG 0.1	MISS	MISS	MISS	MISS
u22.aarch64	PGDG 0.1	MISS	MISS	MISS	MISS
u24.x86_64	PGDG 0.1	MISS	MISS	MISS	MISS
u24.aarch64	PGDG 0.1	MISS	MISS	MISS	MISS
u26.x86_64	PGDG 0.1	MISS	MISS	MISS	MISS
u26.aarch64	PGDG 0.1	MISS	MISS	MISS	MISS

Package	Version	OS	ORG	SIZE	File URL
`pg_stat_log_18`	`0.1`	el8.x86_64	pgdg	23.2 KiB	pg_stat_log_18-0.1-1PGDG.rhel8.10.x86_64.rpm
`pg_stat_log_18`	`0.1`	el8.aarch64	pgdg	23.1 KiB	pg_stat_log_18-0.1-1PGDG.rhel8.10.aarch64.rpm
`pg_stat_log_18`	`0.1`	el9.x86_64	pgdg	23.4 KiB	pg_stat_log_18-0.1-1PGDG.rhel9.8.x86_64.rpm
`pg_stat_log_18`	`0.1`	el9.aarch64	pgdg	23.4 KiB	pg_stat_log_18-0.1-1PGDG.rhel9.8.aarch64.rpm
`pg_stat_log_18`	`0.1`	el10.x86_64	pgdg	23.5 KiB	pg_stat_log_18-0.1-1PGDG.rhel10.2.x86_64.rpm
`pg_stat_log_18`	`0.1`	el10.aarch64	pgdg	23.7 KiB	pg_stat_log_18-0.1-1PGDG.rhel10.2.aarch64.rpm
`postgresql-18-stat-log`	`0.1`	d12.x86_64	pgdg	42.2 KiB	postgresql-18-stat-log_0.1-1.pgdg12+1_amd64.deb
`postgresql-18-stat-log`	`0.1`	d12.aarch64	pgdg	42.2 KiB	postgresql-18-stat-log_0.1-1.pgdg12+1_arm64.deb
`postgresql-18-stat-log`	`0.1`	d13.x86_64	pgdg	42.1 KiB	postgresql-18-stat-log_0.1-1.pgdg13+1_amd64.deb
`postgresql-18-stat-log`	`0.1`	d13.aarch64	pgdg	42.3 KiB	postgresql-18-stat-log_0.1-1.pgdg13+1_arm64.deb
`postgresql-18-stat-log`	`0.1`	u22.x86_64	pgdg	42.6 KiB	postgresql-18-stat-log_0.1-1.pgdg22.04+1_amd64.deb
`postgresql-18-stat-log`	`0.1`	u22.aarch64	pgdg	42.4 KiB	postgresql-18-stat-log_0.1-1.pgdg22.04+1_arm64.deb
`postgresql-18-stat-log`	`0.1`	u24.x86_64	pgdg	42.4 KiB	postgresql-18-stat-log_0.1-1.pgdg24.04+1_amd64.deb
`postgresql-18-stat-log`	`0.1`	u24.aarch64	pgdg	42.2 KiB	postgresql-18-stat-log_0.1-1.pgdg24.04+1_arm64.deb
`postgresql-18-stat-log`	`0.1`	u26.x86_64	pgdg	42.2 KiB	postgresql-18-stat-log_0.1-1.pgdg26.04+1_amd64.deb
`postgresql-18-stat-log`	`0.1`	u26.aarch64	pgdg	42.2 KiB	postgresql-18-stat-log_0.1-1.pgdg26.04+1_arm64.deb

Source

Repository

github.com/fabriziomello/pg_stat_log

Install

Make sure PGDG repo available:

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

Install this extension with pig:

pig install pg_stat_log;		# install via package name, for the active PG version

pig install pg_stat_log -v 18;   # install for PG 18

Config this extension to shared_preload_libraries:

shared_preload_libraries = '$libdir/pg_stat_log';

Create this extension with:

CREATE EXTENSION pg_stat_log;

Last updated on 2026-06-25

pg_stat_backtrace pg_stat_plans