Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
56 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pg_squeeze | 1.9.4 | A tool to remove unused space from a relation. | ADMIN | BSD-2-Clause | C | 14–18 | 691 |
| pg_regresql | 2.0.0 | Trust pg_class statistics for planning instead of physical relation size | LANG | BSD-2-Clause | C | 14–18 | 393 |
| pg_profile | 4.16 | PostgreSQL load profile repository and report builder | STAT | BSD-2-Clause | C | 14–18 | 312 |
| pg_permissions | 1.4.1 | view object permissions and compare them with the desired state | ADMIN | BSD-2-Clause | SQL | 14–18 | 167 |
| acl | 1.0.4 | ACL Data type | TYPE | BSD-2-Clause | C | 14–18 | 90 |
| count_distinct | 3.0.2 | An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate | FUNC | BSD-2-Clause | C | 14–18 | 80 |
| geoip | 0.3.0 | IP-based geolocation query | GIS | BSD-2-Clause | SQL | 14–18 | 52 |
| quantile | 1.1.8 | Quantile aggregation function | FUNC | BSD-2-Clause | C | 14–18 | 39 |
| pg_checksums | 1.3 | Activate/deactivate/verify checksums in offline Postgres clusters | ADMIN | BSD-2-Clause | C | 14–18 | 30 |
| r53db | 0.1 | r53db, the PostgreSQL Foreign Data Wrapper for the AWS Route53 Database service | FDW | BSD-2-Clause | C | — | 26 |
| meta | 0.4.0 | Normalized, friendlier system catalog for PostgreSQL | STAT | BSD-2-Clause | SQL | 14–18 | 24 |
| pgbitmap | 0.9.5 | Bitmap-type extension for PostgreSQL | TYPE | BSD-2-Clause | C | 10–18 | 23 |
| hyperloglog_counter | 1.2.6 | Aggregation functions and data type for distinct estimation based on HyperLogLog. | FUNC | BSD-2-Clause | C | 10–18 | 18 |
| loglog_counter | 1.2.4 | Aggregation functions and data type for distinct estimation based on LogLog. | FUNC | BSD-2-Clause | C | 10–18 | 18 |
| pcsa_counter | 1.3.3 | Aggregation functions and data type for distinct estimation based on PCSA. | FUNC | BSD-2-Clause | C | 10–18 | 18 |
| probabilistic_counter | 1.3.3 | A C data type and aggregates for approximate distinct counting using the Flajolet-Martin probabilistic counting algorithm. | FUNC | BSD-2-Clause | C | 10–18 | 18 |
| pg_sentence_transformer | 0.1 | Runs a Hugging Face sentence-transformer model inside a preload background worker and maintains pgvector embeddings for a configured table. | RAG | BSD-2-Clause | Python | — | 17 |
| pguecc | 1.0 | uECC bindings for Postgres | UTIL | BSD-2-Clause | C | 14–18 | 15 |
| connection_limits | 1.0.0 | Enforce connection quotas by user, database, source IP or hostname, including combined rules. | ADMIN | BSD-2-Clause | C | 10–18 | 13 |
| schema_triggers | 0.1 | Archived C hook extension adding relation, column, and trigger schema-change events to PostgreSQL event triggers. | FEAT | BSD-2-Clause | C | 10–18 | 11 |
| xxhash | 0.0.1 | xxhash functions for PostgreSQL | UTIL | BSD-2-Clause | C | 14–18 | 11 |
| lambda | 1.0.5 | Lambda function for Postgres | LANG | BSD-2-Clause | SQL | — | 10 |
| pg_audit | 0.1.3 | An extension for creating audit tables | SEC | BSD-2-Clause | SQL | 10–18 | 10 |
| pg_fusion | 24.0.0 | Experimental PostgreSQL extension for DataFusion-backed analytical query execution | OLAP | BSD-2-Clause | Rust | 17 | 10 |
| shared_ispell | 1.0.0 | Shared-memory ispell dictionary template for reducing per-session initialization and memory. | FTS | BSD-2-Clause | C | 10–18 | 10 |
| byteamagic | 0.2.4 | Detect MIME types and file formats from PostgreSQL bytea values | UTIL | BSD-2-Clause | C | 14–18 | 9 |
| md5hash | 1.0.1 | type for storing 128-bit binary data inline | TYPE | BSD-2-Clause | C | 14–18 | 9 |
| meta_triggers | 0.5.0 | Insert, update and delete triggers for the meta system catalog | FEAT | BSD-2-Clause | SQL | — | 9 |
| query_recorder | 1.0.1 | query_recorder: record executed SQL queries to rotating files for later analysis or replay | STAT | BSD-2-Clause | C | — | 9 |
| redis_link | 1.0 | Read-write PostgreSQL foreign data wrapper for Redis strings, hashes, and sets, with basic Redis Cluster support | FDW | BSD-2-Clause | C | 16 | 9 |
| trimmed_aggregates | 2.0.0-dev | C aggregate functions that discard configurable low/high outliers before computing averages, variances, and standard deviations. | FUNC | BSD-2-Clause | C | 10–18 | 9 |
| pg_logfebe | 1.0 | log via febe framing protocol to a unix socket | STAT | BSD-2-Clause | C | — | 8 |
| pg_ta | 1.0 | TA-Lib technical-analysis functions exposed as PostgreSQL functions | FUNC | BSD-2-Clause | C | — | 6 |
| postcode | 1.3.0 | Store UK postcodes in a compact 32-bit type with validation, formatting, partial matching, and B-tree indexing | TYPE | BSD-2-Clause | C | — | 6 |
| panda_post | 0.2.1 | Python Pandas data in Postgres | ETL | BSD-2-Clause | Python | — | 5 |
| pandapost | 0.2.0 | Python Pandas data in Postgres | ETL | BSD-2-Clause | Python | — | 5 |
| pltoolbox | 1.0.3 | provide C utility functions for PostgreSQL stored procedures | FUNC | BSD-2-Clause | C | — | 5 |
| query_histogram | 1.1 | Collects shared-memory histograms of statement and transaction runtimes through executor and utility hooks. | STAT | BSD-2-Clause | C | — | 5 |
| replace_empty_string | 1.0 | C trigger function that replaces empty strings with NULL | UTIL | BSD-2-Clause | C | — | 5 |
| variant | 1.0.1 | Variant data type that can store values from other PostgreSQL types. | TYPE | BSD-2-Clause | C | — | 5 |
| geoip2lookup | 0.0.3 | Look up IP-address info in MaxMind GeoIP2 MMDB files | GIS | BSD-2-Clause | SQL | 10–18 | 4 |
| index_analyzer | 0.1.0 | PL/pgSQL functions for evaluating existing and prospective indexes and checking foreign-key indexing. | FEAT | BSD-2-Clause | SQL | — | 4 |
| pg_sysdatetime | 1.0 | High-precision SQL Server-style system datetime functions for PostgreSQL, mainly useful on older Windows builds. | SIM | BSD-2-Clause | C | — | 4 |
| pgcurl | 0.0.1 | Calls curl/libcurl from PostgreSQL through a SQL function. | UTIL | BSD-2-Clause | C | — | 4 |
| pg_acl | 0.1.3 | Utilities for handling aclitems. | TYPE | BSD-2-Clause | SQL | — | 2 |
| pg_connlimit | 1.0 | Limits per-role connection counts from filesystem configuration without catalog access. | ADMIN | BSD-2-Clause | C | — | 2 |
| count_nulls | 0.9.6 | Count the number of null arguments | FUNC | BSD-2-Clause | SQL | — | 1 |
| pg_stat_usage | 1.0 | track usage statistics of stored procedure calls | STAT | BSD-2-Clause | C | — | 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 |
| template_fdw | 0.0 | Foreign data wrapper for template tables that intentionally rejects SELECT and DML operations. | FDW | BSD-2-Clause | C | 10–18 | 1 |