PIGSTY

STAT

Observability Catalogs, Monitoring Metrics & Views, Statistics, Query Plans, WaitSampling, SlowLogs

STAT category contains 34 PostgreSQL extensions.

IDExtensionPackageVersionDescription
6000pg_profilepg_profile4.8PostgreSQL load profile repository and report builder
6010pg_tracingpg_tracing0.1.3Distributed Tracing for PostgreSQL
6210pg_show_planspg_show_plans2.1.3show query plans of all currently running SQL statements
6220pg_stat_kcachepg_stat_kcache2.3.0Kernel statistics gathering
6230pg_stat_monitorpg_stat_monitor2.1.1The 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.
6240pg_qualstatspg_qualstats2.1.1An extension collecting statistics about quals
6250pg_store_planspg_store_plans1.8track plan statistics of all SQL statements executed
6260pg_track_settingspg_track_settings2.1.2Track settings changes
6270pg_wait_samplingpg_wait_sampling1.1.8sampling based statistics of wait events
6280pgsentinelpgsentinel1.1.0active session history
6290system_statssystem_stats3.2EnterpriseDB system statistics for PostgreSQL
6300metapg_meta0.4.0Normalized, friendlier system catalog for PostgreSQL
6310pgnodemxpgnodemx1.7Capture node OS metrics via SQL queries
6320pg_proctabpgnodemx1.7PostgreSQL extension to access the OS process table
6330pg_sqlogpg_sqlog1.6Provide SQL interface to logs
6340bgw_replstatusbgw_replstatus1.0.7Small PostgreSQL background worker to report whether a node is a replication master or standby
6350pgmeminfopgmeminfo1.0.0show memory usage
6360toastinfotoastinfo1.5show details on toasted datums
6370explain_uipg_explain_ui0.0.1easily jump into a visual plan UI for any SQL query
6380pg_relusagepg_relusage0.0.1Log all the queries that reference a particular column
6800pagevispagevis0.1Visualise database pages in ascii code
6810powapowa5.0.1PostgreSQL Workload Analyser-core
6880pg_overexplainpg_overexplain1.0Allow EXPLAIN to dump even more details
6890pg_logicalinspectpg_logicalinspect1.0Logical decoding components inspection
6900pageinspectpageinspect1.12inspect the contents of database pages at a low level
6910pgrowlockspgrowlocks1.2show row-level locking information
6920sslinfosslinfo1.2information about SSL certificates
6930pg_buffercachepg_buffercache1.5examine the shared buffer cache
6940pg_walinspectpg_walinspect1.1functions to inspect contents of PostgreSQL Write-Ahead Log
6950pg_freespacemappg_freespacemap1.2examine the free space map (FSM)
6960pg_visibilitypg_visibility1.2examine the visibility map (VM) and page-level visibility info
6970pgstattuplepgstattuple1.5show tuple-level statistics
6980auto_explainauto_explain-Provides a means for logging execution plans of slow statements automatically
6990pg_stat_statementspg_stat_statements1.11track planning and execution statistics of all SQL statements executed

pg_profile - 4.8

PostgreSQL load profile repository and report builder

ExtensionWebsiteAttributes
Packagepg_profile
RPMpg_profile_$v*
DDL
DEBpostgresql-$v-pg-profile
LIB
Language
C
License
BSD 2-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_tracing - 0.1.3

Distributed Tracing for PostgreSQL

ExtensionWebsiteAttributes
Packagepg_tracing
LOAD
RPMpg_tracing_$v*
DDL
DEBpostgresql-$v-pg-tracing
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_show_plans - 2.1.3

show query plans of all currently running SQL statements

ExtensionWebsiteAttributes
Packagepg_show_plans
RPMpg_show_plans_$v*
DDL
DEBpostgresql-$v-show-plans
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_stat_kcache - 2.3.0

Kernel statistics gathering

ExtensionWebsiteAttributes
Packagepg_stat_kcache
LOAD
RPMpg_stat_kcache_$v*
DDL
DEBpostgresql-$v-pg-stat-kcache
LIB
Language
C
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_stat_monitor - 2.1.1

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.

ExtensionWebsiteAttributes
Packagepg_stat_monitor
LOAD
RPMpg_stat_monitor_$v*
DDL
DEBpostgresql-$v-pg-stat-monitor
LIB
Language
C
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_qualstats - 2.1.1

An extension collecting statistics about quals

ExtensionWebsiteAttributes
Packagepg_qualstats
LOAD
RPMpg_qualstats_$v*
DDL
DEBpostgresql-$v-pg-qualstats
LIB
Language
C
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_store_plans - 1.8

track plan statistics of all SQL statements executed

ExtensionWebsiteAttributes
Packagepg_store_plans
LOAD
RPMpg_store_plans_$v*
DDL
DEBpostgresql-$v-pg-store-plan
LIB
Language
C
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_track_settings - 2.1.2

Track settings changes

ExtensionWebsiteAttributes
Packagepg_track_settings
RPMpg_track_settings_$v
DDL
DEBpostgresql-$v-pg-track-settings
LIB
Language
SQL
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_wait_sampling - 1.1.8

sampling based statistics of wait events

ExtensionWebsiteAttributes
Packagepg_wait_sampling
LOAD
RPMpg_wait_sampling_$v*
DDL
DEBpostgresql-$v-pg-wait-sampling
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgsentinel - 1.1.0

active session history

ExtensionWebsiteAttributes
Packagepgsentinel
LOAD
RPMpgsentinel_$v*
DDL
DEBpostgresql-$v-pgsentinel
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

system_stats - 3.2

EnterpriseDB system statistics for PostgreSQL

ExtensionWebsiteAttributes
Packagesystem_stats
RPMsystem_stats_$v*
DDL
DEBpostgresql-$v-system-stats
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

meta - 0.4.0

Normalized, friendlier system catalog for PostgreSQL

ExtensionWebsiteAttributes
Packagepg_meta
RPMpg_meta_$v
DDL
DEBpostgresql-$v-pg-meta
Language
SQL
License
BSD 2-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgnodemx - 1.7

Capture node OS metrics via SQL queries

ExtensionWebsiteAttributes
Packagepgnodemx
RPMpgnodemx_$v
DDL
DEBpostgresql-$v-pgnodemx
LIB
Language
C
License
Apache-2.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_proctab - 1.7

PostgreSQL extension to access the OS process table

ExtensionWebsiteAttributes
Packagepgnodemx
RPMpgnodemx_$v
DDL
DEBpostgresql-$v-pgnodemx
LIB
Language
C
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_sqlog - 1.6

Provide SQL interface to logs

ExtensionWebsiteAttributes
Packagepg_sqlog
RPMpg_sqlog_$v
DDL
DEBpostgresql-$v-pg-sqlog
LIB
Language
SQL
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

bgw_replstatus - 1.0.7

Small PostgreSQL background worker to report whether a node is a replication master or standby

ExtensionWebsiteAttributes
Packagebgw_replstatus
LOAD
RPMbgw_replstatus_$v*
DEBpostgresql-$v-bgw-replstatus
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgmeminfo - 1.0.0

show memory usage

ExtensionWebsiteAttributes
Packagepgmeminfo
RPMpgmeminfo_$v*
DDL
DEBpostgresql-$v-pgmeminfo
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

toastinfo - 1.5

show details on toasted datums

ExtensionWebsiteAttributes
Packagetoastinfo
RPMtoastinfo_$v*
DDL
DEBpostgresql-$v-toastinfo
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

explain_ui - 0.0.1

easily jump into a visual plan UI for any SQL query

ExtensionWebsiteAttributes
Packagepg_explain_ui
RPMpg_explain_ui_$v
DDL
DEBpostgresql-$v-pg-explain-ui
LIB
Language
Rust
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_relusage - 0.0.1

Log all the queries that reference a particular column

ExtensionWebsiteAttributes
Packagepg_relusage
LOAD
RPMpg_relusage_$v
DEBpostgresql-$v-pg-relusage
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pagevis - 0.1

Visualise database pages in ascii code

ExtensionWebsiteAttributes
Packagepagevis
RPMpagevis_$v
DDL
DEBpostgresql-$v-pagevis
Language
SQL
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

powa - 5.0.1

PostgreSQL Workload Analyser-core

ExtensionWebsiteAttributes
Packagepowa
RPMpowa_$v*
DDL
DEBpostgresql-$v-powa
LIB
Language
Python
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_overexplain - 1.0

Allow EXPLAIN to dump even more details

ExtensionWebsiteAttributes
Packagepg_overexplain
LOAD
RPMpostgresql$v-contrib
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_logicalinspect - 1.0

Logical decoding components inspection

ExtensionWebsiteAttributes
Packagepg_logicalinspect
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pageinspect - 1.12

inspect the contents of database pages at a low level

ExtensionWebsiteAttributes
Packagepageinspect
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgrowlocks - 1.2

show row-level locking information

ExtensionWebsiteAttributes
Packagepgrowlocks
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

sslinfo - 1.2

information about SSL certificates

ExtensionWebsiteAttributes
Packagesslinfo
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_buffercache - 1.5

examine the shared buffer cache

ExtensionWebsiteAttributes
Packagepg_buffercache
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_walinspect - 1.1

functions to inspect contents of PostgreSQL Write-Ahead Log

ExtensionWebsiteAttributes
Packagepg_walinspect
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_freespacemap - 1.2

examine the free space map (FSM)

ExtensionWebsiteAttributes
Packagepg_freespacemap
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_visibility - 1.2

examine the visibility map (VM) and page-level visibility info

ExtensionWebsiteAttributes
Packagepg_visibility
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pgstattuple - 1.5

show tuple-level statistics

ExtensionWebsiteAttributes
Packagepgstattuple
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

auto_explain - -

Provides a means for logging execution plans of slow statements automatically

ExtensionWebsiteAttributes
Packageauto_explain
LOAD
RPMpostgresql$v-contrib
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_stat_statements - 1.11

track planning and execution statistics of all SQL statements executed

ExtensionWebsiteAttributes
Packagepg_stat_statements
LOAD
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13