explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Sr9 : After MV

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 14,272.464 ↑ 26.0 1 1

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

  • Group Key: ozc.tgt_org_unit_id
2. 7.926 14,275.030 ↑ 17.3 3 1

Gather Merge (cost=2,391,662.72..2,391,668.79 rows=52 width=25) (actual time=14,272.454..14,275.030 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.077 14,267.104 ↑ 26.0 1 3 / 3

Sort (cost=2,390,662.70..2,390,662.76 rows=26 width=25) (actual time=14,267.103..14,267.104 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. 58.656 14,267.027 ↑ 26.0 1 3 / 3

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

  • Group Key: ozc.tgt_org_unit_id
5. 3,722.191 14,208.371 ↑ 2.1 186,605 3 / 3

Hash Join (cost=17.72..2,387,759.58 rows=386,966 width=25) (actual time=0.673..14,208.371 rows=186,605 loops=3)

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

7. 0.079 0.212 ↑ 1.0 249 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 21kB
8. 0.133 0.133 ↑ 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.062..0.133 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.287 ms
Execution time : 14,275.128 ms