Category: STAT
STAT: Observability Catalogs, Monitoring Metrics & Views, Statistics, Query Plans, WaitSampling, SlowLogs, and etc…
Tags: STAT
pg_proctab
PostgreSQL extension to access the OS process table
Module:
Categories:
pg_profile
PostgreSQL load profile repository and report builder
Module:
Categories:
pg_show_plans
show query plans of all currently running SQL statements
Module:
Categories:
pg_stat_kcache
Kernel statistics gathering
Module:
Categories:
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.
Module:
Categories:
pg_qualstats
An extension collecting statistics about quals
Module:
Categories:
pg_store_plans
track plan statistics of all SQL statements executed
Module:
Categories:
pg_track_settings
Track settings changes
Module:
Categories:
pg_wait_sampling
sampling based statistics of wait events
Module:
Categories:
system_stats
EnterpriseDB system statistics for PostgreSQL
Module:
Categories:
meta
Normalized, friendlier system catalog for PostgreSQL
Module:
Categories:
pgnodemx
Capture node OS metrics via SQL queries
Module:
Categories:
pg_sqlog
Provide SQL interface to logs
Module:
Categories:
bgw_replstatus
Small PostgreSQL background worker to report whether a node is a replication master or standby
Module:
Categories:
pgmeminfo
show memory usage
Module:
Categories:
toastinfo
show details on toasted datums
Module:
Categories:
explain_ui
easily jump into a visual plan UI for any SQL query
Module:
Categories:
pg_relusage
Log all the queries that reference a particular column
Module:
Categories:
pg_mon
PostgreSQL extension to enhance query monitoring
Module:
Categories:
pg_statviz
stats visualization and time series analysis
Module:
Categories:
pgexporter_ext
pgexporter extension for extra metrics
Module:
Categories:
pg_top
Monitor PostgreSQL processes similar to unix top
Module:
Categories:
pagevis
Visualise database pages in ascii code
Module:
Categories:
powa
PostgreSQL Workload Analyser-core
Module:
Categories:
pageinspect
inspect the contents of database pages at a low level
Module:
Categories:
pgrowlocks
show row-level locking information
Module:
Categories:
sslinfo
information about SSL certificates
Module:
Categories:
pg_buffercache
examine the shared buffer cache
Module:
Categories:
pg_walinspect
functions to inspect contents of PostgreSQL Write-Ahead Log
Module:
Categories:
pg_freespacemap
examine the free space map (FSM)
Module:
Categories:
pg_visibility
examine the visibility map (VM) and page-level visibility info
Module:
Categories:
pgstattuple
show tuple-level statistics
Module:
Categories:
auto_explain
Provides a means for logging execution plans of slow statements automatically
Module:
Categories:
pg_stat_statements
track planning and execution statistics of all SQL statements executed