Views
WarehousePG Enterprise Manager (WEM) installs the wem schema in your WarehousePG (WHPG) cluster, which includes a suit of specialized views. Use these views to perform deep-dive diagnostics into distributed operations, storage efficiency, and resource group utilization directly from your SQL client.
Monitoring views
Session and activity views
Monitor real-time connectivity and identify execution bottlenecks.
| View name | Description |
|---|---|
wem.v_activity | Extends pg_stat_activity with WHPG-specific columns like resource_group and sess_id to identify distributed query bottlenecks. |
wem.v_session_summary | Provides an overview of connections per user and application to detect service accounts exhausting the connection pool. |
wem.v_replication | Monitors synchronization status and lag (in bytes and time) between primary and mirror segments. |
wem.v_wait_events | Aggregates current wait types to determine if the cluster is bound by I/O, network, or CPU. |
Storage and distribution views
Audit table health, data skew, and compression efficiency.
| View name | Description |
|---|---|
wem.v_check_data_skew | Analyzes row distribution across segments to identify segments that are slowing down parallel processing. |
wem.v_table_sizes_summary | Displays table sizes, storage formats (Heap/AO), and compression levels across the cluster. |
wem.v_table_sizes_aggregated | Provides a high-level view of object sizes and estimated row counts for large-scale storage audits. |
wem.v_bloat_tables | Detects fragmented space (bloat) in tables caused by high-volume UPDATE or DELETE operations. |
wem.v_bloat_tables_detailed | Provides page-level details on expected vs. actual table size to prioritize VACUUM FULL operations. |
wem.v_partitions | Lists child partition metadata, including ranks, boundaries, and associated tablespaces. |
wem.v_list_objects_size | A low-level view of individual object sizes (tables/indexes) per segment. |
Resource and access views
Use these views to audit security policies and resource group limits.
| View name | Description |
|---|---|
wem.v_resource_config | Displays the configured CPU, memory, and concurrency limits for every resource group. |
wem.v_resource_status | Tracks real-time resource group metrics, including running vs. queued queries and total execution counts. |
wem.v_roles_with_resources | Maps database roles to their assigned resource groups and identifies superuser or login privileges. |
wem.v_hba_rules | Displays the parsed rules from pg_hba.conf and highlights any syntax or configuration errors. |
Logging and backup views
Investigate historical events and data protection status.
| View name | Description |
|---|---|
wem.read_gpdb_log_d_[X] | Allows SQL-based searching of coordinator logs for the current day (d) or previous days (d_1 through d_10). |
wem.backup_history_metadata | Provides a historical record of gpbackup operations, including status, compression types, and table filters. |
- On this page
- Monitoring views
Could this page be better? Report a problem or suggest an addition!