PIGSTY

By Attribute

PostgreSQL extensions organized by Attribute


Need Loading

Extensions that require dynamic loading in shared_preload_libraries to work properly.

IDExtensionPackageDescription
7050anonpg_anonPostgreSQL Anonymizer (anon) extension
7970auth_delayauth_delaypause briefly before reporting authentication failure
6980auto_explainauto_explainProvides a means for logging execution plans of slow statements automatically
9310babelfishpg_tsqlbabelfishpg_tsqlSQL Server Transact SQL compatibility
6340bgw_replstatusbgw_replstatusSmall PostgreSQL background worker to report whether a node is a replication master or standby
2400cituscitusDistributed PostgreSQL as an extension
9000documentdbdocumentdbAPI surface for DocumentDB for PostgreSQL
9010documentdb_coredocumentdbCore API surface for DocumentDB for PostgreSQL
9020documentdb_distributeddocumentdbMulti-Node API surface for DocumentDB
7210nosetpg_nosetModule for blocking SET variables for non-super users.
2951omniomnigresAdvanced adapter for Postgres extensions
7990passwordcheckpasswordcheckchecks user passwords and reject weak password
7000passwordcheck_cracklibpasswordcheckStrengthen PostgreSQL user password checks with cracklib
2140pg_bestmatchpg_bestmatchGenerate BM25 sparse vector inside PostgreSQL
5190pg_crashpg_crashSend random signals to random processes
1070pg_cronpg_cronJob scheduler for PostgreSQL
2430pg_duckdbpg_duckdbDuckDB Embedded in Postgres
9530pg_failover_slotspg_failover_slotsPG Failover Slots extension
4080pg_netpg_netAsync HTTP Requests
6880pg_overexplainpg_overexplainAllow EXPLAIN to dump even more details
2460pg_parquetpg_parquetcopy data between Postgres and Parquet
5890pg_prewarmpg_prewarmprewarm relation data
6240pg_qualstatspg_qualstatsAn extension collecting statistics about quals
6380pg_relusagepg_relusageLog all the queries that reference a particular column
7170pg_snakeoilpg_snakeoilThe PostgreSQL Antivirus
5020pg_squeezepg_squeezeA tool to remove unused space from a relation.
6220pg_stat_kcachepg_stat_kcacheKernel statistics gathering
6230pg_stat_monitorpg_stat_monitorThe 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.
6990pg_stat_statementspg_stat_statementstrack planning and execution statistics of all SQL statements executed
9130pg_statement_rollbackpg_statement_rollbackServer side rollback at statement level for PostgreSQL like Oracle or DB2
6250pg_store_planspg_store_planstrack plan statistics of all SQL statements executed
1080pg_taskpg_taskexecute any sql command at any specific time at background
7060pg_tdepg_tdepg_tde access method
3000pg_tlepg_tleTrusted Language Extensions for PostgreSQL
6010pg_tracingpg_tracingDistributed Tracing for PostgreSQL
6270pg_wait_samplingpg_wait_samplingsampling based statistics of wait events
9550pgactivepglogicalActive-Active Replication Extension for PostgreSQL
7080pgauditpgauditprovides auditing functionality
5120pgautofailoverpgautofailoverpg_auto_failover
7180pgextwlistpgextwlistPostgreSQL Extension Whitelisting
3540pglite_fusionpglite_fusionEmbed an SQLite database in your PostgreSQL table
9510pglogical_tickerpglogical_tickerHave an accurate view on pglogical replication delay
1890pgmlpgmlRun AL/ML workloads with SQL interface
3530pgpdfpgpdfPDF type with meta admin & Full-Text Search
6280pgsentinelpgsentinelactive session history
7020pgsodiumpgsodiumPostgres extension for libsodium functions
4510pgx_ulidpgx_ulidulid type and methods
2850plan_filterpg_plan_filterfilter statements by their execution plans.
3060plpgsql_checkplpgsql_checkextended check for plpgsql functions
5820safeupdatesafeupdateRequire criteria for UPDATE and DELETE
7960sepgsqlsepgsqllabel-based mandatory access control (MAC) based on SELinux security policy.
7010supautilssupautilsExtension that secures a cluster on a cloud environment
1000timescaledbtimescaledbEnables scalable inserts and complex queries for time-series data
1810vchordvchordVector database plugin for Postgres, written in Rust
2150vchord_bm25vchord_bm25A postgresql extension for bm25 ranking algorithm

Without DDL

These extensions do not have DDL, so you don't need to run CREATE EXTENSION to use them.

IDExtensionPackageDescription
7970auth_delayauth_delaypause briefly before reporting authentication failure
6980auto_explainauto_explainProvides a means for logging execution plans of slow statements automatically
5950basebackup_to_shellbasebackup_to_shelladds a custom basebackup target called shell
5940basic_archivebasic_archivean example of an archive module
6340bgw_replstatusbgw_replstatusSmall PostgreSQL background worker to report whether a node is a replication master or standby
9660decoder_rawdecoder_rawOutput plugin for logical replication in Raw SQL format
9650decoderbufsdecoderbufsLogical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
7990passwordcheckpasswordcheckchecks user passwords and reject weak password
7000passwordcheck_cracklibpasswordcheckStrengthen PostgreSQL user password checks with cracklib
5080pg_checksumspg_checksumsActivate/deactivate/verify checksums in offline Postgres clusters
5190pg_crashpg_crashSend random signals to random processes
9530pg_failover_slotspg_failover_slotsPG Failover Slots extension
6880pg_overexplainpg_overexplainAllow EXPLAIN to dump even more details
6380pg_relusagepg_relusageLog all the queries that reference a particular column
7170pg_snakeoilpg_snakeoilThe PostgreSQL Antivirus
9130pg_statement_rollbackpg_statement_rollbackServer side rollback at statement level for PostgreSQL like Oracle or DB2
1080pg_taskpg_taskexecute any sql command at any specific time at background
7180pgextwlistpgextwlistPostgreSQL Extension Whitelisting
9980pgoutputpgoutputLogical Replication output plugin
2850plan_filterpg_plan_filterfilter statements by their execution plans.
5820safeupdatesafeupdateRequire criteria for UPDATE and DELETE
7960sepgsqlsepgsqllabel-based mandatory access control (MAC) based on SELinux security policy.
7010supautilssupautilsExtension that secures a cluster on a cloud environment
9970test_decodingtest_decodingSQL-based test/example module for WAL logical decoding
9630wal2jsonwal2jsonChanging data capture in JSON format
9640wal2mongowal2mongoPostgreSQL logical decoding output plugin for MongoDB

Has Dependency

Extensions that have dependencies on other extensions.

ExtensionDependencies
babelfishpg_tdsbabelfishpg_tsql
babelfishpg_tsqlbabelfishpg_common, uuid-ossp
bool_plperlplperl
bool_plperluplperlu
data_historizationplpgsql
ddl_historizationplpgsql
documentdbdocumentdb_core, pg_cron, tsm_system_rows, vector, postgis, rum
earthdistancecube
emajdblink, btree_gist
geoipip4r
h3_postgish3, postgis, postgis_raster
hstore_plluahstore, pllua
hstore_plluauhstore, plluau
hstore_plperlplperl
hstore_plperluplperlu
hstore_plpython3uhstore, plpython3u
jsonb_plperlplperl
jsonb_plperluplperlu
jsonb_plpython3uplpython3u
l10n_table_dependent_extensionpg_xenophile
ltree_plpython3ultree, plpython3u
mimeodblink
mobilitydbpostgis
omni_authomni_types, omni_id, pgcrypto, btree_gist, omni_polyfill
omni_awsomni_httpc, pgcrypto, omni_xml, omni_web
omni_cloudeventsomni_web
omni_containersomni_httpc, omni_web
omni_credentialspgcrypto, omni_os
omni_emailomni_id, omni_cloudevents, omni_polyfill
omni_httpcomni_http, omni_types
omni_httpdomni_types, omni_http
omni_kubeomni_httpc, omni_web, omni_var, pgcrypto
omni_ledgeromni_id, omni_polyfill
omni_pythonplpython3u
omni_restomni_httpd, omni_sql, omni_web, omni_var, pgcrypto
omni_schemaomni_sql, omni_vfs, dblink
omni_sessionomni_var, omni_id, omni_web, omni_httpd, omni_polyfill
omni_testdblink
omni_vfs_types_v1omni_vfs_types_v1, dblink
periodsbtree_gist
pg4mlplpgsql, tablefunc, cube, plpython3u
pg_drop_eventsplpgsql
pg_incrementalpg_cron
pg_jobmondblink
pg_laterpgmq
pg_profiledblink, plpgsql
pg_readmehstore
pg_readme_test_extensionhstore
pg_sqlogfile_fdw
pg_stat_kcachepg_stat_statements
pg_uplessplpgsql
pgautofailoverbtree_gist
pgcryptokeypgcrypto
pgfacetingroaringbitmap
pgl_ddl_deploypglogical
pglogical_tickerpglogical
pgroutingpostgis
plperlplperl
plperluplperlu
plpgsql_checkplpgsql
pointcloud_postgispostgis, pointcloud
postgis_rasterpostgis
postgis_sfcgalpostgis
postgis_tiger_geocoderpostgis, fuzzystrmatch
postgis_topologypostgis
powaplpgsql, pg_stat_statements, btree_gist
schedocddl_historization
sparqlplperl, plperlu
supabase_vaultpgsodium
table_versionplpgsql
timeseriescolumnar, pg_cron, pg_ivm, pg_partman
unitplpgsql
vchordvector
vectorizepg_cron, pgmq, vector
vectorscalevector

Multiple Extension

These packages contain multiple extensions simultaneously: