Investigate slow runs
Outcome
You see which models or tests took the longest in a run and can explore execution timelines interactively.
When to use this
| Surface | Use when |
|---|---|
| CLI | query-executions for sorted durations or CSV/JSON export |
| MCP | Skip unless a coding agent will run many execution queries |
| Web | Primary surface—Timeline (sequencing) and Runs (table) |
Steps
- Confirm artifacts with Check run health.
- Start the web UI and open the URL printed in the terminal (default
http://127.0.0.1:3000). - Open
?view=timelinefor Gantt-style order and critical path; open?view=runsfor a filterable execution list. - Use CLI
query-executionsfor a scripted top-N list.
Example
bash
npx @dbt-tools/web --dbt-target ./targettext
http://127.0.0.1:3000/?view=timeline
http://127.0.0.1:3000/?view=runsbash
dbt-tools query-executions --dbt-target ./target --sort execution_time_desc --limit 20 --jsonNext
- Investigation tour
- Web getting started
- CLI README — query-executions filters