القائمة
Analyze slow queries and suggest optimizations including missing indexes and query rewrites. Use when investigating query performance, high CPU usage, or slow response times.
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
استنادا إلى تصنيف SOC المهني
Debug database connection issues including too many connections, idle transactions, lock contention, and connection pool exhaustion. Use when the database is unresponsive, connections are refused, or queries are stuck waiting.
Diagnose database health issues including cache performance, connection saturation, vacuum status, and unused indexes. Use when investigating database problems or running routine health checks.
| name | slow-query-analysis |
| description | Analyze slow queries and suggest optimizations including missing indexes and query rewrites. Use when investigating query performance, high CPU usage, or slow response times. |
Workflow:
If pg_stat_statements is not installed, guide setup:
