skills.rest
interflownex
interflownexCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/interflownex/All-in-One --skill alloydb-postgres-monitor
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
interflownexinterflownex
2

alloydb-postgres-data

Access AlloyDB PostgreSQL metadata and execute custom SQL queries.

Community
Intermediate
liauw-medialiauw-media
3

lighthouse-performance-optimization

Run Lighthouse audits through MCP to identify website performance bottlenecks.

Community
Advanced
openoctaopenocta
3.1k

Prometheus Analysis

The quick brown fox jumps over the lazy dog.

Community
Intermediate
interflownexinterflownex
2

cloud-sql-postgres-health

Diagnose query bottlenecks and resource constraints in Google Cloud SQL for PostgreSQL instances.

Community
Advanced