hologres-diagnosis-memory

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

17|Updated Apr 22, 2026
One-click install
npx skills add https://github.com/aliyun/hologres-ai-plugins --skill hologres-diagnosis-memory
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: hologres-diagnosis-memory
Source: https://github.com/aliyun/hologres-ai-plugins/tree/main/agent-skills/skills/hologres-diagnosis-memory
Command: npx skills add https://github.com/aliyun/hologres-ai-plugins --skill hologres-diagnosis-memory

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires hologres-cli, and includes references (resource) components.

What problem does it solve?

Hologres 内存使用异常诊断技能,帮助识别并分析实例内存高位、OOM、倾斜和内存泄漏等问题。通过云监控指标、PG/系统表数据及内部工具信息,输出结构化的诊断报告与治理行动清单,提升诊断准确性与修复效率。

Core Features & Use Cases

  • 宏观内存水位分阶段诊断与形态判定,定位全局高、局部倾斜或持续不回落等场景;支持多阶段推进至具体排查路径(Query、倾斜、写入/后台、System/元数据)。
  • 内存分类初筛与多线并行深挖:Query 侧、倾斜侧、写入/后台侧、System/元数据侧,并提供内部工具(OOM/Jeprof/Coredump)辅助排查。
  • 输出结构化诊断报告和治理行动清单,所有步骤均以 hologres-cli 的安全护栏和 JSON 输出为基础,便于 AI 助手接入与决策。

Quick Start

Launch the diagnosis by obtaining the metric prefix with hologres instance-manage get, then follow the guided steps to collect metrics, run queries, and generate the Markdown report.

Frequently Asked Questions about hologres-diagnosis-memory

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

FAQPage Schema
How do I diagnose Hologres OOM events and memory spikes?

To diagnose Hologres OOM events and memory spikes, analyze cloud monitoring metrics and query logs. This identifies memory anomalies across query, data skew, and backend systems to produce a structured remediation report.

What is the best way to identify data skew causing memory leaks in Hologres?

Identifying data skew causing memory leaks in Hologres involves running phased macro memory level analysis. It determines whether issues are global highs or local skews, guiding targeted diagnostic paths for remediation.

Does the Hologres memory diagnosis process require hologres-cli?

Yes, the Hologres memory diagnosis process requires hologres-cli. It relies on this tool for data access, metric queries, and internal tools, requiring appropriate permissions to read memory metrics and system tables.

How do I start memory anomaly diagnosis on a Hologres instance?

Start memory anomaly diagnosis by obtaining the metric prefix with hologres instance-manage get. Then follow guided steps to collect metrics, run queries, and generate a structured Markdown report for remediation.

What internal tools are used for Hologres memory analysis?

Internal tools used for Hologres memory analysis include OOM, Jeprof, and Coredump utilities. These assist deep investigation alongside parallel screening of query, write/backend, and metadata systems.

Why does my Hologres instance memory stay high and not fall back?

Hologres instance memory staying high and not falling back indicates a persistent memory leak or backend issue. Diagnose this by classifying memory usage and deep diving into write/backend or system metadata paths.