WarehousePG Enterprise Manager 0.5 release notes

Release Date: March 2, 2026

Status: Technical preview

We are excited to announce the first release of WarehousePG Enterprise Manager (WEM). WEM is a unified management and monitoring platform designed to provide deep visibility into WarehousePG clusters, simplify administrative tasks, and streamline host-based authentication.

Key highlights

• Deep observability

  • Real-time & historical metrics: Monitor your cluster’s pulse with a dual-layer approach. View live SQL statistics directly from the integrated Exporter or analyze long-term trends using historical data stored in Prometheus.
  • Cluster health overview: Gain an immediate, high-level status of the coordinator and all segment nodes, ensuring high availability and identifying bottlenecks at a glance.
  • Centralized log analysis: Access and search high-volume log streams aggregated via Loki, reducing the time spent SSH-ing into individual nodes for troubleshooting.

• Intelligence & development

  • Query monitor & AI assistant: Identify slow-running queries in real-time. Use the integrated AI Assistant within the SQL Editor to help write, optimize, and explain complex distributed queries.
  • Table & data analysis: Explore your schemas, analyze table distribution across segments, and perform deep-dives into data skew and storage efficiency.

• Administrative control

  • Resource management: Monitor and tune the resource consumption of your WarehousePG cluster to ensure peak performance under heavy workloads.
  • User & access aanagement: Simplify security with a centralized user interface for managing database users, roles, and permissions. Use the interactive HBA Editor to update pg_hba.conf with automatic backups and safe reloads.
  • System settings audit: Search and verify all cluster-level configuration parameters (GUCs) through a dedicated, searchable interface.

• Resilience & reliability

  • Backups & data protection: Manage and monitor your cluster backup schedules and recovery points from a single location.
  • Alerting & Canary checks: Stay ahead of failures with configurable alerts and automated Canary checks that proactively test cluster connectivity and performance.