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

hologres-instance-health-analyse

Analyze Hologres Warehouse resources, error logs, and slow queries to produce a structured diagnostic report.

17|Updated Apr 22, 2026
Search Tags:#diagnostics#error-analysis#slow-query#hologres#instance-health#warehouse-metrics
One-click install
npx skills add https://github.com/aliyun/hologres-ai-plugins --skill hologres-instance-health-analyse
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: hologres-instance-health-analyse
Source: https://github.com/aliyun/hologres-ai-plugins/tree/main/agent-skills/skills/hologres-instance-health-analyse
Command: npx skills add https://github.com/aliyun/hologres-ai-plugins --skill hologres-instance-health-analyse

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Hologres 实例健康诊断与巡检分析。当用户提到实例健康诊断、实例巡检、实例使用状况分析、慢查询分析、报错分析、Warehouse 资源分析、连接数分析、CPU 内存使用分析、查询失败排查等场景时使用。覆盖 Warehouse 资源巡检、FAILED 报错归类分析、CPU/内存粒度慢查询分析三大核心模块，输出结构化诊断报告和优化建议。

Core Features & Use Cases

  • Warehouse 资源巡检：分析 CPU、内存、连接数等资源使用情况，帮助发现瓶颈。
  • 报错归类分析：汇总并分类 FAILED Query 的错误，给出解决思路。
  • 慢查询分析（CPU/内存）：按指纹聚类慢查询，找出高消耗模式。
  • 汇总输出诊断报告：生成结构化诊断报告并给出优化建议。
  • 指定时间范围与服务器池：支持 7 天等默认范围，可调整。

Quick Start

Run hologres instance-health-analyse to generate a structured diagnostic report for the current deployment.

Frequently Asked Questions about hologres-instance-health-analyse

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

FAQPage Schema
How do I diagnose Hologres instance health issues like CPU and memory bottlenecks?▼

Hologres instance health diagnostics analyzes Warehouse resources, error logs, and slow queries to identify CPU and memory bottlenecks, producing a structured diagnostic report with optimization suggestions.

What is the best way to analyze slow queries in Hologres by CPU and memory consumption?▼

Slow-query analysis clusters queries by fingerprint to pinpoint high CPU and memory consumption patterns, helping you identify and optimize the most resource-intensive query operations in your Hologres instance.

How do I categorize and troubleshoot FAILED query errors in Hologres?▼

Error analysis summarizes and categorizes FAILED queries by error type, providing structured troubleshooting approaches within the diagnostic report to resolve recurring Hologres query failures.

Do I need hologres-cli to run instance health diagnostics and checks?▼

Yes, hologres-cli access is required to run analysis queries with safety guards and JSON output, while the diagnostic tool supports retry logic to handle transient failures during the Hologres health check.

Can I analyze Hologres Warehouse resource usage and connection limits for a specific time range?▼

Warehouse resource checks analyze CPU, memory, and connection usage over a specified time range, defaulting to 7 days, to discover resource bottlenecks and connection limit issues in your Hologres instance.

Why does my Hologres instance health analysis fail to retrieve diagnostic data?▼

Diagnostic data retrieval may fail due to transient connection issues, but the analysis supports retry logic for transient failures and applies safety guards to ensure safe query execution during the health check.

Related Skills

Explore More Data & Analytics Skills→
aliyunaliyun
17

hologres-diagnosis-cpu

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

Official
Advanced
lazyFrogLOLlazyFrogLOL
127

query-optimize

Optimize slow SQL queries with plan analysis and index recommendations.

Community
Intermediate
aliyunaliyun
17

hologres-diagnosis-memory

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

Official
Advanced
VXerysVXerys

database-optimizer

Analyze slow PostgreSQL and MySQL queries and generate index strategies.

Community
Advanced