Search PostgreSQL documentation

pg_sortstatsExtensionsExtensionsMonitoring · ExtensionsCollect per-query sort statistics and estimate required work_mem sort statistics work_mem pg_sortstats Monitoring pg_sphereExtensionsExtensionsData types · Extensionsspherical objects with useful functions, operators and index support pgsphere Data types pg_spiExtensionsExtensionsFeatures · ExtensionsFailing test case for SPI rollback pg_spi Features pg_spladeExtensionsExtensionsAI and vectors · ExtensionsGenerate SPLADE sparse-vector embeddings inside PostgreSQL embedding pgrx sparse-vector splade pg_splade AI and vectors pg_sqidsExtensionsExtensionsFunctions and aggregates · ExtensionsEncode numbers as short URL-safe Sqids and decode them in PostgreSQL id-encoding link-shortening pgrx sqids pg_sqids Functions and aggregates pg_sqlite_fsExtensionsExtensionsUtilities · ExtensionsSQLite File System creation pg_sqlite_fs Utilities pg_sqlogExtensionsExtensionsMonitoring · ExtensionsProvide SQL interface to logs pg_sqlog Monitoring pg_squeezeExtensionsExtensionsAdministration · ExtensionsA tool to remove unused space from a relation. pg_squeeze Administration pg_sshExtensionsExtensionsUtilities · ExtensionsRun remote commands over SSH from PostgreSQL (libssh2; in-memory private-key auth) pgrx rust pg_ssh Utilities pg_sslExtensionsExtensionsSecurity · ExtensionsCreate base64-encoded PKCS#7 signatures from PEM certificates and private keys in PostgreSQL pkcs7 signing ssl pg_ssl Security pg_sslstatusExtensionsExtensionsMonitoring · ExtensionsHistorical SSL connection-status views for PostgreSQL releases before 9.5. ssl tls connection monitoring pg_sslstatus Monitoring pg_start_sqlExtensionsExtensionsAdministration · Extensionsruns SQL statement at instance start c configuration postgresql postgresql-extension start pg_start_sql Administration pg_stash_adviceExtensionsExtensionsAdministration · ExtensionsStore plan advice by query ID and automatically apply it during PostgreSQL query planning plan-advice planner query-id shared-memory postgresql Administration pg_stat_activityManual ChaptersPG18The Cumulative Statistics SystemThe pg_stat_activity view will have one row per server process, showing information related to the current activity of that process. Table 27.3. pg_stat_activity View Column Type Description… pg_stat_all_indexesManual ChaptersPG18The Cumulative Statistics SystemThe pg_stat_all_indexes view will contain one row for each index in the current database, showing statistics about accesses to that specific index. The pg_stat_user_indexes and pg_stat_sys_i… pg_stat_all_tablesManual ChaptersPG18The Cumulative Statistics SystemThe pg_stat_all_tables view will contain one row for each table in the current database (including TOAST tables), showing statistics about accesses to that specific table. The pg_stat_user_t… pg_stat_archiverManual ChaptersPG18The Cumulative Statistics SystemThe pg_stat_archiver view will always have a single row, containing data about the archiver process of the cluster. Table 27.22. pg_stat_archiver View Column Type Description archived_count … pg_stat_backtraceExtensionsExtensionsMonitoring · ExtensionsCapture or log C-level stack backtraces of PostgreSQL processes pg_stat_backtrace Monitoring pg_stat_bgwriterManual ChaptersPG18The Cumulative Statistics SystemThe pg_stat_bgwriter view will always have a single row, containing data about the background writer of the cluster. Table 27.24. pg_stat_bgwriter View Column Type Description buffers_clean … pg_stat_chExtensionsExtensionsMonitoring · ExtensionsExport PostgreSQL query telemetry to ClickHouse pg_stat_ch Monitoring pg_stat_checkpointerManual ChaptersPG18The Cumulative Statistics SystemThe pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster. Table 27.25. pg_stat_checkpointer View Column Type Description num… pg_stat_clear_snapshotFunctionsPG18The Cumulative Statistics System › Statistics Functions() → void Discards the current statistics snapshot or cached information. pg_stat_cluster_activityExtensionsExtensionsMonitoring · Extensionstrack execution statistics in whole cluster scope pg_stat_cluster_activity Monitoring pg_stat_connExtensionsExtensionsMonitoring · ExtensionsCumulative connection, disconnection, and authentication-failure counts by database and role. connection authentication statistics monitoring pg_stat_conn Monitoring pg_stat_databaseManual ChaptersPG18The Cumulative Statistics SystemThe pg_stat_database view will contain one row for each database in the cluster, plus one for shared objects, showing database-wide statistics. Table 27.27. pg_stat_database View Column Type… pg_stat_database_conflictsManual ChaptersPG18The Cumulative Statistics SystemThe pg_stat_database_conflicts view will contain one row per database, showing database-wide statistics about query cancels occurring due to conflicts with recovery on standby servers. This … pg_stat_errorExtensionsExtensionsMonitoring · ExtensionsTencentDB provider-managed error statistics extension; version 1.0 is currently listed for PostgreSQL 10-13. error-statistics monitoring pg_stat_error Monitoring pg_stat_errorsExtensionsExtensionsMonitoring · ExtensionsCluster-wide error-class counters with a bounded sample of recent errors. error statistics monitoring shared-memory pg_stat_errors Monitoring pg_stat_get_activityFunctionsPG18The Cumulative Statistics System › Statistics Functions( integer ) → setof record Returns a record of information about the backend with the specified process ID, or one record for each active backend in the system if NULL is specified. The fiel… pg_stat_get_backend_activityFunctionsPG18The Cumulative Statistics System › Statistics Functions( integer ) → text Returns the text of this backend's most recent query. pg_stat_get_backend_activity_startFunctionsPG18The Cumulative Statistics System › Statistics Functions( integer ) → timestamp with time zone Returns the time when the backend's most recent query was started. pg_stat_get_backend_client_addrFunctionsPG18The Cumulative Statistics System › Statistics Functions( integer ) → inet Returns the IP address of the client connected to this backend. pg_stat_get_backend_client_portFunctionsPG18The Cumulative Statistics System › Statistics Functions( integer ) → integer Returns the TCP port number that the client is using for communication. pg_stat_get_backend_dbidFunctionsPG18The Cumulative Statistics System › Statistics Functions( integer ) → oid Returns the OID of the database this backend is connected to. pg_stat_get_backend_idsetFunctionsPG18The Cumulative Statistics System › Statistics Functions() → setof integer Returns the set of currently active backend ID numbers. pg_stat_get_backend_ioFunctionsPG18The Cumulative Statistics System › Statistics Functions( integer ) → setof record Returns I/O statistics about the backend with the specified process ID. The output fields are exactly the same as the ones in the pg_stat_io view. The function doe… pg_stat_get_backend_pidFunctionsPG18The Cumulative Statistics System › Statistics Functions( integer ) → integer Returns the process ID of this backend. pg_stat_get_backend_startFunctionsPG18The Cumulative Statistics System › Statistics Functions( integer ) → timestamp with time zone Returns the time when this process was started. pg_stat_get_backend_subxactFunctionsPG18The Cumulative Statistics System › Statistics Functions( integer ) → record Returns a record of information about the subtransactions of the backend with the specified ID. The fields returned are subxact_count, which is the number of subtransact… pg_stat_get_backend_useridFunctionsPG18The Cumulative Statistics System › Statistics Functions( integer ) → oid Returns the OID of the user logged into this backend.