55.41. Global Views for Distributed System #
Postgres Pro Shardman has a list of global views based on the corresponding local views. The definition of global view columns is the same as in its corresponding local view. Fetching from a global view returns a union of rows from the corresponding local views. The rows are fetched from each of their cluster nodes. Another difference is that the global views have an added column rgid. The rgid value shows the replication group ID of the cluster node from which a row is fetched.
55.41.1. Global Views for Statistics #
Below is the list of the statistics-related global views with links to their corresponding local views:
Table 55.41. Statistics-related global and local views
| Global view | Local view | Description |
|---|---|---|
shardman.gv_stats | pg_stats | One row per planner statistics. |
shardman.gv_stats_ext | pg_stats_ext | Provides access to information about each extended statistics object in the database. |
shardman.gv_stats_ext_exprs | pg_stats_ext_exprs | Provides access to information about all expressions included in extended statistics objects. |
shardman.gv_stat_activity | pg_stat_activity | One row per server process, showing information related to the current activity of that process. |
shardman.gv_stats_vacuum_database | pg_stats_vacuum_database | One row for each index in the current database (including TOAST table indexes), showing statistics about vacuuming that specific index. |
shardman.gv_stats_vacuum_indexes | pg_stats_vacuum_indexes | One row for each database in the current cluster, showing statistics about vacuuming that database. |
shardman.gv_stats_vacuum_tables | pg_stats_vacuum_tables | One row for each table in the current database (including TOAST tables), showing statistics about vacuuming that specific table. |
shardman.gv_stat_replication | pg_stat_replication | One row per WAL sender process, showing statistics about replication to that sender's connected standby server. |
shardman.gv_stat_replication_slots | pg_stat_replication_slots | One row per replication slot, showing statistics about the replication slot's usage. |
shardman.gv_pgpro_stat_wal_activity | pgpro_stat_wal_activity | One row per server process, showing information related to the current activity of that process. |
shardman.gv_stat_subscription | pg_stat_subscription | One row per subscription for main worker (with null PID if the worker is not running), and additional rows for workers handling the initial data copy of the subscribed tables. |
shardman.gv_stat_subscription_stats | pg_stat_subscription_stats | One row per subscription. |
shardman.gv_stat_ssl | pg_stat_ssl | One row per backend or WAL sender process, showing statistics about SSL usage on this connection. |
shardman.gv_stat_gssapi | pg_stat_gssapi | One row per backend, showing information about GSSAPI usage on this connection. |
shardman.gv_stat_archiver | pg_stat_archiver | One row only, showing statistics about the WAL archiver process's activity. |
shardman.gv_stat_io | pg_stat_io | One row only for each combination of backend type, target I/O object, and I/O context, showing cluster-wide I/O statistics. |
shardman.gv_stat_bgwriter | pg_stat_bgwriter | One row only, showing statistics about the background writer process's activity. |
shardman.gv_stat_progress_analyze | pg_stat_progress_analyze | One row for each backend (including autovacuum worker processes) running ANALYZE, showing current progress. |
shardman.gv_stat_progress_basebackup | pg_stat_progress_basebackup | One row for each WAL sender process streaming a base backup, showing current progress. |
shardman.gv_stat_progress_cluster | pg_stat_progress_cluster | One row for each backend running CLUSTER or VACUUM FULL, showing current progress. |
shardman.gv_stat_checkpointer | pg_stat_checkpointer | One row only, containing data about the checkpointer process of the cluster. |
shardman.gv_statistic_ext | pg_statistic_ext | Extended planner statistics (definition). |
shardman.gv_stat_progress_create_index | pg_stat_progress_create_index | One row for each backend running CREATE INDEX or REINDEX, showing current progress. |
shardman.gv_stat_progress_vacuum | pg_stat_progress_vacuum | One row for each backend (including autovacuum worker processes) that is currently vacuuming |
shardman.gv_stat_progress_copy | pg_stat_progress_copy | One row for each backend running COPY, showing current progress. |
shardman.gv_stat_wal | pg_stat_wal | One row only, showing statistics about WAL activity. |
shardman.gv_stat_database | pg_stat_database | One row per database, showing database-wide statistics about query cancels due to conflict with recovery on standby servers. |
shardman.gv_stat_database_conflicts | pg_stat_database_conflicts | One row per database, showing database-wide statistics about query cancels occurring due to conflicts with recovery on standby servers. This view will only contain information on standby servers, since conflicts do not occur on primary servers. |
shardman.gv_stat_all_tables | pg_stat_all_tables | One row for each table in the current database, showing statistics about accesses to that specific table. |
shardman.gv_stat_sys_tables | pg_stat_sys_tables | Same as pg_stat_sys_tables, only as a global view. |
shardman.gv_stat_user_tables | pg_stat_user_tables | Same as pg_stat_user_tables, only as a global view. |
shardman.gv_stat_all_indexes | pg_stat_all_indexes | One row for each index in the current database, showing statistics about accesses to that specific index. |
shardman.gv_stat_sys_indexes | pg_stat_sys_indexes | Same as pg_stat_sys_indexes, only as a global view. |
shardman.gv_stat_user_indexes | pg_stat_user_indexes | Same as pg_stat_user_indexes, only as a global view. |
shardman.gv_statio_all_tables | pg_statio_all_tables | One row for each table in the current database, showing statistics about I/O on that specific table. |
shardman.gv_statio_sys_tables | pg_statio_sys_tables | Same as pg_statio_sys_tables, only as a global view. |
shardman.gv_statio_user_tables | pg_statio_user_tables | Same as pg_statio_user_tables, only as a global view. |
shardman.gv_statio_all_indexes | pg_statio_all_indexes | One row for each index in the current database, showing statistics about I/O on that specific index. |
shardman.gv_statio_sys_indexes | pg_statio_sys_indexes | Same as pg_statio_sys_indexes, only as a global view. |
shardman.gv_statio_user_indexes | pg_statio_user_indexes | Same as pg_statio_user_indexes, only as a global view. |
shardman.gv_statio_all_sequences | pg_statio_all_sequences | One row for each sequence in the current database, showing statistics about I/O on that specific sequence. |
shardman.gv_statio_sys_sequences | pg_statio_sys_sequences | Same as pg_statio_sys_sequences, eonly as a global view. |
shardman.gv_statio_user_sequences | pg_statio_user_sequences | Same as pg_statio_user_sequences, only as a global view. |
shardman.gv_stat_user_functions | pg_stat_user_functions | One row for each tracked function, showing statistics about executions of that function. |
shardman.gv_stat_slru | pg_stat_slru | One row per SLRU, showing statistics of operations. |
shardman.gv_stat_csn | shardman.pg_stat_csn | One row showing statistics on delays that take place during import of CSN snapshots. |
shardman.gv_stat_monitor | shardman.pg_stat_monitor | One row showing metrics of the Postgres Pro Shardman monitor. |
shardman.gv_stat_netusage | shardman.pg_stat_net_usage | One row showing the cumulative network traffic between Postgres Pro Shardman cluster nodes. |
shardman.gv_stat_xact_time | shardman.pg_stat_xact_time | One row showing statistics for the time spent on a transaction. |
shardman.gv_lock_graph | shardman.lock_graph | One row showing a graph of locks between processes on Postgres Pro Shardman cluster nodes including external locks. This view is based on the pg_locks and pg_prepared_xacts system views and on the pg_stat_activity view of the cumulative statistics system. |
shardman.gv_stat_foreign_bytes | shardman.pg_stat_foreign_stat_bytes | One row showing the amount of statistics for foreign relations transferred over the network between Postgres Pro Shardman cluster nodes. |
shardman.gv_stat_recovery_prefetch | pg_stat_recovery_prefetch | One row, the columns wal_distance, block_distance and io_depth show current values, and the other columns show cumulative counters that can be reset with the pg_stat_reset_shared function. |
shardman.gv_stat_wal_receiver | pg_stat_wal_receiver | One row, showing statistics about the WAL receiver from that receiver's connected server. |
shardman.gv_stat_xact_all_tables | pg_stat_xact_all_tables | Similar to pg_stat_all_tables, but counts actions taken so far within the current transaction (which are not yet included in pg_stat_all_tables and related views). The columns for numbers of live and dead rows and vacuum and analyze actions are not present in this view. |
shardman.gv_stat_xact_sys_tables | pg_stat_xact_sys_tables | Same as pg_stat_xact_sys_tables, only as a global view. |
shardman.gv_stat_xact_user_tables | pg_stat_xact_user_tables | Same as pg_stat_xact_user_tables, only as a global view |
shardman.gv_stat_xact_user_functions | pg_stat_xact_user_functions | Similar to pg_stat_user_functions, but counts only calls during the current transaction (which are not yet included in pg_stat_user_functions). |
shardman.gv_sharded_tables | Displays information on all the sharded tables in the cluster. | |
shardman.gv_global_tables | Displays information on all the global tables in the cluster. |
55.41.2. Global Views for System Calalog and System Views #
Below is the list of the global views that relate to the system catalog and system views, and links to their corresponding local views:
Table 55.42. Global and local views for system catalog and system views
| Global view | Local view | Description |
|---|---|---|
shardman.gv_aggregate | pg_aggregate | Stores information about aggregate functions |
shardman.gv_am | pg_am | Relation access methods |
shardman.gv_amop | pg_amop | Access method operators |
shardman.gv_amproc | pg_amproc | Access method support functions |
shardman.gv_attrdef | pg_attrdef | Column default values |
shardman.gv_attribute | pg_attribute | Table columns (“attributes”) |
shardman.gv_auth_members | pg_auth_members | Authorization identifier membership relationships |
shardman.gv_available_extension_versions | pg_available_extension_versions | Specific extension versions that are available for installation |
shardman.gv_available_extensions | pg_available_extensions | Extensions that are available for installation |
shardman.gv_cast | pg_cast | Casts (data type conversions) |
shardman.gv_class | pg_class | Tables, indexes, sequences, views (“relations”) |
shardman.gv_collation | pg_collation | Collations (locale information) |
shardman.gv_config | pg_config | Compile-time configuration parameters of the currently installed version of Postgres Pro Shardman |
shardman.gv_constraint | pg_constraint | Check constraints, unique constraints, primary key constraints, foreign key constraints |
shardman.gv_conversion | pg_conversion | Encoding conversion information |
shardman.gv_database | pg_database | Databases within this database cluster |
shardman.gv_db_role_setting | pg_db_role_setting | Per-role and per-database settings |
shardman.gv_default_acl | pg_default_acl | Default privileges for object types |
shardman.gv_depend | pg_depend | Dependencies between database objects |
shardman.gv_description | pg_description | Descriptions or comments on database objects |
shardman.gv_enum | pg_enum | Enum label and value definitions |
shardman.gv_event_trigger | pg_event_trigger | Event triggers |
shardman.gv_extension | pg_extension | Installed extensions |
shardman.gv_file_settings | pg_file_settings | Installed extensions |
shardman.gv_foreign_data_wrapper | pg_foreign_data_wrapper | Foreign-data wrapper definitions |
shardman.gv_foreign_server | pg_foreign_server | Foreign server definitions |
shardman.gv_foreign_table | pg_foreign_table | Additional foreign table information |
shardman.gv_group | pg_group | Exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before version 8.1 |
shardman.gv_hba_file_rules | pg_hba_file_rules | Summary of the contents of the client authentication configuration file pg_hba.conf |
shardman.gv_ident_file_mappings | pg_ident_file_mappings | Summary of the contents of the client user name mapping configuration file pg_hba.conf |
shardman.gv_index | pg_index | Additional index information |
shardman.gv_indexes | pg_indexes | Provides access to useful information about each index in the database |
shardman.gv_inherits | pg_inherits | Table inheritance hierarchy |
shardman.gv_init_privs | pg_init_privs | Object initial privileges |
shardman.gv_language | pg_language | Languages for writing functions |
shardman.gv_largeobject | pg_largeobject | Data pages for large objects |
shardman.gv_largeobject_metadata | pg_largeobject_metadata | Metadata associated with large objects |
shardman.gv_matviews | pg_matviews | Provides access to useful information about each materialized view in the database |
shardman.gv_namespace | pg_namespace | Schemas |
shardman.gv_opclass | pg_opclass | Access method operator classes |
shardman.gv_operator | pg_operator | Operators |
shardman.gv_opfamily | pg_opfamily | Access method operator families |
shardman.gv_parameter_acl | pg_parameter_acl | Configuration parameters for which privileges have been granted |
shardman.gv_partitioned_table | pg_partitioned_table | Information about partition key of tables |
shardman.gv_proc | pg_proc | Functions and procedures |
shardman.gv_profile | pg_profile | Profiles, a set of authentication restrictions |
shardman.gv_publication | pg_publication | Publications for logical replication |
shardman.gv_publication_namespace | pg_publication_namespace | Schema to publication mapping |
shardman.gv_publication_rel | pg_publication_rel | Relation to publication mapping |
shardman.gv_publication_tables | pg_publication_tables | Information about the mapping between publications and information of tables they contain |
shardman.gv_range | pg_range | Information about range types |
shardman.gv_replication_origin | pg_replication_origin | Registered replication origins |
shardman.gv_replication_origin_status | pg_replication_origin_status | Information about how far replay for a certain origin has progressed |
shardman.gv_replication_slots | pg_replication_slots | Provides a listing of all replication slots that currently exist on the database cluster, along with their current state |
shardman.gv_rewrite | pg_rewrite | Query rewrite rules |
shardman.gv_rules | pg_rules | Provides access to useful information about query rewrite rules |
shardman.gv_seclabel | pg_seclabel | Security labels on database objects |
shardman.gv_seclabels | pg_seclabels | Provides information about security labels |
shardman.gv_sequence | pg_sequence | Information about sequences |
shardman.gv_sequences | pg_sequences | Provides access to useful information about each sequence in the database |
shardman.gv_settings | pg_settings | Provides access to run-time parameters of the server |
shardman.gv_shdepend | pg_shdepend | Dependencies on shared objects |
shardman.gv_shdescription | pg_shdescription | Comments on shared objects |
shardman.gv_shseclabel | pg_shseclabel | Security labels on shared database objects |
shardman.gv_subscription | pg_subscription | Logical replication subscriptions |
shardman.gv_subscription_rel | pg_subscription_rel | Relation state for subscriptions |
shardman.gv_tablespace | pg_tablespace | Tablespaces within this database cluster |
shardman.gv_tables | pg_tables | Provides access to useful information about each table in the database |
shardman.gv_prepared_xacts | pg_prepared_xacts | Provides information about transactions that are currently prepared for two-phase commit |
shardman.gv_timezone_names | pg_timezone_names | List of time zone names that are recognized by SET TIMEZONE, along with their associated abbreviations, UTC offsets, and daylight-savings status |
shardman.gv_timezone_abbrevs | pg_timezone_abbrevs | List of time zone abbreviations that are currently recognized by the datetime input routines |
shardman.gv_transform | pg_transform | Transforms (data type to procedural language conversions) |
shardman.gv_trigger | pg_trigger | Triggers |
shardman.gv_ts_config | pg_ts_config | Text search configurations |
shardman.gv_ts_config_map | pg_ts_config_map | Text search configurations' token mappings |
shardman.gv_ts_dict | pg_ts_dict | Text search dictionaries |
shardman.gv_ts_parser | pg_ts_parser | Text search parsers |
shardman.gv_ts_template | pg_ts_template | Text search templates |
shardman.gv_type | pg_type | Data types |
shardman.gv_user_mapping | pg_user_mapping | Mappings of users to foreign servers |
shardman.gv_user_mappings | pg_user_mappings | Provides access to information about user mappings |
shardman.gv_views | pg_views | Provides access to useful information about each view in the database |
shardman.gv_wait_events | pg_wait_events | Provides description about the wait events |
shardman.gv_locks | pg_locks | Provides access to information about the locks held by active processes within the database server. |
shardman.gv_shmem_allocations | pg_shmem_allocations | Shows allocations made from the server's main shared memory segment. |