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_statviz · Capture PostgreSQL statistics snapshots for time-series analysis and visualization · 1.2 · Monitoring · PostgreSQL · SQL · Packagedpgfr_analyze · Reporting and analysis functions for pgfr_record · 2.29.2 · Monitoring · Apache-2.0 · SQL · Packagedpgfr_record · Server-side PostgreSQL performance flight recorder · 2.29.2 · Monitoring · Apache-2.0 · SQL · 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 packagedpagevis · Visualise database pages in ascii code · 0.1 · Monitoring · MIT · SQL · Packagedpgtelemetry · Provides monitoring views and functions for PostgreSQL activity, storage, locks, replication, WAL, vacuum, and query statistics. · 1.7 · Monitoring · PostgreSQL · SQL · Not packagedmeta · Normalized, friendlier system catalog for PostgreSQL · 0.4.0 · Monitoring · BSD-2-Clause · SQL · Packagedpg_stats · Customized statistics views · 1.0 · Monitoring · Unknown · SQL · Not packagedexplanation · EXPLAIN plan parser that returns plan nodes as relational rows organized as a proximity tree. · 0.3.0 · Monitoring · BSD-3-Clause · SQL · Not packagedgeneric_plan · Generate a generic plan for a parameterized SQL statement. · 1.0 · Monitoring · PostgreSQL · SQL · Not packagedpg_sqlog · Provide SQL interface to logs · 1.6 · Monitoring · BSD-3-Clause · SQL · Packagedpg_eyes · SQL monitoring functions and views for PostgreSQL database activity · 1.4 · Monitoring · MIT · SQL · Not packageddb_info · Functions and views reporting database size, ownership, tablespaces, extensions, and object counts. · 0.2.0 · Monitoring · PostgreSQL · SQL · Not packagedsupa_agent_trace · A browser extension and agent for Supabase · 0.1.0 · Monitoring · MIT · SQL · Not packagedmv_stats · Tracks creation, alteration, refresh, and reset statistics for materialized views. · 0.3.0 · Monitoring · Unknown · SQL · Not packagedpg_dbwa · Analyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots. · 0.3.1 · Monitoring · MIT · SQL · 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 packagedresources · Linux server resource monitoring views backed by file_fdw PROGRAM foreign tables. · 0.1.0 · Monitoring · Unknown · SQL · Not packagedmonitoring_role · Security-definer monitoring wrappers for a non-privileged role · 0.0.1 · Monitoring · WTFPL · SQL · Not packagedstreaminglag · SQL helpers that convert WAL LSNs to integers and estimate primary-to-standby streaming replication lag in bytes. · 1.0 · Monitoring · BSD-2-Clause · SQL · Not packagedxl_global_views · Creates global pgxl_ views over Postgres-XL nodes based on pg_ views. · 0.0.1 · Monitoring · PostgreSQL · SQL · Not packageddventimi@pg_flight_recorder · Server-side flight recorder for PostgreSQL performance monitoring · 2.26.3 · Monitoring · Unknown · SQL · Not packageddventimi@pg_flight_recorder_control · Control functions for pg_flight_recorder · 2.26.3 · Monitoring · Unknown · SQL · Not packageddventimi@pg_flight_recorder_reporting · Reporting and analysis functions for pg_flight_recorder · 2.26.3 · Monitoring · Unknown · SQL · Not packagedjessevent@supa_profile · Database table and column statistical profiler · 1.0.0 · Monitoring · Unknown · SQL · Not packagedlogfmt · logfmt log collector · 1.0.0 · Monitoring · PostgreSQL · SQL · Not packaged

27 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
pg_statviz 1.2 Capture PostgreSQL statistics snapshots for time-series analysis and visualization STAT PostgreSQL SQL 14–18 108
pgfr_analyze 2.29.2 Reporting and analysis functions for pgfr_record STAT Apache-2.0 SQL 15–18 81
pgfr_record 2.29.2 Server-side PostgreSQL performance flight recorder STAT Apache-2.0 SQL 15–18 81
pg_track_settings 2.1.2 Track settings changes STAT PostgreSQL SQL 14–18 55
dsef 2024.4.9 DiffStats and ExplainFull: detailed SQL reports for third party help & support STAT PostgreSQL SQL 52
pagevis 0.1 Visualise database pages in ascii code STAT MIT SQL 14–18 31
pgtelemetry 1.7 Provides monitoring views and functions for PostgreSQL activity, storage, locks, replication, WAL, vacuum, and query statistics. STAT PostgreSQL SQL 10–17 27
meta 0.4.0 Normalized, friendlier system catalog for PostgreSQL STAT BSD-2-Clause SQL 14–18 24
pg_stats 1.0 Customized statistics views STAT SQL 19
explanation 0.3.0 EXPLAIN plan parser that returns plan nodes as relational rows organized as a proximity tree. STAT BSD-3-Clause SQL 10–14 13
generic_plan 1.0 Generate a generic plan for a parameterized SQL statement. STAT PostgreSQL SQL 11
pg_sqlog 1.6 Provide SQL interface to logs STAT BSD-3-Clause SQL 14–18 7
pg_eyes 1.4 SQL monitoring functions and views for PostgreSQL database activity STAT MIT SQL 10–18 5
db_info 0.2.0 Functions and views reporting database size, ownership, tablespaces, extensions, and object counts. STAT PostgreSQL SQL 11–18 4
supa_agent_trace 0.1.0 A browser extension and agent for Supabase STAT MIT SQL 3
mv_stats 0.3.0 Tracks creation, alteration, refresh, and reset statistics for materialized views. STAT SQL 10–18 2
pg_dbwa 0.3.1 Analyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots. STAT MIT SQL 2
pg_monitoring 0.2 Provides a common SQL interface for collecting PostgreSQL replication, table-load and database-load monitoring statistics. STAT PostgreSQL SQL 10–18 2
resources 0.1.0 Linux server resource monitoring views backed by file_fdw PROGRAM foreign tables. STAT SQL 10–18 2
monitoring_role 0.0.1 Security-definer monitoring wrappers for a non-privileged role STAT WTFPL SQL 1
streaminglag 1.0 SQL helpers that convert WAL LSNs to integers and estimate primary-to-standby streaming replication lag in bytes. STAT BSD-2-Clause SQL 10–18 1
xl_global_views 0.0.1 Creates global pgxl_ views over Postgres-XL nodes based on pg_ views. STAT PostgreSQL SQL 1
dventimi@pg_flight_recorder 2.26.3 Server-side flight recorder for PostgreSQL performance monitoring STAT SQL
dventimi@pg_flight_recorder_control 2.26.3 Control functions for pg_flight_recorder STAT SQL
dventimi@pg_flight_recorder_reporting 2.26.3 Reporting and analysis functions for pg_flight_recorder STAT SQL
jessevent@supa_profile 1.0.0 Database table and column statistical profiler STAT SQL
logfmt 1.0.0 logfmt log collector STAT PostgreSQL SQL