explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VHEw

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 10,362.011 ↑ 26.0 1 1

Finalize GroupAggregate (cost=2,391,662.72..2,391,669.44 rows=26 width=25) (actual time=10,362.010..10,362.011 rows=1 loops=1)

  • Group Key: ozc.tgt_org_unit_id
2. 7.144 10,364.761 ↑ 17.3 3 1

Gather Merge (cost=2,391,662.72..2,391,668.79 rows=52 width=25) (actual time=10,362.003..10,364.761 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.028 10,357.617 ↑ 26.0 1 3 / 3

Sort (cost=2,390,662.70..2,390,662.76 rows=26 width=25) (actual time=10,357.617..10,357.617 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. 55.586 10,357.589 ↑ 26.0 1 3 / 3

Partial HashAggregate (cost=2,390,661.83..2,390,662.09 rows=26 width=25) (actual time=10,357.589..10,357.589 rows=1 loops=3)

  • Group Key: ozc.tgt_org_unit_id
5. 3,694.943 10,302.003 ↑ 2.1 186,605 3 / 3

Hash Join (cost=17.72..2,387,759.58 rows=386,966 width=25) (actual time=0.628..10,302.003 rows=186,605 loops=3)

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

Parallel Seq Scan on atdntd_reg_vehicle_exp vr (cost=0.00..1,917,774.60 rows=46,609,760 width=22) (actual time=0.114..6,606.890 rows=37,288,343 loops=3)

7. 0.048 0.170 ↑ 1.0 249 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
8. 0.122 0.122 ↑ 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.058..0.122 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.429 ms
Execution time : 10,364.837 ms