skills.rest
ivanshamaev
ivanshamaevCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

starrocks-admin-query-monitor

Monitor Starrocks queries and enforce resource governance using system tables and slow logs.

14|1|Updated May 5, 2026
Search Tags:#starrocks#resource groups#query monitoring#workload isolation#slow query log#audit loader#killing queries
One-click install
npx skills add https://github.com/ivanshamaev/de-agent-skills --skill starrocks-admin-query-monitor
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: starrocks-admin-query-monitor
Source: https://github.com/ivanshamaev/de-agent-skills/tree/main/group_skills/starrocks_group_skills/starrocks_admin_query_monitor
Command: npx skills add https://github.com/ivanshamaev/de-agent-skills --skill starrocks-admin-query-monitor

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about starrocks-admin-query-monitor

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

FAQPage Schema
How do I find slow queries in StarRocks using the query history?▼

View real-time query activity in StarRocks using SHOW PROCESSLIST or SHOW FULL PROCESSLIST. For advanced filtering, query information_schema.processlist to pinpoint executing statements causing workload contention or blocking operations.

How do I isolate workloads and manage resource contention in StarRocks?▼

Isolate StarRocks workloads by creating resource groups with classifiers using CREATE RESOURCE GROUP. This enforces workload isolation between BI and ETL pipelines and applies query queuing controls to prevent CPU and memory OOM symptoms.

How do I configure a slow query log in StarRocks?▼

Configure the slow query log in StarRocks by setting the qe_slow_log_ms parameter. This threshold logs queries exceeding a specified execution time, enabling administrators to parse operational logs and diagnose latency bottlenecks in production clusters.

How do I persist StarRocks query history for long-term dashboards?▼

Persist StarRocks query history for long-term dashboards by installing the Audit Loader plugin. This captures and stores historical query data to calculate metrics like p95 and p99 latency, top slow SQL by hash, and compliance retention.

What is the best way to kill a runaway query in StarRocks?▼

Kill a runaway query in StarRocks using the KILL QUERY command. This provides emergency mitigation for resource-intensive or failing operations, immediately terminating the session to restore predictable cluster performance.

Related Skills

Explore More Data & Analytics Skills→
StarRocksStarRocks
73

shared-data

Diagnose StarRocks shared-data cluster failures from BE and FE logs.

Official
Advanced
pauljbernardpauljbernard
5

Audit Director Intelligence

Model enterprise audit strategies and coordinate SOX compliance audits.

Community
Advanced
ivanshamaevivanshamaev
14

starrocks-memory-tuning

Tune StarRocks memory limits, spill settings, and pool configurations to resolve query OOM and BE memory pressure.

Community
Advanced
walterrawalterra
58

searxng-search

Search and aggregate web results locally via SearXNG without external API keys.

Community
Intermediate