Search PostgreSQL documentation

pg_statio_all_tablesManual ChaptersPG18The Cumulative Statistics SystemThe pg_statio_all_tables view will contain one row for each table in the current database (including TOAST tables), showing statistics about I/O on that specific table. The pg_statio_user_ta… pg_statisticManual ChaptersPG18The catalog pg_statistic stores statistical data about the contents of the database. Entries are created by ANALYZE and subsequently used by the query planner. Note that all the statistical … pg_statistic_extManual ChaptersPG18The catalog pg_statistic_ext holds definitions of extended planner statistics. Each row in this catalog corresponds to a statistics object created with CREATE STATISTICS. Table 52.52. pg_sta… pg_statistic_ext_dataManual ChaptersPG18The catalog pg_statistic_ext_data holds data for extended planner statistics defined in pg_statistic_ext. Each row in this catalog corresponds to a statistics object created with CREATE STAT… pg_statkitExtensionsExtensionsFunctions and aggregates · ExtensionsDescriptive statistics and clinical effect-size functions over arrays. statistics clinical effect-size arrays pg_statkit Functions and aggregates pg_statsManual ChaptersPG18The view pg_stats provides access to the information stored in the pg_statistic catalog. This view allows access only to rows of pg_statistic that correspond to tables the user has permissio… pg_statsExtensionsExtensionsMonitoring · ExtensionsCustomized statistics views pg_stats Monitoring pg_stats_extManual ChaptersPG18The view pg_stats_ext provides access to information about each extended statistics object in the database, combining information stored in the pg_statistic_ext and pg_statistic_ext_data cat… pg_stats_ext_exprsManual ChaptersPG18The view pg_stats_ext_exprs provides access to information about all expressions included in extended statistics objects, combining information stored in the pg_statistic_ext and pg_statisti… pg_statvfsExtensionsExtensionsMonitoring · ExtensionsExpose server filesystem capacity and inode statistics through statvfs filesystem monitoring pg_statvfs Monitoring pg_statvizExtensionsExtensionsMonitoring · ExtensionsCapture PostgreSQL statistics snapshots for time-series analysis and visualization monitoring statistics snapshot time-series visualization pg_statviz Monitoring pg_stlExtensionsExtensionsTime series · ExtensionsTime series analysis functions for PostgreSQL pg_stl Time series pg_store_plansExtensionsExtensionsMonitoring · Extensionstrack plan statistics of all SQL statements executed pg_store_plans Monitoring pg_strExtensionsExtensionsFunctions and aggregates · ExtensionsAdd Laravel-inspired string manipulation functions to PostgreSQL using pgrx pgrx string text pg_str Functions and aggregates pg_streamingExtensionsExtensionsReplication and streams · ExtensionsDeclarative stream processing engine inside PostgreSQL pgrx pg_extensions Replication and streams pg_strictExtensionsExtensionsAdministration · ExtensionsPrevent dangerous UPDATE and DELETE without WHERE clause pgrx pg_strict Administration pg_string_extensionExtensionsExtensionsFunctions and aggregates · ExtensionsC string helpers for palindrome checks, anagram checks, and character sorting. anagram palindrome string-functions pg_string_extension Functions and aggregates pg_stromExtensionsExtensionsAnalytics · ExtensionsPG-Strom - big-data processing acceleration using GPU and NVME non-free pg_strom Analytics pg_strverscmpExtensionsExtensionsFunctions and aggregates · ExtensionsNatural-sort comparison functions, text operators, and a btree operator class based on a strverscmp-like order. hack postgresql sorting-algorithms pg_strverscmp Functions and aggregates pg_subscriptionManual ChaptersPG18The catalog pg_subscription contains all existing logical replication subscriptions. For more information about logical replication see Chapter 29. Unlike most system catalogs, pg_subscripti… pg_subscription_relManual ChaptersPG18The catalog pg_subscription_rel contains the state for each replicated relation in each subscription. This is a many-to-many mapping. This catalog only contains tables known to the subscript… pg_substraitExtensionsExtensionsAnalytics · ExtensionsExecute Substrait protobuf or JSON query plans through PostgreSQL functions pgrx query-plan substrait pg_substrait Analytics pg_subtrans_infosExtensionsExtensionsAdministration · ExtensionsInspect PostgreSQL subtransaction status, parent XIDs, nesting level, and commit timestamps. subtransactions transactions xid pg_subtrans_infos Administration pg_subxact_countersExtensionsExtensionsMonitoring · ExtensionsGlobal counters for PostgreSQL subtransaction activity monitoring shared-preload subtransactions pg_subxact_counters Monitoring pg_sulogExtensionsExtensionsSecurity · ExtensionsPostgreSQL superuser operation logging and blocking extension pg_sulog Security pg_summarizeExtensionsExtensionsAI and vectors · ExtensionsText Summarization using LLMs. Built using pgrx pgrx nil-lic pg_summarize AI and vectors pg_surgeryExtensionsPG18pg_surgery — perform low-level surgery on relation dataperform 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 and using them may … pg_surgery — perform low-level surgery on relation dataManual ChaptersPG18The pg_surgery module provides various functions to perform surgery on a damaged relation. These functions are unsafe by design and using them may corrupt (or further corrupt) your database.… pg_swarmExtensionsExtensionsFeatures · ExtensionsBackground-worker task scheduling with SQL executors. pgrx proof-of-concept pg_extensions Features pg_sweepExtensionsExtensionsMonitoring · ExtensionsCollect PostgreSQL database and table statistics as JSON for monitoring. monitoring pgrx statistics pg_sweep Monitoring pg_synapse_pgrxExtensionsExtensionsAI and vectors · Extensionspg synapse: Postgres-native agent-loop runtime pgrx rust pg_synapse_pgrx AI and vectors pg_synthesize_walExtensionsExtensionsFeatures · ExtensionsGenerate PostgreSQL WAL records of various sizes development shared-preload testing wal pg_synthesize_wal Features pg_sysdatetimeExtensionsExtensionsCompatibility · ExtensionsHigh-precision SQL Server-style system datetime functions for PostgreSQL, mainly useful on older Windows builds. pg_sysdatetime Compatibility pg_sysloadExtensionsExtensionsMonitoring · ExtensionsExpose Linux system load averages from PostgreSQL linux pgrx system-monitoring pg_sysload Monitoring pg_taExtensionsExtensionsFunctions and aggregates · ExtensionsTA-Lib technical-analysis functions exposed as PostgreSQL functions finance technical-analysis pg_ta Functions and aggregates pg_table_bloatExtensionsExtensionsAdministration · ExtensionsPostgreSQL extension that estimates table bloat from pg class + pg stats — no pgstattuple required pg_table_bloat Administration pg_table_rangeExtensionsExtensionsAnalytics · ExtensionsPlanning-time partition pruning by per-partition data ranges, including non-key columns. brin partitioning pgrx planner postgis pg_table_range Analytics pg_tablesManual ChaptersPG18The view pg_tables provides access to useful information about each table in the database. Table 53.32. pg_tables Columns Column Type Description schemaname name (references pg_namespace.nsp… pg_tablespaceManual ChaptersPG18The catalog pg_tablespace stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration of disk layout. Unlike most system catalogs… pg_tamagotchiExtensionsExtensionsFeatures · ExtensionsA pet for your postgres db postgres postgresql-extension tamagotchi pg_tamagotchi Features