Category: STAT

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

Module:

PGSQL

Tags:

STAT

STAT category has 31 available extensions:

Name (Detail)	Package (Repo)	Repo	Version	Category	License	Description
pg_profile	`pg_profile`	MIXED	4.8	`STAT`	BSD 2	PostgreSQL load profile repository and report builder
pg_tracing	`pg_tracing`	PIGSTY	0.1.0	`STAT`	MIT	Distributed Tracing for PostgreSQL
pg_show_plans	`pg_show_plans`	PGDG	2.1	`STAT`	PostgreSQL	show query plans of all currently running SQL statements
pg_stat_kcache	`pg_stat_kcache`	PGDG	2.3.0	`STAT`	BSD 3	Kernel statistics gathering
pg_stat_monitor	`pg_stat_monitor`	MIXED	2.1	`STAT`	BSD 3	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.
pg_qualstats	`pg_qualstats`	PGDG	2.1.1	`STAT`	BSD 3	An extension collecting statistics about quals
pg_store_plans	`pg_store_plans`	MIXED	1.8	`STAT`	BSD 3	track plan statistics of all SQL statements executed
pg_track_settings	`pg_track_settings`	PGDG	2.1.2	`STAT`	PostgreSQL	Track settings changes
pg_wait_sampling	`pg_wait_sampling`	PGDG	1.1	`STAT`	PostgreSQL	sampling based statistics of wait events
system_stats	`system_stats`	MIXED	3.0	`STAT`	PostgreSQL	EnterpriseDB system statistics for PostgreSQL
meta	`pg_meta`	PIGSTY	0.4.0	`STAT`	BSD 2	Normalized, friendlier system catalog for PostgreSQL
pgnodemx	`pgnodemx`	PIGSTY	1.7	`STAT`	Apache-2.0	Capture node OS metrics via SQL queries
pg_proctab	`pgnodemx`	PIGSTY	0.0.10-compat	`STAT`	BSD 3	PostgreSQL extension to access the OS process table
pg_sqlog	`pg_sqlog`	PIGSTY	1.6	`STAT`	BSD 3	Provide SQL interface to logs
bgw_replstatus	`bgw_replstatus`	PGDG	1.0.6	`STAT`	PostgreSQL	Small PostgreSQL background worker to report whether a node is a replication master or standby
pgmeminfo	`pgmeminfo`	MIXED	1.0	`STAT`	MIT	show memory usage
toastinfo	`toastinfo`	PIGSTY	1	`STAT`	PostgreSQL	show details on toasted datums
explain_ui	`pg_explain_ui`	PIGSTY	0.0.1	`STAT`	PostgreSQL	easily jump into a visual plan UI for any SQL query
pg_relusage	`pg_relusage`	PIGSTY	0.0.1	`STAT`	PostgreSQL	Log all the queries that reference a particular column
pagevis	`pagevis`	PIGSTY	0.1	`STAT`	MIT	Visualise database pages in ascii code
powa	`powa`	PGDG	5.0.1	`STAT`	PostgreSQL	PostgreSQL Workload Analyser-core
pageinspect	`pageinspect`	CONTRIB	1.12	`STAT`	PostgreSQL	inspect the contents of database pages at a low level
pgrowlocks	`pgrowlocks`	CONTRIB	1.2	`STAT`	PostgreSQL	show row-level locking information
sslinfo	`sslinfo`	CONTRIB	1.2	`STAT`	PostgreSQL	information about SSL certificates
pg_buffercache	`pg_buffercache`	CONTRIB	1.5	`STAT`	PostgreSQL	examine the shared buffer cache
pg_walinspect	`pg_walinspect`	CONTRIB	1.1	`STAT`	PostgreSQL	functions to inspect contents of PostgreSQL Write-Ahead Log
pg_freespacemap	`pg_freespacemap`	CONTRIB	1.2	`STAT`	PostgreSQL	examine the free space map (FSM)
pg_visibility	`pg_visibility`	CONTRIB	1.2	`STAT`	PostgreSQL	examine the visibility map (VM) and page-level visibility info
pgstattuple	`pgstattuple`	CONTRIB	1.5	`STAT`	PostgreSQL	show tuple-level statistics
auto_explain	`auto_explain`	CONTRIB	-	`STAT`	PostgreSQL	Provides a means for logging execution plans of slow statements automatically
pg_stat_statements	`pg_stat_statements`	CONTRIB	1.11	`STAT`	PostgreSQL	track planning and execution statistics of all SQL statements executed

pg_profile

PostgreSQL load profile repository and report builder

pg_show_plans

show query plans of all currently running SQL statements

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.