WarehousePG Enterprise Manager

WarehousePG Enterprise Manager (WEM) is a comprehensive management, monitoring, and administration platform designed specifically for WarehousePG (WHPG) clusters. By integrating real-time telemetry, AI-assisted development, and interactive configuration tools into a single interface, WEM transforms complex distributed database operations into a streamlined, visual experience. Whether you are auditing cluster health, tuning SQL performance, or managing security, WEM provides the single pane of glass necessary to maintain a high-performance distributed environment.

Why WEM?

Managing a distributed database manually across multiple segment nodes and coordinators can be resource-intensive and error-prone. WEM solves these challenges by providing:

• Unified visibility: Move beyond per-node SSH sessions. WEM aggregates host metrics, SQL statistics, and system logs into one centralized location.

• Reduced operational fisk: With features like the interactive HBA editor and automatic configuration backups, WEM provides a safety net for critical administrative changes.

• AI-driven optimization: Leverage built-in AI intelligence to explain execution plans and suggest query optimizations, lowering the barrier to entry for managing complex distributed workloads.

• Proactive resilience: Integrated Canary checks and automated alerting ensure you are notified of potential bottlenecks or connectivity issues before they impact your users.

Key capabilities

WEM introduces a robust suite of tools for the modern database administrator and developer:

• Observability & health

  • Real-time & historical metrics: Monitor live cluster pulse via the integrated Exporter or analyze long-term trends using Prometheus data.

  • Cluster overview: A dedicated dashboard for the immediate health status of your coordinator and segment architecture.

  • Log management: Searchable, aggregated log streams powered by Loki for rapid root-cause analysis.

• Intelligence & analysis

  • Query monitor & editor: A full-featured SQL editor featuring an AI Assistant to help write, optimize, and explain distributed queries.

  • Data skew analysis: Deep-dive tools to analyze table distribution and storage efficiency across the cluster segments.

• Cluster administration

  • Access management: An interactive HBA editor for pg_hba.conf and a centralized user interface for user/password management.

  • Resource management: Real-time tracking of CPU, Memory, and I/O consumption across the entire cluster.

  • System settings audit: A searchable interface to verify and audit cluster-level GUC parameters.

• Data protection

  • Backup & recovery: Centralized monitoring of backup schedules, recovery points, and success rates.

  • *Canary checks: Automated "heartbeat" tests that proactively verify cluster connectivity and query responsiveness.