Search PostgreSQL documentation

pg_overexplainExtensionsPG18F.29. pg_overexplain — allow EXPLAIN to dump even more details The pg_overexplain module extends EXPLAIN with new options that provide additional output. It is mostly intended to assist with…pg_overexplain — allow EXPLAIN to dump even more details pg_pageindexExtensionsExtensionsPageIndex document-tree construction and tree search for PDF and Markdown through a C/Go bridge. documents jsonb markdown pageindex pdf tree-search pg_pageindex AI and vectorsAI and vectors · Extensions pg_pageinspect_plusExtensionsExtensionsDecode heap tuple data obtained with PostgreSQL pageinspect helpers page-inspection storage tuple-decoding pg_pageinspect_plus AdministrationAdministration · Extensions pg_pageprepExtensionsExtensionsPrepares heap pages on PostgreSQL or Postgres Pro Standard for migration to the 64-bit-XID page format used by Postgres Pro Enterprise. pg_pageprep Replication and streamsReplication and streams · Extensions pg_paginationExtensionsExtensionsRust functions for cursor- and offset-based pagination with JSON results. pg_pagination Functions and aggregatesFunctions and aggregates · Extensions pg_parapetExtensionsExtensionsHooks that can require WHERE on UPDATE and DELETE and restrict TRUNCATE to superusers. pg_parapet AdministrationAdministration · Extensions pg_parquetExtensionsExtensionscopy data between Postgres and Parquet pgrx pg_parquet AnalyticsAnalytics · Extensions pg_partExtensionsExtensionsTable partitioning utility for PostgreSQL pg_part AnalyticsAnalytics · Extensions pg_particulousExtensionsExtensionsMigrate tables between vanilla PostgreSQL and pg_pathman partitioning migration partitioning pg_pathman pg_particulous AnalyticsAnalytics · Extensions pg_partitionExtensionsExtensionsGenerate and manage timestamp-based PostgreSQL table partitions partition partitioning schlepping pg_partition AnalyticsAnalytics · Extensions pg_partmanExtensionsExtensionsExtension to manage partitioned tables by time or ID pg_partman AnalyticsAnalytics · Extensions pg_pathcheckExtensionsExtensionsValidate planner Path trees for freed or corrupt memory pg_pathcheck AdministrationAdministration · Extensions pg_pathmanExtensionsExtensionsPartitioning tool for PostgreSQL pg_pathman AnalyticsAnalytics · Extensions pg_paxosExtensionsExtensionsPaxos distributed consensus functions and table replication for PostgreSQL cluster consensus failover paxos replication pg_paxos Replication and streamsReplication and streams · Extensions pg_permissionsExtensionsExtensionsview object permissions and compare them with the desired state pg_permissions AdministrationAdministration · Extensions pg_pgbouncerExtensionsExtensionsRuns and manages external PgBouncer processes from a PostgreSQL background worker through a pgrx extension. pgrx pg_pgbouncer AdministrationAdministration · Extensions pg_phashExtensionsExtensionsCalculate Hamming distance between decimal-encoded perceptual image hashes hamming-distance image perceptual-hash postgres_phash_hamming AI and vectorsAI and vectors · Extensions pg_phonenumberExtensionsExtensionsC++ libphonenumber-backed phone type, equality operators, and supported-region helpers google-libphonenumber libphonenumber phone phonenumber-validation postgresql-extension pg_phonenumber D…Data types · Extensions pg_pii_vaultExtensionsExtensionsPostgreSQL extension for GDPR-compliant column-level encryption using HashiCorp Vault Transit Engine. encryption gdpr hashicorp-vault pgrx pii pg_pii_vault SecuritySecurity · Extensions pg_pinyinExtensionsExtensionsPinyin romanization and search helpers for PostgreSQL pgrx pg_pinyin Full-text searchFull-text search · Extensions pg_plan_adviceExtensionsExtensionsDescribe and constrain planner choices with plan advice planner plan-advice postgresql FeaturesFeatures · Extensions pg_plan_advsrExtensionsExtensionsAutomated execution plan tuning extension pg_plan_advsr FeaturesFeatures · Extensions pg_plan_guardExtensionsExtensionsDetect drift from approved PostgreSQL 19 plan-advice baselines plan regression monitoring baseline advice postgresql-19 pg_plan_guard MonitoringMonitoring · Extensions pg_plan_tree_dotExtensionsExtensionsGraphviz DOT rendering of PostgreSQL execution-plan trees. explain graphviz plan visualization pg_plan_tree_dot MonitoringMonitoring · Extensions pg_plpgsql_extExtensionsExtensionsA PostgreSQL extension with a PL/pgSQL function to subtract numbers extension gsoc postgresql postgresql-extension procedural language subtraction tutorial pg_plpgsql_ext Functions and aggre…Functions and aggregates · Extensions pg_plsql_graphsExtensionsExtensionsCapture PL/pgSQL control-flow and dependence graphs for DOT export control-flow graphviz plpgsql profiling pg_plsql_graphs Procedural languagesProcedural languages · Extensions pg_policyExtensionsExtensionsAgentic policy language for PostgreSQL with guardrails, guidance, and session-aware controls security policy rls authorization ai agents guardrails mcp pg_policy SecuritySecurity · Extensions pg_polylineExtensionsExtensionsFast Google Encoded Polyline encoding & decoding for postgres pgrx pg_polyline GeospatialGeospatial · Extensions pg_popyramids_datamartsExtensionsExtensionsCreates population-pyramid analytics data-mart objects in a hard-coded dms schema from a pre-existing ods schema. geojson population-pyramids statistics pg_popyramids_datamarts AnalyticsAnalytics · Extensions pg_postal_code_caExtensionsExtensionsan efficient, validated, formatted Canadian postal code type btree canada postal-code type validation pg_postal_code_ca Data typesData types · Extensions pg_prewarmExtensionsPG18F.30. pg_prewarm — preload relation data into buffer caches The pg_prewarm module provides a convenient way to load relation data into either the operating system buffer cache or the Postgre…pg_prewarm — preload relation data into buffer caches pg_primalExtensionsExtensionsPrimal database extension used by the Primal Nostr cache server. pgrx pg_primal UtilitiesUtilities · Extensions pg_probExtensionsExtensionsProbabilistic data types for PostgreSQL - Monte Carlo simulation in SQL monte-carlo pgrx probability simulation statistics pg_prob Data typesData types · Extensions pg_probablepeopleExtensionsExtensionsCRF-based parsing of personal and organization names into structured components. ner name crf parser pg_probablepeople Full-text searchFull-text search · Extensions pg_procfsExtensionsExtensionsdisplays /proc data from SQL c postgresql postgresql-extension proc fs pg_procfs MonitoringMonitoring · Extensions pg_proctabExtensionsExtensionsPostgreSQL extension to access the OS process table pgnodemx MonitoringMonitoring · Extensions pg_profileExtensionsExtensionsPostgreSQL load profile repository and report builder pg_profile MonitoringMonitoring · Extensions pg_projectionExtensionsExtensionsMongoDB-like read projections for JSONB in PostgreSQL pg_projection CompatibilityCompatibility · Extensions pg_prometheusExtensionsExtensionsPrometheus metric sample type and helpers for PostgreSQL. pg_prometheus MonitoringMonitoring · Extensions pg_promise_guardExtensionsExtensionsCatalog-only checks for schema guarantees that are no longer enforced catalog integrity constraint index trigger rls pg_promise_guard AdministrationAdministration · Extensions