logerrors

Function for collecting statistics about messages in logfile

BSD-3-Clause

PGDG

logerrors : Function for collecting statistics about messages in logfile

Overview

ID	Extension	Package	Version	Category	License	Language
7140	logerrors	logerrors	`2.1.5`	SEC	BSD-3-Clause	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_log pgelog pg_sqlog log_fdw pgaudit pgdisablelogerror pg_auth_mon pgfr_record

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	MIXED	`2.1.5`	18 17 16 15 14	`logerrors`	-
RPM	PGDG	`2.1.5`	18 17 16 15 14	`logerrors_$v`	-
DEB	PIGSTY	`2.1.5`	18 17 16 15 14	`postgresql-$v-logerrors`	-

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

Package	Version	OS	ORG	SIZE	File URL
`logerrors_18`	`2.1.5`	el8.x86_64	pgdg	23.3 KiB	logerrors_18-2.1.5-1PGDG.rhel8.x86_64.rpm
`logerrors_18`	`2.1.5`	el8.aarch64	pgdg	23.4 KiB	logerrors_18-2.1.5-1PGDG.rhel8.aarch64.rpm
`logerrors_18`	`2.1.5`	el9.x86_64	pgdg	22.9 KiB	logerrors_18-2.1.5-3PGDG.rhel9.8.x86_64.rpm
`logerrors_18`	`2.1.5`	el9.x86_64	pgdg	22.7 KiB	logerrors_18-2.1.5-1PGDG.rhel9.x86_64.rpm
`logerrors_18`	`2.1.5`	el9.aarch64	pgdg	23.1 KiB	logerrors_18-2.1.5-3PGDG.rhel9.8.aarch64.rpm
`logerrors_18`	`2.1.5`	el9.aarch64	pgdg	22.9 KiB	logerrors_18-2.1.5-1PGDG.rhel9.aarch64.rpm
`logerrors_18`	`2.1.5`	el10.x86_64	pgdg	23.1 KiB	logerrors_18-2.1.5-3PGDG.rhel10.2.x86_64.rpm
`logerrors_18`	`2.1.5`	el10.x86_64	pgdg	23.2 KiB	logerrors_18-2.1.5-1PGDG.rhel10.x86_64.rpm
`logerrors_18`	`2.1.5`	el10.aarch64	pgdg	23.5 KiB	logerrors_18-2.1.5-3PGDG.rhel10.2.aarch64.rpm
`logerrors_18`	`2.1.5`	el10.aarch64	pgdg	23.4 KiB	logerrors_18-2.1.5-1PGDG.rhel10.aarch64.rpm
`postgresql-18-logerrors`	`2.1.5`	d12.x86_64	pigsty	30.8 KiB	postgresql-18-logerrors_2.1.5-1PIGSTY~bookworm_amd64.deb
`postgresql-18-logerrors`	`2.1.5`	d12.aarch64	pigsty	30.3 KiB	postgresql-18-logerrors_2.1.5-1PIGSTY~bookworm_arm64.deb
`postgresql-18-logerrors`	`2.1.5`	d13.x86_64	pigsty	30.8 KiB	postgresql-18-logerrors_2.1.5-1PIGSTY~trixie_amd64.deb
`postgresql-18-logerrors`	`2.1.5`	d13.aarch64	pigsty	30.5 KiB	postgresql-18-logerrors_2.1.5-1PIGSTY~trixie_arm64.deb
`postgresql-18-logerrors`	`2.1.5`	u22.x86_64	pigsty	33.5 KiB	postgresql-18-logerrors_2.1.5-1PIGSTY~jammy_amd64.deb
`postgresql-18-logerrors`	`2.1.5`	u22.aarch64	pigsty	33.5 KiB	postgresql-18-logerrors_2.1.5-1PIGSTY~jammy_arm64.deb
`postgresql-18-logerrors`	`2.1.5`	u24.x86_64	pigsty	32.4 KiB	postgresql-18-logerrors_2.1.5-1PIGSTY~noble_amd64.deb
`postgresql-18-logerrors`	`2.1.5`	u24.aarch64	pigsty	32.2 KiB	postgresql-18-logerrors_2.1.5-1PIGSTY~noble_arm64.deb
`postgresql-18-logerrors`	`2.1.5`	u26.x86_64	pigsty	32.0 KiB	postgresql-18-logerrors_2.1.5-1PIGSTY~resolute_amd64.deb
`postgresql-18-logerrors`	`2.1.5`	u26.aarch64	pigsty	32.7 KiB	postgresql-18-logerrors_2.1.5-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`logerrors_17`	`2.1.5`	el8.x86_64	pgdg	23.3 KiB	logerrors_17-2.1.5-1PGDG.rhel8.x86_64.rpm
`logerrors_17`	`2.1.3`	el8.x86_64	pgdg	22.9 KiB	logerrors_17-2.1.3-1PGDG.rhel8.x86_64.rpm
`logerrors_17`	`2.1.5`	el8.aarch64	pgdg	23.5 KiB	logerrors_17-2.1.5-1PGDG.rhel8.aarch64.rpm
`logerrors_17`	`2.1.3`	el8.aarch64	pgdg	23.1 KiB	logerrors_17-2.1.3-1PGDG.rhel8.aarch64.rpm
`logerrors_17`	`2.1.5`	el9.x86_64	pgdg	22.9 KiB	logerrors_17-2.1.5-3PGDG.rhel9.8.x86_64.rpm
`logerrors_17`	`2.1.5`	el9.x86_64	pgdg	22.7 KiB	logerrors_17-2.1.5-1PGDG.rhel9.x86_64.rpm
`logerrors_17`	`2.1.3`	el9.x86_64	pgdg	23.3 KiB	logerrors_17-2.1.3-1PGDG.rhel9.x86_64.rpm
`logerrors_17`	`2.1.5`	el9.aarch64	pgdg	23.2 KiB	logerrors_17-2.1.5-3PGDG.rhel9.8.aarch64.rpm
`logerrors_17`	`2.1.5`	el9.aarch64	pgdg	22.9 KiB	logerrors_17-2.1.5-1PGDG.rhel9.aarch64.rpm
`logerrors_17`	`2.1.3`	el9.aarch64	pgdg	23.4 KiB	logerrors_17-2.1.3-1PGDG.rhel9.aarch64.rpm
`logerrors_17`	`2.1.5`	el10.x86_64	pgdg	23.1 KiB	logerrors_17-2.1.5-3PGDG.rhel10.2.x86_64.rpm
`logerrors_17`	`2.1.5`	el10.x86_64	pgdg	23.2 KiB	logerrors_17-2.1.5-1PGDG.rhel10.x86_64.rpm
`logerrors_17`	`2.1.3`	el10.x86_64	pgdg	23.6 KiB	logerrors_17-2.1.3-2PGDG.rhel10.x86_64.rpm
`logerrors_17`	`2.1.5`	el10.aarch64	pgdg	23.4 KiB	logerrors_17-2.1.5-3PGDG.rhel10.2.aarch64.rpm
`logerrors_17`	`2.1.5`	el10.aarch64	pgdg	23.5 KiB	logerrors_17-2.1.5-1PGDG.rhel10.aarch64.rpm
`logerrors_17`	`2.1.3`	el10.aarch64	pgdg	23.9 KiB	logerrors_17-2.1.3-2PGDG.rhel10.aarch64.rpm
`postgresql-17-logerrors`	`2.1.5`	d12.x86_64	pigsty	30.8 KiB	postgresql-17-logerrors_2.1.5-1PIGSTY~bookworm_amd64.deb
`postgresql-17-logerrors`	`2.1.5`	d12.aarch64	pigsty	30.3 KiB	postgresql-17-logerrors_2.1.5-1PIGSTY~bookworm_arm64.deb
`postgresql-17-logerrors`	`2.1.5`	d13.x86_64	pigsty	30.8 KiB	postgresql-17-logerrors_2.1.5-1PIGSTY~trixie_amd64.deb
`postgresql-17-logerrors`	`2.1.5`	d13.aarch64	pigsty	30.5 KiB	postgresql-17-logerrors_2.1.5-1PIGSTY~trixie_arm64.deb
`postgresql-17-logerrors`	`2.1.5`	u22.x86_64	pigsty	38.7 KiB	postgresql-17-logerrors_2.1.5-1PIGSTY~jammy_amd64.deb
`postgresql-17-logerrors`	`2.1.5`	u22.aarch64	pigsty	38.3 KiB	postgresql-17-logerrors_2.1.5-1PIGSTY~jammy_arm64.deb
`postgresql-17-logerrors`	`2.1.5`	u24.x86_64	pigsty	32.4 KiB	postgresql-17-logerrors_2.1.5-1PIGSTY~noble_amd64.deb
`postgresql-17-logerrors`	`2.1.5`	u24.aarch64	pigsty	32.2 KiB	postgresql-17-logerrors_2.1.5-1PIGSTY~noble_arm64.deb
`postgresql-17-logerrors`	`2.1.5`	u26.x86_64	pigsty	31.9 KiB	postgresql-17-logerrors_2.1.5-1PIGSTY~resolute_amd64.deb
`postgresql-17-logerrors`	`2.1.5`	u26.aarch64	pigsty	32.7 KiB	postgresql-17-logerrors_2.1.5-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`logerrors_16`	`2.1.5`	el8.x86_64	pgdg	23.3 KiB	logerrors_16-2.1.5-1PGDG.rhel8.x86_64.rpm
`logerrors_16`	`2.1.3`	el8.x86_64	pgdg	22.9 KiB	logerrors_16-2.1.3-1PGDG.rhel8.x86_64.rpm
`logerrors_16`	`2.1.2`	el8.x86_64	pgdg	22.1 KiB	logerrors_16-2.1.2-1.rhel8.x86_64.rpm
`logerrors_16`	`2.1.5`	el8.aarch64	pgdg	23.5 KiB	logerrors_16-2.1.5-1PGDG.rhel8.aarch64.rpm
`logerrors_16`	`2.1.3`	el8.aarch64	pgdg	23.1 KiB	logerrors_16-2.1.3-1PGDG.rhel8.aarch64.rpm
`logerrors_16`	`2.1.2`	el8.aarch64	pgdg	22.2 KiB	logerrors_16-2.1.2-1.rhel8.aarch64.rpm
`logerrors_16`	`2.1.5`	el9.x86_64	pgdg	22.9 KiB	logerrors_16-2.1.5-3PGDG.rhel9.8.x86_64.rpm
`logerrors_16`	`2.1.5`	el9.x86_64	pgdg	22.7 KiB	logerrors_16-2.1.5-1PGDG.rhel9.x86_64.rpm
`logerrors_16`	`2.1.3`	el9.x86_64	pgdg	23.3 KiB	logerrors_16-2.1.3-1PGDG.rhel9.x86_64.rpm
`logerrors_16`	`2.1.2`	el9.x86_64	pgdg	22.0 KiB	logerrors_16-2.1.2-1.rhel9.x86_64.rpm
`logerrors_16`	`2.1.5`	el9.aarch64	pgdg	23.2 KiB	logerrors_16-2.1.5-3PGDG.rhel9.8.aarch64.rpm
`logerrors_16`	`2.1.5`	el9.aarch64	pgdg	22.9 KiB	logerrors_16-2.1.5-1PGDG.rhel9.aarch64.rpm
`logerrors_16`	`2.1.3`	el9.aarch64	pgdg	23.4 KiB	logerrors_16-2.1.3-1PGDG.rhel9.aarch64.rpm
`logerrors_16`	`2.1.2`	el9.aarch64	pgdg	21.8 KiB	logerrors_16-2.1.2-1.rhel9.aarch64.rpm
`logerrors_16`	`2.1.5`	el10.x86_64	pgdg	23.1 KiB	logerrors_16-2.1.5-3PGDG.rhel10.2.x86_64.rpm
`logerrors_16`	`2.1.5`	el10.x86_64	pgdg	23.2 KiB	logerrors_16-2.1.5-1PGDG.rhel10.x86_64.rpm
`logerrors_16`	`2.1.3`	el10.x86_64	pgdg	23.6 KiB	logerrors_16-2.1.3-2PGDG.rhel10.x86_64.rpm
`logerrors_16`	`2.1.5`	el10.aarch64	pgdg	23.5 KiB	logerrors_16-2.1.5-3PGDG.rhel10.2.aarch64.rpm
`logerrors_16`	`2.1.5`	el10.aarch64	pgdg	23.6 KiB	logerrors_16-2.1.5-1PGDG.rhel10.aarch64.rpm
`logerrors_16`	`2.1.3`	el10.aarch64	pgdg	23.9 KiB	logerrors_16-2.1.3-2PGDG.rhel10.aarch64.rpm
`postgresql-16-logerrors`	`2.1.5`	d12.x86_64	pigsty	30.8 KiB	postgresql-16-logerrors_2.1.5-1PIGSTY~bookworm_amd64.deb
`postgresql-16-logerrors`	`2.1.5`	d12.aarch64	pigsty	30.3 KiB	postgresql-16-logerrors_2.1.5-1PIGSTY~bookworm_arm64.deb
`postgresql-16-logerrors`	`2.1.5`	d13.x86_64	pigsty	30.8 KiB	postgresql-16-logerrors_2.1.5-1PIGSTY~trixie_amd64.deb
`postgresql-16-logerrors`	`2.1.5`	d13.aarch64	pigsty	30.5 KiB	postgresql-16-logerrors_2.1.5-1PIGSTY~trixie_arm64.deb
`postgresql-16-logerrors`	`2.1.5`	u22.x86_64	pigsty	38.3 KiB	postgresql-16-logerrors_2.1.5-1PIGSTY~jammy_amd64.deb
`postgresql-16-logerrors`	`2.1.5`	u22.aarch64	pigsty	37.9 KiB	postgresql-16-logerrors_2.1.5-1PIGSTY~jammy_arm64.deb
`postgresql-16-logerrors`	`2.1.5`	u24.x86_64	pigsty	32.4 KiB	postgresql-16-logerrors_2.1.5-1PIGSTY~noble_amd64.deb
`postgresql-16-logerrors`	`2.1.5`	u24.aarch64	pigsty	32.2 KiB	postgresql-16-logerrors_2.1.5-1PIGSTY~noble_arm64.deb
`postgresql-16-logerrors`	`2.1.5`	u26.x86_64	pigsty	31.9 KiB	postgresql-16-logerrors_2.1.5-1PIGSTY~resolute_amd64.deb
`postgresql-16-logerrors`	`2.1.5`	u26.aarch64	pigsty	32.7 KiB	postgresql-16-logerrors_2.1.5-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`logerrors_15`	`2.1.5`	el8.x86_64	pgdg	23.4 KiB	logerrors_15-2.1.5-1PGDG.rhel8.x86_64.rpm
`logerrors_15`	`2.1.3`	el8.x86_64	pgdg	23.1 KiB	logerrors_15-2.1.3-1PGDG.rhel8.x86_64.rpm
`logerrors_15`	`2.1.2`	el8.x86_64	pgdg	22.3 KiB	logerrors_15-2.1.2-1.rhel8.x86_64.rpm
`logerrors_15`	`2.1`	el8.x86_64	pgdg	21.1 KiB	logerrors_15-2.1-2.rhel8.x86_64.rpm
`logerrors_15`	`2.1`	el8.x86_64	pgdg	20.7 KiB	logerrors_15-2.1-1.rhel8.x86_64.rpm
`logerrors_15`	`2.0`	el8.x86_64	pgdg	19.9 KiB	logerrors_15-2.0-2.rhel8.x86_64.rpm
`logerrors_15`	`2.0`	el8.x86_64	pgdg	41.9 KiB	logerrors_15-2.0-1.rhel8.x86_64.rpm
`logerrors_15`	`2.1.5`	el8.aarch64	pgdg	23.6 KiB	logerrors_15-2.1.5-1PGDG.rhel8.aarch64.rpm
`logerrors_15`	`2.1.3`	el8.aarch64	pgdg	23.2 KiB	logerrors_15-2.1.3-1PGDG.rhel8.aarch64.rpm
`logerrors_15`	`2.1.2`	el8.aarch64	pgdg	22.4 KiB	logerrors_15-2.1.2-1.rhel8.aarch64.rpm
`logerrors_15`	`2.1`	el8.aarch64	pgdg	21.2 KiB	logerrors_15-2.1-2.rhel8.aarch64.rpm
`logerrors_15`	`2.1`	el8.aarch64	pgdg	20.8 KiB	logerrors_15-2.1-1.rhel8.aarch64.rpm
`logerrors_15`	`2.0`	el8.aarch64	pgdg	19.9 KiB	logerrors_15-2.0-2.rhel8.aarch64.rpm
`logerrors_15`	`2.0`	el8.aarch64	pgdg	41.7 KiB	logerrors_15-2.0-1.rhel8.aarch64.rpm
`logerrors_15`	`2.1.5`	el9.x86_64	pgdg	23.1 KiB	logerrors_15-2.1.5-3PGDG.rhel9.8.x86_64.rpm
`logerrors_15`	`2.1.5`	el9.x86_64	pgdg	22.9 KiB	logerrors_15-2.1.5-1PGDG.rhel9.x86_64.rpm
`logerrors_15`	`2.1.3`	el9.x86_64	pgdg	23.5 KiB	logerrors_15-2.1.3-1PGDG.rhel9.x86_64.rpm
`logerrors_15`	`2.1.2`	el9.x86_64	pgdg	22.7 KiB	logerrors_15-2.1.2-1.rhel9.x86_64.rpm
`logerrors_15`	`2.1`	el9.x86_64	pgdg	21.6 KiB	logerrors_15-2.1-2.rhel9.x86_64.rpm
`logerrors_15`	`2.1`	el9.x86_64	pgdg	21.2 KiB	logerrors_15-2.1-1.rhel9.x86_64.rpm
`logerrors_15`	`2.0`	el9.x86_64	pgdg	20.1 KiB	logerrors_15-2.0-2.rhel9.x86_64.rpm
`logerrors_15`	`2.0`	el9.x86_64	pgdg	42.8 KiB	logerrors_15-2.0-1.rhel9.x86_64.rpm
`logerrors_15`	`2.1.5`	el9.aarch64	pgdg	23.3 KiB	logerrors_15-2.1.5-3PGDG.rhel9.8.aarch64.rpm
`logerrors_15`	`2.1.5`	el9.aarch64	pgdg	23.0 KiB	logerrors_15-2.1.5-1PGDG.rhel9.aarch64.rpm
`logerrors_15`	`2.1.3`	el9.aarch64	pgdg	23.8 KiB	logerrors_15-2.1.3-1PGDG.rhel9.aarch64.rpm
`logerrors_15`	`2.1.2`	el9.aarch64	pgdg	22.6 KiB	logerrors_15-2.1.2-1.rhel9.aarch64.rpm
`logerrors_15`	`2.1`	el9.aarch64	pgdg	21.5 KiB	logerrors_15-2.1-2.rhel9.aarch64.rpm
`logerrors_15`	`2.1`	el9.aarch64	pgdg	20.9 KiB	logerrors_15-2.1-1.rhel9.aarch64.rpm
`logerrors_15`	`2.0`	el9.aarch64	pgdg	20.0 KiB	logerrors_15-2.0-2.rhel9.aarch64.rpm
`logerrors_15`	`2.0`	el9.aarch64	pgdg	42.4 KiB	logerrors_15-2.0-1.rhel9.aarch64.rpm
`logerrors_15`	`2.1.5`	el10.x86_64	pgdg	23.4 KiB	logerrors_15-2.1.5-3PGDG.rhel10.2.x86_64.rpm
`logerrors_15`	`2.1.5`	el10.x86_64	pgdg	23.4 KiB	logerrors_15-2.1.5-1PGDG.rhel10.x86_64.rpm
`logerrors_15`	`2.1.3`	el10.x86_64	pgdg	23.8 KiB	logerrors_15-2.1.3-2PGDG.rhel10.x86_64.rpm
`logerrors_15`	`2.1.5`	el10.aarch64	pgdg	23.6 KiB	logerrors_15-2.1.5-3PGDG.rhel10.2.aarch64.rpm
`logerrors_15`	`2.1.5`	el10.aarch64	pgdg	23.7 KiB	logerrors_15-2.1.5-1PGDG.rhel10.aarch64.rpm
`logerrors_15`	`2.1.3`	el10.aarch64	pgdg	24.0 KiB	logerrors_15-2.1.3-2PGDG.rhel10.aarch64.rpm
`postgresql-15-logerrors`	`2.1.5`	d12.x86_64	pigsty	30.9 KiB	postgresql-15-logerrors_2.1.5-1PIGSTY~bookworm_amd64.deb
`postgresql-15-logerrors`	`2.1.5`	d12.aarch64	pigsty	30.5 KiB	postgresql-15-logerrors_2.1.5-1PIGSTY~bookworm_arm64.deb
`postgresql-15-logerrors`	`2.1.5`	d13.x86_64	pigsty	31.0 KiB	postgresql-15-logerrors_2.1.5-1PIGSTY~trixie_amd64.deb
`postgresql-15-logerrors`	`2.1.5`	d13.aarch64	pigsty	30.7 KiB	postgresql-15-logerrors_2.1.5-1PIGSTY~trixie_arm64.deb
`postgresql-15-logerrors`	`2.1.5`	u22.x86_64	pigsty	38.5 KiB	postgresql-15-logerrors_2.1.5-1PIGSTY~jammy_amd64.deb
`postgresql-15-logerrors`	`2.1.5`	u22.aarch64	pigsty	38.1 KiB	postgresql-15-logerrors_2.1.5-1PIGSTY~jammy_arm64.deb
`postgresql-15-logerrors`	`2.1.5`	u24.x86_64	pigsty	32.6 KiB	postgresql-15-logerrors_2.1.5-1PIGSTY~noble_amd64.deb
`postgresql-15-logerrors`	`2.1.5`	u24.aarch64	pigsty	32.4 KiB	postgresql-15-logerrors_2.1.5-1PIGSTY~noble_arm64.deb
`postgresql-15-logerrors`	`2.1.5`	u26.x86_64	pigsty	32.1 KiB	postgresql-15-logerrors_2.1.5-1PIGSTY~resolute_amd64.deb
`postgresql-15-logerrors`	`2.1.5`	u26.aarch64	pigsty	32.8 KiB	postgresql-15-logerrors_2.1.5-1PIGSTY~resolute_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`logerrors_14`	`2.1.5`	el8.x86_64	pgdg	23.3 KiB	logerrors_14-2.1.5-1PGDG.rhel8.x86_64.rpm
`logerrors_14`	`2.1.3`	el8.x86_64	pgdg	23.0 KiB	logerrors_14-2.1.3-1PGDG.rhel8.x86_64.rpm
`logerrors_14`	`2.1.2`	el8.x86_64	pgdg	22.2 KiB	logerrors_14-2.1.2-1.rhel8.x86_64.rpm
`logerrors_14`	`2.1`	el8.x86_64	pgdg	21.1 KiB	logerrors_14-2.1-2.rhel8.x86_64.rpm
`logerrors_14`	`2.1`	el8.x86_64	pgdg	20.7 KiB	logerrors_14-2.1-1.rhel8.x86_64.rpm
`logerrors_14`	`2.0`	el8.x86_64	pgdg	19.8 KiB	logerrors_14-2.0-2.rhel8.x86_64.rpm
`logerrors_14`	`2.0`	el8.x86_64	pgdg	41.2 KiB	logerrors_14-2.0-1.rhel8.x86_64.rpm
`logerrors_14`	`2.1.5`	el8.aarch64	pgdg	23.5 KiB	logerrors_14-2.1.5-1PGDG.rhel8.aarch64.rpm
`logerrors_14`	`2.1.3`	el8.aarch64	pgdg	23.1 KiB	logerrors_14-2.1.3-1PGDG.rhel8.aarch64.rpm
`logerrors_14`	`2.1.2`	el8.aarch64	pgdg	22.3 KiB	logerrors_14-2.1.2-1.rhel8.aarch64.rpm
`logerrors_14`	`2.1`	el8.aarch64	pgdg	21.1 KiB	logerrors_14-2.1-2.rhel8.aarch64.rpm
`logerrors_14`	`2.1`	el8.aarch64	pgdg	20.7 KiB	logerrors_14-2.1-1.rhel8.aarch64.rpm
`logerrors_14`	`2.0`	el8.aarch64	pgdg	19.9 KiB	logerrors_14-2.0-2.rhel8.aarch64.rpm
`logerrors_14`	`2.0`	el8.aarch64	pgdg	39.9 KiB	logerrors_14-2.0-1.rhel8.aarch64.rpm
`logerrors_14`	`2.1.5`	el9.x86_64	pgdg	23.0 KiB	logerrors_14-2.1.5-3PGDG.rhel9.8.x86_64.rpm
`logerrors_14`	`2.1.5`	el9.x86_64	pgdg	22.8 KiB	logerrors_14-2.1.5-1PGDG.rhel9.x86_64.rpm
`logerrors_14`	`2.1.3`	el9.x86_64	pgdg	23.5 KiB	logerrors_14-2.1.3-1PGDG.rhel9.x86_64.rpm
`logerrors_14`	`2.1.2`	el9.x86_64	pgdg	22.6 KiB	logerrors_14-2.1.2-1.rhel9.x86_64.rpm
`logerrors_14`	`2.1`	el9.x86_64	pgdg	21.5 KiB	logerrors_14-2.1-2.rhel9.x86_64.rpm
`logerrors_14`	`2.1`	el9.x86_64	pgdg	21.1 KiB	logerrors_14-2.1-1.rhel9.x86_64.rpm
`logerrors_14`	`2.0`	el9.x86_64	pgdg	20.1 KiB	logerrors_14-2.0-2.rhel9.x86_64.rpm
`logerrors_14`	`2.1.5`	el9.aarch64	pgdg	23.3 KiB	logerrors_14-2.1.5-3PGDG.rhel9.8.aarch64.rpm
`logerrors_14`	`2.1.5`	el9.aarch64	pgdg	23.0 KiB	logerrors_14-2.1.5-1PGDG.rhel9.aarch64.rpm
`logerrors_14`	`2.1.3`	el9.aarch64	pgdg	23.8 KiB	logerrors_14-2.1.3-1PGDG.rhel9.aarch64.rpm
`logerrors_14`	`2.1.2`	el9.aarch64	pgdg	22.6 KiB	logerrors_14-2.1.2-1.rhel9.aarch64.rpm
`logerrors_14`	`2.1`	el9.aarch64	pgdg	21.3 KiB	logerrors_14-2.1-2.rhel9.aarch64.rpm
`logerrors_14`	`2.1`	el9.aarch64	pgdg	21.1 KiB	logerrors_14-2.1-1.rhel9.aarch64.rpm
`logerrors_14`	`2.0`	el9.aarch64	pgdg	20.2 KiB	logerrors_14-2.0-2.rhel9.aarch64.rpm
`logerrors_14`	`2.0`	el9.aarch64	pgdg	40.5 KiB	logerrors_14-2.0-1.rhel9.aarch64.rpm
`logerrors_14`	`2.1.5`	el10.x86_64	pgdg	23.3 KiB	logerrors_14-2.1.5-3PGDG.rhel10.2.x86_64.rpm
`logerrors_14`	`2.1.5`	el10.x86_64	pgdg	23.4 KiB	logerrors_14-2.1.5-1PGDG.rhel10.x86_64.rpm
`logerrors_14`	`2.1.3`	el10.x86_64	pgdg	23.7 KiB	logerrors_14-2.1.3-2PGDG.rhel10.x86_64.rpm
`logerrors_14`	`2.1.5`	el10.aarch64	pgdg	23.6 KiB	logerrors_14-2.1.5-3PGDG.rhel10.2.aarch64.rpm
`logerrors_14`	`2.1.5`	el10.aarch64	pgdg	23.7 KiB	logerrors_14-2.1.5-1PGDG.rhel10.aarch64.rpm
`logerrors_14`	`2.1.3`	el10.aarch64	pgdg	24.0 KiB	logerrors_14-2.1.3-2PGDG.rhel10.aarch64.rpm
`postgresql-14-logerrors`	`2.1.5`	d12.x86_64	pigsty	30.7 KiB	postgresql-14-logerrors_2.1.5-1PIGSTY~bookworm_amd64.deb
`postgresql-14-logerrors`	`2.1.5`	d12.aarch64	pigsty	30.5 KiB	postgresql-14-logerrors_2.1.5-1PIGSTY~bookworm_arm64.deb
`postgresql-14-logerrors`	`2.1.5`	d13.x86_64	pigsty	30.7 KiB	postgresql-14-logerrors_2.1.5-1PIGSTY~trixie_amd64.deb
`postgresql-14-logerrors`	`2.1.5`	d13.aarch64	pigsty	30.6 KiB	postgresql-14-logerrors_2.1.5-1PIGSTY~trixie_arm64.deb
`postgresql-14-logerrors`	`2.1.5`	u22.x86_64	pigsty	36.6 KiB	postgresql-14-logerrors_2.1.5-1PIGSTY~jammy_amd64.deb
`postgresql-14-logerrors`	`2.1.5`	u22.aarch64	pigsty	36.8 KiB	postgresql-14-logerrors_2.1.5-1PIGSTY~jammy_arm64.deb
`postgresql-14-logerrors`	`2.1.5`	u24.x86_64	pigsty	32.3 KiB	postgresql-14-logerrors_2.1.5-1PIGSTY~noble_amd64.deb
`postgresql-14-logerrors`	`2.1.5`	u24.aarch64	pigsty	32.3 KiB	postgresql-14-logerrors_2.1.5-1PIGSTY~noble_arm64.deb
`postgresql-14-logerrors`	`2.1.5`	u26.x86_64	pigsty	31.9 KiB	postgresql-14-logerrors_2.1.5-1PIGSTY~resolute_amd64.deb
`postgresql-14-logerrors`	`2.1.5`	u26.aarch64	pigsty	32.4 KiB	postgresql-14-logerrors_2.1.5-1PIGSTY~resolute_arm64.deb

Source

Repository

github.com/munakoiso/logerrors

Source Tarball

logerrors-2.1.5.tar.gz

pig build pkg logerrors;		# build deb

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

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

pig install logerrors -v 18;   # install for PG 18
pig install logerrors -v 17;   # install for PG 17
pig install logerrors -v 16;   # install for PG 16
pig install logerrors -v 15;   # install for PG 15
pig install logerrors -v 14;   # install for PG 14

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'logerrors';

Create this extension with:

CREATE EXTENSION logerrors;

Usage

logerrors: Collect statistics about log messages

logerrors collects statistics about WARNING, ERROR, and FATAL messages in PostgreSQL log files, making it easy to monitor error rates without parsing logs.

CREATE EXTENSION logerrors;

Configuration Parameters

Parameter	Default	Description
`logerrors.interval`	`5000` (5s)	Time between writing stats to buffer (ms, max 60s)
`logerrors.intervals_count`	`120`	Number of intervals to keep in buffer (max 360)
`logerrors.excluded_errcodes`	(empty)	Error codes to exclude, comma-separated

Querying Error Statistics

SELECT * FROM pg_log_errors_stats();
 time_interval |  type   |       message        | count | username | database | sqlstate
---------------+---------+----------------------+-------+----------+----------+----------
               | WARNING | TOTAL                |     0 |          |          |
               | ERROR   | TOTAL                |     1 |          |          |
               | FATAL   | TOTAL                |     0 |          |          |
             5 | ERROR   | ERRCODE_SYNTAX_ERROR |     1 | postgres | postgres | 42601
           600 | ERROR   | ERRCODE_SYNTAX_ERROR |     1 | postgres | postgres | 42601

Slow Log Statistics

SELECT * FROM pg_slow_log_stats();
 slow_count |         reset_time
------------+----------------------------
          1 | 2020-06-13 00:19:31.084923

Reset Statistics

SELECT pg_log_errors_reset();