explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WaQg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 10,799.147 ↑ 1.0 25 1

Finalize GroupAggregate (cost=2,393,759.32..2,393,766.03 rows=26 width=25) (actual time=10,799.113..10,799.147 rows=25 loops=1)

  • Group Key: ozc.tgt_org_unit_id
2. 140.516 10,934.816 ↓ 1.4 75 1

Gather Merge (cost=2,393,759.32..2,393,765.38 rows=52 width=25) (actual time=10,799.102..10,934.816 rows=75 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.062 10,794.300 ↑ 1.0 25 3 / 3

Sort (cost=2,392,759.29..2,392,759.36 rows=26 width=25) (actual time=10,794.299..10,794.300 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. 79.762 10,794.238 ↑ 1.0 25 3 / 3

Partial HashAggregate (cost=2,392,758.42..2,392,758.68 rows=26 width=25) (actual time=10,794.234..10,794.238 rows=25 loops=3)

  • Group Key: ozc.tgt_org_unit_id
5. 3,802.187 10,714.476 ↑ 1.9 269,616 3 / 3

Hash Join (cost=20.11..2,388,964.37 rows=505,873 width=25) (actual time=0.521..10,714.476 rows=269,616 loops=3)

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

Parallel Seq Scan on atdntd_reg_vehicle_exp vr (cost=0.00..1,917,781.27 rows=46,610,427 width=22) (actual time=0.052..6,912.051 rows=37,288,343 loops=3)

7. 0.063 0.238 ↑ 1.0 325 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 22kB
8. 0.175 0.175 ↑ 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.030..0.175 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.512 ms
Execution time : 10,934.953 ms