Review WarehousePG Enterprise Manager (WEM) technical specifications, definitions, and permission structures.
Configuration parameters
A complete reference for all WEM and Collector configuration parameters, including defaults, types, and descriptions.
Alert rules
WEM ships three sets of Prometheus alert rules. Canary rules cover cluster health indicators. System rules cover WEM service availability. WHPG rules cover query performance, disk usage, segment health, and data distribution.
WEM command reference
WEM includes a powerful CLI tool for initialization, diagnostics, and service management.
- wem setup: Initialize the monitoring database, install schemas, and set the admin password.
- wem doctor: Run pre-flight checks to validate database connectivity and observability stack reachability.
Prometheus metrics
WEM exposes a complete set of Prometheus metrics covering cluster health, query states, resource groups, host hardware, canary checks, and WEM internal state.
Role permissions matrix
WEM utilizes Role-Based Access Control (RBAC). Use this matrix to understand the default capabilities of each user role.
| 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.
Keyboard shortcuts
Speed up your workflow within the WEM interface using the following 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 |
Alert rules
Reference for the Prometheus alert rules shipped with WEM.
Command reference
Command reference for WarehousePG Enterprise Manager.
Configuration parameters
Complete reference for all WEM and Collector configuration parameters.
Metrics
A complete reference of all Prometheus metrics exposed and collected by WarehousePG Enterprise Manager, including their descriptions and types.