扩展列表
共有 575 个已打包的 PostgreSQL 扩展：
| 扩展 | PG 版本 | 属性 | 分类 | 描述 |
|---|---|---|---|---|
| timescaledb | 1817161514 | --sLdt- | TIME | 时序数据库扩展插件 |
| timescaledb_toolkit | 1817161514 | --s-d-- | TIME | 超表分析查询，时间序列流式处理，以及其他SQL工具 |
| pg_timeseries | 1817161514 | ----d-- | TIME | 时序数据API封装 |
| periods | 1817161514 | --s-d-- | TIME | 为 PERIODs 和 SYSTEM VERSIONING 提供标准 SQL 功能 |
| temporal_tables | 1817161514 | --s-d-r | TIME | 时态表功能支持 |
| emaj | 1817161514 | --s-d-- | TIME | 让数据库的子集具有细粒度日志和时间旅行功能 |
| table_version | 1817161514 | --s-d-- | TIME | PostgreSQL 版本控制表扩展 |
| pg_cron | 1817161514 | --sLd-- | TIME | 定时任务调度器 |
| pg_task | 1817161514 | --sL--- | TIME | 在特定时间点在后台执行SQL命令 |
| pg_later | 1817161514 | --sLd-- | TIME | 执行查询，并在稍后异步获取查询结果 |
| pg_dispatch | 1817161514 | ----d-- | TIME | 基于 pg_cron 的异步 SQL 分发器 |
| pg_background | 1817161514 | --s-d-r | TIME | 在后台运行 SQL 查询 |
| pg_when | 1817161514 | --s-d-- | TIME | PostgreSQL 自然语言时间解析扩展 |
| pg_stl | 1817161514 | --s-d-r | TIME | PostgreSQL 时间序列分析函数 |
| cron_utils | 1817161514 | ----d-r | TIME | 解析 Cron 表达式并计算上一次或下一次触发时间 |
| postgis | 1817161514 | --s-d-- | GIS | PostGIS 几何和地理空间扩展 |
| postgis | 1817161514 | --s-d-- | GIS | PostGIS 拓扑空间类型和函数 |
| postgis | 1817161514 | --s-d-- | GIS | PostGIS 光栅类型和函数 |
| postgis | 1817161514 | --s-d-r | GIS | PostGIS SFCGAL 函数 |
| postgis | 1817161514 | --s-dt- | GIS | PostGIS tiger 地理编码器和反向地理编码器 |
| postgis | 1817161514 | --s-d-r | GIS | 地址标准化函数。 |
| postgis | 1817161514 | --s-d-r | GIS | 地址标准化函数：美国数据集示例 |
| pgrouting | 1817161514 | --s-d-r | GIS | 提供寻路能力 |
| pointcloud | 1817161514 | --s-d-- | GIS | 提供激光雷达点云数据类型支持 |
| pointcloud | 1817161514 | --s-dt- | GIS | 将激光雷达点云与PostGIS几何类型相集成 |
| pg_h3 | 1817161514 | --s-d-r | GIS | H3六边形层级索引支持 |
| pg_h3 | 1817161514 | --s-d-r | GIS | H3与PostGIS集成的扩展插件 |
| q3c | 1817161514 | --s-d-r | GIS | Q3C天空索引插件 |
| ogr_fdw | 1817161514 | --s-d-r | GIS | GIS 数据外部数据源包装器 |
| geoip | 1817161514 | --s-d-- | GIS | IP 地理位置扩展（围绕 MaxMind GeoLite 数据集的包装器） |
| pg_polyline | 1817161514 | --s-d-- | GIS | Google快速Polyline编码解码扩展 |
| pg_eviltransform | 1817161514 | --s-d-r | GIS | 基于PostGIS ST_Transform 的 BD09/GCJ02 坐标转换扩展 |
| pg_geohash | 1817161514 | --s-d-r | GIS | 使用GeoHash处理空间坐标的函数包 |
| pghydro | 1817161514 | ----d-- | GIS | PostgreSQL/PostGIS 排水网络分析核心扩展 |
| pghydro | 1817161514 | ----d-- | GIS | PgHydro 栅格水文分析扩展 |
| pghydro | 1817161514 | ----d-- | GIS | PgHydro 水文地貌分析扩展 |
| pghydro | 1817161514 | ----d-- | GIS | PgHydro 输出与报表扩展 |
| pghydro | 1817161514 | ----d-- | GIS | PgHydro 澳式英语输出扩展 |
| pghydro | 1817161514 | ----d-- | GIS | PgHydro 巴西葡语输出扩展 |
| pghydro | 1817161514 | ----d-- | GIS | PgHydro Pfafstetter 一致性检查扩展 |
| mobilitydb | 1817161514 | --sLd-- | GIS | MobilityDB地理空间投影数据管理分析平台 |
| mobilitydb | 1817161514 | ----d-r | GIS | MobilityDB随机数据生成函数 |
| pg_tzf | 1817161514 | --s-d-- | GIS | 快速根据GPS经纬度坐标查找时区 |
| earthdistance | 1817161514 | c-s-d-- | GIS | 计算地球表面上的大圆距离 |
| qdgc | 1817161514 | ----dtr | GIS | 用纯 SQL 编码、解码、遍历和填充扩展四分之一度网格单元（QDGC）编码。 |
| qdgc | 1817161514 | ----d-r | GIS | 为 QDGC 增加 PostGIS geometry/geography 绑定与区域到网格单元的填充能力。 |
| pgvector | 1817161514 | --s-d-r | RAG | 向量数据类型和 ivfflat / hnsw 访问方法 |
| vchord | 1817161514 | --sLd-r | RAG | 使用Rust重写的高性能向量扩展 |
| pgvectorscale | 1817161514 | --s-d-- | RAG | 使用DiskANN算法对向量进行高效索引 |
| pg_vectorize | 1817161514 | --sLd-- | RAG | 在PostgreSQL中封装RAG向量检索服务 |
| pg_similarity | 1817161514 | --s-d-r | RAG | 提供17种距离度量函数 |
| pg_rrf | 1817161514 | --s-d-- | RAG | 混合检索的倒数排序融合函数 |
| smlar | 1817161514 | --s-d-r | RAG | 高效的相似度搜索函数 |
| pg_summarize | 1817161514 | --s-d-- | RAG | 使用LLM对文本字段进行总结 |
| pg_tiktoken | 1817161514 | --s-d-- | RAG | 在PostgreSQL中计算OpenAI使用的Token数 |
| pg_tiktoken_c | 1817161514 | --s-d-- | RAG | 使用 C 实现的 PostgreSQL 高性能 tiktoken BPE 分词扩展 |
| pg4ml | 1817161514 | ----dtr | RAG | PG4ML是一个机器学习框架 |
| pgml | 1817161514 | --sLdt- | RAG | PostgresML：用SQL运行机器学习算法并训练模型 |
| pgmnemo | 1817161514 | ----dt- | RAG | PostgreSQL 单计划多模态智能体记忆扩展 |
| pgcontext | 1817161514 | --s-d-- | RAG | 在 PostgreSQL 权威数据表上提供向量检索、过滤感知 HNSW 与混合检索。 |
| pgcontext | 1817161514 | --s-d-- | RAG | pgcontext HNSW 索引的可选 pgvector 兼容桥接扩展。 |
| pg_turbovec | 1817161514 | --s-d-- | RAG | 基于 TurboQuant 压缩量化的 PostgreSQL 向量类型与 ANN 索引访问方法。 |
| pg_search | 1817161514 | --sLd-- | FTS | 使用 BM25 的 PostgreSQL 全文、分面与混合检索扩展 |
| pgroonga | 1817161514 | --s-dtr | FTS | 使用Groonga，面向所有语言的高速全文检索平台 |
| pgroonga | 1817161514 | --s-dtr | FTS | PGGroonga 数据库管理模块 |
| pg_bigm | 1817161514 | --sLd-r | FTS | 基于二字组的多语言全文检索扩展 |
| zhparser | 1817161514 | --s-d-r | FTS | 中文分词，全文搜索解析器 |
| pg_bestmatch | 1817161514 | --sLd-- | FTS | 在数据库内生成BM25稀疏向量 |
| vchord_bm25 | 1817161514 | --sLd-- | FTS | BM25排序算法 |
| pg_tokenizer | 1817161514 | --sLd-- | FTS | 用于全文检索的分词器 |
| pg_biscuit | 1817161514 | --s-d-- | FTS | 使用IAM的高性能文本模式匹配 |
| pg_textsearch | 1817161514 | --sLd-- | FTS | 带有BM25排序的全文搜索扩展 |
| pg_pinyin | 1817161514 | --s-d-r | FTS | PostgreSQL 拼音转写与检索辅助扩展 |
| pg_kazsearch | 1817161514 | --s-d-- | FTS | PostgreSQL 哈萨克语全文检索扩展 |
| psql_bm25s | 1817161514 | --s-d-- | FTS | PostgreSQL BM25 系列全文检索扩展，提供原生索引访问方法和 BM25 排序 |
| pg_fts | 1817161514 | --s-dtr | FTS | 提供 BM25、BM25F 排序与专用倒排索引的全文检索扩展 |
| pg_cjk_parser | 1817161514 | --s-d-r | FTS | 基于 PostgreSQL 默认解析器的中日韩二字组全文检索分词器 |
| pg_jieba | 1817161514 | --s-d-r | FTS | 基于 cppjieba 的中文全文检索分词器 |
| hunspell | 1817161514 | ----d-r | FTS | Hunspell捷克语全文检索词典 |
| hunspell | 1817161514 | ----d-r | FTS | Hunspell德语全文检索词典 |
| hunspell | 1817161514 | ----d-r | FTS | Hunspell英语全文检索词典 |
| hunspell | 1817161514 | ----d-r | FTS | Hunspell法语全文检索词典 |
| hunspell | 1817161514 | ----d-r | FTS | Hunspell尼泊尔语全文检索词典 |
| hunspell | 1817161514 | ----d-r | FTS | Hunspell荷兰语全文检索词典 |
| hunspell | 1817161514 | ----d-r | FTS | Hunspell挪威语全文检索词典 |
| hunspell | 1817161514 | ----d-r | FTS | Hunspell葡萄牙语全文检索词典 |
| hunspell | 1817161514 | ----d-r | FTS | Hunspell俄语全文检索词典 |
| hunspell | 1817161514 | ----d-r | FTS | Hunspell俄语全文检索词典（来自AOT.ru小组） |
| fuzzystrmatch | 1817161514 | c-s-dt- | FTS | 确定字符串之间的相似性和距离 |
| pg_trgm | 1817161514 | c-s-dt- | FTS | 文本相似度测量函数与模糊检索 |
| citus | 1817161514 | --sLd-- | OLAP | 将 PostgreSQL 横向扩展为分布式数据库 |
| citus | 1817161514 | --s-d-- | OLAP | Citus 列式存储引擎 |
| hydra | 1817161514 | --s-d-- | OLAP | 开源列式存储扩展 |
| pg_duckdb | 1817161514 | --sLd-- | OLAP | 在PostgreSQL中的嵌入式DuckDB扩展 |
| pg_mooncake | 1817161514 | --sLd-- | OLAP | PostgreSQL列式存储表 |
| storage_engine | 1817161514 | --sLd-- | OLAP | 带向量化执行的 colcompress 与 rowcompress 表访问方法 |
| pg_clickhouse | 1817161514 | --s-d-r | OLAP | 从PostgreSQL中查询ClickHouse的接口 |
| duckdb_fdw | 1817161514 | --s-d-r | OLAP | DuckDB 外部数据源包装器 |
| pg_parquet | 1817161514 | --sLd-- | OLAP | 在PostgreSQL与本地/S3中的Parquet文件复制数据 |
| pg_ducklake | 1817161514 | --sLd-- | OLAP | 基于 DuckDB 与 Parquet 的 DuckLake 湖仓一体扩展 |
| pg_fkpart | 1817161514 | ----d-- | OLAP | 按外键实用程序进行表分区的扩展 |
| pg_partman | 1817161514 | --s-d-- | OLAP | 用于按时间或 ID 管理分区表的扩展 |
| plproxy | 1817161514 | --s-d-- | OLAP | 作为过程语言实现的数据库分区 |
| pg_strom | 1817161514 | --s-d-- | OLAP | 使用GPU与NVMe加速大数据处理 |
| pg_orca | 1817161514 | --sLd-- | OLAP | PostgreSQL ORCA 查询优化器扩展 |
| pg_sorted_heap | 1817161514 | --sLd-- | OLAP | 带 zone map 剪枝和内置向量搜索的有序堆表访问方法 |
| pg_lake | 1817161514 | -bsLd-- | OLAP | Snowflake 开源的 PostgreSQL 数据湖与 Iceberg 集成扩展 |
| pg_lake | 1817161514 | --sLd-- | OLAP | Snowflake 提供的 PostgreSQL 扩展开发基础设施，支持库预加载、扩展生命周期后 |
| pg_lake | 1817161514 | --sLd-- | OLAP | 在数据库启动时自动执行 ALTER EXTENSION UPDATE 的扩展更新器 |
| pg_lake | 1817161514 | --s-d-- | OLAP | pg_lake 内置并依赖的 PostgreSQL Map 数据类型。 |
| pg_lake | 1817161514 | --sLd-- | OLAP | 用于数据湖查询的查询引擎 |
| pg_lake | 1817161514 | --s-d-- | OLAP | PostgreSQL 中的 Iceberg 实现 |
| pg_lake | 1817161514 | --sLd-- | OLAP | 数据湖表和 Iceberg 表 |
| pg_lake | 1817161514 | --sLd-- | OLAP | 在 PostgreSQL 与对象存储数据湖文件之间执行 COPY 的扩展 |
| tablefunc | 1817161514 | c-s-dt- | OLAP | 交叉表函数 |
| age | 1817161514 | --sLd-- | FEAT | Apache AGE，图数据库扩展 （Deb可用） |
| pg_liquid | 1817161514 | --s-d-- | FEAT | 受 Liquid 启发的 Datalog 图查询扩展 |
| one_sparse | 1817161514 | --s-d-- | FEAT | PostgreSQL 18 的稀疏线性代数与图算法扩展 |
| pggraph | 1817161514 | --s-d-- | FEAT | PostgreSQL 图查询与遍历扩展 |
| pgrdf | 1817161514 | --sLd-- | FEAT | PostgreSQL 内 RDF、SPARQL、SHACL 与 OWL 推理扩展 |
| pgq | 1817161514 | --s-d-- | FEAT | 通用队列的PG实现 |
| pgmq | 1817161514 | ----d-- | FEAT | 基于Postgres实现类似AWS SQS/RSMQ的消息队列 |
| pgmb | 1817161514 | ----d-- | FEAT | 一个简单的PostgreSQL消息代理系统 |
| ulak | 1817161514 | --sLd-- | FEAT | 支持可靠异步投递的 PostgreSQL 事务型 Outbox 扩展 |
| fsm_core | 1817161514 | ----d-- | FEAT | PostgreSQL 有限状态机工具包 |
| hll | 1817161514 | --s-d-- | FEAT | hyperloglog 数据类型 |
| rum | 1817161514 | --s-d-r | FEAT | RUM 索引访问方法 |
| pg_ai_query | 1817161514 | --s-d-r | FEAT | AI驱动的 Postgres SQL 查询生成 |
| pg_ttl_index | 1817161514 | --sLd-r | FEAT | 基于TTL索引的自动数据过期清理 |
| pg_graphql | 1817161514 | --s-d-- | FEAT | PG内的GraphQL支持 |
| pg_jsonschema | 1817161514 | ----d-- | FEAT | 提供JSON Schema校验能力 |
| jsonschema | 1817161514 | --s-d-r | FEAT | PostgreSQL JSON Schema 校验函数 |
| jsquery | 1817161514 | --s-d-r | FEAT | 用于内省 JSONB 数据类型的查询类型 |
| pg_hint_plan | 1817161514 | --sLd-- | FEAT | 添加强制指定执行计划的能力 |
| hypopg | 1817161514 | --s-d-r | FEAT | 假设索引，用于创建一个虚拟索引检验执行计划 |
| index_advisor | 1817161514 | ----d-r | FEAT | 查询索引建议器 |
| pg_plan_filter | 1817161514 | --sL--- | FEAT | 使用执行计划代价过滤阻止特定查询语句 |
| pg_variables | 1817161514 | --s-d-r | FEAT | 提供标量、数组和记录类型的会话变量 |
| imgsmlr | 1817161514 | --s-d-r | FEAT | 使用Haar小波分析计算图片相似度 |
| pg_ivm | 1817161514 | --sLd-- | FEAT | 增量维护的物化视图 |
| pg_incremental | 1817161514 | --s-d-- | FEAT | 增量处理流式事件 |
| pg_trickle | 1817161514 | --sLd-- | FEAT | 为 PostgreSQL 18 提供流式表与差分视图维护 |
| pg_durable | 1817161514 | --sLd-- | FEAT | 在 PostgreSQL 中使用 SQL 定义可持久化、可恢复的长时间运行函数 |
| pg_disorder | 1817161514 | --sL--- | FEAT | 扰动无 ORDER BY 查询的行序以暴露依赖隐式顺序的测试 |
| pg_local_cache | 1817161514 | --sLd-- | FEAT | 为普通 PostgreSQL 主键读取提供事务感知的共享内存缓存 |
| provsql | 1817161514 | --sLdt- | FEAT | PostgreSQL 半环溯源、概率与不确定性管理扩展 |
| orioledb | 1817161514 | --sLd-r | FEAT | OrioleDB，下一代事务处理引擎 |
| pg_cardano | 1817161514 | --s-d-- | FEAT | Cardano相关工具包：加密函数，地址编解码，区块链处理 |
| rdkit | 1817161514 | --s-d-r | FEAT | 在PostgreSQL化学领域数据管理功能 |
| omnigres | 1817161514 | --sLd-- | FEAT | PostgreSQL即平台，Omnigres主扩展与加载器 |
| omnigres | 1817161514 | ----d-- | FEAT | Omnigres 基础会话认证管理模块 |
| omnigres | 1817161514 | ----dt- | FEAT | Omnigres AWS S3 API封装 |
| omnigres | 1817161514 | ----dt- | FEAT | Omnigres CloudEvents 支持 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres Docker容器管理模块 |
| omnigres | 1817161514 | ----d-- | FEAT | Omnigres 应用密钥管理模块 |
| omni_csv | 1817161514 | --s-d-- | FEAT | Omnigres CSV 工具箱 |
| omni_datasets | 1817161514 | ----d-- | FEAT | Omnigres 数据库置备工具 |
| omnigres | 1817161514 | ----d-- | FEAT | Omnigres Email 框架 |
| omnigres | 1817161514 | ----d-- | FEAT | Omnigres 基本HTTP类型 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres HTTP客户端 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres HTTP服务器 |
| omnigres | 1817161514 | --s-d-r | FEAT | Omnigres ID身份数据类型 |
| omnigres | 1817161514 | ----dt- | FEAT | Omnigres JSON工具箱 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres Kubernetes集成模块 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres 金融账本模块 |
| omnigres | 1817161514 | ----d-- | FEAT | Omnigres 包管理清单模块 |
| omnigres | 1817161514 | ----d-- | FEAT | Omnigres MIME数据类型 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres 操作系统集成模块 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres Postgres多态API |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres 第一类Python支持模块 |
| omnigres | 1817161514 | --s-d-r | FEAT | Omnigres PCRE兼容正则表达式模块 |
| omnigres | 1817161514 | ----d-- | FEAT | Omnigres REST API 工具包 |
| omnigres | 1817161514 | ----d-- | FEAT | Omnigres 高级模式管理组件 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres 分布式整型序列号 |
| omnigres | 1817161514 | ----d-- | FEAT | Omnigres 服务管理器 |
| omnigres | 1817161514 | ----d-- | FEAT | Omnigres 会话管理器 |
| omni_shmem | 1817161514 | --s-d-- | FEAT | Omnigres 共享内存管理 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres SQL编程组件 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres 嵌入的SQLite支持 |
| omnigres | 1817161514 | ----d-- | FEAT | Omnigres 测试框架 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres 事务管理器模块 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres 高级数据类型模块 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres 局部变量模块 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres 虚拟文件系统 |
| omnigres | 1817161514 | ----d-- | FEAT | Omnigres 虚拟文件系统（v1） |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres Web工具箱 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres 通用Worker池 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres XML工具包 |
| omnigres | 1817161514 | --s-d-- | FEAT | Omnigres YAML工具包 |
| pg_mentat | 1817161514 | --s-d-- | FEAT | 在 PostgreSQL 内提供兼容 Datomic 的数据模型与 Datalog 查询引擎 |
| bloom | 1817161514 | c-s-d-- | FEAT | bloom 索引-基于指纹的索引 |
| pg_tle | 1817161514 | --sLd-- | LANG | AWS 可信语言扩展 |
| plv8 | 1817161514 | --s-d-- | LANG | PL/JavaScript (v8) 可信过程程序语言 |
| pljs | 1817161514 | --s-d-- | LANG | PL/JS 可信过程程序语言 |
| pllua | 1817161514 | --s-d-- | LANG | Lua 程序语言 |
| pllua | 1817161514 | --s-d-r | LANG | Lua 程序语言的Hstore适配扩展 |
| pllua | 1817161514 | --s-d-- | LANG | Lua 程序语言（不受信任的） |
| pllua | 1817161514 | --s-d-r | LANG | Lua 程序语言的Hstore适配扩展（不受信任的） |
| plprql | 1817161514 | --s-d-- | LANG | 在PostgreSQL使用PRQL——管线式关系查询语言 |
| pldebugger | 1817161514 | --sLd-r | LANG | 用于调试 PL/pgSQL 函数的服务器端支持 |
| plpgsql_check | 1817161514 | --s-d-- | LANG | PL/pgSQL 函数的附加校验、性能分析与诊断工具 |
| plprofiler | 1817161514 | --sLd-r | LANG | 剖析 PL/pgSQL 函数 |
| plsh | 1817161514 | --s-d-r | LANG | PL/sh 程序语言 |
| pljava | 1817161514 | --s-d-- | LANG | Java 程序语言 |
| plr | 1817161514 | --s-d-- | LANG | 从数据库中加载R语言解释器并执行R脚本 |
| plxslt | 1817161514 | --s-d-r | LANG | XSLT 存储过程语言 |
| pg_mockable | 1817161514 | ----d-- | LANG | 为测试创建可 Mock 的 PostgreSQL 函数包装器 |
| pgsqlmock | 1817161514 | ----d-r | LANG | 为 PostgreSQL 单元测试提供函数 Mock、表和视图伪造能力 |
| plx | 1817161514 | --s-d-r | LANG | 将多种过程语言方言转译为 PL/pgSQL |
| pgwasm | 1817161514 | --s-d-- | LANG | 将沙箱化 WebAssembly 组件映射为强类型 PostgreSQL SQL 函数。 |
| plruby | 1817161514 | --s-d-- | LANG | 将 MRI Ruby 嵌入 PostgreSQL，提供非可信过程语言 |
| plruby | 1817161514 | --s-d-r | LANG | 在 jsonb 与 PL/Ruby 原生 Ruby 数据之间转换 |
| plruby | 1817161514 | --s-d-r | LANG | 在 hstore 与 PL/Ruby 的 Ruby Hash 之间转换 |
| plruby | 1817161514 | --s-d-r | LANG | 在 ltree 与 PL/Ruby 的 Ruby Array 之间转换 |
| pgtap | 1817161514 | --s-d-- | LANG | PostgreSQL单元测试框架 |
| faker | 1817161514 | --s-d-- | LANG | 插入生成的测试伪造数据，Python库的包装 |
| dbt2 | 1817161514 | --s-d-r | LANG | OSDL-DBT-2 测试组件 |
| pg_regresql | 1817161514 | --sLd-r | LANG | 用 pg_class 统计信息替代物理文件大小参与查询规划 |
| pltcl | 1817161514 | c-s-dt- | LANG | PL/TCL 存储过程语言 |
| pltcl | 1817161514 | c---d-- | LANG | PL/TCL 存储过程语言（未受信/高权限） |
| plperl | 1817161514 | c-s-dt- | LANG | PL/Perl 存储过程语言 |
| plperl | 1817161514 | c-s-dt- | LANG | 在 bool 和 plperl 之间转换 |
| plperl | 1817161514 | c-s-d-- | LANG | 在 hstore 和 plperl 之间转换适配类型 |
| plperl | 1817161514 | c---dt- | LANG | 在 jsonb 和 plperl 之间转换 |
| plperlu | 1817161514 | c-s-d-- | LANG | PL/PerlU 存储过程语言（未受信/高权限） |
| plperlu | 1817161514 | c---d-- | LANG | 在 bool 和 plperlu 之间转换 |
| plperlu | 1817161514 | c---d-- | LANG | 在 jsonb 和 plperlu 之间转换 |
| plperlu | 1817161514 | c---d-- | LANG | 在 hstore 和 plperlu 之间转换适配类型 |
| plpgsql | 1817161514 | c-s-dt- | LANG | PL/pgSQL 程序设计语言 |
| plpython3u | 1817161514 | c-s-d-- | LANG | PL/Python3 存储过程语言（未受信/高权限） |
| plpython3u | 1817161514 | c---d-r | LANG | 在 jsonb 和 plpython3u 之间转换 |
| plpython3u | 1817161514 | c-s-d-r | LANG | 在 ltree 和 plpython3u 之间转换 |
| plpython3u | 1817161514 | c---d-r | LANG | 在 hstore 和 plpython3u 之间转换 |
| pg_prefix | 1817161514 | --s-d-r | TYPE | 前缀树数据类型 |
| pg_semver | 1817161514 | --s-d-r | TYPE | 语义版本号数据类型 |
| pg_text_semver | 1817161514 | ----d-r | TYPE | PostgreSQL 语义版本域类型与比较运算符 |
| pgunit | 1817161514 | --s-d-- | TYPE | SI 国标单位扩展 |
| pgpdf | 1817161514 | --sLdtr | TYPE | PDF数据类型，管理函数与全文检索 |
| pglite_fusion | 1817161514 | --sLd-- | TYPE | 在PG表中嵌入SQLite数据库作为数据类型 |
| md5hash | 1817161514 | --s-d-r | TYPE | 提供128位MD5的原生数据类型 |
| asn1oid | 1817161514 | --s-d-r | TYPE | ASN1OID数据类型支持 |
| pg_roaringbitmap | 1817161514 | --s-d-r | TYPE | 支持RoaringBitmap数据类型 |
| pgfaceting | 1817161514 | ----d-- | TYPE | 使用倒排索引的高速切面查询 |
| pgsphere | 1817161514 | --s-d-r | TYPE | 球面对象函数、运算符与索引支持 |
| pg_country | 1817161514 | --s-d-r | TYPE | 国家代码数据类型，遵循ISO 3166-1标准 |
| pg_xenophile | 1817161514 | ----d-- | TYPE | PostgreSQL i8n与l10n工具包 |
| pg_xenophile | 1817161514 | ----d-r | TYPE | PostgreSQL l10n 工具包 |
| pg_currency | 1817161514 | --s-d-r | TYPE | 使用1字节表示的货币数据类型 |
| pgcollection | 1817161514 | --s-d-r | TYPE | 在PlPGSQL中使用的内存优化高性能集合数据结构 |
| pgmp | 1817161514 | --s-d-r | TYPE | 多精度算术扩展 |
| numeral | 1817161514 | --s-d-r | TYPE | 数值类型扩展 |
| pg_rational | 1817161514 | --s-d-- | TYPE | 使用BIGINT表示的有理数数据类型 |
| pguint | 1817161514 | --s-d-r | TYPE | 无符号整型数据类型 |
| pg_uint128 | 1817161514 | --s-d-r | TYPE | 原生128位无符号整型数据类型 |
| hashtypes | 1817161514 | --s-d-- | TYPE | 包括SHA1，MD5在内的多种哈希数据类型 |
| postbis | 1817161514 | --s-d-r | TYPE | 提供压缩的 DNA、RNA、氨基酸及比对序列类型，以及类型转换、运算符、索引 |
| ip4r | 1817161514 | --s-d-r | TYPE | PostgreSQL 的 IPv4/v6 和 IPv4/v6 范围索引类型 |
| pg_uri | 1817161514 | --s-d-r | TYPE | URI数据类型 |
| pg_emailaddr | 1817161514 | --s-d-- | TYPE | Email地址数据类型 |
| pg_acl | 1817161514 | --s-d-r | TYPE | ACL数据类型 |
| debversion | 1817161514 | --s-d-r | TYPE | Debian版本号数据类型 |
| pg_duration | 1817161514 | --s-d-r | TYPE | 用于表示时间段的强化数据类型 |
| pg_bikram_sambat | 1817161514 | --s-d-r | TYPE | Bikram Sambat 日期类型与公历/尼泊尔历转换函数 |
| pg_rrule | 1817161514 | --s-d-r | TYPE | 日历重复规则RRULE数据类型 |
| pgcalendar | 1817161514 | ----d-- | TYPE | 为 PostgreSQL 提供循环日程、投影与例外处理的日历扩展 |
| timestamp9 | 1817161514 | --s-d-- | TYPE | 纳秒分辨率时间戳 |
| pgbson | 1817161514 | --s-d-r | TYPE | 为 PostgreSQL 提供 BSON 数据类型及访问函数 |
| chkpass | 1817161514 | --s-d-- | TYPE | 数据类型：自动加密的密码 |
| isn | 1817161514 | c-s-dt- | TYPE | 用于国际产品编号标准的数据类型 |
| seg | 1817161514 | c-s-dt- | TYPE | 表示线段或浮点间隔的数据类型 |
| cube | 1817161514 | c-s-dt- | TYPE | 用于存储多维立方体的数据类型 |
| ltree | 1817161514 | c-s-dt- | TYPE | 用于表示分层树状结构的数据类型 |
| hstore | 1817161514 | c-s-dt- | TYPE | 用于存储（键，值）对集合的数据类型 |
| citext | 1817161514 | c-s-dt- | TYPE | 提供大小写不敏感的字符串类型 |
| xml2 | 1817161514 | c---d-- | TYPE | XPath 查询和 XSLT |
| pg_gzip | 1817161514 | --s-d-r | UTIL | 使用SQL执行Gzip压缩与解压缩 |
| pg_bzip | 1817161514 | --s-d-- | UTIL | BZIP压缩解压缩函数包 |
| pg_zstd | 1817161514 | --s-d-r | UTIL | ZSTD压缩解压缩函数包 |
| pg_http | 1817161514 | --s-d-- | UTIL | HTTP客户端，允许在数据库内收发HTTP请求 (supabase) |
| pg_net | 1817161514 | --sLd-- | UTIL | 用 SQL 进行异步非阻塞HTTP/HTTPS 请求的扩展 (supabase) |
| pg_curl | 1817161514 | --s-d-r | UTIL | 封装CURL，执行各种用URL传输数据的操作 |
| pg_retry | 1817161514 | --s-d-r | UTIL | 在临时错误中使用指数退避重试语句 |
| pg_fsql | 1817161514 | --s-d-- | UTIL | 支持 JSONB 驱动执行的递归 SQL 模板引擎 |
| pg_protobuf | 1817161514 | --s-d-r | UTIL | 提供Protobuf函数支持 |
| pgproto | 1817161514 | --s-d-r | UTIL | 原生 Protobuf 解析、修改、索引与 JSON 转换支持 |
| pglock | 1817161514 | ----d-- | UTIL | 在 PostgreSQL 内实现轻量级分布式锁服务 |
| pgjq | 1817161514 | --s-dtr | UTIL | 在Postgres中使用jq查询JSON |
| pgjwt | 1817161514 | --s-d-- | UTIL | JSON Web Token API 的PG实现 (supabase) |
| pg_smtp_client | 1817161514 | --s-d-- | UTIL | 使用SMTP从PostgreSQL内发送邮件的客户端扩展 |
| pg_html5_email_address | 1817161514 | ----d-r | UTIL | 验证Email是否符合HTML5规范的扩展 |
| url_encode | 1817161514 | --s-d-r | UTIL | 提供URL编码解码函数 |
| pgsql_tweaks | 1817161514 | --s-d-r | UTIL | 一些日常会用到的便利函数与视图 |
| pg_extra_time | 1817161514 | --s-d-r | UTIL | 一些关于日期与时间的扩展函数 |
| pgpcre | 1817161514 | --s-d-r | UTIL | PCRE/Perl风格的正则表达式支持 |
| re2 | 1817161514 | --s-dtr | UTIL | 使用 RE2 的 ClickHouse 兼容正则函数 |
| icu_ext | 1817161514 | --s-d-r | UTIL | 访问ICU库提供的函数 |
| pgqr | 1817161514 | --s-d-r | UTIL | 从数据库中直接生成QR二维码 |
| pg_envvar | 1817161514 | --s-d-- | UTIL | 获取环境变量的函数 |
| pg_byteamagic | 1817161514 | --s-d-r | UTIL | 从 PostgreSQL bytea 值检测 MIME 类型与文件格式 |
| floatfile | 1817161514 | --s-d-r | UTIL | 将浮点数组存储到文件中而不是堆表中 |
| external_file | 1817161514 | ----d-- | UTIL | 通过 PostgreSQL 函数访问服务器端外部文件 |
| pg_render | 1817161514 | --s-d-- | UTIL | 使用SQL渲染HTML页面 |
| pg_readme | 1817161514 | ----d-r | UTIL | 根据 PostgreSQL COMMENT 对象生成 Markdown README |
| pg_readme | 1817161514 | ----d-r | UTIL | 用于测试 pg_readme 文档生成的夹具扩展 |
| ddl_historization | 1817161514 | ----d-- | UTIL | 用SQL将所有DDL变更写入到数据库表中 |
| data_historization | 1817161514 | ----dt- | UTIL | 用SQL将数据变更历史保存到分区表中 |
| pg_schedoc | 1817161514 | ----d-- | UTIL | 在Django与DBT之间通过注释文档交换元数据 |
| pg_isok | 1817161514 | ----d-- | UTIL | 基于查询的数据完整性管理与软告警扩展 |
| pg_describe | 1817161514 | --s-d-r | UTIL | 不执行查询即可报告其参数与结果列元数据 |
| pg_hashlib | 1817161514 | --s-d-r | UTIL | 稳定哈希函数包 |
| pg_xxhash | 1817161514 | --s-dtr | UTIL | xxhash哈希函数包 |
| shacrypt | 1817161514 | --s-d-r | UTIL | 实现SHA256-CRYPT与SHA512-CRYPT密钥加密算法 |
| cryptint | 1817161514 | --s-d-r | UTIL | 加密INT与BIGINT类型 |
| pg_ecdsa | 1817161514 | --s-d-r | UTIL | PostgreSQL的uECC绑定，椭圆曲线加解密函数包 |
| pgsparql | 1817161514 | ----d-- | UTIL | 使用SQL查询SPARQL数据源 |
| pg_idkit | 1817161514 | --s-d-- | FUNC | 生成各式各样的唯一标识符：UUIDv6, ULID, KSUID |
| pgx_ulid | 1817161514 | --sLd-- | FUNC | ULID数据类型与函数 |
| pg_uuidv7 | 1817161514 | --s-d-r | FUNC | UUIDv7 支持 |
| pg_uuid_v8 | 1817161514 | --s-d-- | FUNC | 带隐藏时间戳的 PostgreSQL UUID v8 生成器 |
| permuteseq | 1817161514 | --s-d-r | FUNC | 伪随机数ID置换生成器 |
| pg_hashids | 1817161514 | --s-d-r | FUNC | 加盐将整型ID转为短字符串ID |
| pg_slug_gen | 1817161514 | --s-d-r | FUNC | 生成带时间戳的加密安全短标识 |
| sequential_uuids | 1817161514 | --s-d-r | FUNC | 生成连续生成的UUID |
| pg_typeid | 1817161514 | --s-d-- | FUNC | PG原生TypeID类型与函数 |
| snowflake | 1817161514 | --s-d-- | FUNC | Snowflake 风格 64 位 ID 生成与序列工具 |
| topn | 1817161514 | --s-d-- | FUNC | top-n JSONB 的类型 |
| quantile | 1817161514 | --s-d-- | FUNC | Quantile聚合函数 |
| lower_quantile | 1817161514 | --s-d-- | FUNC | Lower Quantile 聚合函数 |
| count_distinct | 1817161514 | --s-d-r | FUNC | COUNT(DISTINCT …) 聚合的替代方案 |
| omnisketch | 1817161514 | --s-d-r | FUNC | 实现OmniSketch数据结构，实现近似摘要聚合 |
| ddsketch | 1817161514 | --s-d-r | FUNC | 实现DDSketch数据结构，实现在线的Quantile聚合 |
| vasco | 1817161514 | --s-d-r | FUNC | 使用MIC发现数据中隐含的关联 |
| pgxicor | 1817161514 | --s-dtr | FUNC | 在PG中计算XI相关系数 |
| pg_weighted_statistics | 1817161514 | --s-d-r | FUNC | 针对稀疏数据的高性能加权统计量计算 |
| datasketches | 1817161514 | --s-d-r | FUNC | PostgreSQL 近似分析摘要数据结构与聚合函数 |
| fbsql | 1817161514 | ----d-- | FUNC | 在 SQL 中保持关系闭包的公式化统计建模扩展 |
| tdigest | 1817161514 | --s-d-r | FUNC | tdigest 聚合函数 |
| first_last_agg | 1817161514 | --s-d-r | FUNC | first() 与 last() 聚合函数 |
| extra_window_functions | 1817161514 | --s-d-r | FUNC | 额外的窗口函数 |
| floatvec | 1817161514 | --s-d-r | FUNC | 数组类型数学运算扩展 |
| aggs_for_vecs | 1817161514 | --s-d-r | FUNC | 针对数组类型的聚合函数集合扩展 |
| aggs_for_arrays | 1817161514 | --s-d-r | FUNC | 计算数组聚合统计值的函数包 |
| argm | 1817161514 | --s-d-r | FUNC | 提供 argmax、argmin 与 anyold 聚合函数 |
| pg_csv | 1817161514 | --s-d-r | FUNC | 灵活的CSV聚合处理函数 |
| pg_arraymath | 1817161514 | --s-d-r | FUNC | 数组逐元素数学运算符包 |
| pg_math | 1817161514 | --s-d-r | FUNC | 使用GSL库的数学统计函数 |
| pg_random | 1817161514 | --s-d-r | FUNC | 随机数生成器 |
| pg_base36 | 1817161514 | --s-d-- | FUNC | Base36编码解码扩展 |
| pg_base62 | 1817161514 | --s-d-- | FUNC | Base62编码解码扩展 |
| pg_base58 | 1817161514 | --s-d-- | FUNC | Base58 编码/解码函数 |
| pg_financial | 1817161514 | --s-d-r | FUNC | 金融领域聚合函数 |
| pg_accumulator | 1817161514 | --s-d-- | FUNC | PostgreSQL 中用于余额与周转跟踪的累积寄存器 |
| pg_convert | 1817161514 | --s-d-- | FUNC | 用于空间里程等的公英制转换函数 |
| parray_gin | 1817161514 | --s-d-r | FUNC | 为 text[] 提供部分匹配运算符与 GIN 索引支持 |
| refint | 1817161514 | c-s-d-- | FUNC | 实现引用完整性的函数 |
| autoinc | 1817161514 | c-s-d-- | FUNC | 用于自动递增字段的函数 |
| insert_username | 1817161514 | c-s-d-- | FUNC | 用于跟踪谁更改了表的函数 |
| moddatetime | 1817161514 | c-s-d-- | FUNC | 跟踪最后修改时间 |
| tsm_system_time | 1817161514 | c-s-dt- | FUNC | 接受毫秒数限制的 TABLESAMPLE 方法 |
| dict_xsyn | 1817161514 | c-s-d-- | FUNC | 用于扩展同义词处理的文本搜索字典模板 |
| tsm_system_rows | 1817161514 | c-s-dt- | FUNC | 接受行数限制的 TABLESAMPLE 方法 |
| tcn | 1817161514 | c-s-dt- | FUNC | 用触发器通知变更 |
| uuid-ossp | 1817161514 | c-s-dt- | FUNC | 生成通用唯一标识符（UUIDs） |
| btree_gist | 1817161514 | c-s-dt- | FUNC | 用GiST索引常见数据类型 |
| btree_gin | 1817161514 | c-s-dt- | FUNC | 用GIN索引常见数据类型 |
| intarray | 1817161514 | c---dt- | FUNC | 1维整数数组的额外函数、运算符和索引支持 |
| intagg | 1817161514 | c---d-- | FUNC | 整数聚合器和枚举器（过时） |
| dict_int | 1817161514 | c-s-dt- | FUNC | 用于整数的文本搜索字典模板 |
| unaccent | 1817161514 | c-s-dt- | FUNC | 删除重音的文本搜索字典 |
| pg_repack | 1817161514 | -bs-d-- | ADMIN | 在线垃圾清理与表膨胀治理 |
| pg_rewrite | 1817161514 | --sLd-r | ADMIN | 在线重写整表，不阻塞读写 |
| pg_query_rewrite | 1817161514 | --sLd-- | ADMIN | 使用 ProcessUtility hook 重写 SQL 语句 |
| pg_squeeze | 1817161514 | --sLd-- | ADMIN | 从关系中删除未使用空间 |
| pg_dirtyread | 1817161514 | --s-d-r | ADMIN | 从表中读取尚未垃圾回收的行 |
| pgfincore | 1817161514 | --s-d-r | ADMIN | 检查和管理操作系统缓冲区缓存 |
| pg_cooldown | 1817161514 | --s-d-r | ADMIN | 从缓冲区中移除特定关系的页面 |
| pg_ddlx | 1817161514 | --s-d-- | ADMIN | 提取数据库对象的DDL |
| pglinter | 1817161514 | --s-dt- | ADMIN | PG数据库规则检查插件 |
| pg_prioritize | 1817161514 | --s-d-r | ADMIN | 获取和设置 PostgreSQL 后端的优先级 |
| pg_checksums | 1817161514 | --s---r | ADMIN | 在离线模式下激活/启用/禁用数据库集群的校验和功能 |
| pg_readonly | 1817161514 | --sLd-- | ADMIN | 将集群设置为只读 |
| pgdd | 1817161514 | --s-d-- | ADMIN | 提供通过标准SQL查询数据库目录集簇的能力 |
| pg_permissions | 1817161514 | --s-d-- | ADMIN | 查看对象权限并将其与期望状态进行比较 |
| pgautofailover | 1817161514 | --sLd-- | ADMIN | PG 自动故障迁移 |
| pg_catcheck | 1817161514 | --s-d-- | ADMIN | 用于诊断系统目录是否损坏的工具 |
| preprepare | 1817161514 | --s-d-r | ADMIN | 在服务端预先准备好PreparedStatement备用 |
| pg_upless | 1817161514 | ----dt- | ADMIN | 检测表上的无用UPDATE |
| pgcozy | 1817161514 | ----d-- | ADMIN | 根据先前的pg_buffercache快照预热内存缓冲区 |
| pg_orphaned | 1817161514 | --s-d-- | ADMIN | 处理孤儿文件的扩展插件 |
| pg_crash | 1817161514 | --sL--- | ADMIN | 向数据库进程随机发送信号模拟故障 |
| pg_cheat_funcs | 1817161514 | --s-d-r | ADMIN | 一些超级实用的作弊函数 |
| pg_fio | 1817161514 | --s-d-r | ADMIN | PostgreSQL文件IO函数包 |
| pg_qos | 1817161514 | --sLd-- | ADMIN | PostgreSQL QoS 资源治理扩展（会话与查询限流/隔离） |
| pg_pathcheck | 1817161514 | --sL--- | ADMIN | 校验 planner Path 树，诊断已释放或损坏的内存引用 |
| pgdisablelogerror | 1817161514 | --sLd-r | ADMIN | 按 SQLSTATE 错误码禁止部分错误写入 PostgreSQL 服务器日志。 |
| online_advisor | 1817161514 | --sLd-r | ADMIN | 在线建议缺失索引、扩展统计信息与预备语句 |
| pg_column_tetris | 1817161514 | ----d-- | ADMIN | 强制采用最优列对齐顺序，以减少 PostgreSQL 行数据中的填充浪费。 |
| cat_tools | 1817161514 | ----d-- | ADMIN | 用于操作 PostgreSQL 系统目录的工具集 |
| pg_savior | 1817161514 | --s-d-r | ADMIN | 阻止不带条件的全表更新以避免意外事故 |
| safeupdate | 1817161514 | --sL--- | ADMIN | 强制在 UPDATE 和 DELETE 时提供 Where 条件 |
| pg_strict | 1817161514 | --sLd-- | ADMIN | 防止不带WHERE条件的危险UPDATE和DELETE操作 |
| pg_drop_events | 1817161514 | ----d-- | ADMIN | 记录删表删列删视图的事务号，辅助PITR确定时间点 |
| table_log | 1817161514 | --s-d-- | ADMIN | 记录某张表的修改日志并做表/行级时间点恢复 |
| pgelog | 1817161514 | ----d-- | ADMIN | 通过伪自治事务实现扩展日志记录 |
| pgagent | 1817161514 | --s-d-- | ADMIN | PostgreSQL任务调度工具，与PGADMIN配合使用 |
| pg_prewarm | 1817161514 | c-sLd-- | ADMIN | 预热关系数据 |
| pgpool | 1817161514 | ----d-- | ADMIN | PGPool 管理函数 |
| pgpool | 1817161514 | ----d-- | ADMIN | PGPool辅助扩展，从v4.3提供的恢复函数 |
| pgpool | 1817161514 | ----d-- | ADMIN | PGPool辅助扩展，RegClass替代 |
| lo | 1817161514 | c-s-dt- | ADMIN | 大对象维护 |
| basic_archive | 1817161514 | c-s---- | ADMIN | 归档模块样例 |
| basebackup_to_shell | 1817161514 | c-s---- | ADMIN | 添加一种备份到Shell终端到基础备份方式 |
| old_snapshot | 1817161514 | c-s-d-- | ADMIN | 支持 old_snapshot_threshold 的实用程序 |
| adminpack | 1817161514 | c-s-d-- | ADMIN | PostgreSQL 管理函数集合 |
| amcheck | 1817161514 | c-s-d-- | ADMIN | 校验关系完整性 |
| pg_surgery | 1817161514 | c-s-d-- | ADMIN | 对损坏的关系进行手术 |
| pg_profile | 1817161514 | --s-d-- | STAT | PostgreSQL 数据库负载记录与AWR报表工具 |
| pg_tracing | 1817161514 | --sLd-r | STAT | PostgreSQL分布式Tracing |
| pg_stat_ch | 1817161514 | --sLd-- | STAT | 将 PostgreSQL 查询遥测实时导出到 ClickHouse |
| pg_stat_backtrace | 1817161514 | --s-d-r | STAT | 捕获或记录 PostgreSQL 进程的 C 层调用栈 |
| pg_stat_log | 1817161514 | --sLd-r | STAT | 按后端类型、数据库、用户、日志级别与 SQLSTATE 统计 PostgreSQL 日志消息。 |
| pg_stat_plans | 1817161514 | --sLd-r | STAT | 跟踪查询计划级别的调用次数、执行时间与示例 EXPLAIN 文本。 |
| pg_flight_recorder | 1817161514 | ----d-- | STAT | 基于 pg_cron 的服务端 PostgreSQL 性能飞行记录器 |
| pg_flight_recorder | 1817161514 | ----d-- | STAT | pgfr_record 采集数据的报告与性能分析函数 |
| pgmonitor | 1817161514 | --sLd-- | STAT | 面向外部采集器的指标视图与后台刷新工作进程 |
| pg_statviz | 1817161514 | ----d-- | STAT | 采集 PostgreSQL 统计快照，用于时序分析与可视化 |
| pg_show_plans | 1817161514 | --sLd-r | STAT | 打印所有当前正在运行查询的执行计划 |
| pg_stat_kcache | 1817161514 | --sLd-r | STAT | 内核统计信息收集 |
| pg_stat_monitor | 1817161514 | --sLd-r | STAT | 提供查询聚合统计、客户端信息、执行计划详细信息和直方图 |
| pg_qualstats | 1817161514 | --sLd-- | STAT | 收集有关 quals 的统计信息的扩展 |
| pg_store_plans | 1817161514 | --sLd-r | STAT | 跟踪所有执行的 SQL 语句的计划统计信息 |
| pg_track_settings | 1817161514 | --s-d-- | STAT | 跟踪设置更改 |
| pg_track_optimizer | 1817161514 | --sLd-r | STAT | 跟踪规划器决策与实际执行的差距 |
| pg_wait_sampling | 1817161514 | --sLd-r | STAT | 基于采样的等待事件统计 |
| pg_datasentinel | 1817161514 | --sLd-- | STAT | PostgreSQL 可观测性与活动监控扩展 |
| pgsentinel | 1817161514 | --sLd-r | STAT | 活跃会话历史 |
| system_stats | 1817161514 | --s-d-r | STAT | PostgreSQL 的系统统计函数 |
| pg_meta | 1817161514 | ----d-- | STAT | 标准化，更友好的PostgreSQL系统目录视图 |
| pgnodemx | 1817161514 | --sLd-r | STAT | 使用SQL查询获取操作系统指标 |
| pgnodemx | 1817161514 | --s-d-r | STAT | 通过SQL接口访问操作系统进程表 |
| pg_sqlog | 1817161514 | --s-d-- | STAT | 提供访问PostgreSQL日志的SQL接口 |
| bgw_replstatus | 1817161514 | --sL--- | STAT | 用于汇报本机主从状态的后台工作进程 |
| pgmeminfo | 1817161514 | --s-d-- | STAT | 显示内存使用情况 |
| toastinfo | 1817161514 | --s-d-r | STAT | 显示TOAST字段的详细信息 |
| pg_explain_ui | 1817161514 | --s-d-- | STAT | 快速跳转至PEV查阅可视化执行计划 |
| pg_relusage | 1817161514 | --sL--- | STAT | 打印查询引用的表与列 |
| pagevis | 1817161514 | ----d-r | STAT | 使用ASCII字符可视化数据库物理页面布局 |
| powa | 1817161514 | --s-d-- | STAT | PostgreSQL 工作负载分析器-核心 |
| pg_overexplain | 1817161514 | c-sL--- | STAT | 允许 EXPLAIN 转储更多详细 |
| pg_logicalinspect | 1817161514 | c-s-d-- | STAT | 检视逻辑解码组件详情 |
| pageinspect | 1817161514 | c-s-d-- | STAT | 检查数据库页面二进制内容 |
| pgrowlocks | 1817161514 | c-s-d-- | STAT | 显示行级锁信息 |
| sslinfo | 1817161514 | c-s-d-- | STAT | 关于 SSL 证书的信息 |
| pg_buffercache | 1817161514 | c-s-d-- | STAT | 检查共享缓冲区缓存 |
| pg_walinspect | 1817161514 | c-s-d-- | STAT | 用于检查 PostgreSQL WAL 日志内容的函数 |
| pg_freespacemap | 1817161514 | c-s-d-- | STAT | 检查自由空间映射的内容（FSM） |
| pg_visibility | 1817161514 | c-s-d-- | STAT | 检查可见性图（VM）和页面级可见性信息 |
| pgstattuple | 1817161514 | c-s-d-- | STAT | 显示元组级统计信息 |
| auto_explain | 1817161514 | c-sL--- | STAT | 提供一种自动记录执行计划的手段 |
| pg_stat_statements | 1817161514 | c-sLd-- | STAT | 跟踪所有执行的 SQL 语句的计划和执行统计信息 |
| passwordcheck_cracklib | 1817161514 | --sL--- | SEC | 使用cracklib加固PG用户密码 |
| supautils | 1817161514 | --sL--- | SEC | 用于在云环境中确保数据库集群的安全 |
| pgsodium | 1817161514 | --sLd-- | SEC | 表数据加密存储 TDE |
| column_encrypt | 1817161514 | --sLd-- | SEC | 透明列级加密扩展，提供 encrypted_text 与 encrypted_bytea 类型 |
| passwordpolicy | 1817161514 | --sLd-r | SEC | 可动态配置的 PostgreSQL 密码复杂度检查扩展。 |
| pg_vault | 1817161514 | --s-d-- | SEC | 在 Vault 中存储加密凭证的扩展 (supabase) |
| pg_session_jwt | 1817161514 | --s-dt- | SEC | 使用JWT进行会话认证 |
| pg_anon | 1817161514 | --sLd-- | SEC | 数据匿名化处理工具 |
| pgsmcrypto | 1817161514 | --s-d-- | SEC | 为PostgreSQL提供商密算法支持：SM2,SM3,SM4 |
| pg_enigma | 1817161514 | --s-d-- | SEC | PostgreSQL 加密数据类型 |
| pgaudit | 1817161514 | --sLd-r | SEC | 提供审计功能 |
| pgauditlogtofile | 1817161514 | --sLd-r | SEC | pgAudit 子扩展，将审计日志写入单独的文件中 |
| pg_roast | 1817161514 | --sLd-- | SEC | 覆盖模式设计、安全配置、运行健康与查询行为的数据库审计器 |
| pg_auditor | 1817161514 | ----d-- | SEC | 审计数据变更并提供闪回能力 |
| logerrors | 1817161514 | --sLd-r | SEC | 用于收集日志文件中消息统计信息的函数 |
| pg_auth_mon | 1817161514 | --sLd-r | SEC | 监控每个用户的连接尝试 |
| pg_jobmon | 1817161514 | --s-d-- | SEC | 记录和监控函数 |
| pg_oidc_validator | 1817161514 | --sL--- | SEC | PostgreSQL 18 OAuth 与 OIDC 令牌验证模块 |
| pg_oidc_validator_rust | 1817161514 | --sL--- | SEC | 使用 Rust 与 pgrx 编写的 PostgreSQL 18 OIDC Bearer 令牌验证模块 |
| pgmemento | 1817161514 | ----d-- | SEC | 基于事务日志的审计追踪、模式版本管理与数据恢复 |
| credcheck | 1817161514 | --sLd-- | SEC | 明文凭证检查器 |
| pgcryptokey | 1817161514 | --s-d-r | SEC | PG密钥管理 |
| pg_pwhash | 1817161514 | --s-d-r | SEC | PostgreSQL 高级密码哈希扩展（Argon2/scrypt/yescrypt） |
| login_hook | 1817161514 | --s-d-- | SEC | 在用户登陆时执行login_hook.login()函数 |
| set_user | 1817161514 | --sLd-- | SEC | 增加了日志记录的 SET ROLE |
| pg_snakeoil | 1817161514 | --sLd-r | SEC | PostgreSQL动态链接库反病毒功能 |
| pgextwlist | 1817161514 | --sL--- | SEC | PostgreSQL扩展白名单功能 |
| pg_command_fw | 1817161514 | --sLd-- | SEC | PostgreSQL 的 DDL 与 utility 命令防火墙 |
| sslutils | 1817161514 | --s-d-- | SEC | 使用SQL管理SSL证书 |
| pg_noset | 1817161514 | --sLd-r | SEC | 阻止非超级用户使用SET/RESET设置变量 |
| block_copy_command | 1817161514 | --sLd-- | SEC | 通过可配置的 ProcessUtility hook 阻止 COPY 命令 |
| pg_policy | 1817161514 | ----d-- | SEC | 面向 AI 智能体的 PostgreSQL 策略语言，提供护栏、软性引导与会话级控制 |
| pg_kpart | 1817161514 | --sL--r | SEC | 拒绝未使用分区键的全分区扫描查询 |
| pg_tde | 1817161514 | --sLd-- | SEC | Percona 透明加密存储引擎 |
| pg_vault_tde | 1817161514 | -bsLd-- | SEC | 通过自定义表与索引访问方法为 PostgreSQL 提供透明数据加密 |
| sepgsql | 1817161514 | c-sL--- | SEC | 基于SELinux标签的强制访问控制 |
| auth_delay | 1817161514 | c-sL--- | SEC | 在返回认证失败前暂停一会，避免爆破 |
| pgcrypto | 1817161514 | c-s-dt- | SEC | 实用加解密函数 |
| passwordcheck | 1817161514 | c-sL--- | SEC | 用于强制拒绝修改弱密码的扩展 |
| wrappers | 1817161514 | --s-d-r | FDW | Supabase提供的外部数据源包装器捆绑包 |
| multicorn | 1817161514 | --s-d-- | FDW | 用Python编写自定义的外部数据源包装器 |
| odbc_fdw | 1817161514 | --s-d-r | FDW | 访问ODBC可访问的任何外部数据源 |
| jdbc_fdw | 1817161514 | --s-d-r | FDW | 访问JDBC可访问的任何外部数据源 |
| pgspider_ext | 1817161514 | --s-d-r | FDW | 使用多种FDW访问远程数据库服务器 |
| mysql_fdw | 1817161514 | --s-d-r | FDW | MySQL外部数据包装器 |
| oracle_fdw | 1817161514 | --s-d-- | FDW | 提供对Oracle的外部数据源包装器 |
| tds_fdw | 1817161514 | --s-d-r | FDW | TDS 数据库（Sybase/SQL Server）外部数据包装器 |
| db2_fdw | 1817161514 | --s-d-- | FDW | 提供对DB2的外部数据源包装器 |
| sqlite_fdw | 1817161514 | --s-d-r | FDW | SQLite 外部数据包装器 |
| pgbouncer_fdw | 1817161514 | ----d-- | FDW | 用SQL查询pgbouncer统计信息，并执行pgbouncer命令 |
| etcd_fdw | 1817161514 | --s-d-- | FDW | etcd分布式键值存储外部数据包装器 |
| informix_fdw | 1817161514 | --s-d-r | FDW | Informix 外部数据包装器 |
| nominatim_fdw | 1817161514 | --s-d-r | FDW | Nominatim 地理编码接口的 FDW 扩展 |
| mongo_fdw | 1817161514 | --s-d-- | FDW | MongoDB 外部数据包装器 |
| redis_fdw | 1817161514 | --s-d-r | FDW | 查询外部Redis数据源 |
| pg_redis_pubsub | 1817161514 | --s-d-r | FDW | 从PG向Redis发送Pub/Sub消息 |
| kafka_fdw | 1817161514 | --s-d-r | FDW | Kafka外部数据源包装器 |
| hdfs_fdw | 1817161514 | --s-d-r | FDW | hdfs 外部数据包装器 |
| firebird_fdw | 1817161514 | --s-d-r | FDW | Firebird外部数据源包装器 |
| rdf_fdw | 1817161514 | --s-d-r | FDW | 通过 SPARQL 端点访问 RDF 三元组存储的 FDW |
| aws_s3 | 1817161514 | ----d-r | FDW | 从S3导入导出数据的外部数据源包装器 |
| log_fdw | 1817161514 | --s-d-- | FDW | 访问PostgreSQL日志文件的FDW |
| dblink | 1817161514 | c-s-d-- | FDW | 从数据库内连接到其他 PostgreSQL 数据库 |
| file_fdw | 1817161514 | c-s-d-- | FDW | 访问外部文件的外部数据包装器 |
| postgres_fdw | 1817161514 | c-s-d-- | FDW | 用于远程 PostgreSQL 服务器的外部数据包装器 |
| documentdb | 1817161514 | --sLd-- | SIM | 微软DocumentDB的API层 |
| documentdb | 1817161514 | --sLd-- | SIM | 微软DocumentDB的核心API层实现 |
| documentdb | 1817161514 | --sLd-- | SIM | DocumentDB多节点模式的API层 |
| documentdb | 1817161514 | --sLd-r | SIM | DocumentDB扩展RUM索引访问方法 |
| pg_projection | 1817161514 | ----d-r | SIM | PostgreSQL JSONB 的 MongoDB 风格投影读取函数 |
| orafce | 1817161514 | --s-d-- | SIM | 模拟 Oracle RDBMS 的一部分函数和包的函数和运算符 |
| pgtt | 1817161514 | --sLd-- | SIM | 类似Oracle的全局临时表功能 |
| session_variable | 1817161514 | --s-d-- | SIM | Oracle兼容的会话变量/常量操作函数 |
| pg_statement_rollback | 1817161514 | --sL--- | SIM | 在服务端提供类似Oracle/DB2的语句级回滚能力 |
| ivorysql | 1817161514 | --s-d-- | SIM | Oracle 兼容扩展 |
| ivorysql | 1817161514 | --s-dt- | SIM | Oracle 数据类型 GIN 索引支持 |
| ivorysql | 1817161514 | --s-dt- | SIM | Oracle 数据类型 GiST 索引支持 |
| ivorysql | 1817161514 | --s-dt- | SIM | 获取函数定义 |
| ivorysql | 1817161514 | --s-dt- | SIM | PL/iSQL 过程语言 |
| ivorysql | 1817161514 | --s-dt- | SIM | 支持 GB18030-2022 与 UTF-8 编码转换 |
| db2fce | 1817161514 | ----d-- | SIM | 为 PostgreSQL 提供 DB2 兼容函数、类型、操作符与 SYSIBM.SYSDUMMY1。 |
| plpgsql_wrap | 1817161514 | --s-d-- | SIM | Oracle WRAP 等价的 PL/pgSQL 语言处理器，以 AES-256-GCM 加密存储过程源码。 |
| pg_dbms_metadata | 1817161514 | ----d-- | SIM | 添加 Oracle DBMS_METADATA 兼容性支持的扩展 |
| pg_dbms_lock | 1817161514 | ----d-- | SIM | 为PG添加对 Oracle DBMS_LOCK 的完整兼容性支持 |
| pg_dbms_job | 1817161514 | --sLd-- | SIM | 添加 Oracle DBMS_JOB 兼容性支持的扩展 |
| pg_dbms_errlog | 1817161514 | --sLd-- | SIM | 模仿 Oracle DBMS_ERRLOG 模块来记录特定表的DML错误 |
| pg_utl_smtp | 1817161514 | ----d-- | SIM | Oracle UTL_SMTP 兼容扩展（基于 plperlu） |
| babelfish | 1817161514 | --s-d-r | SIM | SQL Server 数据类型兼容扩展 |
| babelfish | 1817161514 | --s-d-r | SIM | SQL Server SQL语法兼容性扩展 |
| babelfish | 1817161514 | --sLd-r | SIM | SQL Server TDS线缆协议兼容扩展 |
| babelfish | 1817161514 | --s-dt- | SIM | SQL Server 货币数据类型兼容扩展 |
| pgmemcache | 1817161514 | --s-d-r | SIM | 为PG提供memcached兼容接口 |
| openhalo | 1817161514 | --s-d-- | SIM | MySQL兼容辅助扩展模块 |
| pglogical | 1817161514 | --sLd-- | ETL | PostgreSQL逻辑复制：三方扩展实现 |
| pglogical | 1817161514 | --s-d-- | ETL | 用于从 Postgres 9.4 升级时的兼容性虚拟扩展 |
| pglogical_ticker | 1817161514 | --sLd-- | ETL | pglogical复制延迟以秒计的精确视图 |
| pgl_ddl_deploy | 1817161514 | --s-d-- | ETL | 使用 pglogical 执行自动 DDL 部署 |
| logical_ddl | 1817161514 | --s-d-- | ETL | 在 PostgreSQL 逻辑复制中复制受支持的 DDL 变更 |
| pg_failover_slots | 1817161514 | --sL--r | ETL | 在Failover过程中保留复制槽 |
| db_migrator | 1817161514 | ----d-r | ETL | 使用FDW从其他DBMS迁移到PostgreSQL |
| pgactive | 1817161514 | -bsLd-- | ETL | PostgreSQL多主逻辑复制 |
| spock | 1817161514 | -bsLd-- | ETL | PostgreSQL 多主逻辑复制扩展 |
| lolor | 1817161514 | --s-dt- | ETL | 让 PostgreSQL 大对象兼容逻辑复制的扩展 |
| pgclone | 1817161514 | --sLd-- | ETL | 在不同环境间克隆 PostgreSQL 数据库、模式、表和函数 |
| pgmqtt | 1817161514 | --s-d-- | ETL | PostgreSQL 的 CDC 到 MQTT 代理扩展 |
| wal2json | 1817161514 | --s---- | ETL | 用逻辑解码捕获 JSON 格式的 CDC 变更 |
| wal2mongo | 1817161514 | --s---- | ETL | 使用逻辑解码捕获MongoDB JSON格式的CDC变更 |
| decoderbufs | 1817161514 | --sL--- | ETL | 将WAL逻辑解码为ProtocolBuffer协议的消息 |
| decoder_raw | 1817161514 | --s---- | ETL | 逻辑复制解码输出插件：RAW SQL格式 |
| mimeo | 1817161514 | ----d-- | ETL | 在PostgreSQL实例间进行表级复制 |
| repmgr | 1817161514 | --sLd-- | ETL | PostgreSQL复制管理组件 |
| pg_fact_loader | 1817161514 | --s-d-- | ETL | 在 Postgres 中构建事实表 |
| pg_bulkload | 1817161514 | -bs-d-- | ETL | 向 PostgreSQL 中高速加载数据 |
| test_decoding | 1817161514 | c-s---- | ETL | 基于SQL的WAL逻辑解码样例 |
| pgoutput | 1817161514 | c-s---- | ETL | PG内置的逻辑解码输出插件 |
属性说明: c:contrib b:二进制 s:动态库 l:需加载 d:需DDL t:无需特权 r:可重定位
Enables scalable inserts and complex queries for time-series data
Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities
Convenience API for time series stack
Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
temporal tables
Enables fine-grained write logging and time travel on subsets of the database.
PostgreSQL table versioning extension
Job scheduler for PostgreSQL
execute any sql command at any specific time at background
Run queries now and get results later
Asynchronous SQL dispatcher built on pg_cron
Run SQL queries in the background
Natural language time parsing for PostgreSQL
Time series analysis functions for PostgreSQL
Parse cron expressions and compute previous or next trigger times
PostGIS geometry and geography spatial types and functions
PostGIS topology spatial types and functions
PostGIS raster types and functions
PostGIS SFCGAL functions
PostGIS tiger geocoder and reverse geocoder
Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
Address Standardizer US dataset example
pgRouting Extension
data type for lidar point clouds
integration for pointcloud LIDAR data and PostGIS geometry data
H3 bindings for PostgreSQL
H3 PostGIS integration
q3c sky indexing plugin
foreign-data wrapper for GIS data access
IP-based geolocation query
Fast Google Encoded Polyline encoding & decoding for postgres
Coordinate transforms for BD09/GCJ02 via PostGIS ST_Transform
Handle geohash based functionality for spatial coordinates
Drainage network analysis core for PostgreSQL and PostGIS
Raster hydrology extension for PgHydro
Hydrogeomorphological analysis extension for PgHydro
Output and reporting objects for PgHydro
Australian English output pack for PgHydro
Brazilian Portuguese output pack for PgHydro
Pfafstetter consistency checks for PgHydro
MobilityDB geospatial trajectory data management & analysis platform
MobilityDB random data generator functions
Fast lookup timezone name by GPS coordinates
calculate great-circle distances on the surface of the Earth
Encode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL.
Add PostGIS geometry and geography bindings plus area-to-cell fills for QDGC.
vector data type and ivfflat and hnsw access methods
Vector database plugin for Postgres, written in Rust
Advanced indexing for vector data with DiskANN
The simplest way to do vector search on Postgres
support similarity queries
Reciprocal rank fusion functions for hybrid search
Effective similarity search
Text Summarization using LLMs. Built using pgrx
tiktoken tokenizer for use with OpenAI models in postgres
Fast tiktoken BPE tokenizer for PostgreSQL implemented in C
Machine learning framework for PostgreSQL
Run AL/ML workloads with SQL interface
Single-plan multimodal agent memory for PostgreSQL
Vector, filter-aware HNSW, and hybrid retrieval over authoritative PostgreSQL tables.
Optional pgvector compatibility bridge for pgcontext HNSW indexes.
TurboQuant-compressed vector type and ANN index access method for PostgreSQL.
Full text search for PostgreSQL using BM25
Use Groonga as index, fast full text search platform for all languages!
PGroonga database management module
create 2-gram (bigram) index for faster full text search.
a parser for full-text search of Chinese
Generate BM25 sparse vector inside PostgreSQL
A postgresql extension for bm25 ranking algorithm
Tokenizers for full-text search
IAM-LIKE pattern matching with bitmap indexing
Full-text search with BM25 ranking
Pinyin romanization and search helpers for PostgreSQL
Kazakh full-text search extension for PostgreSQL
PostgreSQL extension for BM25-family lexical retrieval
Full-text search with BM25 and BM25F ranking
CJK bigram parser derived from PostgreSQL full-text search
Chinese full-text search parser based on cppjieba
Czech Hunspell Dictionary
German Hunspell Dictionary
en_US Hunspell Dictionary
French Hunspell Dictionary
Nepali Hunspell Dictionary
Dutch Hunspell Dictionary
Norwegian (norsk) Hunspell Dictionary
Portuguese Hunspell Dictionary
Russian Hunspell Dictionary
Russian Hunspell Dictionary (from AOT.ru group)
determine similarities and distance between strings
text similarity measurement and index searching based on trigrams
Distributed PostgreSQL as an extension
Citus columnar storage engine
Hydra Columnar extension
Postgres for analytics, powered by DuckDB
DuckDB Embedded in Postgres
Columnstore Table in Postgres
colcompress and rowcompress Table Access Methods with vectorized execution
Interfaces to query ClickHouse databases from PostgreSQL
DuckDB Foreign Data Wrapper
copy data between Postgres and Parquet
DuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet
Table partitioning by foreign key utility
Extension to manage partitioned tables by time or ID
Database partitioning implemented as procedural language
PG-Strom - big-data processing acceleration using GPU and NVME
ORCA query optimizer as a PostgreSQL extension
Sorted heap table AM with zone map scan pruning and built-in vector search
Data lake extension by Snowflake
Extension development kit by Snowflake
Automatic extension updater
Map type for PostgreSQL, bundled as a required pg_lake component.
Query engine for data lake queries
Iceberg implementation in Postgres
Data lake tables and Iceberg tables
Copy to/from data lake files
functions that manipulate whole tables, including crosstab
AGE graph database extension
Liquid-inspired Datalog graph query extension for PostgreSQL
Sparse linear algebra and graph extension for PostgreSQL 18
Graph database capabilities for PostgreSQL
RDF, SPARQL, SHACL, and OWL reasoning for PostgreSQL
Generic queue for PostgreSQL
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
A simple PostgreSQL Message Broker system
Transactional Outbox extension for PostgreSQL with reliable asynchronous delivery
Finite state machine toolkit for PostgreSQL
type for storing hyperloglog data
RUM index access method
AI-powered SQL query generation for PostgreSQL
Automatic data expiration with TTL indexes
Add in-database GraphQL support
PostgreSQL extension providing JSON Schema validation
JSON Schema validation functions for PostgreSQL
data type for jsonb inspection
Give PostgreSQL ability to manually force some decisions in execution plans.
Hypothetical indexes for PostgreSQL
Query index advisor
filter statements by their execution plans.
Session-scoped variables with scalar, array, and record types
Image similarity with haar
incremental view maintenance on PostgreSQL
Incremental Processing by Crunchy Data
Streaming tables and differential view maintenance for PostgreSQL 18
Durable SQL functions for PostgreSQL
Perturb unordered SELECT row order to expose order-dependent tests
Transaction-aware shared-memory cache for ordinary PostgreSQL primary-key reads
Semiring provenance and probability management for PostgreSQL
OrioleDB, the next generation transactional engine
A suite of Cardano-related tools
Cheminformatics functionality for PostgreSQL.
Advanced adapter for Postgres extensions
Basic session management
Amazon Web Services APIs (S3)
CloudEvents support
Docker container management
Application credential management
CSV toolkit
Dataset provisioning
E-mail framework
Basic HTTP types
HTTP client
HTTP server
Identity types
JSON toolkit
Kubernetes (k8s) integration
Financial ledger
Package installation manifests
MIME types
Operating system integration
Postgres API polyfills
First-class Python support
PCRE-compatible regular expressions
REST API toolkit (with PostgREST support)
Advanced schema management tooling
Distributed integer sequences
Service management
Session management
Shared Memory Management
Programmatic SQL manipulation
Embedded SQLite
Testing framework
Transaction management
Advanced types
Scoped variables
Virtual File System
Virtual File System types (v1)
Common web stack primitives
Generalized worker pool
XML toolkit
YAML toolkit
Datomic-compatible data model and Datalog query engine inside PostgreSQL
bloom access method - signature file based index
Trusted Language Extensions for PostgreSQL
PL/JavaScript (v8) trusted procedural language
PL/JS trusted procedural language
Lua as a procedural language
Hstore transform for Lua
Lua as an untrusted procedural language
Hstore transform for untrusted Lua
Use PRQL in PostgreSQL - Pipelined Relational Query Language
server-side support for debugging PL/pgSQL functions
Additional validation, profiling, and diagnostics for PL/pgSQL functions
server-side support for profiling PL/pgSQL functions
PL/sh procedural language
PL/Java procedural language
load R interpreter and execute R script from within a database
XSLT procedural language for PostgreSQL
Create mockable wrappers for PostgreSQL functions in tests
Mocking and faking helpers for PostgreSQL unit tests
Transpile multiple procedural dialects to PL/pgSQL
Run sandboxed WebAssembly components as strongly typed PostgreSQL SQL functions.
Embed MRI Ruby as an untrusted PostgreSQL procedural language
Transform between jsonb and native Ruby data for PL/Ruby
Transform between hstore and Ruby Hashes for PL/Ruby
Transform between ltree and Ruby Arrays for PL/Ruby
Unit testing for PostgreSQL
Wrapper for the Faker Python library
OSDL-DBT-2 test kit
Trust pg_class statistics for planning instead of physical relation size
PL/Tcl procedural language
PL/TclU untrusted procedural language
PL/Perl procedural language
transform between bool and plperl
transform between hstore and plperl
transform between jsonb and plperl
PL/PerlU untrusted procedural language
transform between bool and plperlu
transform between jsonb and plperlu
transform between hstore and plperlu
PL/pgSQL procedural language
PL/Python3U untrusted procedural language
transform between jsonb and plpython3u
transform between ltree and plpython3u
transform between hstore and plpython3u
Prefix Range module for PostgreSQL
Semantic version data type
Semantic version domain and comparison operators for PostgreSQL
SI units extension
PDF type with meta admin & Full-Text Search
Embed an SQLite database in your PostgreSQL table
type for storing 128-bit binary data inline
asn1oid extension
support for Roaring Bitmaps
fast faceting queries using an inverted index
spherical objects with useful functions, operators and index support
Country data type, ISO 3166-1
More than the bare necessities for PostgreSQL i18n and l10n.
PostgreSQL l10n toolbox
Custom PostgreSQL currency type in 1Byte
Memory optimized data type to be used inside of plpglsql func
Multiple Precision Arithmetic extension
numeral datatypes extension
bigint fractions
unsigned integer types
Native uint128 type
sha1, md5 and other data types for PostgreSQL
Adds compressed DNA, RNA, amino-acid, and aligned sequence types with casts, operators, indexes, and bioinformatics functions.
IPv4/v6 and IPv4/v6 range index type for PostgreSQL
URI Data type for PostgreSQL
Email address type for PostgreSQL
ACL Data type
Debian version number data type
data type for representing durations
Bikram Sambat date type and AD/BS conversion functions
RRULE field type for PostgreSQL
Recurring calendar, schedule, and exception management for PostgreSQL
timestamp nanosecond resolution
BSON data type and accessor functions for PostgreSQL
data type for auto-encrypted passwords
data types for international product numbering standards
data type for representing line segments or floating-point intervals
data type for multidimensional cubes
data type for hierarchical tree-like structures
data type for storing sets of (key, value) pairs
data type for case-insensitive character strings
XPath querying and XSLT
gzip and gunzip functions.
Bzip compression and decompression
Zstandard compression algorithm implementation in PostgreSQL
HTTP client for PostgreSQL, allows web page retrieval inside the database.
Async HTTP Requests
Run curl actions for data transfer in URL syntax
Retry SQL statements on transient errors with exponential backoff
Recursive SQL template engine with JSONB-driven execution
Protobuf support for PostgreSQL
Native Protobuf parsing, mutation, indexing, and JSON conversion support
Lightweight distributed lock service inside PostgreSQL
Use jq in Postgres
JSON Web Token API for Postgresql
PostgreSQL extension to send email using SMTP
PostgreSQL email validation that is consistent with the HTML5 spec
url_encode, url_decode functions
Some functions and views for daily usage
Generate inlinable SQL functions for navigating PostgreSQL foreign-key relations
Some date time functions and operators that,
Perl Compatible Regular Expression functions
ClickHouse-compatible regex functions using RE2
Access ICU functions
QR Code generator from PostgreSQL
Fetch the value of an environment variable
Detect MIME types and file formats from PostgreSQL bytea values
Simple file storage for arrays of floats
Access external server-side files through PostgreSQL functions
Render HTML in SQL
Generate a Markdown README from PostgreSQL COMMENT objects
Fixture extension used to test pg_readme document generation
Historize the ddl changes inside PostgreSQL database
PLPGSQL Script to historize data in partitionned table
Cross documentation between Django and DBT projects
Query-based data integrity management and soft alerting for PostgreSQL
Report a query’s parameters and result columns without executing it
Stable hash functions for Postgres
xxhash functions for PostgreSQL
Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
Encryption functions for int and bigint values
uECC bindings for Postgres
Query SPARQL datasource with SQL
multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
ulid type and methods
Create UUIDv7 values in postgres
UUID v8 generator with embedded timestamps for PostgreSQL
Pseudo-randomly permute sequences with a format-preserving encryption on elements
Short unique id generator for PostgreSQL, using hashids
Generate cryptographically secure timestamp-based slugs
generator of sequential UUIDs
Allows to use TypeIDs in Postgres natively
Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL
type for top-n JSONB
Quantile aggregation function
Lower quantile aggregate function
An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
data structure for on-line agg of data into approximate sketch
Provides ddsketch aggregate function
discover hidden correlations in your data with MIC
XI Correlation Coefficient in Postgres
High-performance weighted statistics functions for sparse data
Approximate analytics sketches and aggregates for PostgreSQL
Closure-preserving formula-based statistical modeling in SQL
Provides tdigest aggregate function.
first() and last() aggregate functions
Extra Window Functions for PostgreSQL
Math for vectors (arrays) of numbers
Aggregate functions for array inputs
Various functions for computing statistics on arrays of numbers
argmax, argmin, and anyold aggregate functions
Flexible CSV processing for Postgres
Array math and operators that work element by element on the contents of arrays
GSL statistical functions for postgresql
random data generator
Integer Base36 types
Base62 extension for PostgreSQL
Base58 Encoder/Decoder Extension for PostgreSQL
Financial aggregate functions
Accumulation registers for balance and turnover tracking in PostgreSQL
conversion functions for spatial, routing and other specialized uses
GIN index operator class and partial-match operators for text arrays
functions for implementing referential integrity (obsolete)
functions for autoincrementing fields
functions for tracking who changed a table
functions for tracking last modification time
TABLESAMPLE method which accepts time in milliseconds as a limit
text search dictionary template for extended synonym processing
TABLESAMPLE method which accepts number of rows as a limit
Triggered change notifications
generate universally unique identifiers (UUIDs)
support for indexing common datatypes in GiST
support for indexing common datatypes in GIN
functions, operators, and index support for 1-D arrays of integers
integer aggregator and enumerator (obsolete)
text search dictionary template for integers
text search dictionary that removes accents
Reorganize tables in PostgreSQL databases with minimal locks
Tool allows read write to the table during the rewriting
Rewrite SQL statements with a PostgreSQL ProcessUtility hook
A tool to remove unused space from a relation.
Read dead but unvacuumed rows from table
examine and manage the os buffer cache
remove buffered pages for specific relations
DDL eXtractor functions
PostgreSQL Linting and Analysis Extension
get and set the priority of PostgreSQL backends
Activate/deactivate/verify checksums in offline Postgres clusters
cluster database read only
Introspect pg data dictionary via standard SQL
view object permissions and compare them with the desired state
pg_auto_failover
Diagnosing system catalog corruption
Pre Prepare your Statement server side
Detect Useless UPDATE
Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
Deal with orphaned files
Send random signals to random processes
Provides cheat (but useful) functions
PostgreSQL File I/O Functions
QoS resource governor extension for PostgreSQL sessions and queries
Validate planner Path trees for freed or corrupt memory
Disable selected SQLSTATE error codes from PostgreSQL server logging.
Suggest missing indexes and extended statistics online
Enforce optimal column alignment to minimize row padding
Tools for interfacing with the PostgreSQL catalog
Postgres extension to save OOPS mistakes
Require criteria for UPDATE and DELETE
Prevent dangerous UPDATE and DELETE without WHERE clause
logs transaction ids of drop table, drop column, drop materialized view statements
record table modification logs and PITR for table/row
Extended logging via pseudo-autonomous transactions
A PostgreSQL job scheduler
prewarm relation data
Administrative functions for pgPool
recovery functions for pgpool-II for V4.3
replacement for regclass
Large Object maintenance
an example of an archive module
adds a custom basebackup target called shell
utilities in support of old_snapshot_threshold
administrative functions for PostgreSQL
functions for verifying relation integrity
extension to perform surgery on a damaged relation
PostgreSQL load profile repository and report builder
Distributed Tracing for PostgreSQL
Export PostgreSQL query telemetry to ClickHouse
Capture or log C-level stack backtraces of PostgreSQL processes
Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE.
Track per-plan call counts, execution times, and example EXPLAIN texts.
Server-side PostgreSQL performance flight recorder
Reporting and analysis functions for pgfr_record
Collector-friendly metric views and background refresh worker
Capture PostgreSQL statistics snapshots for time-series analysis and visualization
show query plans of all currently running SQL statements
Kernel statistics gathering
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.
An extension collecting statistics about quals
track plan statistics of all SQL statements executed
Track settings changes
Track planning decisions in comparison with execution reality
sampling based statistics of wait events
Observability and activity monitoring extension for PostgreSQL
active session history
EnterpriseDB system statistics for PostgreSQL
Normalized, friendlier system catalog for PostgreSQL
Capture node OS metrics via SQL queries
PostgreSQL extension to access the OS process table
Provide SQL interface to logs
Small PostgreSQL background worker to report whether a node is a replication master or standby
show memory usage
show details on toasted datums
easily jump into a visual plan UI for any SQL query
Log all the queries that reference a particular column
Visualise database pages in ascii code
PostgreSQL Workload Analyser-core
Allow EXPLAIN to dump even more details
Logical decoding components inspection
inspect the contents of database pages at a low level
show row-level locking information
information about SSL certificates
examine the shared buffer cache
functions to inspect contents of PostgreSQL Write-Ahead Log
examine the free space map (FSM)
examine the visibility map (VM) and page-level visibility info
show tuple-level statistics
Provides a means for logging execution plans of slow statements automatically
track planning and execution statistics of all SQL statements executed
Strengthen PostgreSQL user password checks with cracklib
Extension that secures a cluster on a cloud environment
Postgres extension for libsodium functions
Transparent column-level encryption with encrypted_text and encrypted_bytea types
Dynamically configurable PostgreSQL password complexity checks.
Supabase Vault Extension
Manage authentication sessions using JWTs
PostgreSQL Anonymizer (anon) extension
PostgreSQL SM Algorithm Extension
Encrypted postgres data type
provides auditing functionality
pgAudit addon to redirect audit log to an independent file
Opinionated PostgreSQL database auditor
Audit data changes and provide flashback ability
Function for collecting statistics about messages in logfile
monitor connection attempts per user
Extension for logging and monitoring functions in PostgreSQL
OAuth and OIDC token validator for PostgreSQL 18
PostgreSQL 18 OIDC bearer-token validator plugin written in Rust
Transaction-based audit trail with schema versioning
credcheck - postgresql plain text credential checker
cryptographic key management
Advanced password hashing methods for PostgreSQL
login_hook - hook to execute login_hook.login() at login time
similar to SET ROLE but with added logging
The PostgreSQL Antivirus
PostgreSQL Extension Whitelisting
DDL and utility command firewall for PostgreSQL
A Postgres extension for managing SSL certificates through SQL
Module for blocking SET variables for non-super users.
Block COPY commands via a configurable ProcessUtility hook
Agentic policy language for PostgreSQL with guardrails, guidance, and session-aware controls
Reject full partition scans that omit the partition key
Percona pg_tde access method
Transparent Data Encryption for PostgreSQL through custom table and index access methods
label-based mandatory access control (MAC) based on SELinux security policy.
pause briefly before reporting authentication failure
cryptographic functions
checks user passwords and reject weak password
Foreign data wrappers developed by Supabase
Fetch foreign data in Python in your PostgreSQL server.
Foreign data wrapper for accessing remote databases using ODBC
foreign-data wrapper for remote servers available over JDBC
foreign-data wrapper for remote PGSpider servers
Foreign data wrapper for querying a MySQL server
foreign data wrapper for Oracle access
Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
foreign data wrapper for DB2 access
SQLite Foreign Data Wrapper
Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
Foreign data wrapper for etcd
Foreign data wrapper for Informix access
Nominatim Foreign Data Wrapper for PostgreSQL
foreign data wrapper for MongoDB access
Foreign data wrapper for querying a Redis server
Send redis pub/sub messages to Redis from PostgreSQL Directly
kafka Foreign Data Wrapper for CSV formatted messages
foreign-data wrapper for remote hdfs servers
Foreign data wrapper for Firebird
Foreign data wrapper for RDF triplestores over SPARQL endpoints
aws_s3 postgres extension to import/export data from/to s3
foreign-data wrapper for Postgres log file access
connect to other PostgreSQL databases from within a database
foreign-data wrapper for flat file access
foreign-data wrapper for remote PostgreSQL servers
API surface for DocumentDB for PostgreSQL
Core API surface for DocumentDB on PostgreSQL
Multi-Node API surface for DocumentDB
DocumentDB Extended RUM index access method
MongoDB-like read projections for JSONB in PostgreSQL
Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
Extension to add Global Temporary Tables feature to PostgreSQL
Registration and manipulation of session variables and constants
Server side rollback at statement level for PostgreSQL like Oracle or DB2
Oracle Compatible extension on Postgres Database
Support for indexing oracle datatypes in GIN
Support for oracle indexing common datatypes in GiST
Get function’s definition
PL/iSQL procedural language
Support GB18030-2022 and UTF-8 conversion
DB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL.
Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source.
Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL
Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.
Oracle UTL_SMTP compatibility extension for PostgreSQL
SQL Server Transact SQL Datatype Support
SQL Server Transact SQL compatibility
SQL Server TDS protocol extension
SQL Server Money Data Type
Redis-like In-Memory DB Embedded in Postgres
memcached interface
MySQL Supplementary Extension
PostgreSQL Logical Replication
Dummy extension for compatibility when upgrading from Postgres 9.4
Have an accurate view on pglogical replication delay
automated ddl deployment using pglogical
Replicate supported DDL changes over PostgreSQL logical replication
PG Failover Slots extension
Tools to migrate other databases to PostgreSQL
Active-Active Replication Extension for PostgreSQL
Multi-master logical replication extension for PostgreSQL
Logical-replication-friendly replacement for PostgreSQL large objects
Clone PostgreSQL databases, schemas, tables, and functions across environments
CDC-to-MQTT broker for PostgreSQL
Changing data capture in JSON format
PostgreSQL logical decoding output plugin for MongoDB
Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
Output plugin for logical replication in Raw SQL format
Extension for specialized, per-table replication between PostgreSQL instances
Replication manager for PostgreSQL
build fact tables with Postgres
pg_bulkload is a high speed data loading utility for PostgreSQL
SQL-based test/example module for WAL logical decoding
Logical Replication output plugin