explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NXhg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 9,353.803 ↑ 1.0 25 1

Finalize GroupAggregate (cost=2,393,732.03..2,393,738.75 rows=26 width=25) (actual time=9,353.769..9,353.803 rows=25 loops=1)

  • Group Key: ozc.tgt_org_unit_id
2. 134.419 9,484.102 ↓ 1.4 75 1

Gather Merge (cost=2,393,732.03..2,393,738.10 rows=52 width=25) (actual time=9,353.760..9,484.102 rows=75 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.062 9,349.683 ↑ 1.0 25 3 / 3

Sort (cost=2,392,732.01..2,392,732.07 rows=26 width=25) (actual time=9,349.682..9,349.683 rows=25 loops=3)

  • Sort Key: ozc.tgt_org_unit_id
  • Sort Method: quicksort Memory: 26kB
  • Worker 0: Sort Method: quicksort Memory: 26kB
  • Worker 1: Sort Method: quicksort Memory: 26kB
4. 75.922 9,349.621 ↑ 1.0 25 3 / 3

Partial HashAggregate (cost=2,392,731.14..2,392,731.40 rows=26 width=25) (actual time=9,349.617..9,349.621 rows=25 loops=3)

  • Group Key: ozc.tgt_org_unit_id
5. 4,128.124 9,273.699 ↑ 1.9 269,616 3 / 3

Hash Join (cost=20.11..2,388,943.07 rows=505,076 width=25) (actual time=0.419..9,273.699 rows=269,616 loops=3)

  • Hash Cond: (vr.zip_code = (ozc.zip_code)::text)
6. 5,145.361 5,145.361 ↑ 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.059..5,145.361 rows=37,288,343 loops=3)

7. 0.059 0.214 ↑ 1.0 325 3 / 3

Hash (cost=16.05..16.05 rows=325 width=15) (actual time=0.214..0.214 rows=325 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
8. 0.155 0.155 ↑ 1.0 325 3 / 3

Seq Scan on market_zip_code_org ozc (cost=0.00..16.05 rows=325 width=15) (actual time=0.026..0.155 rows=325 loops=3)

  • Filter: ((tgt_org_level_number = 2) AND ((src_org_unit_id)::text = 'Organization-1'::text) AND ((client_id)::text = '1'::text))
  • Rows Removed by Filter: 249
Planning time : 0.393 ms
Execution time : 9,484.201 ms