- pg_log 0.0.1
- displays log content from SQL
PostgreSQL extension to display log from SQL
This module can be built using the standard PGXS infrastructure. For this to work, the
pg_config program must be available in your $PATH:
git clone https://github.com/pierreforstmann/pg_log.git
This extension has been validated with PostgreSQL 10, 11, 12, 13 and 14.
Extension must loaded at server level with
pg_log has 3 specific GUC settings:
pg_log.fraction which is the log fraction that is displayed between 0 and 1. To display 10% of log contents starting from the end, use
pg_log.naptime is the duration between each log refresh in the database. Default is 30 seconds.
pg_log.datname is the database name where
pglog table and
log view are created. This database must be created before installing the extension. Default database name is
shared_preload_libraries = 'pg_log'
create database pg_log;
Run in database
create extension pg_log;
To display 10% of log contents connect to database
pg_log and query the
select * from log;