Search PostgreSQL documentation

pg_session_statsExtensionsExtensionsRecords per-session and parallel-worker CPU, process status, and I/O data into an external SQLite database. observability resource-usage session-statistics pg_session_stats MonitoringMonitoring · Extensions pg_session_traceExtensionsExtensionsTrace session SQL, bind variables, execution plans, and timing metrics bind-variables query-plan session-tracing pg_session_trace MonitoringMonitoring · Extensions pg_sessionsExtensionsExtensionsTracks per-session SQL execution metrics and optional Linux process resource statistics in shared memory. monitoring query-statistics session-history shared-preload pg_sessions MonitoringMonitoring · Extensions pg_set_aclExtensionsExtensionsSET command access control list access control list acl c postgresql postgresql-extension privilege set pg_set_acl SecuritySecurity · Extensions pg_set_levelExtensionsExtensionstrigger action for SET statement c info, log, notice, warning, error, fatal postgresql postgresql-extension set statement pg_set_level AdministrationAdministration · Extensions pg_setpriorityExtensionsExtensionsGet or change Unix scheduling priority for PostgreSQL processes process-priority resource-control unix pg_setpriority AdministrationAdministration · Extensions pg_sexpExtensionsExtensionsAdds a compact S-expression type with parsing, list operations, matching, containment, and hash/GIN indexing. data-type gin-index s-expression pg_sexp Data typesData types · Extensions pg_sexp_rsExtensionsExtensionsPostgreSQL extension to add support for s-expressions store, query, index. pg_sexp_rs Data typesData types · Extensions pg_shardExtensionsExtensionsShard and replicate PostgreSQL tables across remote servers cluster distribution failover replication scale sharding pg_shard AnalyticsAnalytics · Extensions pg_shardmanExtensionsExtensionsManages PostgreSQL 10 hash-sharded tables across nodes using pg_pathman, postgres_fdw, and logical replication. logical-replication pg_pathman postgres_fdw sharding pg_shardman AnalyticsAnalytics · Extensions pg_shared_plansExtensionsExtensionsProof-of-concept shared-memory execution-plan cache for PostgreSQL plan-cache query-planning shared-memory pg_shared_plans FeaturesFeatures · Extensions pg_sheet_fdwExtensionsExtensionsRead local Excel XLSX worksheets as PostgreSQL foreign tables excel fdw xlsx pg_sheet_fdw Foreign data wrappersForeign data wrappers · Extensions pg_shmemvizExtensionsExtensionsCapture shared-memory snapshots for offline structural visualization shared-memory debugging visualization pg_shmemviz MonitoringMonitoring · Extensions pg_show_plansExtensionsExtensionsshow query plans of all currently running SQL statements pg_show_plans MonitoringMonitoring · Extensions pg_show_vmExtensionsExtensionspg show vm displays the visibility map data for a specified relation, including its corresponding indexes and partitions. pg_show_vm AdministrationAdministration · Extensions pg_simdjsonExtensionsExtensionsPrototype SIMD-accelerated parser that converts JSON text to jsonb json jsonb parser simd pg_simdjson UtilitiesUtilities · Extensions pg_similarityExtensionsExtensionssupport similarity queries pg_similarity AI and vectorsAI and vectors · Extensions pg_simulaExtensionsExtensionsInject WAIT, ERROR, FATAL, or PANIC failures into PostgreSQL operations failure-injection testing pg_simula FeaturesFeatures · Extensions pg_siose_benchExtensionsExtensionsA PostgreSQL extension for benchmarking different SIOSE database configurations (pure relational, with indexes, json, jsonb, xml, etc)) pg_siose_bench FeaturesFeatures · Extensions pg_sipExtensionsExtensionsEarly-stage SIP extension exposing only a library version helper protocol sip pg_sip UtilitiesUtilities · Extensions pg_sirenExtensionsExtensionsValidated French SIREN and SIRET identifier types with B-tree and hash index support. pg_siren Data typesData types · Extensions pg_slug_genExtensionsExtensionsGenerate cryptographically secure timestamp-based slugs pg_slug_gen Functions and aggregatesFunctions and aggregates · Extensions pg_slugifyExtensionsExtensionsNormalize text into URL-friendly slugs with unaccent slug text-normalization unaccent pg_slugify Functions and aggregatesFunctions and aggregates · Extensions pg_smazExtensionsExtensionsSmaz-compressed text type with length and raw-byte accessors. pg_smaz Data typesData types · Extensions pg_smolidExtensionsExtensionsA Postgres pgrx extension adding smolid type and helper functions. btree hash identifier pgrx pg_smolid Data typesData types · Extensions pg_smtp_clientExtensionsExtensionsPostgreSQL extension to send email using SMTP pgrx pg_smtp_client UtilitiesUtilities · Extensions pg_snakeoilExtensionsExtensionsThe PostgreSQL Antivirus pg_snakeoil SecuritySecurity · Extensions pg_snowflake_idExtensionsExtensionsSnowflake-style 64-bit ID generator for PostgreSQL implemented with pgrx id-generator pgrx snowflake pg_snowflake_id Functions and aggregatesFunctions and aggregates · Extensions pg_snowidExtensionsExtensionsGenerate thread-safe, time-sorted Snowflake-like IDs in PostgreSQL pgrx pg_snowid Functions and aggregatesFunctions and aggregates · Extensions pg_sorted_heapExtensionsExtensionsSorted heap table AM with zone map scan pruning and built-in vector search pg_sorted_heap AnalyticsAnalytics · Extensions pg_sortstatsExtensionsExtensionsCollect per-query sort statistics and estimate required work_mem sort statistics work_mem pg_sortstats MonitoringMonitoring · Extensions pg_sphereExtensionsExtensionsspherical objects with useful functions, operators and index support pgsphere Data typesData types · Extensions pg_spiExtensionsExtensionsFailing test case for SPI rollback pg_spi FeaturesFeatures · Extensions pg_spladeExtensionsExtensionsGenerate SPLADE sparse-vector embeddings inside PostgreSQL embedding pgrx sparse-vector splade pg_splade AI and vectorsAI and vectors · Extensions pg_sqidsExtensionsExtensionsEncode numbers as short URL-safe Sqids and decode them in PostgreSQL id-encoding link-shortening pgrx sqids pg_sqids Functions and aggregatesFunctions and aggregates · Extensions pg_sqlite_fsExtensionsExtensionsSQLite File System creation pg_sqlite_fs UtilitiesUtilities · Extensions pg_sqlogExtensionsExtensionsProvide SQL interface to logs pg_sqlog MonitoringMonitoring · Extensions pg_squeezeExtensionsExtensionsA tool to remove unused space from a relation. pg_squeeze AdministrationAdministration · Extensions pg_sshExtensionsExtensionsRun remote commands over SSH from PostgreSQL (libssh2; in-memory private-key auth) pgrx rust pg_ssh UtilitiesUtilities · Extensions pg_sslExtensionsExtensionsCreate base64-encoded PKCS#7 signatures from PEM certificates and private keys in PostgreSQL pkcs7 signing ssl pg_ssl SecuritySecurity · Extensions