explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X1BD

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 32,981.340 ↓ 0.0 0 1

Merge Semi Join (cost=41.05..222.97 rows=2 width=935) (actual time=32,981.339..32,981.340 rows=0 loops=1)

  • Merge Cond: (action.id = wfelt.entity_id)
2. 0.009 0.009 ↑ 746.0 1 1

Index Scan using action_item_mgmt_id_idx on action_item_mgmt action (cost=0.28..150.03 rows=746 width=935) (actual time=0.008..0.009 rows=1 loops=1)

3. 14,831.229 32,981.327 ↓ 0.0 0 1

Nested Loop (cost=10.49..6,111.59 rows=403 width=8) (actual time=32,981.327..32,981.327 rows=0 loops=1)

  • Join Filter: (wfelt.lead_time_id = wftlt.lead_time_id)
  • Rows Removed by Join Filter: 23,747,346
4. 5.680 12.650 ↓ 194.0 194 1

Merge Join (cost=10.49..12.59 rows=1 width=12) (actual time=10.411..12.650 rows=194 loops=1)

  • Merge Cond: (wfelt.entity_id = action_1.id)
5. 6.830 6.830 ↓ 1.1 8,049 1

Index Only Scan using idx_work_flow_entity_lead_time_1 on work_flow_entity_lead_time wfelt (cost=0.43..441.97 rows=7,559 width=8) (actual time=0.011..6.830 rows=8,049 loops=1)

  • Index Cond: (entity_type_id = 18)
  • Heap Fetches: 610
6. 0.080 0.140 ↓ 1.5 25 1

Sort (cost=7.86..7.90 rows=17 width=4) (actual time=0.086..0.140 rows=25 loops=1)

  • Sort Key: action_1.id
  • Sort Method: quicksort Memory: 26kB
7. 0.060 0.060 ↓ 1.5 25 1

Index Scan using action_item_mgmt_client_id_idx on action_item_mgmt action_1 (cost=0.28..7.51 rows=17 width=4) (actual time=0.009..0.060 rows=25 loops=1)

  • Index Cond: (client_id = 1,003)
  • Filter: (NOT deleted)
8. 18,137.448 18,137.448 ↑ 1.0 122,409 194

Seq Scan on work_flow_task_lead_time wftlt (cost=0.00..4,567.95 rows=122,484 width=4) (actual time=0.003..93.492 rows=122,409 loops=194)

  • Filter: (lead_time_type = 3)
  • Rows Removed by Filter: 7,667
Planning time : 0.850 ms
Execution time : 32,981.425 ms