What problem does it solve?
Manually troubleshooting Cloud SQL PostgreSQL performance issues like slow queries, resource bottlenecks, and system anomalies requires deep database expertise and time-consuming checks across multiple tools and dashboards. This Skill eliminates that overhead by providing unified, natural language access to all critical monitoring and troubleshooting data.
Core Features & Use Cases
- Query Performance Analysis: Generate EXPLAIN plans for SQL statements, retrieve aggregated query statistics, and list active slow-running queries to identify inefficient code.
- System & Query Metric Monitoring: Fetch time series metrics via PromQL for both system-level resources (CPU, memory, disk I/O, connections) and query-level performance (execution time, IO wait, lock contention, row counts).
- Troubleshooting Support: Identify long-running transactions, lock contention issues, and resource-heavy processes to resolve performance incidents faster.
Use Case: If your application is experiencing elevated latency, use this Skill to pull the top 10 slowest queries and current CPU utilization metrics to quickly pinpoint whether the issue is query-related or resource-constrained.
Quick Start
Use the cloud-sql-postgres-monitor skill to retrieve the last 5 minutes of CPU utilization metrics for your Cloud SQL PostgreSQL instance in project my-project and instance my-instance.
