Skip to main content

mz-profile

Trigger: "profile Materialize", "check memory usage", "analyze binary size", "debug performance", or mentions profiling, samply, heaptrack, flame graphs, memory checking, binary size, slow queries, high CPU/memory in Materialize. Also "slow" or "using too much memory" without explicit profile mention.

Source facts

Repository
MaterializeInc/materialize
Last source activity
October 12, 2026 at 10:28
Detected SKILL.md language
English
Stars
6,383
Forks
515

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

Showing SKILL.md

SKILL.md
Source instructions · Read-only preview
name
mz-profile
description
Trigger: "profile Materialize", "check memory usage", "analyze binary size", "debug performance", or mentions profiling, samply, heaptrack, flame graphs, memory checking, binary size, slow queries, high CPU/memory in Materialize. Also "slow" or "using too much memory" without explicit profile mention.
# Profiling Materialize ## CPU profiling Prefer profiling with [samply](https://github.com/mstange/samply), which produces Firefox Profiler-compatible flame graphs. * Attach to a running process: `samply record -p PID` * Record environmentd from startup: `bin/environmentd --wrapper "samply record"` * Record clusterd processes from startup: `bin/environmentd -- --orchestrator-process-wrapper "samply record"` Samply opens a browser tab with an interactive flame graph when recording finishes. On macOS, enable codesigning for Instruments support: `bin/environmentd --enable-mac-codesigning` ### Continuous profiles in cloud environments Observed: Polar Signals offers on-CPU and in-use heap profiles only, no off-CPU profiles, so threads blocked on page faults or IO are invisible. Flame graph root totals are not additive across series. Take absolute load from cAdvisor's `container_cpu_usage_seconds_total` or rusage, and use the profiler only for proportions within it. ## Memory profiling Valgrind doesn't work on Materialize as it's too slow to yield results. Heaptrack works, but is slow. Run heaptrack on environmentd processes: `bin/environmentd --reset --no-default-features --wrapper "heaptrack --raw"` Run heaptrack on clusterd processes: `bin/environmentd --reset --no-default-features -- --orchestrator-process-wrapper "heaptrack --raw"` Use `heaptrack --interpret` on the `.raw.zst` file to analyze. Set `MALLOC_CHECK_=3 MALLOC_PERTURB_=123` (and compile with `--no-default-features` on Linux to use the system allocator instead of jemalloc) to detect some memory corruption issues. ## Analyze the size of binary functions `nm --demangle=rust --print-size --size-sort --radix=d BINARY` to determine the binary size of symbols in `BINARY`. Produces a potentially large output, which should be redirected and analyzed separately. Filter with `cut -d' ' -f2- | sort | sort -k3 | uniq` to just learn about the size of symbols.
View on GitHub