explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sutK

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=13,032,073.90..13,033,768.46 rows=8,891,067 width=1,967) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=13,032,073.46..13,032,075.46 rows=200 width=8) (actual rows= loops=)

  • Group Key: r.id
3. 0.000 0.000 ↓ 0.0

CTE Scan on r (cost=12,812,862.07..12,947,761.39 rows=6,744,966 width=8) (actual rows= loops=)

4.          

CTE r

5. 0.000 0.000 ↓ 0.0

Recursive Union (cost=0.44..12,812,862.07 rows=6,744,966 width=1,967) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using index_workflow_histories_on_fiber_id on workflow_histories workflow_histories_1 (cost=0.44..224.32 rows=166 width=1,967) (actual rows= loops=)

  • Index Cond: (fiber_id = 2539741)
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..1,267,773.84 rows=674,480 width=1,967) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

WorkTable Scan on r r_1 (cost=0.00..33.20 rows=1,660 width=8) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using index_workflow_histories_on_parent_fiber_id on workflow_histories workflow_histories_2 (cost=0.56..759.64 rows=406 width=1,967) (actual rows= loops=)

  • Index Cond: (parent_fiber_id = r_1.fiber_id)
10. 0.000 0.000 ↓ 0.0

Index Scan using workflow_histories_pkey on workflow_histories (cost=0.44..8.46 rows=1 width=1,967) (actual rows= loops=)

  • Index Cond: (id = r.id)