扩展目录

PostgreSQL 扩展目录包含了 504 个扩展和 357 个包。

扩展统计

分类	All	PGDG	PIGSTY	CONTRIB	MISS	PG18	PG17	PG16	PG15	PG14
ALL	504	155	332	71	0	481	488	479	473	457
EL	499	150	332	71	5	472	482	474	468	452
Debian	489	107	311	71	15	466	474	464	458	442

扩展包统计

※ 一个扩展软件包可能同时包含多个 PG 扩展，因此按软件包统计的数量会少于扩展数量。

分类	All	PGDG	PIGSTY	CONTRIB	MISS	PG18	PG17	PG16	PG15	PG14
ALL	357	139	271	0	0	339	350	342	337	327
EL	355	137	271	0	63	334	347	340	335	325
Debian	342	92	250	0	76	324	336	327	322	312

分类

类别	扩展
ADMIN	pg_repack pg_rewrite pg_query_rewrite pg_squeeze pg_dirtyread pgfincore pg_cooldown ddlx pglinter prioritize pg_checksums pg_readonly pgdd pg_permissions pgautofailover pg_catcheck pre_prepare pg_upless pgcozy pg_orphaned pg_crash pg_cheat_funcs fio qos pg_savior safeupdate pg_strict pg_drop_events table_log pgelog pgagent pg_prewarm pgpool_adm pgpool_recovery pgpool_regclass lo basic_archive basebackup_to_shell old_snapshot adminpack amcheck pg_surgery
ETL	pglogical pglogical_origin pglogical_ticker pgl_ddl_deploy logical_ddl pg_failover_slots db_migrator pgactive spock lolor pgclone pgmqtt wal2json wal2mongo decoderbufs decoder_raw mimeo repmgr pg_fact_loader pg_bulkload test_decoding pgoutput
FDW	wrappers multicorn odbc_fdw jdbc_fdw pgspider_ext mysql_fdw oracle_fdw tds_fdw db2_fdw sqlite_fdw pgbouncer_fdw etcd_fdw informix_fdw nominatim_fdw mongo_fdw redis_fdw redis kafka_fdw hdfs_fdw firebird_fdw rdf_fdw aws_s3 log_fdw dblink file_fdw postgres_fdw
FEAT	age pg_liquid hll rum pg_ai_query pg_ttl_index pg_graphql pg_jsonschema jsquery pg_hint_plan hypopg index_advisor plan_filter pg_variables imgsmlr pg_ivm pg_incremental pg_trickle pgmb pgmq pgq provsql orioledb pg_cardano rdkit omni omni_auth omni_aws omni_cloudevents omni_containers omni_credentials omni_csv omni_datasets omni_email omni_http omni_httpc omni_httpd omni_id omni_json omni_kube omni_ledger omni_manifest omni_mimetypes omni_os omni_polyfill omni_python omni_regex omni_rest omni_schema omni_seq omni_service omni_session omni_shmem omni_sql omni_sqlite omni_test omni_txn omni_types omni_var omni_vfs omni_vfs_types_v1 omni_web omni_worker omni_xml omni_yaml onesparse bloom
FTS	pg_search pgroonga pgroonga_database pg_bigm zhparser pg_bestmatch vchord_bm25 pg_tokenizer biscuit pg_textsearch pg_pinyin pg_kazsearch hunspell_cs_cz hunspell_de_de hunspell_en_us hunspell_fr hunspell_ne_np hunspell_nl_nl hunspell_nn_no hunspell_pt_pt hunspell_ru_ru hunspell_ru_ru_aot fuzzystrmatch pg_trgm
FUNC	pg_idkit pgx_ulid pg_uuidv7 permuteseq pg_hashids pg_slug_gen sequential_uuids typeid snowflake topn quantile lower_quantile count_distinct omnisketch ddsketch vasco xicor weighted_statistics datasketches tdigest first_last_agg extra_window_functions floatvec aggs_for_vecs aggs_for_arrays pg_csv arraymath pg_math random base36 base62 pg_base58 financial convert parray_gin refint autoinc insert_username moddatetime tsm_system_time dict_xsyn tsm_system_rows tcn uuid-ossp btree_gist btree_gin intarray intagg dict_int unaccent
GIS	postgis postgis_topology postgis_raster postgis_sfcgal postgis_tiger_geocoder address_standardizer address_standardizer_data_us pgrouting pointcloud pointcloud_postgis h3 h3_postgis q3c ogr_fdw geoip pg_polyline pg_eviltransform pg_geohash pghydro pgh_raster pgh_hgm pgh_output pgh_output_en_au pgh_output_pt_br pgh_consistency mobilitydb mobilitydb_datagen tzf earthdistance
LANG	pg_tle plv8 pljs pllua hstore_pllua plluau hstore_plluau plprql pldbgapi plpgsql_check plprofiler plsh pljava plr plxslt pgtap faker dbt2 pg_regresql pltcl pltclu plperl bool_plperl hstore_plperl jsonb_plperl plperlu bool_plperlu jsonb_plperlu hstore_plperlu plpgsql plpython3u jsonb_plpython3u ltree_plpython3u hstore_plpython3u
OLAP	citus citus_columnar columnar pg_analytics pg_duckdb pg_mooncake pg_clickhouse duckdb_fdw pg_parquet pg_fkpart pg_partman plproxy pg_strom tablefunc
RAG	vector vchord vectorscale vectorize pg_similarity pg_rrf smlar pg_summarize pg_tiktoken pg4ml pgml
SEC	passwordcheck_cracklib supautils pgsodium column_encrypt supabase_vault pg_session_jwt anon pgsmcrypto pg_enigma pgaudit pgauditlogtofile pg_auditor logerrors pg_auth_mon pg_jobmon credcheck pgcryptokey pg_pwhash login_hook set_user pg_snakeoil pgextwlist pg_command_fw block_copy_command sslutils noset pg_tde sepgsql auth_delay pgcrypto passwordcheck
SIM	documentdb documentdb_core documentdb_distributed documentdb_extended_rum orafce pgtt session_variable pg_statement_rollback ivorysql_ora ora_btree_gin ora_btree_gist pg_get_functiondef plisql gb18030_2022 pg_dbms_metadata pg_dbms_lock pg_dbms_job pg_dbms_errlog pg_utl_smtp babelfishpg_common babelfishpg_tsql babelfishpg_tds babelfishpg_money spat pgmemcache aux_mysql
STAT	pg_profile pg_tracing pg_stat_ch pg_show_plans pg_stat_kcache pg_stat_monitor pg_qualstats pg_store_plans pg_track_settings pg_track_optimizer pg_wait_sampling pg_datasentinel pgsentinel system_stats meta pgnodemx pg_proctab pg_sqlog bgw_replstatus pgmeminfo toastinfo explain_ui pg_relusage pagevis powa pg_overexplain pg_logicalinspect pageinspect pgrowlocks sslinfo pg_buffercache pg_walinspect pg_freespacemap pg_visibility pgstattuple auto_explain pg_stat_statements
TIME	timescaledb timescaledb_toolkit timeseries periods temporal_tables emaj table_version pg_cron pg_task pg_later pg_dispatch pg_background pg_when
TYPE	prefix semver pg_text_semver unit pgpdf pglite_fusion md5hash asn1oid roaringbitmap pgfaceting pg_sphere country pg_xenophile l10n_table_dependent_extension currency collection pgmp numeral pg_rational uint uint128 hashtypes ip4r pg_duration uri emailaddr acl debversion pg_rrule pgcalendar timestamp9 pgbson chkpass isn seg cube ltree hstore citext xml2
UTIL	gzip bzip zstd http pg_net pg_curl pg_retry pg_fsql pg_protobuf pgproto pglock pgjq pgjwt pg_smtp_client pg_html5_email_address url_encode pgsql_tweaks pg_extra_time pgpcre icu_ext pgqr envvar byteamagic floatfile external_file pg_render pg_readme pg_readme_test_extension ddl_historization data_historization schedoc pg_isok hashlib xxhash shacrypt cryptint pguecc sparql