Search PostgreSQL documentation

permuteFunctionsPG18permute ( i, size [, seed ] ) → integer Permuted value of i, in the range [0, size). This is the new position of i (modulo size) in a pseudorandom permutation of the integers 0...size-1, par…pgbench › Notes › Built-In Functions permuteseqExtensionsExtensionsPseudo-randomly permute sequences with a format-preserving encryption on elements permuteseq Functions and aggregatesFunctions and aggregates · Extensions PerSessionDSAWait EventsReferencePerSessionDSA LWLock 13 Waiting for parallel query dynamic shared memory allocation. 14 15 16 17 18 19 20 A brief sample is normal around short internal critical sections. Investigate when t…Wait Events · LWLock PerSessionRecordTypeWait EventsReferencePerSessionRecordType LWLock 13 Waiting to access a parallel query's information about composite types. 14 15 16 17 18 19 20 A brief sample is normal around short internal critical sections. …Wait Events · LWLock PerSessionRecordTypmodWait EventsReferencePerSessionRecordTypmod LWLock 13 Waiting to access a parallel query's information about type modifiers that identify anonymous record types. 14 15 16 17 18 19 20 A brief sample is normal aro…Wait Events · LWLock PerXactPredicateListWait EventsReferencePerXactPredicateList LWLock 12 Waiting to perform an operation on a serializable transaction in a parallel query. 13 Waiting to access the list of predicate locks held by the current seriali…Wait Events · LWLock pg-audit-jsonExtensionsExtensionsTrigger-based PostgreSQL table auditing with JSONB row snapshots and recursive change diffs. audit jsonb trigger pg-audit-json SecuritySecurity · Extensions pg-gvmExtensionsExtensionsFunctions for GVMd pg-gvm UtilitiesUtilities · Extensions pg-jsonExtensionsExtensionsA json data type and related functions pg-json Data typesData types · Extensions pg2podgExtensionsExtensionsPostgreSQL extension for two-player open deterministic games. game pg2podg FeaturesFeatures · Extensions pg4mlExtensionsExtensionsMachine learning framework for PostgreSQL pg4ml AI and vectorsAI and vectors · Extensions pg_aaExtensionsExtensionsASCII art extension for PostgreSQL pg_aa Functions and aggregatesFunctions and aggregates · Extensions pg_abrisExtensionsExtensionsAbris metadata extension that creates a meta schema with metadata tables, views, and helper functions. metadata pg_abris FeaturesFeatures · Extensions pg_acExtensionsExtensionsPostgreSQL extension for full text search aho-corasick full-text-search postgresql postgresql-extension sql pg_ac Full-text searchFull-text search · Extensions pg_acceExtensionsExtensionspg_acce -- Accelerated Engine background-worker pg_acce AnalyticsAnalytics · Extensions pg_accumulatorExtensionsExtensionsAccumulation registers for balance and turnover tracking in PostgreSQL accounting finance ledger aggregation pg_accumulator Functions and aggregatesFunctions and aggregates · Extensions pg_aclExtensionsExtensionsUtilities for handling aclitems. acl aclitem grant permissions revoke pg_acl Data typesData types · Extensions pg_ad_mappingExtensionsExtensionsMaps Active Directory security groups to database roles on Aurora PostgreSQL. pg_ad_mapping SecuritySecurity · Extensions pg_addressExtensionsExtensionsExtension creates composite type to store address address composite-type pg_address Data typesData types · Extensions pg_admExtensionsExtensionsA PostgreSQL extension providing some administrative tools. bloat disk sizes maintenance management reports statistics pg_adm AdministrationAdministration · Extensions pg_advisory_lockFunctionsReferencepg_advisory_lock System Administration Functions 10 Obtain exclusive session level advisory lock pg_advisory_lock ( key bigint ) → void Obtain exclusive session level advisory lock pg_adviso…Functions · System Administration Functions pg_advisory_lock_sharedFunctionsReferencepg_advisory_lock_shared System Administration Functions 10 Obtain shared session level advisory lock pg_advisory_lock_shared ( key bigint ) → void Obtain shared session level advisory lock p…Functions · System Administration Functions pg_advisory_unlockFunctionsReferencepg_advisory_unlock System Administration Functions 10 Release an exclusive session level advisory lock pg_advisory_unlock ( key bigint ) → boolean Release an exclusive session level advisory…Functions · System Administration Functions pg_advisory_unlock_allFunctionsReferencepg_advisory_unlock_all System Administration Functions 10 Release all session level advisory locks held by the current session pg_advisory_unlock_all ( ) → void Release all session level adv…Functions · System Administration Functions pg_advisory_unlock_sharedFunctionsReferencepg_advisory_unlock_shared System Administration Functions 10 Release a shared session level advisory lock pg_advisory_unlock_shared ( key bigint ) → boolean Release a shared session level ad…Functions · System Administration Functions pg_advisory_xact_lockFunctionsReferencepg_advisory_xact_lock System Administration Functions 10 Obtain exclusive transaction level advisory lock pg_advisory_xact_lock ( key bigint ) → void Obtain exclusive transaction level advis…Functions · System Administration Functions pg_advisory_xact_lock_sharedFunctionsReferencepg_advisory_xact_lock_shared System Administration Functions 10 Obtain shared transaction level advisory lock pg_advisory_xact_lock_shared ( key bigint ) → void Obtain shared transaction lev…Functions · System Administration Functions pg_aggExtensionsExtensionsExperimental aggregate-query support extension; its install script currently creates the untrusted PL/Python language. aggregate index plpython3u pg_agg Procedural languagesProcedural languages · Extensions pg_aggregateManual ChaptersPG1852.2. pg_aggregate The catalog pg_aggregate stores information about aggregate functions. An aggregate function is a function that operates on a set of values (typically one column from each…pg_aggregate pg_aggregateCatalogs & ViewsReferencepg_aggregate System catalogs 10 The catalog pg_aggregate stores information about aggregate functions. An aggregate function is a function that operates on a set of values (typically one col…System Catalogs · System catalogs pg_aiExtensionsExtensionsPostgreSQL extension that provides (RAG capable)SQL functions to interpret data using multi modal LLMs and vectors. pg_ai AI and vectorsAI and vectors · Extensions pg_ai_queryExtensionsExtensionsAI-powered SQL query generation for PostgreSQL pg_ai_query FeaturesFeatures · Extensions pg_ai_sdkExtensionsExtensionsTranslate natural language to SQL using Clickhouse ai-sdk-cpp pg_ai_sdk AI and vectorsAI and vectors · Extensions pg_ai_stewardsExtensionsExtensionsPostgreSQL-backed agent state, work queues and model dispatch agents queues pgrx pg-ai-stewards AI and vectorsAI and vectors · Extensions pg_aiosManual ChaptersPG1853.2. pg_aios The pg_aios view lists all Asynchronous I/O handles that are currently in-use. An I/O handle is used to reference an I/O operation that is being prepared, executed or is in the…pg_aios pg_aiosCatalogs & ViewsReferencepg_aios System views 18 The pg_aios view lists all Asynchronous I/O handles that are currently in-use. An I/O handle is used to reference an I/O operation that is being prepared, executed or…System Catalogs · System views pg_algorandExtensionsExtensionsAlgorand address, application, asset, transaction, and checksum encoding utilities. algorand encoding address blockchain pg_algorand UtilitiesUtilities · Extensions pg_algorithmsExtensionsExtensionsC extension that adds example algorithm functions, including bubble sort and quicksort for integer arrays. algorithm sort pg_algorithms Functions and aggregatesFunctions and aggregates · Extensions pg_amManual ChaptersPG1852.3. pg_am The catalog pg_am stores information about relation access methods. There is one row for each access method supported by the system. Currently, only tables and indexes have acces…pg_am pg_amCatalogs & ViewsReferencepg_am System catalogs 10 The catalog pg_am stores information about relation access methods. There is one row for each access method supported by the system. Currently, only indexes have acc…System Catalogs · System catalogs