Reference

Suggest edits

This reference page provides the technical specifications, definitions, and permission structures governing WarehousePG Enterprise Manager (WEM).

Keyboard shortcuts

Shortcut	Action	Context
`Ctrl+Enter`	Execute query	Query Editor
`Ctrl+K`	Open AI Assistant	Query Editor
`Ctrl+Space`	Auto-complete	Query Editor
`Escape`	Close modal/dialog	Anywhere

Role permissions matrix

Permission	Admin	Operator	Viewer
View dashboard	Yes	Yes	Yes
View cluster status	Yes	Yes	Yes
View active queries	Yes	Yes	Yes
Cancel queries	Yes	Yes	No
Terminate sessions	Yes	Yes	No
Execute DDL (`CREATE`/`DROP`)	Yes	No	No
Execute DML (`INSERT`/`UPDATE`/`DELETE`)	Yes	Limited	No
Execute `SELECT`	Yes	Yes	Yes
View data analysis	Yes	Yes	No
Run `ANALYZE`	Yes	No	No
View storage	Yes	Yes	Yes
View metrics	Yes	Yes	Yes
View logs	Yes	Yes	Yes
View backups	Yes	Yes	No
Manage users	Yes	No	No
Configure permissions	Yes	No	No
View audit log	Yes	No	No

Note

This matrix represents the default system settings. Administrators can customize these permissions for each role via the Users panel under the Permissions tab.

Monitoring views

Core views (available in all databases)

View Name	Description
`v_activity`	Enhanced session monitoring. This view extends the standard `pg_stat_activity` by adding WarehousePG-specific columns to help identify distributed query bottlenecks.
`v_table_sizes_summary`	Comprehensive storage analysis. Displays table sizes while accounting for different storage formats (Heap/Append-Only) and compression ratios.
`v_check_data_skew`	Distribution health check. Analyzes how data is spread across segments to identify "hot" segments that might be slowing down parallel processing.
`v_bloat_tables`	Maintenance indicator. Detects table bloat (fragmented space) caused by high volumes of `UPDATE` or `DELETE` operations.
`v_locks`	Concurrency monitoring. Provides a clear view of current database locks and identifies exactly which queries are blocking others.
`v_size_files`	Low-level storage view. Provides file-level size information directly from the underlying file system of the cluster.
`v_indexes_size`	Index audit tool. Lists all index definitions along with their current storage footprint to help identify redundant or oversized indexes.

Dashboard-specific views (WarehousePG database only)

View Name	Description
`v_database_sizes`	Historical storage tracking. Provides total database sizes alongside trend data to help with capacity planning.
`v_query_stats`	Performance analytics. Aggregates query performance statistics to identify the most resource-intensive or frequently executed queries.

Technical glossary

Coordinator: The primary node that manages distributed queries and coordinates segment activity.
Standby: A replica of the coordinator for high availability.
Segment: A data storage node that holds a portion of the database.
Primary segment: The active segment handling reads and writes.
Mirror segment: A replica segment for redundancy.
Content ID: A unique identifier for a segment pair (primary + mirror).
Distribution key: Column(s) determining how data is distributed across segments.
Bloat: Wasted space in tables from UPDATE/DELETE operations.
Skew: Uneven data distribution across segments.
Motion: Data movement between segments during query execution.
Redistribute: Re-distributing data between segments for a join.
Broadcast: Sending all data to all segments.
Gather: Collecting results from segments to the coordinator.
Resource group: A container for resource limits and concurrency.
Resource queue: A queue managing query concurrency and resources.
Canary check: Automated health check query.
DDL: Data Definition Language (CREATE, DROP, ALTER).
DML: Data Manipulation Language (INSERT, UPDATE, DELETE).

Could this page be better? Report a problem or suggest an addition!