Search PostgreSQL documentation

ANALYZESQL CommandsReferenceANALYZE Maintenance 10 collect statistics about a database ANALYZE [ VERBOSE ] [ table_name [ ( column_name [, ...] ) ] ] ANALYZE collects statistics about the contents of tables in the data…SQL Commands · Maintenance ANALYZE Progress ReportingManual ChaptersPG1827.4.1. ANALYZE Progress Reporting Whenever ANALYZE is running, the pg_stat_progress_analyze view will contain a row for each backend that is currently running that command. The tables below…ANALYZE Progress Reporting anonExtensionsExtensionsPostgreSQL Anonymizer (anon) extension pgrx pg_anon SecuritySecurity · Extensions Anonymous Code BlocksManual ChaptersPG1844.4. Anonymous Code Blocks PL/Python also supports anonymous code blocks called with the DO statement: DO $$ # PL/Python code $$ LANGUAGE plpython3u; An anonymous code block receives no arg…Anonymous Code Blocks ansilo_pgxExtensionsExtensionsA Postgres interface into any database data-engineering data-mesh data-products data-virtualization pgrx postgresql-extension rust sql-med ansilo_pgx Foreign data wrappersForeign data wrappers · Extensions Anti-FeaturesManual ChaptersPG1817.3.3.3. Anti-Features The options described in this section allow disabling certain PostgreSQL features that are built by default, but which might need to be turned off if the required sof…Anti-Features Anti-FeaturesManual ChaptersPG1817.4.3.3. Anti-Features -Dreadline={ auto | enabled | disabled } # Allows use of the Readline library (and libedit as well). This option defaults to auto and enables command-line editing and…Anti-Features anyData TypesPG18any Indicates that a function accepts any input data type.Pseudo-Types ANYSQL CommandsPG189.25.3. ANY/SOME (array) # expression operator ANY (array expression) expression operator SOME (array expression) The right-hand side is a parenthesized expression, which must yield an array…Row and Array Comparisons › ANY/SOME (array) ANY/SOMEManual ChaptersPG189.24.4. ANY/SOME expression operator ANY (subquery) expression operator SOME (subquery) The right-hand side is a parenthesized subquery, which must return exactly one column. The left-hand e…ANY/SOME ANY/SOME (array)Manual ChaptersPG189.25.3. ANY/SOME (array) expression operator ANY (array expression) expression operator SOME (array expression) The right-hand side is a parenthesized expression, which must yield an array v…ANY/SOME (array) any_valueFunctionsReferenceany_value Aggregate Functions 16 Returns an arbitrary value from the non-null input values. any_value ( anyelement ) → same as input type Returns an arbitrary value from the non-null input v…Functions · Aggregate Functions anyarrayData TypesPG18anyarray Indicates that a function accepts any array data type (see Section 36.2.5).Pseudo-Types anycompatibleData TypesPG18anycompatible Indicates that a function accepts any data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5).Pseudo-Types anycompatiblearrayData TypesPG18anycompatiblearray Indicates that a function accepts any array data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5).Pseudo-Types anycompatiblemultirangeData TypesPG18anycompatiblemultirange Indicates that a function accepts any multirange data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5 and Section 8.17)…Pseudo-Types anycompatiblenonarrayData TypesPG18anycompatiblenonarray Indicates that a function accepts any non-array data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5).Pseudo-Types anycompatiblerangeData TypesPG18anycompatiblerange Indicates that a function accepts any range data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5 and Section 8.17).Pseudo-Types anyelementData TypesPG18anyelement Indicates that a function accepts any data type (see Section 36.2.5).Pseudo-Types anyenumData TypesPG18anyenum Indicates that a function accepts any enum data type (see Section 36.2.5 and Section 8.7).Pseudo-Types anymultirangeData TypesPG18anymultirange Indicates that a function accepts any multirange data type (see Section 36.2.5 and Section 8.17).Pseudo-Types anynonarrayData TypesPG18anynonarray Indicates that a function accepts any non-array data type (see Section 36.2.5).Pseudo-Types anyrangeData TypesPG18anyrange Indicates that a function accepts any range data type (see Section 36.2.5 and Section 8.17).Pseudo-Types apg_plan_mgmtExtensionsExtensionsAmazon Aurora PostgreSQL Query Plan Management extension for managed plan baselines. aurora plan-management query-plan apg_plan_mgmt AdministrationAdministration · Extensions apgccExtensionsExtensionsNo-longer-supported internal RDS/Aurora PostgreSQL extension listed for older Aurora PostgreSQL 9.6 releases. aurora aws internal apgcc MonitoringMonitoring · Extensions apgunitExtensionsExtensionsNo-longer-supported internal RDS/Aurora PostgreSQL extension listed for older Aurora PostgreSQL 9.6 releases. aws internal apgunit AdministrationAdministration · Extensions API CompatibilityManual ChaptersPG1836.10.6.2. API Compatibility The API, or application programming interface, is the interface used at compile time.API Compatibility append_only_heapExtensionsExtensionsPostgreSQL table access method that avoids fragmentation of variable-length append-only data. append-only table-access-method append_only_heap FeaturesFeatures · Extensions AppendixManual ChaptersPG1841.13.3. Appendix This section contains the code for a set of Oracle-compatible instr functions that you can use to simplify your porting efforts. -- -- instr functions that mimic Oracle's c…Appendix AppendixesManual ChaptersPG18Part VIII. AppendixesAppendixes AppendReadyWait EventsReferenceAppendReady IPC 14 Waiting for subplan nodes of an Append plan node to be ready. 15 16 17 18 19 20 Brief rendezvous is normal when every participant continues to advance. Investigate when th…Wait Events · IPC applicable_rolesManual ChaptersPG1835.5. applicable_roles The view applicable_roles identifies all roles whose privileges the current user can use. This means there is some chain of role grants from the current user to the ro…applicable_roles Application of Multiple PoliciesManual ChaptersPG18Application of Multiple Policies When multiple policies of different command types apply to the same command (for example, SELECT and UPDATE policies applied to an UPDATE command), then the …Application of Multiple Policies application_nameCommand-line ToolsPG18application_name Specifies a value for the application_name configuration parameter.Database Connection Control Functions › Parameter Key Words application_nameConfigurationReferenceapplication_name Reporting and Logging 10 The application_name can be any string of less than NAMEDATALEN characters (64 characters in a standard build). It is typically set by an applicatio…Configuration · Reporting and Logging applytransactionWait EventsReferenceapplytransaction Lock 16 Waiting to acquire a lock on a remote transaction being applied by a logical replication subscriber. 17 18 19 20 Sub-second handoff during ordinary writes or planned…Wait Events · Lock approx_countExtensionsExtensionsFast approximate row counts for tables and indexes in PostgreSQL 14+ from pg class.reltuples, with a governed ANALYZE refresh approx_count Functions and aggregatesFunctions and aggregates · Extensions aqoExtensionsExtensionsAdaptive query optimization extension using execution statistics to improve cardinality estimation. adaptive-query-optimization cardinality-estimation machine-learning aqo FeaturesFeatures · Extensions aquaExtensionsExtensionsIn-database neural user-defined functions for machine-learning inference. aqua AI and vectorsAI and vectors · Extensions Arbitrary Precision NumbersManual ChaptersPG188.1.2. Arbitrary Precision Numbers The type numeric can store numbers with a very large number of digits. It is especially recommended for storing monetary amounts and other quantities where…Arbitrary Precision Numbers