Reference

Review WarehousePG Enterprise Manager (WEM) technical specifications, definitions, and permission structures.

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.

Monitoring views

WEM installs specialized views across your cluster to provide deep visibility into distributed operations.

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

Command reference

Command reference for WarehousePG Enterprise Manager.

Views

A complete list of views installed with WarehousePG Enterprise Manager, including their descriptions and use cases.

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