Getting started with WarehousePG Enterprise Manager
Once WarehousePG Enterprise Manager (WEM) is installed and the backend services are running, you can begin observing system health and tuning performance.
Important
The host running WEM must remain online and the application must be active to ensure continuous data gathering. Stopping the application will halt the collection of SQL and cluster-level metrics.
Accessing the console and managing your session
Access the centralized management suite to begin monitoring your WarehousePG (WHPG) cluster.
- Navigate to your WEM server URL (for example,
http://your-server:8080) and enter your administrative credentials. - Check the top right bar of the interface to confirm your current role (Admin, Operator, or Viewer). Your role determines which panels and actions are visible during the session.
- Sessions automatically expire after a period of inactivity for security. If a timeout occurs, you must log in again to return to the authentication screen. Save any active work in the Query Editor regularly to prevent data loss.
Navigating the interface structure
The WEM interface is organized into functional areas designed to help you move from high-level alerts to deep-dive diagnostics.
- Panels (left sidebar): Access the primary functional modules such as Cluster, Monitoring, and Access Management.
- Header (top): View the current page title, system time, and global controls.
- Tabs (top of content): Navigate between specific tools or sub-views in a selected panel.
- Interactive data (center): Interact with data tables, live performance charts, and configuration tools.
Navigation directory
Locate specific operational goals and their corresponding section:
| Goal | Panel |
|---|---|
| Verifying the cluster health | Cluster |
| Monitoring and evaluating queries | Query Monitor |
| Analyzing data distribution | Data Analysis |
| Planning storage capacity | Storage |
| Defining access policies | Access Management |
| Visualizing hardware performance | System Metrics |
| Managing system resources | Resource Management |
| Securing backups | Backups |
| Auditing system logs | Logs |
| Validating database responsiveness | Monitoring |
| Managing alerts | Alerts |
| Performing administrative management | Management |
Understanding user roles and permissions
WEM utilizes Role-Based Access Control (RBAC). After the initial bootstrap, all user management and password updates are handled exclusively via the Management panel. A user's assigned profile determines which panels and actions are visible.
| Profile | Description | Access scope |
|---|---|---|
| Admin | Full system administration | All panels, user management, and system configuration. |
| Operator | Operational management | Query monitoring, data analysis, and backup operations. |
| Viewer | Read-only observation | High-level dashboards, cluster status, and system metrics. |
Refer to the Role permissions matrix for details.
Monitoring cluster health with the Dashboard
The Dashboard is your landing page, which provides a real-time snapshot of cluster health and resource consumption.
Review status and resources:
- Monitor high-level indicators for an immediate status check, such as Uptime, Connections, and Last Sync time.
- View healthy vs. unhealthy segments.
- Monitor storage utilization for the coordinator and segments.
Analyze performance charts
- Track running, queued, and blocked queries in the Active Queries chart.
- Visualize system and user utilization with CPU Usage.
- Monitor total memory usage percentage with Memory Usage.
Audit recent alerts
- Review the Recent WHPG Log Alerts card for the latest log events. Navigate to the Logs panel for a full audit trail.
Could this page be better? Report a problem or suggest an addition!