systing-analyze

Analyze systing trace databases to diagnose system performance issues.

174|18|Updated Oct 17, 2024
One-click install
npx skills add https://github.com/josefbacik/systing --skill systing-analyze
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: systing-analyze
Source: https://github.com/josefbacik/systing/tree/main/skills/systing-analyze
Command: npx skills add https://github.com/josefbacik/systing --skill systing-analyze

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you analyze complex system performance traces stored in DuckDB databases, enabling you to diagnose performance bottlenecks, understand resource utilization, and identify root causes of system issues.

Core Features & Use Cases

  • Trace Exploration: Quickly get an overview of trace contents, time ranges, and available data.
  • Performance Diagnosis: Analyze CPU hotspots, scheduling latency, off-CPU time, and network behavior.
  • TPU Performance: Investigate TPU utilization, operational performance, and identify performance gaps.
  • Use Case: When a system is experiencing slowdowns, use this Skill to analyze a trace.duckdb file to pinpoint whether the issue is CPU-bound, I/O-bound, or related to network congestion.

Quick Start

Use the systing-analyze skill to get information about the trace file located at /path/to/your/trace.duckdb.

Frequently Asked Questions about systing-analyze

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

FAQPage Schema
How do I analyze a DuckDB trace database to diagnose system performance issues?

To analyze a DuckDB trace database, you can use this Skill to orchestrate trace information retrieval, schema discovery, and generate flamegraphs to diagnose CPU hotspots, scheduling latency, and network behavior directly from the file.

What is the best way to find the root cause of CPU bottlenecks in a Linux trace file?

Finding the root cause of CPU bottlenecks in a Linux trace file involves analyzing CPU utilization metrics, off-CPU time, and generating flamegraphs from the trace database to pinpoint exactly where the system resources are being consumed.

Can I run ad-hoc SQL queries on trace data to investigate TPU performance?

Yes, you can run ad-hoc SQL queries on the trace database to investigate TPU performance, allowing you to dive deep into TPU utilization, operational metrics, and identify specific performance gaps.

How do I check scheduling latency and off-CPU time from a trace.duckdb file?

You can check scheduling latency and off-CPU time from a trace.duckdb file by utilizing the built-in scheduling statistics and CPU utilization analysis tools to understand thread blocking and context switching impacts.

Does this trace analysis approach work for identifying network congestion bottlenecks?

Yes, this trace analysis approach works for identifying network congestion bottlenecks by analyzing the network behavior data captured within the DuckDB trace database to isolate I/O-bound system slowdowns.

What do I need to start diagnosing performance slowdowns using a trace database?

To start diagnosing performance slowdowns using a trace database, you need a valid .duckdb trace file path; the Skill then automatically handles schema discovery, metric extraction, and visualization orchestration.