explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P7aP

Settings
# exclusive inclusive rows x rows loops node
1. 81.349 193.591 ↓ 0.0 0 1

Hash Join (cost=10.72..5,042.39 rows=482 width=4) (actual time=193.590..193.591 rows=0 loops=1)

  • Hash Cond: (wftlt.lead_time_id = wfelt.lead_time_id)
2. 100.233 100.233 ↑ 1.0 122,409 1

Seq Scan on work_flow_task_lead_time wftlt (cost=0.00..4,567.95 rows=122,484 width=4) (actual time=0.008..100.233 rows=122,409 loops=1)

  • Filter: (lead_time_type = 3)
  • Rows Removed by Filter: 7,667
3. 0.142 12.009 ↓ 194.0 194 1

Hash (cost=10.71..10.71 rows=1 width=8) (actual time=12.008..12.009 rows=194 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
4. 5.312 11.867 ↓ 194.0 194 1

Merge Join (cost=9.49..10.71 rows=1 width=8) (actual time=10.988..11.867 rows=194 loops=1)

  • Merge Cond: (wfelt.entity_id = action.id)
5. 6.453 6.453 ↑ 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.011..6.453 rows=8,049 loops=1)

  • Index Cond: (entity_type_id = 18)
  • Heap Fetches: 400
6. 0.044 0.102 ↓ 1.5 25 1

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

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

Index Scan using action_item_mgmt_client_id_idx on action_item_mgmt action (cost=0.28..7.51 rows=17 width=4) (actual time=0.008..0.058 rows=25 loops=1)

  • Index Cond: (client_id = 1,003)
  • Filter: (NOT deleted)
Planning time : 0.515 ms
Execution time : 193.642 ms