select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

pg_show_plans · show query plans of all currently running SQL statements · 2.1.8 · Monitoring · PostgreSQL · C · Packagedpgsentinel · active session history · 1.4.2 · Monitoring · PostgreSQL · C · Packagedpg_wait_sampling · sampling based statistics of wait events · 1.1.11 · Monitoring · PostgreSQL · C · Packagedsystem_stats · EnterpriseDB system statistics for PostgreSQL · 4.1 · Monitoring · PostgreSQL · C · Packagedpg_query_state · Tool for query progress monitoring in PostgreSQL · 1.2 · Monitoring · PostgreSQL · C · Not packagedopm_core · Central module of the OPM suite · 2.6 · Monitoring · PostgreSQL · C · Not packagedpg_statviz · Capture PostgreSQL statistics snapshots for time-series analysis and visualization · 1.2 · Monitoring · PostgreSQL · SQL · Packagedpowa · PostgreSQL Workload Analyser-core · 5.3.0 · Monitoring · PostgreSQL · PLpgSQL · Packagedpg_track_settings · Track settings changes · 2.1.2 · Monitoring · PostgreSQL · SQL · Packageddsef · DiffStats and ExplainFull: detailed SQL reports for third party help & support · 2024.4.9 · Monitoring · PostgreSQL · SQL · Not packagedpg_stat_plans · Track per-plan call counts, execution times, and example EXPLAIN texts. · 2.1.0 · Monitoring · PostgreSQL · C · Packagedbgw_replstatus · Small PostgreSQL background worker to report whether a node is a replication master or standby · 1.0.8 · Monitoring · PostgreSQL · C · Packagedpg_stat_log · Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE. · 0.1 · Monitoring · PostgreSQL · C · Packagedpgtelemetry · Provides monitoring views and functions for PostgreSQL activity, storage, locks, replication, WAL, vacuum, and query statistics. · 1.7 · Monitoring · PostgreSQL · SQL · Not packagedpg_relusage · Log all the queries that reference a particular column · 0.0.1 · Monitoring · PostgreSQL · C · Packagedpg_backtrace · Show backtrace for errors and signals · 1.0 · Monitoring · PostgreSQL · C · Not packagedpgsampler · Experimental PostgreSQL background worker that collects time-series status and performance metrics. · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_sampletolog · Samples statements or whole transactions into PostgreSQL logs through executor and utility hooks. · 2.0.0 · Monitoring · PostgreSQL · C · Not packagedpg_logging · Captures PostgreSQL log records in a shared-memory ring buffer and exposes them through SQL functions. · 0.2 · Monitoring · PostgreSQL · C · Not packagedpg_sortstats · Collect per-query sort statistics and estimate required work_mem · 0.0.1 · Monitoring · PostgreSQL · C · Not packagedpg_log_statements · Enables log_statement=all selectively for chosen PostgreSQL backend processes or newly started backends matching connection filters. · 0.0.2 · Monitoring · PostgreSQL · C · Not packagedpg_log_userqueries · Module to log user queries · 1.0.0 · Monitoring · PostgreSQL · C · Not packagedgeneric_plan · Generate a generic plan for a parameterized SQL statement. · 1.0 · Monitoring · PostgreSQL · SQL · Not packagedlog_functions · Module to log functions · 1.0.0 · Monitoring · PostgreSQL · C · Not packagedpg_stat_sql_plans · Track execution statistics by normalized SQL query and plan ID. · 0.2 · Monitoring · PostgreSQL · C · Not packagedpg_subxact_counters · Global counters for PostgreSQL subtransaction activity · 1.0 · Monitoring · PostgreSQL · C · Not packagedconfig_log · custom background worker process to log changes to postgresql.conf to a table · 0.1.7 · Monitoring · PostgreSQL · C · Not packagedpg_octopus · Runs a background worker that periodically connects to configured PostgreSQL nodes and records their health status. · 0.1 · Monitoring · PostgreSQL · C · Not packagedprogress · progress: query-progress estimation for a patched PostgreSQL 9.3 development branch · 0.0.1 · Monitoring · PostgreSQL · C · Not packagedpg_feedback · PostgreSQL extension that generates a report about database usage · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_logqueryid · Logs pg_stat_statements query IDs alongside auto_explain output. · 0.0.1 · Monitoring · PostgreSQL · C · Not packagedpg_queryid · Compute configurable external query fingerprints for PostgreSQL · 0.0.1 · Monitoring · PostgreSQL · C · Not packagedquerymem · pgEdge Labs: The querymem Postgres extension for estimating query memory usage · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_track_slow_queries · Tracks slow queries and their execution plans · 1.0 · Monitoring · PostgreSQL · C · Not packagedtimeit · High-resolution benchmarking of PostgreSQL built-in functions and SQL expressions. · 1.0 · Monitoring · PostgreSQL · C · Not packageddb_info · Functions and views reporting database size, ownership, tablespaces, extensions, and object counts. · 0.2.0 · Monitoring · PostgreSQL · SQL · Not packagedpg_llm_helper · Captures PostgreSQL errors in shared memory and exposes history plus an optional pgai-backed LLM troubleshooting function. · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_memorycontext · Examines PostgreSQL memory context information. · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_stat_backtrace · Capture or log C-level stack backtraces of PostgreSQL processes · 1.0.0 · Monitoring · PostgreSQL · C · Packagedtoastinfo · show details on toasted datums · 1.7 · Monitoring · PostgreSQL · C · Packagedpg_get_queryid · get last queryid generated/used by pg_stat_statements for a given backend pid · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_log · displays log content from SQL · 1.0.0 · Monitoring · PostgreSQL · C · Not packagedpg_monitoring · Provides a common SQL interface for collecting PostgreSQL replication, table-load and database-load monitoring statistics. · 0.2 · Monitoring · PostgreSQL · SQL · Not packagedpg_procfs · displays /proc data from SQL · 0.0.1 · Monitoring · PostgreSQL · C · Not packagedstatsmgr · C extension that snapshots PostgreSQL cumulative WAL, SLRU, checkpoint, archiver, I/O, and background-writer statistics in dynamic shared memory. · 0.1-alpha · Monitoring · PostgreSQL · C · Not packagedpg_plan_guard · Detect drift from approved PostgreSQL 19 plan-advice baselines · 1.1 · Monitoring · PostgreSQL · PLpgSQL · Not packagedpg_stat_errors · Cluster-wide error-class counters with a bounded sample of recent errors. · 1.2 · Monitoring · PostgreSQL · C · Not packagedxl_global_views · Creates global pgxl_ views over Postgres-XL nodes based on pg_ views. · 0.0.1 · Monitoring · PostgreSQL · SQL · Not packagedauto_explain · Provides a means for logging execution plans of slow statements automatically · - · Monitoring · PostgreSQL · C · Packagedlogfmt · logfmt log collector · 1.0.0 · Monitoring · PostgreSQL · SQL · Not packagedmods_since_analyze · Estimation of number of changed tuples · 1.0.0 · Monitoring · PostgreSQL · C · Not packagedpageinspect · inspect the contents of database pages at a low level · 1.12 · Monitoring · PostgreSQL · C · Packagedpg_buffercache · examine the shared buffer cache · 1.5 · Monitoring · PostgreSQL · C · Packagedpg_freespacemap · examine the free space map (FSM) · 1.2 · Monitoring · PostgreSQL · C · Packagedpg_logicalinspect · Logical decoding components inspection · 1.0 · Monitoring · PostgreSQL · C · Packagedpg_overexplain · Allow EXPLAIN to dump even more details · 1.0 · Monitoring · PostgreSQL · C · Packagedpg_stat_conn · Cumulative connection, disconnection, and authentication-failure counts by database and role. · 1.0 · Monitoring · PostgreSQL · C · Not packagedpg_stat_statements · track planning and execution statistics of all SQL statements executed · 1.11 · Monitoring · PostgreSQL · C · Packagedpg_stat_statements2 · Track SQL execution statistics using a PostgreSQL 9.4 pg_stat_statements derivative integrated with sql_firewall · 1.2 · Monitoring · PostgreSQL · C · Not packagedpg_visibility · examine the visibility map (VM) and page-level visibility info · 1.2 · Monitoring · PostgreSQL · C · Packagedpg_walinspect · functions to inspect contents of PostgreSQL Write-Ahead Log · 1.1 · Monitoring · PostgreSQL · C · Packagedpgrowlocks · show row-level locking information · 1.2 · Monitoring · PostgreSQL · C · Packagedpgstattuple · show tuple-level statistics · 1.5 · Monitoring · PostgreSQL · C · Packagedplaninstr · Planner hook for measuring PostgreSQL planning time, intended mainly for debugging. · 0.0.1 · Monitoring · PostgreSQL · C · Not packagedpr_grapher · Grapher process for OPM · 1.1 · Monitoring · PostgreSQL · JavaScript · Not packagedsslinfo · information about SSL certificates · 1.2 · Monitoring · PostgreSQL · C · Packagedstreaming_lag · A custom background worker process to measure lag in units of time · 0.0.1 · Monitoring · PostgreSQL · C · Not packaged

67 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
mods_since_analyze 1.0.0 Estimation of number of changed tuples STAT PostgreSQL C
pageinspect 1.12 inspect the contents of database pages at a low level STAT PostgreSQL C 14–18
pg_buffercache 1.5 examine the shared buffer cache STAT PostgreSQL C 14–18
pg_freespacemap 1.2 examine the free space map (FSM) STAT PostgreSQL C 14–18
pg_logicalinspect 1.0 Logical decoding components inspection STAT PostgreSQL C 18
pg_overexplain 1.0 Allow EXPLAIN to dump even more details STAT PostgreSQL C 18
pg_stat_conn 1.0 Cumulative connection, disconnection, and authentication-failure counts by database and role. STAT PostgreSQL C 15–18
pg_stat_statements 1.11 track planning and execution statistics of all SQL statements executed STAT PostgreSQL C 14–18
pg_stat_statements2 1.2 Track SQL execution statistics using a PostgreSQL 9.4 pg_stat_statements derivative integrated with sql_firewall STAT PostgreSQL C
pg_visibility 1.2 examine the visibility map (VM) and page-level visibility info STAT PostgreSQL C 14–18
pg_walinspect 1.1 functions to inspect contents of PostgreSQL Write-Ahead Log STAT PostgreSQL C 15–18
pgrowlocks 1.2 show row-level locking information STAT PostgreSQL C 14–18
pgstattuple 1.5 show tuple-level statistics STAT PostgreSQL C 14–18
planinstr 0.0.1 Planner hook for measuring PostgreSQL planning time, intended mainly for debugging. STAT PostgreSQL C
pr_grapher 1.1 Grapher process for OPM STAT PostgreSQL JavaScript
sslinfo 1.2 information about SSL certificates STAT PostgreSQL C 14–18
streaming_lag 0.0.1 A custom background worker process to measure lag in units of time STAT PostgreSQL C