STAT - Monitoring & Stats

Extension List

There are 35 extensions in 34 packages.

pg_profile

pg_profile - 4.11 : PostgreSQL load profile repository and report builder

pg_tracing

pg_tracing - 0.1.3 : Distributed Tracing for PostgreSQL

pg_show_plans

pg_show_plans - 2.1.7 : show query plans of all currently running SQL statements

pg_stat_kcache

pg_stat_kcache - 2.3.1 : Kernel statistics gathering

pg_stat_monitor

pg_stat_monitor - 2.3.2 : 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 - 2.1.3 : An extension collecting statistics about quals

pg_store_plans

pg_store_plans - 1.9 : track plan statistics of all SQL statements executed

pg_track_settings

pg_track_settings - 2.1.2 : Track settings changes

pg_track_optimizer

pg_track_optimizer - 0.9.1 : Track planning decisions in comparison with execution reality

pg_wait_sampling

pg_wait_sampling - 1.1.9 : sampling based statistics of wait events

pgsentinel

pgsentinel - 1.4.0 : active session history

system_stats

system_stats - 3.2 : EnterpriseDB system statistics for PostgreSQL

meta

pg_meta - 0.4.0 : Normalized, friendlier system catalog for PostgreSQL

pgnodemx

pgnodemx - 1.7 : Capture node OS metrics via SQL queries

pg_proctab

pgnodemx - 1.7 : PostgreSQL extension to access the OS process table

pg_sqlog

pg_sqlog - 1.6 : Provide SQL interface to logs

bgw_replstatus

bgw_replstatus - 1.0.8 : Small PostgreSQL background worker to report whether a node is a replication master or standby

pgmeminfo

pgmeminfo - 1.0.0 : show memory usage

toastinfo

toastinfo - 1.5 : show details on toasted datums

explain_ui

pg_explain_ui - 0.0.2 : easily jump into a visual plan UI for any SQL query

pg_relusage

pg_relusage - 0.0.1 : Log all the queries that reference a particular column

pagevis

pagevis - 0.1 : Visualise database pages in ascii code

powa

powa - 5.1.1 : PostgreSQL Workload Analyser-core

pg_overexplain

pg_overexplain - 1.0 : Allow EXPLAIN to dump even more details

pg_logicalinspect

pg_logicalinspect - 1.0 : Logical decoding components inspection

pageinspect

pageinspect - 1.12 : inspect the contents of database pages at a low level

pgrowlocks

pgrowlocks - 1.2 : show row-level locking information

sslinfo

sslinfo - 1.2 : information about SSL certificates

pg_buffercache

pg_buffercache - 1.5 : examine the shared buffer cache

pg_walinspect

pg_walinspect - 1.1 : functions to inspect contents of PostgreSQL Write-Ahead Log

pg_freespacemap

pg_freespacemap - 1.2 : examine the free space map (FSM)

pg_visibility

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

pgstattuple

pgstattuple - 1.5 : show tuple-level statistics

auto_explain

auto_explain - - : Provides a means for logging execution plans of slow statements automatically

pg_stat_statements

pg_stat_statements - 1.11 : track planning and execution statistics of all SQL statements executed