explain.depesz.com

PostgreSQL's explain analyze made readable

Result: loi9

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 12,588.981 ↑ 26.0 1 1

Finalize GroupAggregate (cost=2,391,622.38..2,391,629.10 rows=26 width=25) (actual time=12,588.980..12,588.981 rows=1 loops=1)

  • Group Key: ozc.tgt_org_unit_id
2. 126.152 12,709.485 ↑ 17.3 3 1

Gather Merge (cost=2,391,622.38..2,391,628.45 rows=52 width=25) (actual time=12,588.971..12,709.485 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.027 12,583.333 ↑ 26.0 1 3 / 3

Sort (cost=2,390,622.36..2,390,622.42 rows=26 width=25) (actual time=12,583.333..12,583.333 rows=1 loops=3)

  • Sort Key: ozc.tgt_org_unit_id
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
4. 80.496 12,583.306 ↑ 26.0 1 3 / 3

Partial HashAggregate (cost=2,390,621.49..2,390,621.75 rows=26 width=25) (actual time=12,583.305..12,583.306 rows=1 loops=3)

  • Group Key: ozc.tgt_org_unit_id
5. 4,861.703 12,502.810 ↑ 2.1 186,605 3 / 3

Hash Join (cost=17.72..2,387,726.67 rows=385,975 width=25) (actual time=0.445..12,502.810 rows=186,605 loops=3)

  • Hash Cond: (vr.zip_code = (ozc.zip_code)::text)
6. 7,640.924 7,640.924 ↑ 1.2 37,288,343 3 / 3

Parallel Seq Scan on atdntd_reg_vehicle_exp vr (cost=0.00..1,917,763.10 rows=46,608,610 width=22) (actual time=0.094..7,640.924 rows=37,288,343 loops=3)

7. 0.049 0.183 ↑ 1.0 249 3 / 3

Hash (cost=14.61..14.61 rows=249 width=15) (actual time=0.183..0.183 rows=249 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 21kB
8. 0.134 0.134 ↑ 1.0 249 3 / 3

Seq Scan on market_zip_code_org ozc (cost=0.00..14.61 rows=249 width=15) (actual time=0.062..0.134 rows=249 loops=3)

  • Filter: ((tgt_org_level_number = 1) AND ((src_org_unit_id)::text = 'Organization-1'::text))
  • Rows Removed by Filter: 325
Planning time : 0.434 ms
Execution time : 12,709.578 ms