Search PostgreSQL documentation

pg_sequencesManual ChaptersPG18The view pg_sequences provides access to useful information about each sequence in the database. Table 53.24. pg_sequences Columns Column Type Description schemaname name (references pg_name… pg_session_jwtExtensionsExtensionsSecurity · ExtensionsManage authentication sessions using JWTs pgrx pg_session_jwt Security pg_session_statsExtensionsExtensionsMonitoring · ExtensionsRecords 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 Monitoring pg_session_traceExtensionsExtensionsMonitoring · ExtensionsTrace session SQL, bind variables, execution plans, and timing metrics bind-variables query-plan session-tracing pg_session_trace Monitoring pg_sessionsExtensionsExtensionsMonitoring · ExtensionsTracks per-session SQL execution metrics and optional Linux process resource statistics in shared memory. monitoring query-statistics session-history shared-preload pg_sessions Monitoring pg_set_aclExtensionsExtensionsSecurity · ExtensionsSET command access control list access control list acl c postgresql postgresql-extension privilege set pg_set_acl Security pg_set_levelExtensionsExtensionsAdministration · Extensionstrigger action for SET statement c info, log, notice, warning, error, fatal postgresql postgresql-extension set statement pg_set_level Administration pg_setpriorityExtensionsExtensionsAdministration · ExtensionsGet or change Unix scheduling priority for PostgreSQL processes process-priority resource-control unix pg_setpriority Administration pg_settingsManual ChaptersPG18The view pg_settings provides access to run-time parameters of the server. It is essentially an alternative interface to the SHOW and SET commands. It also provides access to some facts abou… pg_sexpExtensionsExtensionsData types · ExtensionsAdds a compact S-expression type with parsing, list operations, matching, containment, and hash/GIN indexing. data-type gin-index s-expression pg_sexp Data types pg_sexp_rsExtensionsExtensionsData types · ExtensionsPostgreSQL extension to add support for s-expressions store, query, index. pg_sexp_rs Data types pg_shadowManual ChaptersPG18The view pg_shadow exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before version 8.1. It shows properties of all roles that are marked as rolcanlogin in… pg_shardExtensionsExtensionsAnalytics · ExtensionsShard and replicate PostgreSQL tables across remote servers cluster distribution failover replication scale sharding pg_shard Analytics pg_shardmanExtensionsExtensionsAnalytics · ExtensionsManages PostgreSQL 10 hash-sharded tables across nodes using pg_pathman, postgres_fdw, and logical replication. logical-replication pg_pathman postgres_fdw sharding pg_shardman Analytics pg_shared_plansExtensionsExtensionsFeatures · ExtensionsProof-of-concept shared-memory execution-plan cache for PostgreSQL plan-cache query-planning shared-memory pg_shared_plans Features pg_shdependManual ChaptersPG18The catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles. This information allows PostgreSQL to ensure that those objects are u… pg_shdescriptionManual ChaptersPG18The catalog pg_shdescription stores optional descriptions (comments) for shared database objects. Descriptions can be manipulated with the COMMENT command and viewed with psql's \d commands.… pg_sheet_fdwExtensionsExtensionsForeign data wrappers · ExtensionsRead local Excel XLSX worksheets as PostgreSQL foreign tables excel fdw xlsx pg_sheet_fdw Foreign data wrappers pg_shmem_allocationsManual ChaptersPG18The pg_shmem_allocations view shows allocations made from the server's main shared memory segment. This includes both memory allocated by PostgreSQL itself and memory allocated by extensions… pg_shmem_allocations_numaManual ChaptersPG18The pg_shmem_allocations_numa shows how shared memory allocations in the server's main shared memory segment are distributed across NUMA nodes. This includes both memory allocated by Postgre… pg_shmemvizExtensionsExtensionsMonitoring · ExtensionsCapture shared-memory snapshots for offline structural visualization shared-memory debugging visualization pg_shmemviz Monitoring pg_show_plansExtensionsExtensionsMonitoring · Extensionsshow query plans of all currently running SQL statements pg_show_plans Monitoring pg_show_vmExtensionsExtensionsAdministration · Extensionspg show vm displays the visibility map data for a specified relation, including its corresponding indexes and partitions. pg_show_vm Administration pg_shseclabelManual ChaptersPG18The catalog pg_shseclabel stores security labels on shared database objects. Security labels can be manipulated with the SECURITY LABEL command. For an easier way to view security labels, se… pg_simdjsonExtensionsExtensionsUtilities · ExtensionsPrototype SIMD-accelerated parser that converts JSON text to jsonb json jsonb parser simd pg_simdjson Utilities pg_similarityExtensionsExtensionsAI and vectors · Extensionssupport similarity queries pg_similarity AI and vectors pg_simulaExtensionsExtensionsFeatures · ExtensionsInject WAIT, ERROR, FATAL, or PANIC failures into PostgreSQL operations failure-injection testing pg_simula Features pg_siose_benchExtensionsExtensionsFeatures · ExtensionsA PostgreSQL extension for benchmarking different SIOSE database configurations (pure relational, with indexes, json, jsonb, xml, etc)) pg_siose_bench Features pg_sipExtensionsExtensionsUtilities · ExtensionsEarly-stage SIP extension exposing only a library version helper protocol sip pg_sip Utilities pg_sirenExtensionsExtensionsData types · ExtensionsValidated French SIREN and SIRET identifier types with B-tree and hash index support. pg_siren Data types pg_slug_genExtensionsExtensionsFunctions and aggregates · ExtensionsGenerate cryptographically secure timestamp-based slugs pg_slug_gen Functions and aggregates pg_slugifyExtensionsExtensionsFunctions and aggregates · ExtensionsNormalize text into URL-friendly slugs with unaccent slug text-normalization unaccent pg_slugify Functions and aggregates pg_smazExtensionsExtensionsData types · ExtensionsSmaz-compressed text type with length and raw-byte accessors. pg_smaz Data types pg_smolidExtensionsExtensionsData types · ExtensionsA Postgres pgrx extension adding smolid type and helper functions. btree hash identifier pgrx pg_smolid Data types pg_smtp_clientExtensionsExtensionsUtilities · ExtensionsPostgreSQL extension to send email using SMTP pgrx pg_smtp_client Utilities pg_snakeoilExtensionsExtensionsSecurity · ExtensionsThe PostgreSQL Antivirus pg_snakeoil Security pg_snapshotData TypesPG18Data Typesuser-level transaction ID snapshot pg_snowflake_idExtensionsExtensionsFunctions and aggregates · ExtensionsSnowflake-style 64-bit ID generator for PostgreSQL implemented with pgrx id-generator pgrx snowflake pg_snowflake_id Functions and aggregates pg_snowidExtensionsExtensionsFunctions and aggregates · ExtensionsGenerate thread-safe, time-sorted Snowflake-like IDs in PostgreSQL pgrx pg_snowid Functions and aggregates pg_sorted_heapExtensionsExtensionsAnalytics · ExtensionsSorted heap table AM with zone map scan pruning and built-in vector search pg_sorted_heap Analytics