materialized-view

Installation
SKILL.md

Materialized View Troubleshooting

Investigation guide for async MV refresh failures, refresh timeouts, MV inactivation, query rewrite failures, and sync MV optimization.

Five root causes account for the vast majority of cases:

  • Cause A — refresh OOM (memory exhaustion during materialization)
  • Cause B — refresh timeout (SQL takes longer than configured limit)
  • Cause C — MV inactive (base table schema change or manual deactivation)
  • Cause D — query rewrite not used (structural mismatch, staleness, or disabled)
  • Cause E — schedule persistence issue (FE restart breaks scheduler timing)

Metric Taxonomy — Read This First

Before using any metrics, understand the three observability layers:

Installs
6
GitHub Stars
78
First Seen
Jun 3, 2026