Category: STAT
44 extensions
-
pg_profile
PostgreSQL load profile repository and report builder
-
pg_tracing
Distributed Tracing for PostgreSQL
-
pg_stat_ch
Export PostgreSQL query telemetry to ClickHouse
-
pg_stat_backtrace
Capture or log C-level stack backtraces of PostgreSQL processes
-
pg_stat_log
Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE.
-
pg_stat_plans
Track per-plan call counts, execution times, and example EXPLAIN texts.
-
pgfr_record
Server-side PostgreSQL performance flight recorder
-
pgfr_analyze
Reporting and analysis functions for pgfr_record
-
pgmonitor
Collector-friendly metric views and background refresh worker
-
pg_statviz
Capture PostgreSQL statistics snapshots for time-series analysis and visualization
-
pg_show_plans
show query plans of all currently running SQL statements
-
pg_stat_kcache
Kernel statistics gathering
-
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.
-
pg_qualstats
An extension collecting statistics about quals
-
pg_store_plans
track plan statistics of all SQL statements executed
-
pg_track_settings
Track settings changes
-
pg_track_optimizer
Track planning decisions in comparison with execution reality
-
pg_wait_sampling
sampling based statistics of wait events
-
pg_datasentinel
Observability and activity monitoring extension for PostgreSQL
-
pgsentinel
active session history
-
system_stats
EnterpriseDB system statistics for PostgreSQL
-
meta
Normalized, friendlier system catalog for PostgreSQL
-
pgnodemx
Capture node OS metrics via SQL queries
-
pg_proctab
PostgreSQL extension to access the OS process table
-
pg_sqlog
Provide SQL interface to logs
-
bgw_replstatus
Small PostgreSQL background worker to report whether a node is a replication master or standby
-
pgmeminfo
show memory usage
-
toastinfo
show details on toasted datums
-
explain_ui
easily jump into a visual plan UI for any SQL query
-
pg_relusage
Log all the queries that reference a particular column
-
pagevis
Visualise database pages in ascii code
-
powa
PostgreSQL Workload Analyser-core
-
pg_overexplain
Allow EXPLAIN to dump even more details
-
pg_logicalinspect
Logical decoding components inspection
-
pageinspect
inspect the contents of database pages at a low level
-
pgrowlocks
show row-level locking information
-
sslinfo
information about SSL certificates
-
pg_buffercache
examine the shared buffer cache
-
pg_walinspect
functions to inspect contents of PostgreSQL Write-Ahead Log
-
pg_freespacemap
examine the free space map (FSM)
-
pg_visibility
examine the visibility map (VM) and page-level visibility info
-
pgstattuple
show tuple-level statistics
-
auto_explain
Provides a means for logging execution plans of slow statements automatically
-
pg_stat_statements
track planning and execution statistics of all SQL statements executed