Search PostgreSQL documentation

pg_stat_xact_all_tablesCatalogs & ViewsReferencepg_stat_xact_all_tables Statistics views 10 A transaction can also see its own statistics (as yet untransmitted to the collector) in the views pg_stat_xact_all_tables, pg_stat_xact_sys_table…System Catalogs · Statistics views pg_stat_xact_sys_tablesCatalogs & ViewsReferencepg_stat_xact_sys_tables Statistics views 10 A transaction can also see its own statistics (as yet untransmitted to the collector) in the views pg_stat_xact_all_tables, pg_stat_xact_sys_table…System Catalogs · Statistics views pg_stat_xact_user_functionsCatalogs & ViewsReferencepg_stat_xact_user_functions Statistics views 10 A transaction can also see its own statistics (as yet untransmitted to the collector) in the views pg_stat_xact_all_tables, pg_stat_xact_sys_t…System Catalogs · Statistics views pg_stat_xact_user_tablesCatalogs & ViewsReferencepg_stat_xact_user_tables Statistics views 10 A transaction can also see its own statistics (as yet untransmitted to the collector) in the views pg_stat_xact_all_tables, pg_stat_xact_sys_tabl…System Catalogs · Statistics views pg_statio_all_indexesCatalogs & ViewsReferencepg_statio_all_indexes Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, listed in…System Catalogs · Statistics views pg_statio_all_sequencesCatalogs & ViewsReferencepg_statio_all_sequences Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, listed …System Catalogs · Statistics views pg_statio_all_tablesCatalogs & ViewsReferencepg_statio_all_tables Statistics views 10 Several predefined views, listed in Table 28.1, are available to show the current state of the system. There are also several other views, listed in …System Catalogs · Statistics views pg_statio_sys_indexesCatalogs & ViewsReferencepg_statio_sys_indexes Statistics views 10 The pg_statio_all_indexes view will contain one row for each index in the current database, showing statistics about I/O on that specific index. The…System Catalogs · Statistics views pg_statio_sys_sequencesCatalogs & ViewsReferencepg_statio_sys_sequences Statistics views 10 Same as pg_statio_all_sequences, except that only system sequences are shown. (Presently, no system sequences are defined, so this view is always …System Catalogs · Statistics views pg_statio_sys_tablesCatalogs & ViewsReferencepg_statio_sys_tables Statistics views 10 The 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 t…System Catalogs · Statistics views pg_statio_user_indexesCatalogs & ViewsReferencepg_statio_user_indexes Statistics views 10 The pg_statio_all_indexes view will contain one row for each index in the current database, showing statistics about I/O on that specific index. Th…System Catalogs · Statistics views pg_statio_user_sequencesCatalogs & ViewsReferencepg_statio_user_sequences Statistics views 10 Same as pg_statio_all_sequences, except that only user sequences are shown. relid OID of a sequence schemaname Name of the schema this sequence i…System Catalogs · Statistics views pg_statio_user_tablesCatalogs & ViewsReferencepg_statio_user_tables Statistics views 10 The 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 …System Catalogs · Statistics views pg_statisticCatalogs & ViewsReferencepg_statistic System catalogs 10 The catalog pg_statistic stores statistical data about the contents of the database. Entries are created by ANALYZE and subsequently used by the query planner…System Catalogs · System catalogs pg_statistic_extCatalogs & ViewsReferencepg_statistic_ext System catalogs 10 The catalog pg_statistic_ext holds extended planner statistics. Each row in this catalog corresponds to a statistics object created with CREATE STATISTICS…System Catalogs · System catalogs pg_statistic_ext_dataCatalogs & ViewsReferencepg_statistic_ext_data System catalogs 12 The catalog pg_statistic_ext_data holds data for extended planner statistics defined in pg_statistic_ext. Each row in this catalog corresponds to a s…System Catalogs · System catalogs pg_statsCatalogs & ViewsReferencepg_stats System views 10 The 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 tabl…System Catalogs · System views pg_stats_extCatalogs & ViewsReferencepg_stats_ext System views 12 The view pg_stats_ext provides access to the information stored in the pg_statistic_ext and pg_statistic_ext_data catalogs. This view allows access only to rows …System Catalogs · System views pg_stats_ext_exprsCatalogs & ViewsReferencepg_stats_ext_exprs System views 14 The view pg_stats_ext_exprs provides access to information about all expressions included in extended statistics objects, combining information stored in t…System Catalogs · System views pg_subscriptionCatalogs & ViewsReferencepg_subscription System catalogs 10 The catalog pg_subscription contains all existing logical replication subscriptions. For more information about logical replication see Chapter 31. Unlike…System Catalogs · System catalogs pg_subscription_relCatalogs & ViewsReferencepg_subscription_rel System catalogs 10 The catalog pg_subscription_rel contains the state for each replicated relation in each subscription. This is a many-to-many mapping. This catalog onl…System Catalogs · System catalogs pg_tablesCatalogs & ViewsReferencepg_tables System views 10 The view pg_tables provides access to useful information about each table in the database. schemaname Name of schema containing table tablename Name of table tableo…System Catalogs · System views pg_tablespaceCatalogs & ViewsReferencepg_tablespace System catalogs 10 The catalog pg_tablespace stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration of disk la…System Catalogs · System catalogs pg_timezone_abbrevsCatalogs & ViewsReferencepg_timezone_abbrevs System views 10 The view pg_timezone_abbrevs provides a list of time zone abbreviations that are currently recognized by the datetime input routines. The contents of this…System Catalogs · System views pg_timezone_namesCatalogs & ViewsReferencepg_timezone_names System views 10 The view pg_timezone_names provides a list of time zone names that are recognized by SET TIMEZONE, along with their associated abbreviations, UTC offsets, a…System Catalogs · System views pg_transformCatalogs & ViewsReferencepg_transform System catalogs 10 The catalog pg_transform stores information about transforms, which are a mechanism to adapt data types to procedural languages. See CREATE TRANSFORM for more…System Catalogs · System catalogs pg_triggerCatalogs & ViewsReferencepg_trigger System catalogs 10 The catalog pg_trigger stores triggers on tables and views. See CREATE TRIGGER for more information. oid Row identifier (hidden attribute; must be explicitly se…System Catalogs · System catalogs pg_ts_configCatalogs & ViewsReferencepg_ts_config System catalogs 10 The pg_ts_config catalog contains entries representing text search configurations. A configuration specifies a particular text search parser and a list of dic…System Catalogs · System catalogs pg_ts_config_mapCatalogs & ViewsReferencepg_ts_config_map System catalogs 10 The pg_ts_config_map catalog contains entries showing which text search dictionaries should be consulted, and in what order, for each output token type of…System Catalogs · System catalogs pg_ts_dictCatalogs & ViewsReferencepg_ts_dict System catalogs 10 The pg_ts_dict catalog contains entries defining text search dictionaries. A dictionary depends on a text search template, which specifies all the implementatio…System Catalogs · System catalogs pg_ts_parserCatalogs & ViewsReferencepg_ts_parser System catalogs 10 The pg_ts_parser catalog contains entries defining text search parsers. A parser is responsible for splitting input text into lexemes and assigning a token ty…System Catalogs · System catalogs pg_ts_templateCatalogs & ViewsReferencepg_ts_template System catalogs 10 The pg_ts_template catalog contains entries defining text search templates. A template is the implementation skeleton for a class of text search dictionarie…System Catalogs · System catalogs pg_typeCatalogs & ViewsReferencepg_type System catalogs 10 The catalog pg_type stores information about data types. Base types and enum types (scalar types) are created with CREATE TYPE, and domains with CREATE DOMAIN. A c…System Catalogs · System catalogs pg_userCatalogs & ViewsReferencepg_user System views 10 The view pg_user provides access to information about database users. This is simply a publicly readable view of pg_shadow that blanks out the password field. usename…System Catalogs · System views pg_user_mappingCatalogs & ViewsReferencepg_user_mapping System catalogs 10 The catalog pg_user_mapping stores the mappings from local user to remote. Access to this catalog is restricted from normal users, use the view pg_user_map…System Catalogs · System catalogs pg_user_mappingsCatalogs & ViewsReferencepg_user_mappings System views 10 The view pg_user_mappings provides access to information about user mappings. This is essentially a publicly readable view of pg_user_mapping that leaves out…System Catalogs · System views pg_viewsCatalogs & ViewsReferencepg_views System views 10 The view pg_views provides access to useful information about each view in the database. schemaname Name of schema containing view viewname Name of view viewowner Na…System Catalogs · System views pg_wait_eventsCatalogs & ViewsReferencepg_wait_events System views 17 The view pg_wait_events provides description about the wait events. type Wait event type name Wait event name description Wait event description 18 19 20System Catalogs · System views