explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eVSN

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 0.229 ↑ 23.8 12 1

Sort (cost=68,335.66..68,336.38 rows=286 width=1,967) (actual time=0.223..0.229 rows=12 loops=1)

  • Sort Key: workflow_histories.id
  • Sort Method: quicksort Memory: 49kB
2. 0.020 0.203 ↑ 23.8 12 1

Nested Loop (cost=66,628.93..68,323.99 rows=286 width=1,967) (actual time=0.159..0.203 rows=12 loops=1)

3. 0.013 0.111 ↑ 16.7 12 1

HashAggregate (cost=66,628.49..66,630.49 rows=200 width=8) (actual time=0.106..0.111 rows=12 loops=1)

  • Group Key: r.id
4. 0.098 0.098 ↑ 2,727.2 12 1

CTE Scan on r (cost=65,564.90..66,219.42 rows=32,726 width=8) (actual time=0.021..0.098 rows=12 loops=1)

5.          

CTE r

6. 0.012 0.076 ↑ 2,727.2 12 1

Recursive Union (cost=0.44..65,564.90 rows=32,726 width=1,967) (actual time=0.017..0.076 rows=12 loops=1)

7. 0.025 0.025 ↑ 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.016..0.025 rows=12 loops=1)

  • Index Cond: (fiber_id = 2539741)
8. 0.010 0.039 ↓ 0.0 0 1

Nested Loop (cost=0.56..6,468.61 rows=3,256 width=1,967) (actual time=0.039..0.039 rows=0 loops=1)

9. 0.005 0.005 ↓ 1.5 12 1

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

  • Filter: (case_file_id = 418653)
10. 0.024 0.024 ↓ 0.0 0 12

Index Scan using index_workflow_histories_on_parent_fiber_id on workflow_histories workflow_histories_2 (cost=0.56..799.84 rows=407 width=1,967) (actual time=0.002..0.002 rows=0 loops=12)

  • Index Cond: (parent_fiber_id = r_1.fiber_id)
11. 0.072 0.072 ↑ 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.006..0.006 rows=1 loops=12)

  • Index Cond: (id = r.id)
  • Filter: (case_file_id = 418653)
Planning time : 0.463 ms
Execution time : 0.309 ms