explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pbs8

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 39,968.114 ↓ 0.0 0 1

Merge Semi Join (cost=47.74..224.71 rows=3 width=935) (actual time=39,968.114..39,968.114 rows=0 loops=1)

  • Merge Cond: (action.id = wfelt.entity_id)
2. 0.024 0.024 ↑ 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.023..0.024 rows=1 loops=1)

3. 17,260.291 39,968.087 ↓ 0.0 0 1

Nested Loop (cost=9.49..6,109.71 rows=482 width=8) (actual time=39,968.086..39,968.087 rows=0 loops=1)

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

Merge Join (cost=9.49..10.71 rows=1 width=12) (actual time=15.658..17.944 rows=194 loops=1)

  • Merge Cond: (wfelt.entity_id = action_1.id)
5. 10.744 10.744 ↑ 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..201.94 rows=9,189 width=8) (actual time=0.042..10.744 rows=8,049 loops=1)

  • Index Cond: (entity_type_id = 18)
  • Heap Fetches: 499
6. 0.101 0.359 ↓ 1.5 25 1

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

  • Sort Key: action_1.id
  • Sort Method: quicksort Memory: 26kB
7. 0.258 0.258 ↓ 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.047..0.258 rows=25 loops=1)

  • Index Cond: (client_id = 1,003)
  • Filter: (NOT deleted)
8. 22,689.852 22,689.852 ↑ 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.004..116.958 rows=122,409 loops=194)

  • Filter: (lead_time_type = 3)
  • Rows Removed by Filter: 7,667
Planning time : 5.755 ms
Execution time : 39,968.410 ms