loading
loading
Introducing the AlloyDB Omni web UI for easier cluster observability Omkar Deshmukh Product Manager Josh Choinsky Software Engineer Managing PostgreSQL databases across on-premises, edge, and multi-cloud environments often forces administrators to rely on command-line tools, making it hard to see cluster health and quickly diagnose issues. To solve this, we are announcing the General Availability (GA) of the AlloyDB Omni Web UI for Red Hat and containers. This production-ready, read-only console gives you direct visibility into hardware telemetry, query performance, and configuration flags for AlloyDB Omni so you can troubleshoot workloads quickly and safely without leaving your local or enterprise environment. What is AlloyDB Omni? AlloyDB Omni is a downloadable, self-managed edition of AlloyDB that brings enterprise capabilities and full PostgreSQL compatibility to your own infrastructure. Built to run anywhere — across on-premises data centers, edge environments, and multi-cloud deployments — it includes built-in columnar acceleration and integrated AI tooling. With AlloyDB Omni, you can modernize demanding transactional and analytical workloads while retaining complete control over your operating environment. Key Web UI capabilities at a glance - Cluster overview and profiles: Switch between target connection profiles quickly without using the command line. - System monitoring: View real-time performance telemetry for CPU, memory, and disk I/O to plan capacity and triage infrastructure issues. - Query performance: Identify resource-heavy SQL statements through a visual breakdown of database load, latency bottlenecks, and slow queries. - Columnar Engine diagnostics: Track the in-memory columnar store, caching, and coverage to verify analytical query acceleration. - Parameter and flag auditing: Inspect runtime database parameters centrally to identify configuration drift against your organizational baselines. - AlloyDB AI and ecosystem shortcuts: Inspect vector search and AI workflows, and access quick launchpad shortcuts for ecosystem tools like pgBackRest. Production-safe diagnostics and profile management When you triage complex database workloads across bare-metal VMs, containers, or Kubernetes, you need a clear, isolated view of instance health. The Web UI provides a dedicated visual environment for this. - Profile management: Store and toggle between saved connection profiles for local development, staging, or production environments. - Read-only operations: The interface operates strictly in read-only mode, ensuring that diagnostic sessions cannot execute write commands or modify your underlying database configurations. Dual-layer observability: System and query monitoring To isolate production performance spikes, you need immediate visibility into both hardware health and SQL statement execution. - System monitoring: The Web UI integrates with standard Prometheus telemetry to show you real-time CPU use, memory allocation, storage I/O, and active connection trends. - Query monitoring: The dashboard automatically ranks execution-heavy SQL statements by total latency and call frequency. You can instantly isolate unindexed or resource-intensive queries to resolve issues faster. System Insights and Query Insights in AlloyDB Omni Web UI Real-time Columnar Engine diagnostics AlloyDB Omni includes an advanced Columnar Engine that organizes frequently accessed data in memory, accelerating analytical queries significantly compared to standard PostgreSQL. The Web UI helps you monitor this feature directly: - Memory footprint tracking: Check real-time columnar memory consumption against your hardware limits. - Columnarization and cache coverage: See exactly which tables and columns are actively cached in memory to confirm your workloads are running as fast as possible. AlloyDB AI and Columnar Engine Insights in AlloyDB Omni Web UI Database flag and parameter auditing Keeping database parameters uniform across distributed environments keeps your operations stable. The Web UI gives you a central catalog to inspect active database flags and runtime settings. You can verify node settings against your organizational policies without connecting to servers via SSH or parsing configuration files manually. If configuration drift is detected, changes should be applied via the authoritative provisioning workflow (e.g., updating Kubernetes CRDs/GitOps manifests, running Ansible playbooks, or using alloydbctl). Database flags in AlloyDB Omni Web UI Built-in AlloyDB AI and tooling hub As you build generative AI applications on top of PostgreSQL, the Web UI gives you direct visibility into vector search workflows and AI model integrations. You can also quickly navigate to documentation and external ecosystem resources, including backup tools like pgBackRest, directly from the console's tooling hub. Operational scope and prerequisites We designed the AlloyDB Omni Web UI with clear operational boundaries so you can deploy it easily within enterprise security boundaries and air-gapped environments. - Non-Intrusive Monitoring: The interface operates with minimal permissions out of the box, preserving your existing command-line tools and CI/CD pipelines as the authoritative controls for cluster provisioning and administrative workflows. - Standard monitoring prerequisites: To see complete system hardware metrics, you need standard Prometheus monitoring configured within your host environment. Get started Ready to modernize your PostgreSQL workloads and get dedicated observability for your AlloyDB Omni cluster ? - Sign up for enterprise access: - To request access to RPM-based enterprise distributions, advanced tooling, and the Web UI, complete the sign-up form for RPM based deployment of AlloyDB Omni. - To request access to container-based enterprise distributions, advanced tooling, and the Web UI, complete the sign-up form for container-based deployment. - Install the Web UI: Follow the step-by-step installation instructions in the AlloyDB Omni documentation to deploy the AlloyDB Omni Web UI - For deployment using Red Hat RPM: Deploy via native RPM Package - For deployment using Docker or Podman: Deploy via container image
document fetched 2026-10-29 03:01 · canonical https://cloud.google.com/blog/products/databases/alloydb-omni-delivers-a-web-ui-for-cluster-observability