explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sM6yV

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 1.568 ↑ 740,511.9 12 1

Nested Loop (cost=66,527.61..68,222.18 rows=8,886,143 width=1,967) (actual time=1.507..1.568 rows=12 loops=1)

2. 0.019 1.099 ↑ 16.7 12 1

HashAggregate (cost=66,527.18..66,529.18 rows=200 width=8) (actual time=1.094..1.099 rows=12 loops=1)

  • Group Key: r.id
3. 1.080 1.080 ↑ 2,721.3 12 1

CTE Scan on r (cost=65,465.86..66,118.98 rows=32,656 width=8) (actual time=0.103..1.080 rows=12 loops=1)

4.          

CTE r

5. 0.013 1.033 ↑ 2,721.3 12 1

Recursive Union (cost=0.44..65,465.86 rows=32,656 width=1,967) (actual time=0.098..1.033 rows=12 loops=1)

6. 0.567 0.567 ↑ 13.8 12 1

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 time=0.096..0.567 rows=12 loops=1)

  • Index Cond: (fiber_id = 2539741)
7. 0.010 0.453 ↓ 0.0 0 1

Nested Loop (cost=0.56..6,458.84 rows=3,249 width=1,967) (actual time=0.453..0.453 rows=0 loops=1)

8. 0.011 0.011 ↓ 1.5 12 1

WorkTable Scan on r r_1 (cost=0.00..37.35 rows=8 width=8) (actual time=0.006..0.011 rows=12 loops=1)

  • Filter: (case_file_id = 418653)
9. 0.432 0.432 ↓ 0.0 0 12

Index Scan using index_workflow_histories_on_parent_fiber_id on workflow_histories workflow_histories_2 (cost=0.56..798.63 rows=406 width=1,967) (actual time=0.036..0.036 rows=0 loops=12)

  • Index Cond: (parent_fiber_id = r_1.fiber_id)
10. 0.456 0.456 ↑ 1.0 1 12

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

  • Index Cond: (id = r.id)
Planning time : 1.589 ms
Execution time : 1.700 ms