alloydb-postgres-monitor

Monitor AlloyDB for PostgreSQL query performance, system metrics, and lock states.

2|1|Updated May 25, 2026

Search Tags:#performance #monitoring #database #postgresql #promql #alloydb

Ready to run

npx skills add https://github.com/interflownex/All-in-One --skill alloydb-postgres-monitor

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: alloydb-postgres-monitor
Source: https://github.com/interflownex/All-in-One/tree/main/.gemini/skills/alloydb-postgres-monitor
Command: npx skills add https://github.com/interflownex/All-in-One --skill alloydb-postgres-monitor

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires @toolbox-sdk/server, and includes scripts (resource) components.

What problem does it solve?

This skill addresses performance bottlenecks and resource contention in AlloyDB for PostgreSQL by providing deep visibility into query execution, system metrics, and locking behavior.

Core Features & Use Cases

Performance Diagnostics: Analyze query execution plans and identify slow-running queries using pg_stat_statements.
System Monitoring: Access real-time PromQL metrics for CPU, memory, and storage utilization to ensure cluster health.
Concurrency Management: Detect and resolve lock contention and long-running transactions that block database operations.

Quick Start

Use the alloydb-postgres-monitor skill to list the top 10 longest running active queries in my database.

Frequently Asked Questions about alloydb-postgres-monitor

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I troubleshoot slow queries in AlloyDB for PostgreSQL?▼

Troubleshoot slow AlloyDB queries by analyzing execution plans and identifying long-running queries using pg_stat_statements. This provides deep visibility into query performance to help resolve execution bottlenecks.

How do I monitor AlloyDB system resource utilization like CPU and memory?▼

Monitor AlloyDB system resources by accessing real-time PromQL metrics for CPU, memory, and storage utilization. This integration with Cloud Monitoring ensures ongoing cluster health and resource availability.

How can I detect and resolve lock contention in PostgreSQL?▼

Detect PostgreSQL lock contention by diagnosing transaction locking states and long-running operations. This resolves concurrency issues that block database operations and cause resource contention.

Can I use PromQL to analyze AlloyDB cluster health?▼

Use PromQL to analyze AlloyDB cluster health by querying real-time system-level metrics. This integration with Cloud Monitoring provides comprehensive diagnostic capabilities for cluster utilization.

What is the best way to identify long-running active queries in a database?▼

Identify long-running active database queries by analyzing PostgreSQL statistics views. This diagnostic capability isolates slow-running operations to facilitate targeted database tuning and troubleshooting.