skills.rest
aliyun
aliyunOFFICIAL
Explore all skills by this author →
WebsiteGitHub

hologres-diagnosis-cpu

Diagnose Hive Hologres CPU anomalies and generate a Markdown report with remediation actions.

17|Updated Apr 22, 2026
Search Tags:#performance#monitoring#troubleshooting#sql-analysis#hologres#cpu-diagnosis
One-click install
npx skills add https://github.com/aliyun/hologres-ai-plugins --skill hologres-diagnosis-cpu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: hologres-diagnosis-cpu
Source: https://github.com/aliyun/hologres-ai-plugins/tree/main/agent-skills/skills/hologres-diagnosis-cpu
Command: npx skills add https://github.com/aliyun/hologres-ai-plugins --skill hologres-diagnosis-cpu

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Hologres 实例 CPU 使用率异常诊断技能，帮助运维与开发团队快速识别并解释 CPU 峰值、持续高位及不均衡负载的根因，并生成可操作的治理清单。

Core Features & Use Cases

  • End-to-end CPU anomaly detection: 从云监控数据到元仓/PG 系统表，逐步诊断并产出结构化 Markdown 报告与治理建议。
  • Multi-stage diagnosis: 覆盖宏观定性、分布定位、查询归因和后台任务干扰，确保完整的问题链路分析。
  • Safety and guardrails: 借助 hologres-cli 的安全护栏、JSON 输出与自动重试能力，降低误判与操作风险。

Quick Start

Describe the steps to run an end-to-end CPU diagnostic for a specified instance_id and time window.

Frequently Asked Questions about hologres-diagnosis-cpu

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

FAQPage Schema
How do I diagnose Hologres CPU utilization anomalies across warehouses?▼

To diagnose Hologres CPU utilization anomalies, fetch cloud metrics and query system tables to identify root causes across multi-stage analysis. This generates a structured Markdown diagnostic report with specific remediation actions.

Why does my Hologres instance have persistently high or maxed out CPU?▼

Persistently high or maxed out Hologres CPU often stems from workload spikes, uneven worker CPU distribution, or background compaction tasks. Analyzing cloud metrics and PG system tables pinpoints the exact query or task interference.

What's the best way to identify uneven worker CPU load in Hologres?▼

Identifying uneven worker CPU load in Hologres requires analyzing cloud metrics and querying system tables. This process isolates distribution imbalances and attributes them to specific queries or background tasks for targeted remediation.

Can I troubleshoot Hologres CPU spikes without risking operational safety?▼

Yes, you can safely troubleshoot Hologres CPU spikes using hologres-cli. It provides built-in safety guards, JSON output, and automatic retry capabilities, significantly reducing operational risks and misdiagnosis during anomaly investigation.

How to attribute Hologres CPU usage to specific SQL queries and background tasks?▼

To attribute Hologres CPU usage, analyze cloud metrics and query metadata system tables. This multi-stage diagnosis isolates query-level impacts and detects background compaction interference to produce a remediation checklist.

Does Hologres CPU diagnosis require manual credential handling for metric queries?▼

No, Hologres CPU diagnosis handles credentials automatically during metric queries and system table access. Built-in retry mechanisms and hologres-cli safety guards ensure seamless data retrieval without manual credential intervention.

Related Skills

Explore More Data & Analytics Skills→
aliyunaliyun
17

hologres-diagnosis-memory

Diagnose Hologres memory anomalies from cloud monitoring metrics and query logs.

Official
Advanced
joshbandjoshband
3

debug

Automate LocusQ debugging workflows with codebase inspection and runtime diagnostics.

Community
Advanced
aliyunaliyun
17

hologres-query-optimizer

Analyze Hologres EXPLAIN outputs and recommend query optimizations.

Official
Advanced
zinohomezinohome
1

sql-query-optimizer

Analyze SQL EXPLAIN plans and recommend index strategies.

Community
Advanced