explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cZZE

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

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

  • Group Key: ozc.tgt_org_unit_id
2. 136.628 10,196.509 ↑ 17.3 3 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.033 10,059.881 ↑ 26.0 1 3 / 3

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

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

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

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

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

7. 0.045 0.249 ↑ 1.0 249 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 21kB
8. 0.204 0.204 ↑ 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.109..0.204 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.606 ms
Execution time : 10,196.662 ms