STAT

STAT: Observability Catalogs, Monitoring Metrics & Views, Statistics, Query Plans, WaitSampling, SlowLogs, and etc...

STAT category contains 34 PostgreSQL extensions.

ID	Extension	Package	Version	Description
6000	`pg_profile`	`pg_profile`	4.10	PostgreSQL load profile repository and report builder
6010	`pg_tracing`	`pg_tracing`	0.1.3	Distributed Tracing for PostgreSQL
6210	`pg_show_plans`	`pg_show_plans`	2.1.6	show query plans of all currently running SQL statements
6220	`pg_stat_kcache`	`pg_stat_kcache`	2.3.0	Kernel statistics gathering
6230	`pg_stat_monitor`	`pg_stat_monitor`	2.2.0	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.
6240	`pg_qualstats`	`pg_qualstats`	2.1.2	An extension collecting statistics about quals
6250	`pg_store_plans`	`pg_store_plans`	1.8	track plan statistics of all SQL statements executed
6260	`pg_track_settings`	`pg_track_settings`	2.1.2	Track settings changes
6270	`pg_wait_sampling`	`pg_wait_sampling`	1.1.9	sampling based statistics of wait events
6280	`pgsentinel`	`pgsentinel`	1.2.0	active session history
6290	`system_stats`	`system_stats`	3.2	EnterpriseDB system statistics for PostgreSQL
6300	`meta`	`pg_meta`	0.4.0	Normalized, friendlier system catalog for PostgreSQL
6310	`pgnodemx`	`pgnodemx`	1.7	Capture node OS metrics via SQL queries
6320	`pg_proctab`	`pgnodemx`	1.7	PostgreSQL extension to access the OS process table
6330	`pg_sqlog`	`pg_sqlog`	1.6	Provide SQL interface to logs
6340	`bgw_replstatus`	`bgw_replstatus`	1.0.8	Small PostgreSQL background worker to report whether a node is a replication master or standby
6350	`pgmeminfo`	`pgmeminfo`	1.0.0	show memory usage
6360	`toastinfo`	`toastinfo`	1.5	show details on toasted datums
6370	`explain_ui`	`pg_explain_ui`	0.0.1	easily jump into a visual plan UI for any SQL query
6380	`pg_relusage`	`pg_relusage`	0.0.1	Log all the queries that reference a particular column
6800	`pagevis`	`pagevis`	0.1	Visualise database pages in ascii code
6810	`powa`	`powa`	5.0.1	PostgreSQL Workload Analyser-core
6880	`pg_overexplain`	`pg_overexplain`	1.0	Allow EXPLAIN to dump even more details
6890	`pg_logicalinspect`	`pg_logicalinspect`	1.0	Logical decoding components inspection
6900	`pageinspect`	`pageinspect`	1.12	inspect the contents of database pages at a low level
6910	`pgrowlocks`	`pgrowlocks`	1.2	show row-level locking information
6920	`sslinfo`	`sslinfo`	1.2	information about SSL certificates
6930	`pg_buffercache`	`pg_buffercache`	1.5	examine the shared buffer cache
6940	`pg_walinspect`	`pg_walinspect`	1.1	functions to inspect contents of PostgreSQL Write-Ahead Log
6950	`pg_freespacemap`	`pg_freespacemap`	1.2	examine the free space map (FSM)
6960	`pg_visibility`	`pg_visibility`	1.2	examine the visibility map (VM) and page-level visibility info
6970	`pgstattuple`	`pgstattuple`	1.5	show tuple-level statistics
6980	`auto_explain`	`auto_explain`	-	Provides a means for logging execution plans of slow statements automatically
6990	`pg_stat_statements`	`pg_stat_statements`	1.11	track planning and execution statistics of all SQL statements executed

pg_profile - 4.10

PostgreSQL load profile repository and report builder

Extension	Website	Attributes
Package	`pg_profile`
RPM	`pg_profile_$v*`	DDL
DEB	`postgresql-$v-pg-profile`	LIB
Language	C
License	BSD 2-Clause

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_tracing - 0.1.3

Distributed Tracing for PostgreSQL

Extension	Website	Attributes
Package	`pg_tracing`	LOAD
RPM	`pg_tracing_$v*`	DDL
DEB	`postgresql-$v-pg-tracing`	LIB
Language	C
License	MIT

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_show_plans - 2.1.6

show query plans of all currently running SQL statements

Extension	Website	Attributes
Package	`pg_show_plans`
RPM	`pg_show_plans_$v*`	DDL
DEB	`postgresql-$v-show-plans`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_stat_kcache - 2.3.0

Kernel statistics gathering

Extension	Website	Attributes
Package	`pg_stat_kcache`	LOAD
RPM	`pg_stat_kcache_$v*`	DDL
DEB	`postgresql-$v-pg-stat-kcache`	LIB
Language	C
License	BSD 3-Clause

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_stat_monitor - 2.2.0

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.

Extension	Website	Attributes
Package	`pg_stat_monitor`	LOAD
RPM	`pg_stat_monitor_$v*`	DDL
DEB	`postgresql-$v-pg-stat-monitor`	LIB
Language	C
License	BSD 3-Clause

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_qualstats - 2.1.2

An extension collecting statistics about quals

Extension	Website	Attributes
Package	`pg_qualstats`	LOAD
RPM	`pg_qualstats_$v*`	DDL
DEB	`postgresql-$v-pg-qualstats`	LIB
Language	C
License	BSD 3-Clause

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_store_plans - 1.8

track plan statistics of all SQL statements executed

Extension	Website	Attributes
Package	`pg_store_plans`	LOAD
RPM	`pg_store_plans_$v*`	DDL
DEB	`postgresql-$v-pg-store-plan`	LIB
Language	C
License	BSD 3-Clause

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_track_settings - 2.1.2

Track settings changes

Extension	Website	Attributes
Package	`pg_track_settings`
RPM	`pg_track_settings_$v`	DDL
DEB	`postgresql-$v-pg-track-settings`	LIB
Language	SQL	TRUST
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_wait_sampling - 1.1.9

sampling based statistics of wait events

Extension	Website	Attributes
Package	`pg_wait_sampling`	LOAD
RPM	`pg_wait_sampling_$v*`	DDL
DEB	`postgresql-$v-pg-wait-sampling`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pgsentinel - 1.2.0

active session history

Extension	Website	Attributes
Package	`pgsentinel`	LOAD
RPM	`pgsentinel_$v*`	DDL
DEB	`postgresql-$v-pgsentinel`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

system_stats - 3.2

EnterpriseDB system statistics for PostgreSQL

Extension	Website	Attributes
Package	`system_stats`
RPM	`system_stats_$v*`	DDL
DEB	`postgresql-$v-system-stats`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

meta - 0.4.0

Normalized, friendlier system catalog for PostgreSQL

Extension	Website	Attributes
Package	`pg_meta`
RPM	`pg_meta_$v`	DDL
DEB	`postgresql-$v-pg-meta`
Language	SQL
License	BSD 2-Clause

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pgnodemx - 1.7

Capture node OS metrics via SQL queries

Extension	Website	Attributes
Package	`pgnodemx`
RPM	`pgnodemx_$v`	DDL
DEB	`postgresql-$v-pgnodemx`	LIB
Language	C
License	Apache-2.0

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_proctab - 1.7

PostgreSQL extension to access the OS process table

Extension	Website	Attributes
Package	`pgnodemx`
RPM	`pgnodemx_$v`	DDL
DEB	`postgresql-$v-pgnodemx`	LIB
Language	C
License	BSD 3-Clause

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_sqlog - 1.6

Provide SQL interface to logs

Extension	Website	Attributes
Package	`pg_sqlog`
RPM	`pg_sqlog_$v`	DDL
DEB	`postgresql-$v-pg-sqlog`	LIB
Language	SQL
License	BSD 3-Clause

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

bgw_replstatus - 1.0.8

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

Extension	Website	Attributes
Package	`bgw_replstatus`	LOAD
RPM	`bgw_replstatus_$v*`
DEB	`postgresql-$v-bgw-replstatus`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pgmeminfo - 1.0.0

show memory usage

Extension	Website	Attributes
Package	`pgmeminfo`
RPM	`pgmeminfo_$v*`	DDL
DEB	`postgresql-$v-pgmeminfo`	LIB
Language	C
License	MIT

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

toastinfo - 1.5

show details on toasted datums

Extension	Website	Attributes
Package	`toastinfo`
RPM	`toastinfo_$v*`	DDL
DEB	`postgresql-$v-toastinfo`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

explain_ui - 0.0.1

easily jump into a visual plan UI for any SQL query

Extension	Website	Attributes
Package	`pg_explain_ui`
RPM	`pg_explain_ui_$v`	DDL
DEB	`postgresql-$v-pg-explain-ui`	LIB
Language	Rust	TRUST
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_relusage - 0.0.1

Log all the queries that reference a particular column

Extension	Website	Attributes
Package	`pg_relusage`	LOAD
RPM	`pg_relusage_$v`
DEB	`postgresql-$v-pg-relusage`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pagevis - 0.1

Visualise database pages in ascii code

Extension	Website	Attributes
Package	`pagevis`
RPM	`pagevis_$v`	DDL
DEB	`postgresql-$v-pagevis`
Language	SQL
License	MIT

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

powa - 5.0.1

PostgreSQL Workload Analyser-core

Extension	Website	Attributes
Package	`powa`
RPM	`powa_$v*`	DDL
DEB	`postgresql-$v-powa`	LIB
Language	Python
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_overexplain - 1.0

Allow EXPLAIN to dump even more details

Extension	Website	Attributes
Package	`pg_overexplain`	LOAD
RPM	`postgresql$v-contrib`
DEB	`postgresql-$v`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_logicalinspect - 1.0

Logical decoding components inspection

Extension	Website	Attributes
Package	`pg_logicalinspect`
RPM	`postgresql$v-contrib`	DDL
DEB	`postgresql-$v`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pageinspect - 1.12

inspect the contents of database pages at a low level

Extension	Website	Attributes
Package	`pageinspect`
RPM	`postgresql$v-contrib`	DDL
DEB	`postgresql-$v`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pgrowlocks - 1.2

show row-level locking information

Extension	Website	Attributes
Package	`pgrowlocks`
RPM	`postgresql$v-contrib`	DDL
DEB	`postgresql-$v`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

sslinfo - 1.2

information about SSL certificates

Extension	Website	Attributes
Package	`sslinfo`
RPM	`postgresql$v-contrib`	DDL
DEB	`postgresql-$v`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_buffercache - 1.5

examine the shared buffer cache

Extension	Website	Attributes
Package	`pg_buffercache`
RPM	`postgresql$v-contrib`	DDL
DEB	`postgresql-$v`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_walinspect - 1.1

functions to inspect contents of PostgreSQL Write-Ahead Log

Extension	Website	Attributes
Package	`pg_walinspect`
RPM	`postgresql$v-contrib`	DDL
DEB	`postgresql-$v`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_freespacemap - 1.2

examine the free space map (FSM)

Extension	Website	Attributes
Package	`pg_freespacemap`
RPM	`postgresql$v-contrib`	DDL
DEB	`postgresql-$v`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_visibility - 1.2

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

Extension	Website	Attributes
Package	`pg_visibility`
RPM	`postgresql$v-contrib`	DDL
DEB	`postgresql-$v`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pgstattuple - 1.5

show tuple-level statistics

Extension	Website	Attributes
Package	`pgstattuple`
RPM	`postgresql$v-contrib`	DDL
DEB	`postgresql-$v`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

auto_explain - -

Provides a means for logging execution plans of slow statements automatically

Extension	Website	Attributes
Package	`auto_explain`	LOAD
RPM	`postgresql$v-contrib`
DEB	`postgresql-$v`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14

pg_stat_statements - 1.11

track planning and execution statistics of all SQL statements executed

Extension	Website	Attributes
Package	`pg_stat_statements`	LOAD
RPM	`postgresql$v-contrib`	DDL
DEB	`postgresql-$v`	LIB
Language	C
License	PostgreSQL

OS/Arch	x86_64	aarch64
el8	18 17 16 15 14	18 17 16 15 14
el9	18 17 16 15 14	18 17 16 15 14
d12	18 17 16 15 14	18 17 16 15 14
u22	18 17 16 15 14	18 17 16 15 14
u24	18 17 16 15 14	18 17 16 15 14