explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EnX8

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

Finalize GroupAggregate (cost=2,391,664.16..2,391,670.87 rows=26 width=25) (actual time=10,848.783..10,848.784 rows=1 loops=1)

  • Group Key: ozc.tgt_org_unit_id
2. 138.977 10,982.488 ↑ 17.3 3 1

Gather Merge (cost=2,391,664.16..2,391,670.22 rows=52 width=25) (actual time=10,848.774..10,982.488 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.036 10,843.511 ↑ 26.0 1 3 / 3

Sort (cost=2,390,664.13..2,390,664.20 rows=26 width=25) (actual time=10,843.511..10,843.511 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.780 10,843.475 ↑ 26.0 1 3 / 3

Partial HashAggregate (cost=2,390,663.26..2,390,663.52 rows=26 width=25) (actual time=10,843.475..10,843.475 rows=1 loops=3)

  • Group Key: ozc.tgt_org_unit_id
5. 4,216.091 10,787.695 ↑ 2.1 186,605 3 / 3

Hash Join (cost=19.16..2,387,761.02 rows=386,966 width=25) (actual time=0.372..10,787.695 rows=186,605 loops=3)

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

7. 0.064 0.286 ↑ 1.0 249 3 / 3

Hash (cost=16.05..16.05 rows=249 width=15) (actual time=0.285..0.286 rows=249 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
8. 0.222 0.222 ↑ 1.0 249 3 / 3

Seq Scan on market_zip_code_org ozc (cost=0.00..16.05 rows=249 width=15) (actual time=0.119..0.222 rows=249 loops=3)

  • Filter: ((tgt_org_level_number = 1) AND ((src_org_unit_id)::text = 'Organization-1'::text) AND ((client_id)::text = '1'::text))
  • Rows Removed by Filter: 325
Planning time : 0.691 ms
Execution time : 10,982.653 ms