hologres-slow-query-analysis
OfficialDiagnose and optimize Hologres slow queries fast.
Data & Analytics#optimization#diagnostics#performance-tuning#slow-query#query-log#hologres#database-logs
Authoraliyun
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Analyzes slow and failed Hologres queries by inspecting the hologres.hg_query_log data to identify bottlenecks, root causes, and optimization opportunities.
Core Features & Use Cases
- Top slow query identification, per-digest aggregation, and per-query detail views for targeted optimization.
- Instance-wide slow query analytics: compute total counts, durations, and distribution across engines (HQE, PQE, SDK/FixedQE, PG).
- Per-query deep-dive: inspect plan, resources, reads/writes, and execution details for a given query_id; generate actionable recommendations.
- Real-world use case: diagnose a spike in slow queries during peak hours and propose schema/plan improvements to restore performance.
Quick Start
Run a concise, end-to-end diagnostic for a defined time window using hologres.hg_query_log to surface bottlenecks and recommended optimizations.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: hologres-slow-query-analysis Download link: https://github.com/aliyun/hologres-ai-plugins/archive/main.zip#hologres-slow-query-analysis Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 510,000+ vetted skills library on demand.