explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XXnK

Settings
# exclusive inclusive rows x rows loops node
1. 79.137 186.745 ↓ 0.0 0 1

Hash Join (cost=12.60..5,044.29 rows=403 width=4) (actual time=186.745..186.745 rows=0 loops=1)

  • Hash Cond: (wftlt.lead_time_id = wfelt.lead_time_id)
2. 96.070 96.070 ↑ 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.007..96.070 rows=122,409 loops=1)

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

Hash (cost=12.59..12.59 rows=1 width=8) (actual time=11.537..11.538 rows=194 loops=1)

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

Merge Join (cost=10.49..12.59 rows=1 width=8) (actual time=10.547..11.394 rows=194 loops=1)

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

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

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

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

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