Search PostgreSQL documentation

pg_overexplainExtensionsPG18pg_overexplain — allow EXPLAIN to dump even more detailsallow 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 debugging of and devel… pg_overexplain — allow EXPLAIN to dump even more detailsManual ChaptersPG18The pg_overexplain module extends EXPLAIN with new options that provide additional output. It is mostly intended to assist with debugging of and development of the planner, rather than for g… pg_pageindexExtensionsExtensionsAI and vectors · ExtensionsPageIndex 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 vectors pg_pageinspect_plusExtensionsExtensionsAdministration · ExtensionsDecode heap tuple data obtained with PostgreSQL pageinspect helpers page-inspection storage tuple-decoding pg_pageinspect_plus Administration pg_pageprepExtensionsExtensionsReplication and streams · ExtensionsPrepares 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 streams pg_paginationExtensionsExtensionsFunctions and aggregates · ExtensionsRust functions for cursor- and offset-based pagination with JSON results. pg_pagination Functions and aggregates pg_parameter_aclManual ChaptersPG18The catalog pg_parameter_acl records configuration parameters for which privileges have been granted to one or more roles. No entry is made for parameters that have default privileges. Unlik… pg_parapetExtensionsExtensionsAdministration · ExtensionsHooks that can require WHERE on UPDATE and DELETE and restrict TRUNCATE to superusers. pg_parapet Administration pg_parquetExtensionsExtensionsAnalytics · Extensionscopy data between Postgres and Parquet pgrx pg_parquet Analytics pg_partExtensionsExtensionsAnalytics · ExtensionsTable partitioning utility for PostgreSQL pg_part Analytics pg_particulousExtensionsExtensionsAnalytics · ExtensionsMigrate tables between vanilla PostgreSQL and pg_pathman partitioning migration partitioning pg_pathman pg_particulous Analytics pg_partitionExtensionsExtensionsAnalytics · ExtensionsGenerate and manage timestamp-based PostgreSQL table partitions partition partitioning schlepping pg_partition Analytics pg_partitioned_tableManual ChaptersPG18The catalog pg_partitioned_table stores information about how tables are partitioned. Table 52.37. pg_partitioned_table Columns Column Type Description partrelid oid (references pg_class.oid… pg_partmanExtensionsExtensionsAnalytics · ExtensionsExtension to manage partitioned tables by time or ID pg_partman Analytics pg_pathcheckExtensionsExtensionsAdministration · ExtensionsValidate planner Path trees for freed or corrupt memory pg_pathcheck Administration pg_pathmanExtensionsExtensionsAnalytics · ExtensionsPartitioning tool for PostgreSQL pg_pathman Analytics pg_paxosExtensionsExtensionsReplication and streams · ExtensionsPaxos distributed consensus functions and table replication for PostgreSQL cluster consensus failover paxos replication pg_paxos Replication and streams pg_permissionsExtensionsExtensionsAdministration · Extensionsview object permissions and compare them with the desired state pg_permissions Administration pg_pgbouncerExtensionsExtensionsAdministration · ExtensionsRuns and manages external PgBouncer processes from a PostgreSQL background worker through a pgrx extension. pgrx pg_pgbouncer Administration pg_phashExtensionsExtensionsAI and vectors · ExtensionsCalculate Hamming distance between decimal-encoded perceptual image hashes hamming-distance image perceptual-hash postgres_phash_hamming AI and vectors pg_phonenumberExtensionsExtensionsData types · ExtensionsC++ libphonenumber-backed phone type, equality operators, and supported-region helpers google-libphonenumber libphonenumber phone phonenumber-validation postgresql-extension pg_phonenumber D… pg_pii_vaultExtensionsExtensionsSecurity · ExtensionsPostgreSQL extension for GDPR-compliant column-level encryption using HashiCorp Vault Transit Engine. encryption gdpr hashicorp-vault pgrx pii pg_pii_vault Security pg_pinyinExtensionsExtensionsFull-text search · ExtensionsPinyin romanization and search helpers for PostgreSQL pgrx pg_pinyin Full-text search pg_plan_adviceExtensionsExtensionsFeatures · ExtensionsDescribe and constrain planner choices with plan advice planner plan-advice postgresql Features pg_plan_advsrExtensionsExtensionsFeatures · ExtensionsAutomated execution plan tuning extension pg_plan_advsr Features pg_plan_guardExtensionsExtensionsMonitoring · ExtensionsDetect drift from approved PostgreSQL 19 plan-advice baselines plan regression monitoring baseline advice postgresql-19 pg_plan_guard Monitoring pg_plan_tree_dotExtensionsExtensionsMonitoring · ExtensionsGraphviz DOT rendering of PostgreSQL execution-plan trees. explain graphviz plan visualization pg_plan_tree_dot Monitoring pg_plpgsql_extExtensionsExtensionsFunctions and aggregates · ExtensionsA 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… pg_plsql_graphsExtensionsExtensionsProcedural languages · ExtensionsCapture PL/pgSQL control-flow and dependence graphs for DOT export control-flow graphviz plpgsql profiling pg_plsql_graphs Procedural languages pg_policiesManual ChaptersPG18The view pg_policies provides access to useful information about each row-level security policy in the database. Table 53.15. pg_policies Columns Column Type Description schemaname name (ref… pg_policyManual ChaptersPG18The catalog pg_policy stores row-level security policies for tables. A policy includes the kind of command that it applies to (possibly all commands), the roles that it applies to, the expre… pg_policyExtensionsExtensionsSecurity · ExtensionsAgentic policy language for PostgreSQL with guardrails, guidance, and session-aware controls security policy rls authorization ai agents guardrails mcp pg_policy Security pg_polylineExtensionsExtensionsGeospatial · ExtensionsFast Google Encoded Polyline encoding & decoding for postgres pgrx pg_polyline Geospatial pg_popyramids_datamartsExtensionsExtensionsAnalytics · ExtensionsCreates 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 Analytics pg_postal_code_caExtensionsExtensionsData types · Extensionsan efficient, validated, formatted Canadian postal code type btree canada postal-code type validation pg_postal_code_ca Data types pg_prepared_statementsManual ChaptersPG18The pg_prepared_statements view displays all the prepared statements that are available in the current session. See PREPARE for more information about prepared statements. pg_prepared_statem… pg_prepared_xactsManual ChaptersPG18The view pg_prepared_xacts displays information about transactions that are currently prepared for two-phase commit (see PREPARE TRANSACTION for details). pg_prepared_xacts contains one row … pg_prewarmExtensionsPG18pg_prewarm — preload relation data into buffer cachespreload 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 PostgreSQL buffer cache. P… pg_prewarm — preload relation data into buffer cachesManual ChaptersPG18The pg_prewarm module provides a convenient way to load relation data into either the operating system buffer cache or the PostgreSQL buffer cache. Prewarming can be performed manually using… pg_primalExtensionsExtensionsUtilities · ExtensionsPrimal database extension used by the Primal Nostr cache server. pgrx pg_primal Utilities