By Repository
PostgreSQL Extensions organized by Repository Source
There are 421 PostgreSQL extensions in total: 71 CONTRIB extensions, 331 available on both EL and Debian platforms, 13 available only on EL platforms, and 6 available only on Debian platforms.
| Entry | ALL | CONTRIB | Both | EL Only | Debian Only |
|---|---|---|---|---|---|
| Count | 421 | 71 | 331 | 13 | 6 |
CONTRIB
Extensions that come with PostgreSQL core distribution. There are 71 contrib extensions.
| ID | Extension | Package | Description |
|---|---|---|---|
| 1690 | earthdistance | earthdistance | calculate great-circle distances on the surface of the Earth |
| 2180 | fuzzystrmatch | fuzzystrmatch | determine similarities and distance between strings |
| 2190 | pg_trgm | pg_trgm | text similarity measurement and index searching based on trigrams |
| 2590 | tablefunc | tablefunc | functions that manipulate whole tables, including crosstab |
| 2990 | bloom | bloom | bloom access method - signature file based index |
| 3240 | pltcl | pltcl | PL/Tcl procedural language |
| 3250 | pltclu | pltcl | PL/TclU untrusted procedural language |
| 3260 | plperl | plperl | PL/Perl procedural language |
| 3261 | bool_plperl | plperl | transform between bool and plperl |
| 3262 | hstore_plperl | plperl | transform between hstore and plperl |
| 3263 | jsonb_plperl | plperl | transform between jsonb and plperl |
| 3270 | plperlu | plperlu | PL/PerlU untrusted procedural language |
| 3271 | bool_plperlu | plperlu | transform between bool and plperlu |
| 3272 | jsonb_plperlu | plperlu | transform between jsonb and plperlu |
| 3273 | hstore_plperlu | plperlu | transform between hstore and plperlu |
| 3280 | plpgsql | plpgsql | PL/pgSQL procedural language |
| 3290 | plpython3u | plpython3u | PL/Python3U untrusted procedural language |
| 3291 | jsonb_plpython3u | plpython3u | transform between jsonb and plpython3u |
| 3292 | ltree_plpython3u | plpython3u | transform between ltree and plpython3u |
| 3293 | hstore_plpython3u | plpython3u | transform between hstore and plpython3u |
| 3930 | isn | isn | data types for international product numbering standards |
| 3940 | seg | seg | data type for representing line segments or floating-point intervals |
| 3950 | cube | cube | data type for multidimensional cubes |
| 3960 | ltree | ltree | data type for hierarchical tree-like structures |
| 3970 | hstore | hstore | data type for storing sets of (key, value) pairs |
| 3980 | citext | citext | data type for case-insensitive character strings |
| 3990 | xml2 | xml2 | XPath querying and XSLT |
| 4880 | refint | refint | functions for implementing referential integrity (obsolete) |
| 4881 | autoinc | autoinc | functions for autoincrementing fields |
| 4882 | insert_username | insert_username | functions for tracking who changed a table |
| 4883 | moddatetime | moddatetime | functions for tracking last modification time |
| 4890 | tsm_system_time | tsm_system_time | TABLESAMPLE method which accepts time in milliseconds as a limit |
| 4900 | dict_xsyn | dict_xsyn | text search dictionary template for extended synonym processing |
| 4910 | tsm_system_rows | tsm_system_rows | TABLESAMPLE method which accepts number of rows as a limit |
| 4920 | tcn | tcn | Triggered change notifications |
| 4930 | uuid-ossp | uuid-ossp | generate universally unique identifiers (UUIDs) |
| 4940 | btree_gist | btree_gist | support for indexing common datatypes in GiST |
| 4950 | btree_gin | btree_gin | support for indexing common datatypes in GIN |
| 4960 | intarray | intarray | functions, operators, and index support for 1-D arrays of integers |
| 4970 | intagg | intagg | integer aggregator and enumerator (obsolete) |
| 4980 | dict_int | dict_int | text search dictionary template for integers |
| 4990 | unaccent | unaccent | text search dictionary that removes accents |
| 5890 | pg_prewarm | pg_prewarm | prewarm relation data |
| 5930 | lo | lo | Large Object maintenance |
| 5940 | basic_archive | basic_archive | an example of an archive module |
| 5950 | basebackup_to_shell | basebackup_to_shell | adds a custom basebackup target called shell |
| 5960 | old_snapshot | old_snapshot | utilities in support of old_snapshot_threshold |
| 5970 | adminpack | adminpack | administrative functions for PostgreSQL |
| 5980 | amcheck | amcheck | functions for verifying relation integrity |
| 5990 | pg_surgery | pg_surgery | extension to perform surgery on a damaged relation |
| 6880 | pg_overexplain | pg_overexplain | Allow EXPLAIN to dump even more details |
| 6890 | pg_logicalinspect | pg_logicalinspect | Logical decoding components inspection |
| 6900 | pageinspect | pageinspect | inspect the contents of database pages at a low level |
| 6910 | pgrowlocks | pgrowlocks | show row-level locking information |
| 6920 | sslinfo | sslinfo | information about SSL certificates |
| 6930 | pg_buffercache | pg_buffercache | examine the shared buffer cache |
| 6940 | pg_walinspect | pg_walinspect | functions to inspect contents of PostgreSQL Write-Ahead Log |
| 6950 | pg_freespacemap | pg_freespacemap | examine the free space map (FSM) |
| 6960 | pg_visibility | pg_visibility | examine the visibility map (VM) and page-level visibility info |
| 6970 | pgstattuple | pgstattuple | show tuple-level statistics |
| 6980 | auto_explain | auto_explain | Provides a means for logging execution plans of slow statements automatically |
| 6990 | pg_stat_statements | pg_stat_statements | track planning and execution statistics of all SQL statements executed |
| 7960 | sepgsql | sepgsql | label-based mandatory access control (MAC) based on SELinux security policy. |
| 7970 | auth_delay | auth_delay | pause briefly before reporting authentication failure |
| 7980 | pgcrypto | pgcrypto | cryptographic functions |
| 7990 | passwordcheck | passwordcheck | checks user passwords and reject weak password |
| 8970 | dblink | dblink | connect to other PostgreSQL databases from within a database |
| 8980 | file_fdw | file_fdw | foreign-data wrapper for flat file access |
| 8990 | postgres_fdw | postgres_fdw | foreign-data wrapper for remote PostgreSQL servers |
| 9970 | test_decoding | test_decoding | SQL-based test/example module for WAL logical decoding |
| 9980 | pgoutput | pgoutput | Logical Replication output plugin |
BOTH
There are 331 non-contrib extensions available in both EL and Debian platforms.
| ID | Name | Category | RPM | DEB | Description |
|---|---|---|---|---|---|
| 1000 | timescaledb | PIGSTY | PIGSTY | Enables scalable inserts and complex queries for time-series data | |
| 1010 | timescaledb_toolkit | PIGSTY | PIGSTY | Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities | |
| 1020 | timeseries | PIGSTY | PIGSTY | Convenience API for time series stack | |
| 1030 | periods | PGDG | PGDG | Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING | |
| 1040 | temporal_tables | PIGSTY | PIGSTY | temporal tables | |
| 1050 | emaj | PGDG | PIGSTY | Enables fine-grained write logging and time travel on subsets of the database. | |
| 1060 | table_version | PIGSTY | PIGSTY | PostgreSQL table versioning extension | |
| 1070 | pg_cron | PGDG | PGDG | Job scheduler for PostgreSQL | |
| 1080 | pg_task | PGDG | PIGSTY | execute any sql command at any specific time at background | |
| 1090 | pg_later | PIGSTY | PIGSTY | Run queries now and get results later | |
| 1100 | pg_background | PGDG | PIGSTY | Run SQL queries in the background | |
| 1500 | postgis | PGDG | PGDG | PostGIS geometry and geography spatial types and functions | |
| 1501 | postgis_topology | PGDG | PGDG | PostGIS topology spatial types and functions | |
| 1502 | postgis_raster | PGDG | PGDG | PostGIS raster types and functions | |
| 1503 | postgis_sfcgal | PGDG | PGDG | PostGIS SFCGAL functions | |
| 1504 | postgis_tiger_geocoder | PGDG | PGDG | PostGIS tiger geocoder and reverse geocoder | |
| 1505 | address_standardizer | PGDG | PGDG | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. | |
| 1506 | address_standardizer_data_us | PGDG | PGDG | Address Standardizer US dataset example | |
| 1510 | pgrouting | PGDG | PGDG | pgRouting Extension | |
| 1520 | pointcloud | PIGSTY | PGDG | data type for lidar point clouds | |
| 1521 | pointcloud_postgis | PGDG | PGDG | integration for pointcloud LIDAR data and PostGIS geometry data | |
| 1530 | h3 | PGDG | PGDG | H3 bindings for PostgreSQL | |
| 1531 | h3_postgis | PGDG | PGDG | H3 PostGIS integration | |
| 1540 | q3c | PIGSTY | PGDG | q3c sky indexing plugin | |
| 1550 | ogr_fdw | PGDG | PGDG | foreign-data wrapper for GIS data access | |
| 1560 | geoip | PIGSTY | PIGSTY | IP-based geolocation query | |
| 1570 | pg_polyline | PIGSTY | PIGSTY | Fast Google Encoded Polyline encoding & decoding for postgres | |
| 1590 | pg_geohash | PIGSTY | PIGSTY | Handle geohash based functionality for spatial coordinates | |
| 1680 | tzf | PIGSTY | PIGSTY | Fast lookup timezone name by GPS coordinates | |
| 1800 | vector | PGDG | PGDG | vector data type and ivfflat and hnsw access methods | |
| 1810 | vchord | PIGSTY | PIGSTY | Vector database plugin for Postgres, written in Rust | |
| 1820 | vectorscale | PIGSTY | PIGSTY | Advanced indexing for vector data with DiskANN | |
| 1830 | vectorize | PIGSTY | PIGSTY | The simplest way to do vector search on Postgres | |
| 1840 | pg_similarity | PIGSTY | PGDG | support similarity queries | |
| 1850 | smlar | PIGSTY | PIGSTY | Effective similarity search | |
| 1860 | pg_summarize | PIGSTY | PIGSTY | Text Summarization using LLMs. Built using pgrx | |
| 1870 | pg_tiktoken | PIGSTY | PIGSTY | tiktoken tokenizer for use with OpenAI models in postgres | |
| 1880 | pg4ml | PIGSTY | PIGSTY | Machine learning framework for PostgreSQL | |
| 1890 | pgml | PIGSTY | PIGSTY | Run AL/ML workloads with SQL interface | |
| 2100 | pg_search | PIGSTY | PIGSTY | Full text search for PostgreSQL using BM25 | |
| 2110 | pgroonga | PIGSTY | PIGSTY | Use Groonga as index, fast full text search platform for all languages! | |
| 2111 | pgroonga_database | PIGSTY | PIGSTY | PGroonga database management module | |
| 2120 | pg_bigm | PGDG | PIGSTY | create 2-gram (bigram) index for faster full text search. | |
| 2130 | zhparser | PIGSTY | PIGSTY | a parser for full-text search of Chinese | |
| 2140 | pg_bestmatch | PIGSTY | PIGSTY | Generate BM25 sparse vector inside PostgreSQL | |
| 2150 | vchord_bm25 | PIGSTY | PIGSTY | A postgresql extension for bm25 ranking algorithm | |
| 2160 | pg_tokenizer | PIGSTY | PIGSTY | Tokenizers for full-text search | |
| 2170 | hunspell_cs_cz | PIGSTY | PIGSTY | Czech Hunspell Dictionary | |
| 2171 | hunspell_de_de | PIGSTY | PIGSTY | German Hunspell Dictionary | |
| 2172 | hunspell_en_us | PIGSTY | PIGSTY | en_US Hunspell Dictionary | |
| 2173 | hunspell_fr | PIGSTY | PIGSTY | French Hunspell Dictionary | |
| 2174 | hunspell_ne_np | PIGSTY | PIGSTY | Nepali Hunspell Dictionary | |
| 2175 | hunspell_nl_nl | PIGSTY | PIGSTY | Dutch Hunspell Dictionary | |
| 2176 | hunspell_nn_no | PIGSTY | PIGSTY | Norwegian (norsk) Hunspell Dictionary | |
| 2177 | hunspell_pt_pt | PIGSTY | PIGSTY | Portuguese Hunspell Dictionary | |
| 2178 | hunspell_ru_ru | PIGSTY | PIGSTY | Russian Hunspell Dictionary | |
| 2179 | hunspell_ru_ru_aot | PIGSTY | PIGSTY | Russian Hunspell Dictionary (from AOT.ru group) | |
| 2400 | citus | PIGSTY | PIGSTY | Distributed PostgreSQL as an extension | |
| 2401 | citus_columnar | PIGSTY | PIGSTY | Citus columnar storage engine | |
| 2410 | columnar | PIGSTY | PIGSTY | Hydra Columnar extension | |
| 2420 | pg_analytics | PIGSTY | PIGSTY | Postgres for analytics, powered by DuckDB | |
| 2430 | pg_duckdb | PIGSTY | PIGSTY | DuckDB Embedded in Postgres | |
| 2440 | pg_mooncake | PIGSTY | PIGSTY | Columnstore Table in Postgres | |
| 2450 | duckdb_fdw | PIGSTY | PIGSTY | DuckDB Foreign Data Wrapper | |
| 2460 | pg_parquet | PIGSTY | PIGSTY | copy data between Postgres and Parquet | |
| 2500 | pg_fkpart | PIGSTY | PIGSTY | Table partitioning by foreign key utility | |
| 2510 | pg_partman | PGDG | PGDG | Extension to manage partitioned tables by time or ID | |
| 2520 | plproxy | PIGSTY | PGDG | Database partitioning implemented as procedural language | |
| 2760 | age | PIGSTY | PGDG | AGE graph database extension | |
| 2770 | hll | PGDG | PGDG | type for storing hyperloglog data | |
| 2780 | rum | PGDG | PGDG | RUM index access method | |
| 2790 | pg_graphql | PIGSTY | PIGSTY | Add in-database GraphQL support | |
| 2800 | pg_jsonschema | PIGSTY | PIGSTY | PostgreSQL extension providing JSON Schema validation | |
| 2810 | jsquery | PGDG | PGDG | data type for jsonb inspection | |
| 2820 | pg_hint_plan | PGDG | PGDG | Give PostgreSQL ability to manually force some decisions in execution plans. | |
| 2830 | hypopg | PGDG | PGDG | Hypothetical indexes for PostgreSQL | |
| 2840 | index_advisor | PIGSTY | PIGSTY | Query index advisor | |
| 2850 | plan_filter | PIGSTY | PIGSTY | filter statements by their execution plans. | |
| 2860 | imgsmlr | PIGSTY | PIGSTY | Image similarity with haar | |
| 2870 | pg_ivm | PGDG | PIGSTY | incremental view maintenance on PostgreSQL | |
| 2880 | pg_incremental | PIGSTY | PIGSTY | Incremental Processing by Crunchy Data | |
| 2900 | pgmq | PIGSTY | PIGSTY | A lightweight message queue. Like AWS SQS and RSMQ but on Postgres. | |
| 2910 | pgq | PGDG | PGDG | Generic queue for PostgreSQL | |
| 2930 | pg_cardano | PIGSTY | PIGSTY | A suite of Cardano-related tools | |
| 2951 | omni | PIGSTY | PIGSTY | Advanced adapter for Postgres extensions | |
| 2952 | omni_auth | PIGSTY | PIGSTY | Basic session management | |
| 2953 | omni_aws | PIGSTY | PIGSTY | Amazon Web Services APIs (S3) | |
| 2954 | omni_cloudevents | PIGSTY | PIGSTY | CloudEvents support | |
| 2955 | omni_containers | PIGSTY | PIGSTY | Docker container management | |
| 2956 | omni_credentials | PIGSTY | PIGSTY | Application credential management | |
| 2958 | omni_email | PIGSTY | PIGSTY | E-mail framework | |
| 2959 | omni_http | PIGSTY | PIGSTY | Basic HTTP types | |
| 2960 | omni_httpc | PIGSTY | PIGSTY | HTTP client | |
| 2961 | omni_httpd | PIGSTY | PIGSTY | HTTP server | |
| 2962 | omni_id | PIGSTY | PIGSTY | Identity types | |
| 2963 | omni_json | PIGSTY | PIGSTY | JSON toolkit | |
| 2964 | omni_kube | PIGSTY | PIGSTY | Kubernetes (k8s) integration | |
| 2965 | omni_ledger | PIGSTY | PIGSTY | Financial ledger | |
| 2966 | omni_manifest | PIGSTY | PIGSTY | Package installation manifests | |
| 2967 | omni_mimetypes | PIGSTY | PIGSTY | MIME types | |
| 2968 | omni_os | PIGSTY | PIGSTY | Operating system integration | |
| 2969 | omni_polyfill | PIGSTY | PIGSTY | Postgres API polyfills | |
| 2970 | omni_python | PIGSTY | PIGSTY | First-class Python support | |
| 2971 | omni_regex | PIGSTY | PIGSTY | PCRE-compatible regular expressions | |
| 2972 | omni_rest | PIGSTY | PIGSTY | REST API toolkit (with PostgREST support) | |
| 2973 | omni_schema | PIGSTY | PIGSTY | Advanced schema management tooling | |
| 2974 | omni_seq | PIGSTY | PIGSTY | Distributed integer sequences | |
| 2975 | omni_service | PIGSTY | PIGSTY | Service management | |
| 2976 | omni_session | PIGSTY | PIGSTY | Session management | |
| 2977 | omni_sql | PIGSTY | PIGSTY | Programmatic SQL manipulation | |
| 2979 | omni_sqlite | PIGSTY | PIGSTY | Embedded SQLite | |
| 2980 | omni_test | PIGSTY | PIGSTY | Testing framework | |
| 2981 | omni_txn | PIGSTY | PIGSTY | Transaction management | |
| 2982 | omni_types | PIGSTY | PIGSTY | Advanced types | |
| 2983 | omni_var | PIGSTY | PIGSTY | Scoped variables | |
| 2984 | omni_vfs | PIGSTY | PIGSTY | Virtual File System | |
| 2985 | omni_vfs_types_v1 | PIGSTY | PIGSTY | Virtual File System types (v1) | |
| 2986 | omni_web | PIGSTY | PIGSTY | Common web stack primitives | |
| 2987 | omni_worker | PIGSTY | PIGSTY | Generalized worker pool | |
| 2988 | omni_xml | PIGSTY | PIGSTY | XML toolkit | |
| 2989 | omni_yaml | PIGSTY | PIGSTY | YAML toolkit | |
| 3000 | pg_tle | PIGSTY | PIGSTY | Trusted Language Extensions for PostgreSQL | |
| 3010 | plv8 | PIGSTY | PIGSTY | PL/JavaScript (v8) trusted procedural language | |
| 3020 | pllua | PGDG | PGDG | Lua as a procedural language | |
| 3030 | plluau | PGDG | PGDG | Lua as an untrusted procedural language | |
| 3040 | plprql | PIGSTY | PIGSTY | Use PRQL in PostgreSQL - Pipelined Relational Query Language | |
| 3050 | pldbgapi | PGDG | PGDG | server-side support for debugging PL/pgSQL functions | |
| 3060 | plpgsql_check | PGDG | PGDG | extended check for plpgsql functions | |
| 3070 | plprofiler | PGDG | PGDG | server-side support for profiling PL/pgSQL functions | |
| 3080 | plsh | PGDG | PGDG | PL/sh procedural language | |
| 3090 | pljava | PGDG | PGDG | PL/Java procedural language | |
| 3100 | plr | PGDG | PGDG | load R interpreter and execute R script from within a database | |
| 3200 | pgtap | PGDG | PGDG | Unit testing for PostgreSQL | |
| 3500 | prefix | PGDG | PGDG | Prefix Range module for PostgreSQL | |
| 3510 | semver | PGDG | PGDG | Semantic version data type | |
| 3520 | unit | PGDG | PGDG | SI units extension | |
| 3530 | pgpdf | PIGSTY | PIGSTY | PDF type with meta admin & Full-Text Search | |
| 3540 | pglite_fusion | PIGSTY | PIGSTY | Embed an SQLite database in your PostgreSQL table | |
| 3550 | md5hash | PIGSTY | PIGSTY | type for storing 128-bit binary data inline | |
| 3560 | asn1oid | PIGSTY | PGDG | asn1oid extension | |
| 3570 | roaringbitmap | PIGSTY | PGDG | support for Roaring Bitmaps | |
| 3580 | pgfaceting | PIGSTY | PGDG | fast faceting queries using an inverted index | |
| 3590 | pg_sphere | PIGSTY | PGDG | spherical objects with useful functions, operators and index support | |
| 3600 | country | PIGSTY | PIGSTY | Country data type, ISO 3166-1 | |
| 3610 | pg_xenophile | PIGSTY | PIGSTY | More than the bare necessities for PostgreSQL i18n and l10n. | |
| 3611 | l10n_table_dependent_extension | PIGSTY | PIGSTY | PostgreSQL l10n toolbox | |
| 3620 | currency | PIGSTY | PIGSTY | Custom PostgreSQL currency type in 1Byte | |
| 3630 | collection | PIGSTY | PIGSTY | Memory optimized data type to be used inside of plpglsql func | |
| 3700 | pgmp | PGDG | PGDG | Multiple Precision Arithmetic extension | |
| 3710 | numeral | PIGSTY | PGDG | numeral datatypes extension | |
| 3720 | pg_rational | PIGSTY | PGDG | bigint fractions | |
| 3730 | uint | PIGSTY | PIGSTY | unsigned integer types | |
| 3740 | uint128 | PIGSTY | PIGSTY | Native uint128 type | |
| 3750 | hashtypes | PIGSTY | PIGSTY | sha1, md5 and other data types for PostgreSQL | |
| 3820 | ip4r | PGDG | PGDG | IPv4/v6 and IPv4/v6 range index type for PostgreSQL | |
| 3830 | pg_duration | PIGSTY | PIGSTY | data type for representing durations | |
| 3840 | uri | PIGSTY | PIGSTY | URI Data type for PostgreSQL | |
| 3850 | emailaddr | PIGSTY | PIGSTY | Email address type for PostgreSQL | |
| 3860 | acl | PIGSTY | PIGSTY | ACL Data type | |
| 3890 | timestamp9 | PGDG | PIGSTY | timestamp nanosecond resolution | |
| 3920 | chkpass | PIGSTY | PIGSTY | data type for auto-encrypted passwords | |
| 4010 | gzip | PGDG | PIGSTY | gzip and gunzip functions. | |
| 4020 | bzip | PIGSTY | PIGSTY | Bzip compression and decompression | |
| 4030 | zstd | PIGSTY | PIGSTY | Zstandard compression algorithm implementation in PostgreSQL | |
| 4070 | http | PGDG | PGDG | HTTP client for PostgreSQL, allows web page retrieval inside the database. | |
| 4080 | pg_net | PIGSTY | PIGSTY | Async HTTP Requests | |
| 4090 | pg_curl | PIGSTY | PIGSTY | Run curl actions for data transfer in URL syntax | |
| 4150 | pgjq | PIGSTY | PIGSTY | Use jq in Postgres | |
| 4160 | pgjwt | PIGSTY | PIGSTY | JSON Web Token API for Postgresql | |
| 4170 | pg_smtp_client | PIGSTY | PIGSTY | PostgreSQL extension to send email using SMTP | |
| 4180 | pg_html5_email_address | PIGSTY | PIGSTY | PostgreSQL email validation that is consistent with the HTML5 spec | |
| 4190 | url_encode | PIGSTY | PIGSTY | url_encode, url_decode functions | |
| 4200 | pgsql_tweaks | PGDG | PIGSTY | Some functions and views for daily usage | |
| 4220 | pg_extra_time | PGDG | PIGSTY | Some date time functions and operators that, | |
| 4230 | pgpcre | PIGSTY | PGDG | Perl Compatible Regular Expression functions | |
| 4240 | icu_ext | PIGSTY | PGDG | Access ICU functions | |
| 4250 | pgqr | PIGSTY | PIGSTY | QR Code generator from PostgreSQL | |
| 4260 | pg_protobuf | PIGSTY | PIGSTY | Protobuf support for PostgreSQL | |
| 4270 | envvar | PIGSTY | PIGSTY | Fetch the value of an environment variable | |
| 4280 | floatfile | PIGSTY | PIGSTY | Simple file storage for arrays of floats | |
| 4290 | pg_render | PIGSTY | PIGSTY | Render HTML in SQL | |
| 4300 | pg_readme | PGDG | PIGSTY | Generate a README.md document for a database extension or schema | |
| 4301 | pg_readme_test_extension | PGDG | PIGSTY | Test generating a README.md document for extension or schema | |
| 4310 | ddl_historization | PIGSTY | PIGSTY | Historize the ddl changes inside PostgreSQL database | |
| 4320 | data_historization | PIGSTY | PIGSTY | PLPGSQL Script to historize data in partitionned table | |
| 4330 | schedoc | PIGSTY | PIGSTY | Cross documentation between Django and DBT projects | |
| 4400 | hashlib | PIGSTY | PIGSTY | Stable hash functions for Postgres | |
| 4430 | xxhash | PIGSTY | PIGSTY | xxhash functions for PostgreSQL | |
| 4440 | shacrypt | PIGSTY | PIGSTY | Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes | |
| 4450 | cryptint | PIGSTY | PIGSTY | Encryption functions for int and bigint values | |
| 4460 | pguecc | PIGSTY | PIGSTY | uECC bindings for Postgres | |
| 4470 | sparql | PIGSTY | PIGSTY | Query SPARQL datasource with SQL | |
| 4500 | pg_idkit | PIGSTY | PIGSTY | multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID) | |
| 4510 | pgx_ulid | PIGSTY | PIGSTY | ulid type and methods | |
| 4540 | pg_uuidv7 | PGDG | PIGSTY | Create UUIDv7 values in postgres | |
| 4550 | permuteseq | PIGSTY | PIGSTY | Pseudo-randomly permute sequences with a format-preserving encryption on elements | |
| 4560 | pg_hashids | PIGSTY | PIGSTY | Short unique id generator for PostgreSQL, using hashids | |
| 4570 | sequential_uuids | PGDG | PIGSTY | generator of sequential UUIDs | |
| 4600 | topn | PGDG | PIGSTY | type for top-n JSONB | |
| 4610 | quantile | PIGSTY | PIGSTY | Quantile aggregation function | |
| 4620 | lower_quantile | PIGSTY | PIGSTY | Lower quantile aggregate function | |
| 4630 | count_distinct | PIGSTY | PIGSTY | An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate | |
| 4640 | omnisketch | PIGSTY | PIGSTY | data structure for on-line agg of data into approximate sketch | |
| 4650 | ddsketch | PIGSTY | PIGSTY | Provides ddsketch aggregate function | |
| 4660 | vasco | PIGSTY | PIGSTY | discover hidden correlations in your data with MIC | |
| 4670 | xicor | PIGSTY | PIGSTY | XI Correlation Coefficient in Postgres | |
| 4700 | tdigest | PGDG | PGDG | Provides tdigest aggregate function. | |
| 4710 | first_last_agg | PIGSTY | PGDG | first() and last() aggregate functions | |
| 4720 | extra_window_functions | PGDG | PGDG | Extra Window Functions for PostgreSQL | |
| 4730 | floatvec | PIGSTY | PIGSTY | Math for vectors (arrays) of numbers | |
| 4740 | aggs_for_vecs | PIGSTY | PIGSTY | Aggregate functions for array inputs | |
| 4750 | aggs_for_arrays | PIGSTY | PIGSTY | Various functions for computing statistics on arrays of numbers | |
| 4760 | arraymath | PIGSTY | PIGSTY | Array math and operators that work element by element on the contents of arrays | |
| 4770 | pg_math | PIGSTY | PIGSTY | GSL statistical functions for postgresql | |
| 4780 | random | PIGSTY | PIGSTY | random data generator | |
| 4800 | base36 | PIGSTY | PIGSTY | Integer Base36 types | |
| 4810 | base62 | PIGSTY | PIGSTY | Base62 extension for PostgreSQL | |
| 4830 | pg_base58 | PIGSTY | PIGSTY | Base58 Encoder/Decoder Extension for PostgreSQL | |
| 4840 | financial | PIGSTY | PIGSTY | Financial aggregate functions | |
| 4850 | convert | PIGSTY | PIGSTY | conversion functions for spatial, routing and other specialized uses | |
| 5010 | pg_repack | PGDG | PGDG | Reorganize tables in PostgreSQL databases with minimal locks | |
| 5020 | pg_squeeze | PGDG | PGDG | A tool to remove unused space from a relation. | |
| 5030 | pg_dirtyread | PIGSTY | PGDG | Read dead but unvacuumed rows from table | |
| 5040 | pgfincore | PGDG | PGDG | examine and manage the os buffer cache | |
| 5050 | pg_cooldown | PIGSTY | PIGSTY | remove buffered pages for specific relations | |
| 5060 | ddlx | PIGSTY | PIGSTY | DDL eXtractor functions | |
| 5070 | prioritize | PGDG | PGDG | get and set the priority of PostgreSQL backends | |
| 5080 | pg_checksums | PGDG | PGDG | Activate/deactivate/verify checksums in offline Postgres clusters | |
| 5090 | pg_readonly | PGDG | PGDG | cluster database read only | |
| 5100 | pgdd | PIGSTY | PIGSTY | Introspect pg data dictionary via standard SQL | |
| 5110 | pg_permissions | PGDG | PIGSTY | view object permissions and compare them with the desired state | |
| 5120 | pgautofailover | PGDG | PGDG | pg_auto_failover | |
| 5130 | pg_catcheck | PGDG | PGDG | Diagnosing system catalog corruption | |
| 5140 | pre_prepare | PIGSTY | PGDG | Pre Prepare your Statement server side | |
| 5150 | pg_upless | PIGSTY | PIGSTY | Detect Useless UPDATE | |
| 5170 | pgcozy | PIGSTY | PIGSTY | Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL. | |
| 5180 | pg_orphaned | PIGSTY | PIGSTY | Deal with orphaned files | |
| 5190 | pg_crash | PIGSTY | PIGSTY | Send random signals to random processes | |
| 5200 | pg_cheat_funcs | PIGSTY | PIGSTY | Provides cheat (but useful) functions | |
| 5230 | fio | PIGSTY | PIGSTY | PostgreSQL File I/O Functions | |
| 5810 | pg_savior | PIGSTY | PIGSTY | Postgres extension to save OOPS mistakes | |
| 5820 | safeupdate | PGDG | PGDG | Require criteria for UPDATE and DELETE | |
| 5830 | pg_drop_events | PGDG | PIGSTY | logs transaction ids of drop table, drop column, drop materialized view statements | |
| 5840 | table_log | PIGSTY | PGDG | record table modification logs and PITR for table/row | |
| 5880 | pgagent | PGDG | PGDG | A PostgreSQL job scheduler | |
| 5900 | pgpool_adm | PGDG | PGDG | Administrative functions for pgPool | |
| 5910 | pgpool_recovery | PGDG | PGDG | recovery functions for pgpool-II for V4.3 | |
| 5920 | pgpool_regclass | PGDG | PGDG | replacement for regclass | |
| 6000 | pg_profile | PGDG | PIGSTY | PostgreSQL load profile repository and report builder | |
| 6010 | pg_tracing | PIGSTY | PIGSTY | Distributed Tracing for PostgreSQL | |
| 6210 | pg_show_plans | PGDG | PGDG | show query plans of all currently running SQL statements | |
| 6220 | pg_stat_kcache | PGDG | PGDG | Kernel statistics gathering | |
| 6230 | pg_stat_monitor | PGDG | PIGSTY | 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. | |
| 6240 | pg_qualstats | PGDG | PGDG | An extension collecting statistics about quals | |
| 6250 | pg_store_plans | PIGSTY | PIGSTY | track plan statistics of all SQL statements executed | |
| 6260 | pg_track_settings | PGDG | PGDG | Track settings changes | |
| 6270 | pg_wait_sampling | PGDG | PGDG | sampling based statistics of wait events | |
| 6280 | pgsentinel | PIGSTY | PIGSTY | active session history | |
| 6290 | system_stats | PGDG | PIGSTY | EnterpriseDB system statistics for PostgreSQL | |
| 6300 | meta | PIGSTY | PIGSTY | Normalized, friendlier system catalog for PostgreSQL | |
| 6310 | pgnodemx | PIGSTY | PIGSTY | Capture node OS metrics via SQL queries | |
| 6320 | pg_proctab | PIGSTY | PIGSTY | PostgreSQL extension to access the OS process table | |
| 6330 | pg_sqlog | PIGSTY | PIGSTY | Provide SQL interface to logs | |
| 6340 | bgw_replstatus | PGDG | PGDG | Small PostgreSQL background worker to report whether a node is a replication master or standby | |
| 6350 | pgmeminfo | PIGSTY | PIGSTY | show memory usage | |
| 6360 | toastinfo | PIGSTY | PIGSTY | show details on toasted datums | |
| 6370 | explain_ui | PIGSTY | PIGSTY | easily jump into a visual plan UI for any SQL query | |
| 6380 | pg_relusage | PIGSTY | PIGSTY | Log all the queries that reference a particular column | |
| 6800 | pagevis | PIGSTY | PIGSTY | Visualise database pages in ascii code | |
| 6810 | powa | PGDG | PGDG | PostgreSQL Workload Analyser-core | |
| 7000 | passwordcheck_cracklib | PGDG | PIGSTY | Strengthen PostgreSQL user password checks with cracklib | |
| 7010 | supautils | PIGSTY | PIGSTY | Extension that secures a cluster on a cloud environment | |
| 7020 | pgsodium | PIGSTY | PIGSTY | Postgres extension for libsodium functions | |
| 7030 | supabase_vault | PIGSTY | PIGSTY | Supabase Vault Extension | |
| 7040 | pg_session_jwt | PIGSTY | PIGSTY | Manage authentication sessions using JWTs | |
| 7050 | anon | PIGSTY | PIGSTY | PostgreSQL Anonymizer (anon) extension | |
| 7060 | pg_tde | PIGSTY | PIGSTY | pg_tde access method | |
| 7070 | pgsmcrypto | PIGSTY | PIGSTY | PostgreSQL SM Algorithm Extension | |
| 7080 | pgaudit | PGDG | PGDG | provides auditing functionality | |
| 7090 | pgauditlogtofile | PGDG | PGDG | pgAudit addon to redirect audit log to an independent file | |
| 7100 | pg_auth_mon | PGDG | PIGSTY | monitor connection attempts per user | |
| 7110 | credcheck | PGDG | PGDG | credcheck - postgresql plain text credential checker | |
| 7120 | pgcryptokey | PIGSTY | PIGSTY | cryptographic key management | |
| 7130 | pg_jobmon | PGDG | PIGSTY | Extension for logging and monitoring functions in PostgreSQL | |
| 7140 | logerrors | PGDG | PIGSTY | Function for collecting statistics about messages in logfile | |
| 7150 | login_hook | PGDG | PIGSTY | login_hook - hook to execute login_hook.login() at login time | |
| 7160 | set_user | PGDG | PGDG | similar to SET ROLE but with added logging | |
| 7170 | pg_snakeoil | PIGSTY | PGDG | The PostgreSQL Antivirus | |
| 7180 | pgextwlist | PIGSTY | PIGSTY | PostgreSQL Extension Whitelisting | |
| 7190 | pg_auditor | PIGSTY | PIGSTY | Audit data changes and provide flashback ability | |
| 7200 | sslutils | PIGSTY | PIGSTY | A Postgres extension for managing SSL certificates through SQL | |
| 7210 | noset | PIGSTY | PIGSTY | Module for blocking SET variables for non-super users. | |
| 8500 | wrappers | PIGSTY | PIGSTY | Foreign data wrappers developed by Supabase | |
| 8540 | pgspider_ext | PGDG | PIGSTY | foreign-data wrapper for remote PGSpider servers | |
| 8600 | mysql_fdw | PGDG | PGDG | Foreign data wrapper for querying a MySQL server | |
| 8610 | oracle_fdw | PGDG | PGDG | foreign data wrapper for Oracle access | |
| 8620 | tds_fdw | PGDG | PGDG | Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) | |
| 8640 | sqlite_fdw | PGDG | PGDG | SQLite Foreign Data Wrapper | |
| 8710 | redis_fdw | PIGSTY | PIGSTY | Foreign data wrapper for querying a Redis server | |
| 8720 | redis | PIGSTY | PIGSTY | Send redis pub/sub messages to Redis from PostgreSQL Directly | |
| 8730 | kafka_fdw | PIGSTY | PIGSTY | kafka Foreign Data Wrapper for CSV formatted messages | |
| 8750 | firebird_fdw | PIGSTY | PIGSTY | Foreign data wrapper for Firebird | |
| 8800 | aws_s3 | PIGSTY | PIGSTY | aws_s3 postgres extension to import/export data from/to s3 | |
| 8810 | log_fdw | PIGSTY | PIGSTY | foreign-data wrapper for Postgres log file access | |
| 9000 | documentdb | PIGSTY | PIGSTY | API surface for DocumentDB for PostgreSQL | |
| 9010 | documentdb_core | PIGSTY | PIGSTY | Core API surface for DocumentDB for PostgreSQL | |
| 9020 | documentdb_distributed | PIGSTY | PIGSTY | Multi-Node API surface for DocumentDB | |
| 9100 | orafce | PGDG | PGDG | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | |
| 9110 | pgtt | PGDG | PGDG | Extension to add Global Temporary Tables feature to PostgreSQL | |
| 9120 | session_variable | PIGSTY | PIGSTY | Registration and manipulation of session variables and constants | |
| 9130 | pg_statement_rollback | PGDG | PIGSTY | Server side rollback at statement level for PostgreSQL like Oracle or DB2 | |
| 9300 | babelfishpg_common | PIGSTY | PIGSTY | SQL Server Transact SQL Datatype Support | |
| 9310 | babelfishpg_tsql | PIGSTY | PIGSTY | SQL Server Transact SQL compatibility | |
| 9320 | babelfishpg_tds | PIGSTY | PIGSTY | SQL Server TDS protocol extension | |
| 9330 | babelfishpg_money | PIGSTY | PIGSTY | SQL Server Money Data Type | |
| 9400 | spat | PGDG | PIGSTY | Redis-like In-Memory DB Embedded in Postgres | |
| 9410 | pgmemcache | PGDG | PGDG | memcached interface | |
| 9500 | pglogical | PGDG | PGDG | PostgreSQL Logical Replication | |
| 9501 | pglogical_origin | PGDG | PGDG | Dummy extension for compatibility when upgrading from Postgres 9.4 | |
| 9510 | pglogical_ticker | PIGSTY | PGDG | Have an accurate view on pglogical replication delay | |
| 9520 | pgl_ddl_deploy | PGDG | PGDG | automated ddl deployment using pglogical | |
| 9530 | pg_failover_slots | PIGSTY | PIGSTY | PG Failover Slots extension | |
| 9540 | db_migrator | PIGSTY | PIGSTY | Tools to migrate other databases to PostgreSQL | |
| 9630 | wal2json | PGDG | PGDG | Changing data capture in JSON format | |
| 9640 | wal2mongo | PIGSTY | PIGSTY | PostgreSQL logical decoding output plugin for MongoDB | |
| 9650 | decoderbufs | PGDG | PGDG | Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format | |
| 9660 | decoder_raw | PIGSTY | PIGSTY | Output plugin for logical replication in Raw SQL format | |
| 9700 | mimeo | PIGSTY | PGDG | Extension for specialized, per-table replication between PostgreSQL instances | |
| 9710 | repmgr | PGDG | PGDG | Replication manager for PostgreSQL | |
| 9820 | pg_fact_loader | PGDG | PGDG | build fact tables with Postgres | |
| 9830 | pg_bulkload | PGDG | PIGSTY | pg_bulkload is a high speed data loading utility for PostgreSQL |
EL
There are 13 non-contrib extensions only available in EL platforms.
| ID | Name | Category | RPM | DEB | Description |
|---|---|---|---|---|---|
| 2530 | pg_strom | PGDG | - | PG-Strom - big-data processing acceleration using GPU and NVME | |
| 3210 | faker | PGDG | - | Wrapper for the Faker Python library | |
| 3220 | dbt2 | PGDG | - | OSDL-DBT-2 test kit | |
| 8510 | multicorn | PGDG | - | Fetch foreign data in Python in your PostgreSQL server. | |
| 8520 | odbc_fdw | PGDG | - | Foreign data wrapper for accessing remote databases using ODBC | |
| 8530 | jdbc_fdw | PGDG | - | foreign-data wrapper for remote servers available over JDBC | |
| 8630 | db2_fdw | PGDG | - | foreign data wrapper for DB2 access | |
| 8650 | pgbouncer_fdw | PGDG | - | Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions | |
| 8700 | mongo_fdw | PGDG | - | foreign data wrapper for MongoDB access | |
| 8740 | hdfs_fdw | PGDG | - | foreign-data wrapper for remote hdfs servers | |
| 9240 | pg_dbms_metadata | PGDG | - | Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL | |
| 9250 | pg_dbms_lock | PGDG | - | Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL | |
| 9260 | pg_dbms_job | PGDG | - | Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL |
Debian
There are 6 non-contrib extensions only available in Debian platforms.
| ID | Name | Category | RPM | DEB | Description |
|---|---|---|---|---|---|
| 1650 | mobilitydb | - | PGDG | MobilityDB geospatial trajectory data management & analysis platform | |
| 2940 | rdkit | - | PGDG | Cheminformatics functionality for PostgreSQL. | |
| 3021 | hstore_pllua | - | PGDG | Hstore transform for Lua | |
| 3031 | hstore_plluau | - | PGDG | Hstore transform for untrusted Lua | |
| 3870 | debversion | - | PGDG | Debian version number data type | |
| 3880 | pg_rrule | - | PGDG | RRULE field type for PostgreSQL |