This is the multi-page printable view of this section.
Click here to print.
Return to the regular view of this page.
Category: STAT
STAT: Observability Catalogs, Monitoring Metrics & Views, Statistics, Query Plans, WaitSampling, SlowLogs, and etc…
STAT category has 31 available extensions:
1 - pg_profile
PostgreSQL load profile repository and report builder
Overview
MIXED 3rd Party Extension: pg_profile : PostgreSQL load profile repository and report builder
- Latest Version: 4.8
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
dblink, plpgsql
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_profile_$v*
- RPM Ver :
4.8
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-profile
- DEB Ver :
4.7
- DEB Deps: N/A
Packages
Installation
Install pg_profile via the pig CLI tool:
pig ext install pg_profile
Install pg_profile via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_profile"]}' # -l <cls>
Install pg_profile RPM from YUM repo directly:
dnf install pg_profile_17*;
dnf install pg_profile_16*;
dnf install pg_profile_15*;
dnf install pg_profile_14*;
dnf install pg_profile_13*;
Install pg_profile DEB from APT repo directly:
apt install postgresql-17-pg-profile;
apt install postgresql-16-pg-profile;
apt install postgresql-15-pg-profile;
apt install postgresql-14-pg-profile;
apt install postgresql-13-pg-profile;
Enable pg_profile extension on PostgreSQL cluster：
CREATE EXTENSION pg_profile CASCADE;
2 - pg_tracing
Distributed Tracing for PostgreSQL
Overview
PIGSTY 3rd Party Extension: pg_tracing : Distributed Tracing for PostgreSQL
- Latest Version: 0.1.0
- Postgres Support:
17,16,15
- Need Load: Explicit Loading Required
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_tracing_$v*
- RPM Ver :
0.1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-tracing
- DEB Ver :
0.1.0
- DEB Deps: N/A
Packages
Installation
Install pg_tracing via the pig CLI tool:
pig ext install pg_tracing
Install pg_tracing via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_tracing"]}' # -l <cls>
Install pg_tracing RPM from YUM repo directly:
dnf install pg_tracing_17*;
dnf install pg_tracing_16*;
dnf install pg_tracing_15*;
Install pg_tracing DEB from APT repo directly:
apt install postgresql-17-pg-tracing;
apt install postgresql-16-pg-tracing;
apt install postgresql-15-pg-tracing;
Extension pg_tracing has to be added to shared_preload_libraries
shared_preload_libraries = 'pg_tracing'; # add to pg cluster config
Enable pg_tracing extension on PostgreSQL cluster：
CREATE EXTENSION pg_tracing;
3 - pg_show_plans
show query plans of all currently running SQL statements
Overview
PGDG 1st Party Extension: pg_show_plans : show query plans of all currently running SQL statements
- Latest Version: 2.1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_show_plans_$v*
- RPM Ver :
2.1
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-show-plans
- DEB Ver :
2.1
- DEB Deps: N/A
Packages
Installation
Install pg_show_plans via the pig CLI tool:
pig ext install pg_show_plans
Install pg_show_plans via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_show_plans"]}' # -l <cls>
Install pg_show_plans RPM from YUM repo directly:
dnf install pg_show_plans_17*;
dnf install pg_show_plans_16*;
dnf install pg_show_plans_15*;
dnf install pg_show_plans_14*;
dnf install pg_show_plans_13*;
Install pg_show_plans DEB from APT repo directly:
apt install postgresql-17-show-plans;
apt install postgresql-16-show-plans;
apt install postgresql-15-show-plans;
apt install postgresql-14-show-plans;
apt install postgresql-13-show-plans;
Enable pg_show_plans extension on PostgreSQL cluster：
CREATE EXTENSION pg_show_plans;
4 - pg_stat_kcache
Kernel statistics gathering
Overview
PGDG 1st Party Extension: pg_stat_kcache : Kernel statistics gathering
- Latest Version: 2.3.0
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
pg_stat_statements
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_stat_kcache_$v*
- RPM Ver :
2.3.0
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-stat-kcache
- DEB Ver :
2.3.0
- DEB Deps: N/A
Packages
Installation
Install pg_stat_kcache via the pig CLI tool:
pig ext install pg_stat_kcache
Install pg_stat_kcache via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_stat_kcache"]}' # -l <cls>
Install pg_stat_kcache RPM from YUM repo directly:
dnf install pg_stat_kcache_17*;
dnf install pg_stat_kcache_16*;
dnf install pg_stat_kcache_15*;
dnf install pg_stat_kcache_14*;
dnf install pg_stat_kcache_13*;
Install pg_stat_kcache DEB from APT repo directly:
apt install postgresql-17-pg-stat-kcache;
apt install postgresql-16-pg-stat-kcache;
apt install postgresql-15-pg-stat-kcache;
apt install postgresql-14-pg-stat-kcache;
apt install postgresql-13-pg-stat-kcache;
Extension pg_stat_kcache has to be added to shared_preload_libraries
shared_preload_libraries = 'pg_stat_kcache'; # add to pg cluster config
Enable pg_stat_kcache extension on PostgreSQL cluster：
CREATE EXTENSION pg_stat_kcache CASCADE;
5 - pg_stat_monitor
The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.
Overview
MIXED 3rd Party Extension: pg_stat_monitor : The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.
- Latest Version: 2.1
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_stat_monitor_$v*
- RPM Ver :
2.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-stat-monitor
- DEB Ver :
2.1
- DEB Deps: N/A
Packages
Installation
Install pg_stat_monitor via the pig CLI tool:
pig ext install pg_stat_monitor
Install pg_stat_monitor via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_stat_monitor"]}' # -l <cls>
Install pg_stat_monitor RPM from YUM repo directly:
dnf install pg_stat_monitor_17*;
dnf install pg_stat_monitor_16*;
dnf install pg_stat_monitor_15*;
dnf install pg_stat_monitor_14*;
dnf install pg_stat_monitor_13*;
Install pg_stat_monitor DEB from APT repo directly:
apt install postgresql-17-pg-stat-monitor;
apt install postgresql-16-pg-stat-monitor;
apt install postgresql-15-pg-stat-monitor;
apt install postgresql-14-pg-stat-monitor;
apt install postgresql-13-pg-stat-monitor;
Extension pg_stat_monitor has to be added to shared_preload_libraries
shared_preload_libraries = 'pg_stat_monitor'; # add to pg cluster config
Enable pg_stat_monitor extension on PostgreSQL cluster：
CREATE EXTENSION pg_stat_monitor;
6 - pg_qualstats
An extension collecting statistics about quals
Overview
PGDG 1st Party Extension: pg_qualstats : An extension collecting statistics about quals
- Latest Version: 2.1.1
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_qualstats_$v*
- RPM Ver :
2.1.1
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-qualstats
- DEB Ver :
2.1.1
- DEB Deps: N/A
Packages
Installation
Install pg_qualstats via the pig CLI tool:
pig ext install pg_qualstats
Install pg_qualstats via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_qualstats"]}' # -l <cls>
Install pg_qualstats RPM from YUM repo directly:
dnf install pg_qualstats_17*;
dnf install pg_qualstats_16*;
dnf install pg_qualstats_15*;
dnf install pg_qualstats_14*;
dnf install pg_qualstats_13*;
Install pg_qualstats DEB from APT repo directly:
apt install postgresql-17-pg-qualstats;
apt install postgresql-16-pg-qualstats;
apt install postgresql-15-pg-qualstats;
apt install postgresql-14-pg-qualstats;
apt install postgresql-13-pg-qualstats;
Extension pg_qualstats has to be added to shared_preload_libraries
shared_preload_libraries = 'pg_qualstats'; # add to pg cluster config
Enable pg_qualstats extension on PostgreSQL cluster：
CREATE EXTENSION pg_qualstats;
7 - pg_store_plans
track plan statistics of all SQL statements executed
Overview
MIXED 3rd Party Extension: pg_store_plans : track plan statistics of all SQL statements executed
- Latest Version: 1.8
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_store_plans_$v*
- RPM Ver :
1.8
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-store-plan
- DEB Ver :
1.8
- DEB Deps: N/A
Packages
Installation
Install pg_store_plans via the pig CLI tool:
pig ext install pg_store_plans
Install pg_store_plans via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_store_plans"]}' # -l <cls>
Install pg_store_plans RPM from YUM repo directly:
dnf install pg_store_plans_17*;
dnf install pg_store_plans_16*;
dnf install pg_store_plans_15*;
dnf install pg_store_plans_14*;
dnf install pg_store_plans_13*;
Install pg_store_plans DEB from APT repo directly:
apt install postgresql-17-pg-store-plan;
apt install postgresql-16-pg-store-plan;
apt install postgresql-15-pg-store-plan;
apt install postgresql-14-pg-store-plan;
apt install postgresql-13-pg-store-plan;
Extension pg_store_plans has to be added to shared_preload_libraries
shared_preload_libraries = 'pg_store_plans'; # add to pg cluster config
Enable pg_store_plans extension on PostgreSQL cluster：
CREATE EXTENSION pg_store_plans;
8 - pg_track_settings
Track settings changes
Overview
PGDG 1st Party Extension: pg_track_settings : Track settings changes
- Latest Version: 2.1.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Trusted, Can be created by user with
CREATE Privilege
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_track_settings_$v
- RPM Ver :
2.1.2
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-track-settings
- DEB Ver :
2.1.2
- DEB Deps: N/A
Packages
Installation
Install pg_track_settings via the pig CLI tool:
pig ext install pg_track_settings
Install pg_track_settings via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_track_settings"]}' # -l <cls>
Install pg_track_settings RPM from YUM repo directly:
dnf install pg_track_settings_17;
dnf install pg_track_settings_16;
dnf install pg_track_settings_15;
dnf install pg_track_settings_14;
dnf install pg_track_settings_13;
Install pg_track_settings DEB from APT repo directly:
apt install postgresql-17-pg-track-settings;
apt install postgresql-16-pg-track-settings;
apt install postgresql-15-pg-track-settings;
apt install postgresql-14-pg-track-settings;
apt install postgresql-13-pg-track-settings;
Enable pg_track_settings extension on PostgreSQL cluster：
CREATE EXTENSION pg_track_settings;
9 - pg_wait_sampling
sampling based statistics of wait events
Overview
PGDG 1st Party Extension: pg_wait_sampling : sampling based statistics of wait events
- Latest Version: 1.1
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_wait_sampling_$v*
- RPM Ver :
1.1
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-wait-sampling
- DEB Ver :
1.1
- DEB Deps: N/A
Packages
Installation
Install pg_wait_sampling via the pig CLI tool:
pig ext install pg_wait_sampling
Install pg_wait_sampling via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_wait_sampling"]}' # -l <cls>
Install pg_wait_sampling RPM from YUM repo directly:
dnf install pg_wait_sampling_17*;
dnf install pg_wait_sampling_16*;
dnf install pg_wait_sampling_15*;
dnf install pg_wait_sampling_14*;
dnf install pg_wait_sampling_13*;
Install pg_wait_sampling DEB from APT repo directly:
apt install postgresql-17-pg-wait-sampling;
apt install postgresql-16-pg-wait-sampling;
apt install postgresql-15-pg-wait-sampling;
apt install postgresql-14-pg-wait-sampling;
apt install postgresql-13-pg-wait-sampling;
Extension pg_wait_sampling has to be added to shared_preload_libraries
shared_preload_libraries = 'pg_wait_sampling'; # add to pg cluster config
Enable pg_wait_sampling extension on PostgreSQL cluster：
CREATE EXTENSION pg_wait_sampling;
10 - system_stats
EnterpriseDB system statistics for PostgreSQL
Overview
MIXED 3rd Party Extension: system_stats : EnterpriseDB system statistics for PostgreSQL
- Latest Version: 3.0
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
system_stats_$v*
- RPM Ver :
3.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-system-stats
- DEB Ver :
3.0
- DEB Deps: N/A
Packages
Installation
Install system_stats via the pig CLI tool:
pig ext install system_stats
Install system_stats via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["system_stats"]}' # -l <cls>
Install system_stats RPM from YUM repo directly:
dnf install system_stats_17*;
dnf install system_stats_16*;
dnf install system_stats_15*;
dnf install system_stats_14*;
dnf install system_stats_13*;
Install system_stats DEB from APT repo directly:
apt install postgresql-17-system-stats;
apt install postgresql-16-system-stats;
apt install postgresql-15-system-stats;
apt install postgresql-14-system-stats;
apt install postgresql-13-system-stats;
Enable system_stats extension on PostgreSQL cluster：
CREATE EXTENSION system_stats;
11 - meta
Normalized, friendlier system catalog for PostgreSQL
Overview
PIGSTY 3rd Party Extension: pg_meta : Normalized, friendlier system catalog for PostgreSQL
- Latest Version: 0.4.0
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_meta_$v
- RPM Ver :
0.4.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-meta
- DEB Ver :
0.4.0
- DEB Deps: N/A
Packages
Installation
Install meta via the pig CLI tool:
pig ext install pg_meta; # Extension Namepig ext install meta; # normalized package name
Install pg_meta via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_meta"]}' # -l <cls>
Install pg_meta RPM from YUM repo directly:
dnf install pg_meta_17;
dnf install pg_meta_16;
dnf install pg_meta_15;
dnf install pg_meta_14;
dnf install pg_meta_13;
Install pg_meta DEB from APT repo directly:
apt install postgresql-17-pg-meta;
apt install postgresql-16-pg-meta;
apt install postgresql-15-pg-meta;
apt install postgresql-14-pg-meta;
apt install postgresql-13-pg-meta;
Enable meta extension on PostgreSQL cluster：
12 - pgnodemx
Capture node OS metrics via SQL queries
Overview
PIGSTY 3rd Party Extension: pgnodemx : Capture node OS metrics via SQL queries
- Latest Version: 1.7
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pgnodemx_$v
- RPM Ver :
1.7
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pgnodemx
- DEB Ver :
1.7
- DEB Deps: N/A
Packages
Installation
Install pgnodemx via the pig CLI tool:
Install pgnodemx via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgnodemx"]}' # -l <cls>
Install pgnodemx RPM from YUM repo directly:
dnf install pgnodemx_17;
dnf install pgnodemx_16;
dnf install pgnodemx_15;
dnf install pgnodemx_14;
dnf install pgnodemx_13;
Install pgnodemx DEB from APT repo directly:
apt install postgresql-17-pgnodemx;
apt install postgresql-16-pgnodemx;
apt install postgresql-15-pgnodemx;
apt install postgresql-14-pgnodemx;
apt install postgresql-13-pgnodemx;
Enable pgnodemx extension on PostgreSQL cluster：
CREATE EXTENSION pgnodemx;
13 - pg_proctab
PostgreSQL extension to access the OS process table
Overview
PIGSTY 3rd Party Extension: pgnodemx : PostgreSQL extension to access the OS process table
- Latest Version: 0.0.10-compat
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pgnodemx_$v
- RPM Ver :
0.0.10-compat
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pgnodemx
- DEB Ver :
0.0.10-compat
- DEB Deps: N/A
Packages
Installation
Install pg_proctab via the pig CLI tool:
pig ext install pgnodemx; # Extension Namepig ext install pg_proctab; # normalized package name
Install pgnodemx via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgnodemx"]}' # -l <cls>
Install pgnodemx RPM from YUM repo directly:
dnf install pgnodemx_17;
dnf install pgnodemx_16;
dnf install pgnodemx_15;
dnf install pgnodemx_14;
dnf install pgnodemx_13;
Install pgnodemx DEB from APT repo directly:
apt install postgresql-17-pgnodemx;
apt install postgresql-16-pgnodemx;
apt install postgresql-15-pgnodemx;
apt install postgresql-14-pgnodemx;
apt install postgresql-13-pgnodemx;
Enable pg_proctab extension on PostgreSQL cluster：
CREATE EXTENSION pg_proctab;
14 - pg_sqlog
Provide SQL interface to logs
Overview
PIGSTY 3rd Party Extension: pg_sqlog : Provide SQL interface to logs
- Latest Version: 1.6
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas:
sqlog
- Requires:
file_fdw
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_sqlog_$v
- RPM Ver :
1.6
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-sqlog
- DEB Ver :
1.6
- DEB Deps: N/A
Packages
Installation
Install pg_sqlog via the pig CLI tool:
Install pg_sqlog via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_sqlog"]}' # -l <cls>
Install pg_sqlog RPM from YUM repo directly:
dnf install pg_sqlog_17;
dnf install pg_sqlog_16;
dnf install pg_sqlog_15;
dnf install pg_sqlog_14;
dnf install pg_sqlog_13;
Install pg_sqlog DEB from APT repo directly:
apt install postgresql-17-pg-sqlog;
apt install postgresql-16-pg-sqlog;
apt install postgresql-15-pg-sqlog;
apt install postgresql-14-pg-sqlog;
apt install postgresql-13-pg-sqlog;
Enable pg_sqlog extension on PostgreSQL cluster：
CREATE EXTENSION pg_sqlog CASCADE;
15 - bgw_replstatus
Small PostgreSQL background worker to report whether a node is a replication master or standby
Overview
PGDG 1st Party Extension: bgw_replstatus : Small PostgreSQL background worker to report whether a node is a replication master or standby
- Latest Version: 1.0.6
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
bgw_replstatus_$v*
- RPM Ver :
1.0.6
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-bgw-replstatus
- DEB Ver :
1.0.6
- DEB Deps: N/A
Packages
Installation
Install bgw_replstatus via the pig CLI tool:
pig ext install bgw_replstatus
Install bgw_replstatus via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["bgw_replstatus"]}' # -l <cls>
Install bgw_replstatus RPM from YUM repo directly:
dnf install bgw_replstatus_17*;
dnf install bgw_replstatus_16*;
dnf install bgw_replstatus_15*;
dnf install bgw_replstatus_14*;
dnf install bgw_replstatus_13*;
Install bgw_replstatus DEB from APT repo directly:
apt install postgresql-17-bgw-replstatus;
apt install postgresql-16-bgw-replstatus;
apt install postgresql-15-bgw-replstatus;
apt install postgresql-14-bgw-replstatus;
apt install postgresql-13-bgw-replstatus;
Extension bgw_replstatus has to be added to shared_preload_libraries
shared_preload_libraries = 'bgw_replstatus'; # add to pg cluster config
Extension %s does not need CREATE EXTENSION command
16 - pgmeminfo
show memory usage
Overview
MIXED 3rd Party Extension: pgmeminfo : show memory usage
- Latest Version: 1.0
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pgmeminfo_$v*
- RPM Ver :
1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pgmeminfo
- DEB Ver :
1.0
- DEB Deps: N/A
Packages
Installation
Install pgmeminfo via the pig CLI tool:
pig ext install pgmeminfo
Install pgmeminfo via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgmeminfo"]}' # -l <cls>
Install pgmeminfo RPM from YUM repo directly:
dnf install pgmeminfo_17*;
dnf install pgmeminfo_16*;
dnf install pgmeminfo_15*;
dnf install pgmeminfo_14*;
dnf install pgmeminfo_13*;
Install pgmeminfo DEB from APT repo directly:
apt install postgresql-17-pgmeminfo;
apt install postgresql-16-pgmeminfo;
apt install postgresql-15-pgmeminfo;
apt install postgresql-14-pgmeminfo;
apt install postgresql-13-pgmeminfo;
Enable pgmeminfo extension on PostgreSQL cluster：
CREATE EXTENSION pgmeminfo;
17 - toastinfo
show details on toasted datums
Overview
PIGSTY 3rd Party Extension: toastinfo : show details on toasted datums
- Latest Version: 1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
toastinfo_$v*
- RPM Ver :
1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-toastinfo
- DEB Ver :
1
- DEB Deps: N/A
Packages
Installation
Install toastinfo via the pig CLI tool:
pig ext install toastinfo
Install toastinfo via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["toastinfo"]}' # -l <cls>
Install toastinfo RPM from YUM repo directly:
dnf install toastinfo_17*;
dnf install toastinfo_16*;
dnf install toastinfo_15*;
dnf install toastinfo_14*;
dnf install toastinfo_13*;
Install toastinfo DEB from APT repo directly:
apt install postgresql-17-toastinfo;
apt install postgresql-16-toastinfo;
apt install postgresql-15-toastinfo;
apt install postgresql-14-toastinfo;
apt install postgresql-13-toastinfo;
Enable toastinfo extension on PostgreSQL cluster：
CREATE EXTENSION toastinfo;
18 - explain_ui
easily jump into a visual plan UI for any SQL query
Overview
PIGSTY 3rd Party Extension: pg_explain_ui : easily jump into a visual plan UI for any SQL query
- Latest Version: 0.0.1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Trusted, Can be created by user with
CREATE Privilege
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_explain_ui_$v
- RPM Ver :
0.0.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-explain-ui
- DEB Ver :
0.0.1
- DEB Deps: N/A
Packages
Installation
Install explain_ui via the pig CLI tool:
pig ext install pg_explain_ui; # Extension Namepig ext install explain_ui; # normalized package name
Install pg_explain_ui via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_explain_ui"]}' # -l <cls>
Install pg_explain_ui RPM from YUM repo directly:
dnf install pg_explain_ui_17;
dnf install pg_explain_ui_16;
dnf install pg_explain_ui_15;
dnf install pg_explain_ui_14;
dnf install pg_explain_ui_13;
Install pg_explain_ui DEB from APT repo directly:
apt install postgresql-17-pg-explain-ui;
apt install postgresql-16-pg-explain-ui;
apt install postgresql-15-pg-explain-ui;
apt install postgresql-14-pg-explain-ui;
apt install postgresql-13-pg-explain-ui;
Enable explain_ui extension on PostgreSQL cluster：
CREATE EXTENSION explain_ui;
19 - pg_relusage
Log all the queries that reference a particular column
Overview
PIGSTY 3rd Party Extension: pg_relusage : Log all the queries that reference a particular column
- Latest Version: 0.0.1
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_relusage_$v
- RPM Ver :
0.0.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-relusage
- DEB Ver :
0.0.1
- DEB Deps: N/A
Packages
Installation
Install pg_relusage via the pig CLI tool:
pig ext install pg_relusage
Install pg_relusage via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_relusage"]}' # -l <cls>
Install pg_relusage RPM from YUM repo directly:
dnf install pg_relusage_17;
dnf install pg_relusage_16;
dnf install pg_relusage_15;
dnf install pg_relusage_14;
dnf install pg_relusage_13;
Install pg_relusage DEB from APT repo directly:
apt install postgresql-17-pg-relusage;
apt install postgresql-16-pg-relusage;
apt install postgresql-15-pg-relusage;
apt install postgresql-14-pg-relusage;
apt install postgresql-13-pg-relusage;
Extension pg_relusage has to be added to shared_preload_libraries
shared_preload_libraries = 'pg_relusage'; # add to pg cluster config
Extension %s does not need CREATE EXTENSION command
20 - pagevis
Visualise database pages in ascii code
Overview
PIGSTY 3rd Party Extension: pagevis : Visualise database pages in ascii code
- Latest Version: 0.1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pagevis_$v
- RPM Ver :
0.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pagevis
- DEB Ver :
0.1
- DEB Deps: N/A
Packages
Installation
Install pagevis via the pig CLI tool:
Install pagevis via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pagevis"]}' # -l <cls>
Install pagevis RPM from YUM repo directly:
dnf install pagevis_17;
dnf install pagevis_16;
dnf install pagevis_15;
dnf install pagevis_14;
dnf install pagevis_13;
Install pagevis DEB from APT repo directly:
apt install postgresql-17-pagevis;
apt install postgresql-16-pagevis;
apt install postgresql-15-pagevis;
apt install postgresql-14-pagevis;
apt install postgresql-13-pagevis;
Enable pagevis extension on PostgreSQL cluster：
CREATE EXTENSION pagevis;
21 - powa
PostgreSQL Workload Analyser-core
Overview
PGDG 1st Party Extension: powa : PostgreSQL Workload Analyser-core
- Latest Version: 5.0.1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas:
public
- Requires:
plpgsql, pg_stat_statements, btree_gist
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
powa_$v*
- RPM Ver :
5.0.1
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-powa
- DEB Ver :
5.0.1
- DEB Deps: N/A
Packages
Installation
Install powa via the pig CLI tool:
Install powa via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["powa"]}' # -l <cls>
Install powa RPM from YUM repo directly:
dnf install powa_17*;
dnf install powa_16*;
dnf install powa_15*;
dnf install powa_14*;
dnf install powa_13*;
Install powa DEB from APT repo directly:
apt install postgresql-17-powa;
apt install postgresql-16-powa;
apt install postgresql-15-powa;
apt install postgresql-14-powa;
apt install postgresql-13-powa;
Enable powa extension on PostgreSQL cluster：
CREATE EXTENSION powa CASCADE;
22 - pageinspect
inspect the contents of database pages at a low level
Overview
CONTRIB Built-in Extension: pageinspect : inspect the contents of database pages at a low level
- Latest Version: 1.12
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Packages
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension pageinspect is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install pageinspect RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install pageinspect DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Enable pageinspect extension on PostgreSQL cluster：
CREATE EXTENSION pageinspect;
23 - pgrowlocks
show row-level locking information
Overview
CONTRIB Built-in Extension: pgrowlocks : show row-level locking information
- Latest Version: 1.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Packages
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension pgrowlocks is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install pgrowlocks RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install pgrowlocks DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Enable pgrowlocks extension on PostgreSQL cluster：
CREATE EXTENSION pgrowlocks;
24 - sslinfo
information about SSL certificates
Overview
CONTRIB Built-in Extension: sslinfo : information about SSL certificates
- Latest Version: 1.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Packages
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension sslinfo is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install sslinfo RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install sslinfo DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Enable sslinfo extension on PostgreSQL cluster：
CREATE EXTENSION sslinfo;
25 - pg_buffercache
examine the shared buffer cache
Overview
CONTRIB Built-in Extension: pg_buffercache : examine the shared buffer cache
- Latest Version: 1.5
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Packages
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension pg_buffercache is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install pg_buffercache RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install pg_buffercache DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Enable pg_buffercache extension on PostgreSQL cluster：
CREATE EXTENSION pg_buffercache;
26 - pg_walinspect
functions to inspect contents of PostgreSQL Write-Ahead Log
Overview
CONTRIB Built-in Extension: pg_walinspect : functions to inspect contents of PostgreSQL Write-Ahead Log
- Latest Version: 1.1
- Postgres Support:
17,16,15
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Packages
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension pg_walinspect is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install pg_walinspect RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
Install pg_walinspect DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
Enable pg_walinspect extension on PostgreSQL cluster：
CREATE EXTENSION pg_walinspect;
27 - pg_freespacemap
examine the free space map (FSM)
Overview
CONTRIB Built-in Extension: pg_freespacemap : examine the free space map (FSM)
- Latest Version: 1.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Packages
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension pg_freespacemap is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install pg_freespacemap RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install pg_freespacemap DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Enable pg_freespacemap extension on PostgreSQL cluster：
CREATE EXTENSION pg_freespacemap;
28 - pg_visibility
examine the visibility map (VM) and page-level visibility info
Overview
CONTRIB Built-in Extension: pg_visibility : examine the visibility map (VM) and page-level visibility info
- Latest Version: 1.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Packages
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension pg_visibility is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install pg_visibility RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install pg_visibility DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Enable pg_visibility extension on PostgreSQL cluster：
CREATE EXTENSION pg_visibility;
29 - pgstattuple
show tuple-level statistics
Overview
CONTRIB Built-in Extension: pgstattuple : show tuple-level statistics
- Latest Version: 1.5
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Packages
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension pgstattuple is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install pgstattuple RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install pgstattuple DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Enable pgstattuple extension on PostgreSQL cluster：
CREATE EXTENSION pgstattuple;
30 - auto_explain
Provides a means for logging execution plans of slow statements automatically
Overview
CONTRIB Built-in Extension: auto_explain : Provides a means for logging execution plans of slow statements automatically
- Latest Version: -
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Dd not need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Packages
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension auto_explain is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install auto_explain RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install auto_explain DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Extension auto_explain has to be added to shared_preload_libraries
shared_preload_libraries = 'auto_explain'; # add to pg cluster config
Extension %s does not need CREATE EXTENSION command
31 - pg_stat_statements
track planning and execution statistics of all SQL statements executed
Overview
CONTRIB Built-in Extension: pg_stat_statements : track planning and execution statistics of all SQL statements executed
- Latest Version: 1.11
- Postgres Support:
17,16,15,14,13
- Need Load: Explicit Loading Required
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
PostgreSQL Built-in Contrib Extension
Packages
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension pg_stat_statements is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install pg_stat_statements RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install pg_stat_statements DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Extension pg_stat_statements has to be added to shared_preload_libraries
shared_preload_libraries = 'pg_stat_statements'; # add to pg cluster config
Enable pg_stat_statements extension on PostgreSQL cluster：
CREATE EXTENSION pg_stat_statements;