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 33 available extensions:
1 - pg_proctab
PostgreSQL extension to access the OS process table
Overview
PIGSTY 3rd Party Extension: pg_proctab : PostgreSQL extension to access the OS process table
- Version: 0.0.10
- PG Vers:
16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pg_proctab_$v*
- RPM Ver : 0.0.10
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-proctab
- DEB Ver : 0.0.10
- DEB Deps: Nil
Details
2 - pg_profile
PostgreSQL load profile repository and report builder
Overview
PGDG 3rd Party Extension: pg_profile : PostgreSQL load profile repository and report builder
- Version: 4.7
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
dblink, plpgsql
Packages
- RPM Repo: PGDG
- RPM Name:
pg_profile_$v*
- RPM Ver :
4.7
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-profile
- DEB Ver :
4.7
- DEB Deps: Nil
Details
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
- Version: 2.1
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
pg_show_plans_$v*
- RPM Ver :
2.1
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-show-plans
- DEB Ver :
2.1
- DEB Deps: Nil
Details
4 - pg_stat_kcache
Kernel statistics gathering
Overview
PGDG 1st Party Extension: pg_stat_kcache : Kernel statistics gathering
- Version: 2.3.0
- PG Vers:
17,16,15,14,13,12
- Need Load: Explicit Loading Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
pg_stat_statements
Packages
- RPM Repo: PGDG
- RPM Name:
pg_stat_kcache_$v*
- RPM Ver :
2.3.0
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-stat-kcache
- DEB Ver :
2.3.0
- DEB Deps: Nil
Details
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
PGDG 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.
- Version: 2.1
- PG Vers:
17,16,15,14,13,12
- Need Load: Explicit Loading Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
pg_stat_monitor_$v*
- RPM Ver :
2.1
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-stat-monitor
- DEB Ver :
2.1
- DEB Deps: Nil
Details
6 - pg_qualstats
An extension collecting statistics about quals
Overview
PGDG 1st Party Extension: pg_qualstats : An extension collecting statistics about quals
- Version: 2.1.1
- PG Vers:
17,16,15,14,13,12
- Need Load: Explicit Loading Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
pg_qualstats_$v*
- RPM Ver :
2.1.1
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-qualstats
- DEB Ver :
2.1.1
- DEB Deps: Nil
Details
7 - pg_store_plans
track plan statistics of all SQL statements executed
Overview
PGDG 3rd Party Extension: pg_store_plans : track plan statistics of all SQL statements executed
- Version: 1.8
- PG Vers:
16,15,14,13,12
- Need Load: Explicit Loading Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
pg_store_plans_$v*
- RPM Ver :
1.8
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-store-plan
- DEB Ver :
1.8
- DEB Deps: Nil
Details
8 - pg_track_settings
Track settings changes
Overview
PGDG 1st Party Extension: pg_track_settings : Track settings changes
- Version: 2.1.2
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Relocatable
- Trusted: Trusted, Can be created by user with
CREATE Privilege
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
pg_track_settings_$v*
- RPM Ver :
2.1.2
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-track-settings
- DEB Ver :
2.1.2
- DEB Deps: Nil
Details
9 - pg_wait_sampling
sampling based statistics of wait events
Overview
PGDG 1st Party Extension: pg_wait_sampling : sampling based statistics of wait events
- Version: 1.1
- PG Vers:
17,16,15,14,13,12
- Need Load: Explicit Loading Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
pg_wait_sampling_$v*
- RPM Ver :
1.1
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pg-wait-sampling
- DEB Ver :
1.1
- DEB Deps: Nil
Details
10 - system_stats
EnterpriseDB system statistics for PostgreSQL
Overview
PGDG 3rd Party Extension: system_stats : EnterpriseDB system statistics for PostgreSQL
- Version: 3.0
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
system_stats_$v*
- RPM Ver :
3.0
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-system-stats
- DEB Ver :
3.0
- DEB Deps: Nil
Details
11 - meta
Normalized, friendlier system catalog for PostgreSQL
Overview
PIGSTY 3rd Party Extension: pg_meta : Normalized, friendlier system catalog for PostgreSQL
- Version: 0.4.0
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Not Relocatable
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pg_meta_$v
- RPM Ver :
0.4.0
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-meta
- DEB Ver :
0.4.0
- DEB Deps: Nil
Details
12 - pgnodemx
Capture node OS metrics via SQL queries
Overview
PIGSTY 3rd Party Extension: pgnodemx : Capture node OS metrics via SQL queries
- Version: 1.7
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pgnodemx_$v
- RPM Ver :
1.7
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pgnodemx
- DEB Ver :
1.7
- DEB Deps: Nil
Details
13 - pg_sqlog
Provide SQL interface to logs
Overview
PIGSTY 3rd Party Extension: pg_sqlog : Provide SQL interface to logs
- Version: 1.6
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas:
sqlog
- Requires:
file_fdw
Packages
- RPM Repo: PIGSTY
- RPM Name:
pg_sqlog_$v*
- RPM Ver :
1.6
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-sqlog
- DEB Ver :
1.6
- DEB Deps: Nil
Details
14 - 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
- Version: 1.0.6
- PG Vers:
17,16,15,14,13,12
- Need Load: Explicit Loading Required
- Need DDL: DO NOT
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
bgw_replstatus_$v*
- RPM Ver :
1.0.6
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-bgw-replstatus
- DEB Ver :
1.0.6
- DEB Deps: Nil
Details
15 - pgmeminfo
show memory usage
Overview
PGDG 3rd Party Extension: pgmeminfo : show memory usage
- Version: 1.0
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
pgmeminfo_$v*
- RPM Ver :
1.0
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pgmeminfo
- DEB Ver :
1.0
- DEB Deps: Nil
Details
16 - toastinfo
show details on toasted datums
Overview
PIGSTY 3rd Party Extension: toastinfo : show details on toasted datums
- Version: 1
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Not Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
toastinfo_$v*
- RPM Ver :
1
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-toastinfo
- DEB Ver :
1
- DEB Deps: Nil
Details
17 - 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
- Version: 0.0.1
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Relocatable
- Trusted: Trusted, Can be created by user with
CREATE Privilege
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pg_explain_ui_$v
- RPM Ver :
0.0.1
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-explain-ui
- DEB Ver :
0.0.1
- DEB Deps: Nil
Details
18 - 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
- Version: 0.0.1
- PG Vers:
17,16,15,14,13,12
- Need Load: Explicit Loading Required
- Need DDL: DO NOT
CREATE EXTENSION DDL
- Relocatable: Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pg_relusage_$v
- RPM Ver :
0.0.1
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-relusage
- DEB Ver :
0.0.1
- DEB Deps: Nil
Details
19 - pg_mon
PostgreSQL extension to enhance query monitoring
Overview
PIGSTY 3rd Party Extension: pg_mon : PostgreSQL extension to enhance query monitoring
- Version: 1.0
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pg_mon_$v*
- RPM Ver :
1.0
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-mon
- DEB Ver :
1.0
- DEB Deps: Nil
Details
20 - pg_statviz
stats visualization and time series analysis
Overview
PGDG 1st Party Extension: pg_statviz : stats visualization and time series analysis
- Version: 0.6
- PG Vers:
16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
pg_statviz_extension_$v
- RPM Ver :
0.6
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-statviz
- DEB Ver :
0.6
- DEB Deps: Nil
Details
21 - pgexporter_ext
pgexporter extension for extra metrics
Overview
PGDG 1st Party Extension: pgexporter_ext : pgexporter extension for extra metrics
- Version: 0.2.3
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
pgexporter_ext_$v
- RPM Ver :
0.2.3
- RPM Deps: Nil
- DEB Repo: N/A
- DEB Name:
N/A
- DEB Ver : N/A
- DEB Deps: Nil
Details
22 - pg_top
Monitor PostgreSQL processes similar to unix top
Overview
PGDG 1st Party Extension: pg_top : Monitor PostgreSQL processes similar to unix top
- Version: 3.7.0
- PG Vers:
16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO NOT
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PGDG
- RPM Name:
pg_top_$v*
- RPM Ver :
3.7.0
- RPM Deps: Nil
- DEB Repo: N/A
- DEB Name:
N/A
- DEB Ver : N/A
- DEB Deps: Nil
Details
23 - pagevis
Visualise database pages in ascii code
Overview
PIGSTY 3rd Party Extension: pagevis : Visualise database pages in ascii code
- Version: 0.1
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Not Relocatable
- Trusted: Unknown
- Schemas: N/A
- Requires: N/A
Packages
- RPM Repo: PIGSTY
- RPM Name:
pagevis_$v
- RPM Ver :
0.1
- RPM Deps: Nil
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pagevis
- DEB Ver :
0.1
- DEB Deps: Nil
Details
24 - powa
PostgreSQL Workload Analyser-core
Overview
PGDG 1st Party Extension: powa : PostgreSQL Workload Analyser-core
- Version: 4.2.2
- PG Vers:
16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Relocatable
- Trusted: Untrusted, Require Superuser to Create
- Schemas:
public
- Requires:
plpgsql, pg_stat_statements, btree_gist
Packages
- RPM Repo: PGDG
- RPM Name:
powa_$v*
- RPM Ver :
4.2.2
- RPM Deps: Nil
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-powa
- DEB Ver :
4.2.2
- DEB Deps: Nil
Details
25 - 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
- Version: 1.12
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
26 - pgrowlocks
show row-level locking information
Overview
CONTRIB Built-in Extension: pgrowlocks : show row-level locking information
- Version: 1.2
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
27 - sslinfo
information about SSL certificates
Overview
CONTRIB Built-in Extension: sslinfo : information about SSL certificates
- Version: 1.2
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
28 - pg_buffercache
examine the shared buffer cache
Overview
CONTRIB Built-in Extension: pg_buffercache : examine the shared buffer cache
- Version: 1.4
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
29 - 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
- Version: 1.1
- PG Vers:
17,16,15
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
30 - pg_freespacemap
examine the free space map (FSM)
Overview
CONTRIB Built-in Extension: pg_freespacemap : examine the free space map (FSM)
- Version: 1.2
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
31 - 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
- Version: 1.2
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
32 - pgstattuple
show tuple-level statistics
Overview
CONTRIB Built-in Extension: pgstattuple : show tuple-level statistics
- Version: 1.5
- PG Vers:
17,16,15,14,13,12
- Need Load: Lib Loading NOT Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
33 - 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
- Version: 16.3
- PG Vers:
17,16,15,14,13,12
- Need Load: Explicit Loading Required
- Need DDL: DO NOT
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details
34 - 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
- Version: 1.10
- PG Vers:
17,16,15,14,13,12
- Need Load: Explicit Loading Required
- Need DDL: DO
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
Packages
PostgreSQL Built-in Contrib Extension
Details