starrocks-admin-query-monitor

What problem does it solve?

This Skill helps you investigate slow, failing, or resource-intensive queries in StarRocks and restore predictable performance by monitoring query activity, enforcing workload isolation, and managing runaway queries.

Core Features & Use Cases

• Real-time query monitoring with session-level visibility using SHOW PROCESSLIST / SHOW FULL PROCESSLIST and processlist-style filtering via information_schema.processlist.
• Query history analysis using information_schema.query_history to find slow, CPU-heavy, memory-heavy, and failed queries with practical SQL patterns.
• Operational safety for production clusters via slow query logging configuration (qe_slow_log_ms), resource group governance (CREATE/ALTER/DROP RESOURCE GROUP with classifiers), query queuing controls, and emergency mitigation through KILL QUERY.
• Long-term audit and dashboards by installing and using the Audit Loader plugin to persist query history for retention, compliance, and metrics like p95/p99 latency and top slow SQL by hash.

Quick Start

Use the starrocks-admin-query-monitor skill to analyze the last 24 hours of slow completed queries by running a query against information_schema.query_history and ranking results by TotalTime.