gsmolk/pg_errors

pg_errors

Overview

pg_errors is an extension to count statement errors that are not already tracked by core PostgreSQL. Currently only following conditions are tracked:

• statement_timeout
• statement cancel due to user request
• lock_timeout
• idle_in_transaction_timeout

This extension is compatible with PostgreSQL 10 and higher.

Installation

1. Get latest pg_errors sources:

git clone https://github.com/pgtoolz/pg_errors

2. Get latest PostgreSQL sources:

git clone https://github.com/postgres/postgres.git -b REL_16_STABLE && cd postgres

4. Compile and install PostgreSQL

5. Compile and install pg_errors extension

USE_PGXS=1 make -C /path/to/pg_errors/ install

6. Configure extension

echo "shared_preload_libraries = 'pg_errors'" >> postgres_data/postgresql.conf

7. Run PostgreSQL and create pg_errors extension

postgres=# CREATE EXTENSION pg_errors;

Public SQL API

• pg_errors — returns current statistics
• pg_errors_reset() — reset statistics

Upgrading

Usually, you have to only install new version of pg_errors, do ALTER EXTENSION 'pg_errors' UPDATE; and restart PostgreSQL.

Tests

make check