Search PostgreSQL documentation

pg_sslstatusExtensionsExtensionsHistorical SSL connection-status views for PostgreSQL releases before 9.5. ssl tls connection monitoring pg_sslstatus MonitoringMonitoring · Extensions pg_start_sqlExtensionsExtensionsruns SQL statement at instance start c configuration postgresql postgresql-extension start pg_start_sql AdministrationAdministration · Extensions pg_stash_adviceExtensionsExtensionsStore plan advice by query ID and automatically apply it during PostgreSQL query planning plan-advice planner query-id shared-memory postgresql AdministrationAdministration · Extensions pg_stat_backtraceExtensionsExtensionsCapture or log C-level stack backtraces of PostgreSQL processes pg_stat_backtrace MonitoringMonitoring · Extensions pg_stat_chExtensionsExtensionsExport PostgreSQL query telemetry to ClickHouse pg_stat_ch MonitoringMonitoring · Extensions pg_stat_cluster_activityExtensionsExtensionstrack execution statistics in whole cluster scope pg_stat_cluster_activity MonitoringMonitoring · Extensions pg_stat_connExtensionsExtensionsCumulative connection, disconnection, and authentication-failure counts by database and role. connection authentication statistics monitoring pg_stat_conn MonitoringMonitoring · Extensions pg_stat_errorExtensionsExtensionsTencentDB provider-managed error statistics extension; version 1.0 is currently listed for PostgreSQL 10-13. error-statistics monitoring pg_stat_error MonitoringMonitoring · Extensions pg_stat_errorsExtensionsExtensionsCluster-wide error-class counters with a bounded sample of recent errors. error statistics monitoring shared-memory pg_stat_errors MonitoringMonitoring · Extensions pg_stat_insightsExtensionsExtensionsQuery planning/execution statistics with replication, index, trend, and contention analysis. query statistics performance monitoring pg_stat_insights MonitoringMonitoring · Extensions pg_stat_kcacheExtensionsExtensionsKernel statistics gathering pg_stat_kcache MonitoringMonitoring · Extensions pg_stat_logExtensionsExtensionsTrack cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE. pg_stat_log MonitoringMonitoring · Extensions pg_stat_monitorExtensionsExtensionsThe pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client informati…Monitoring · Extensions pg_stat_plansExtensionsExtensionsTrack per-plan call counts, execution times, and example EXPLAIN texts. pg_stat_plans MonitoringMonitoring · Extensions pg_stat_sql_plansExtensionsExtensionsTrack execution statistics by normalized SQL query and plan ID. pg_stat_statements plan-stats query-stats shared-preload pg_stat_sql_plans MonitoringMonitoring · Extensions pg_stat_ssi_failuresExtensionsExtensionsCluster-wide counter for PostgreSQL SSI serialization failures. monitoring serialization-failures shared-preload ssi ssi_failures MonitoringMonitoring · Extensions pg_stat_statementsExtensionsPG18F.32. pg_stat_statements — track statistics of SQL planning and execution The pg_stat_statements module provides a means for tracking planning and execution statistics of all SQL statements …pg_stat_statements — track statistics of SQL planning and execution pg_stat_statements2ExtensionsExtensionsTrack SQL execution statistics using a PostgreSQL 9.4 pg_stat_statements derivative integrated with sql_firewall query-statistics sql-firewall statistics pg_stat_statements2 MonitoringMonitoring · Extensions pg_stat_sysinfoExtensionsExtensionsQuery host load, CPU, memory, swap, and disk statistics from PostgreSQL, with optional shared-memory caching. monitoring pgrx system-statistics pg_stat_sysinfo MonitoringMonitoring · Extensions pg_stat_usageExtensionsExtensionstrack usage statistics of stored procedure calls pg_stat_usage MonitoringMonitoring · Extensions pg_statement_rollbackExtensionsExtensionsServer side rollback at statement level for PostgreSQL like Oracle or DB2 oracle pg_statement_rollback CompatibilityCompatibility · Extensions pg_statkitExtensionsExtensionsDescriptive statistics and clinical effect-size functions over arrays. statistics clinical effect-size arrays pg_statkit Functions and aggregatesFunctions and aggregates · Extensions pg_statsExtensionsExtensionsCustomized statistics views pg_stats MonitoringMonitoring · Extensions pg_statvizExtensionsExtensionsCapture PostgreSQL statistics snapshots for time-series analysis and visualization monitoring statistics snapshot time-series visualization pg_statviz MonitoringMonitoring · Extensions pg_stlExtensionsExtensionsTime series analysis functions for PostgreSQL pg_stl Time seriesTime series · Extensions pg_store_plansExtensionsExtensionstrack plan statistics of all SQL statements executed pg_store_plans MonitoringMonitoring · Extensions pg_strExtensionsExtensionsAdd Laravel-inspired string manipulation functions to PostgreSQL using pgrx pgrx string text pg_str Functions and aggregatesFunctions and aggregates · Extensions pg_streamingExtensionsExtensionsDeclarative stream processing engine inside PostgreSQL pgrx pg_streaming Replication and streamsReplication and streams · Extensions pg_strictExtensionsExtensionsPrevent dangerous UPDATE and DELETE without WHERE clause pgrx pg_strict AdministrationAdministration · Extensions pg_string_extensionExtensionsExtensionsC string helpers for palindrome checks, anagram checks, and character sorting. anagram palindrome string-functions pg_string_extension Functions and aggregatesFunctions and aggregates · Extensions pg_stromExtensionsExtensionsPG-Strom - big-data processing acceleration using GPU and NVME non-free pg_strom AnalyticsAnalytics · Extensions pg_strverscmpExtensionsExtensionsNatural-sort comparison functions, text operators, and a btree operator class based on a strverscmp-like order. hack postgresql sorting-algorithms pg_strverscmp Functions and aggregatesFunctions and aggregates · Extensions pg_substraitExtensionsExtensionsExecute Substrait protobuf or JSON query plans through PostgreSQL functions pgrx query-plan substrait pg_substrait AnalyticsAnalytics · Extensions pg_subtrans_infosExtensionsExtensionsInspect PostgreSQL subtransaction status, parent XIDs, nesting level, and commit timestamps. subtransactions transactions xid pg_subtrans_infos AdministrationAdministration · Extensions pg_subxact_countersExtensionsExtensionsGlobal counters for PostgreSQL subtransaction activity monitoring shared-preload subtransactions pg_subxact_counters MonitoringMonitoring · Extensions pg_sulogExtensionsExtensionsPostgreSQL superuser operation logging and blocking extension pg_sulog SecuritySecurity · Extensions pg_summarizeExtensionsExtensionsText Summarization using LLMs. Built using pgrx pgrx nil-lic pg_summarize AI and vectorsAI and vectors · Extensions pg_surgeryExtensionsPG18F.34. pg_surgery — perform low-level surgery on relation data The pg_surgery module provides various functions to perform surgery on a damaged relation. These functions are unsafe by design …pg_surgery — perform low-level surgery on relation data pg_sweepExtensionsExtensionsCollect PostgreSQL database and table statistics as JSON for monitoring. monitoring pgrx statistics pg_sweep MonitoringMonitoring · Extensions pg_synapse_pgrxExtensionsExtensionspg synapse: Postgres-native agent-loop runtime pgrx rust pg_synapse_pgrx AI and vectorsAI and vectors · Extensions