Skip to content

Latest commit

 

History

History
57 lines (38 loc) · 3.24 KB

index.mdx

File metadata and controls

57 lines (38 loc) · 3.24 KB
title description navigation navRootedTo
WarehousePG Enterprise Manager
Use WarehousePG Enterprise Manager as a centralized hub for monitoring, managing, and optimizing WarehousePG clusters.
release_notes
overview
installing
get-started
monitoring
performance
system-access
troubleshooting
reference
/supported-open-source/warehousepg/

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.