explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kncL

Settings
# exclusive inclusive rows x rows loops node
1. 151,014.183 219,596.729 ↓ 1,405,191,040.0 1,405,191,040 1

Gather Motion 24:1 (slice2; segments: 24) (cost=0.00..874.90 rows=1 width=8) (actual time=44,790.422..219,596.729 rows=1,405,191,040 loops=1)

  • (slice0) Executor memory: 183K bytes.
  • (slice1) Executor memory: 58K bytes avg x 24 workers, 58K bytes max (seg0).
  • (slice2) Executor memory: 385,144K bytes avg x 24 workers, 385144K bytes max (seg0). Work_mem: 208,093K bytes max. Memory used: 2,457,600kB Optimizer: Pivotal Optimizer (GPORCA)
2. 23,683.780 68,582.546 ↓ 59,051,886.0 59,051,886 1

Hash Join (cost=0.00..874.90 rows=1 width=8) (actual time=44,714.451..68,582.546 rows=59,051,886 loops=1)

  • Hash Cond: (s_art_ext.art_grp_vend_lvl_0_id = t_osa_whs3.art_grp_vend_lvl_0_id)
  • Extra Text: (seg21) Hash chain length 595.1 avg, 4999 max, using 11189 of 8388608 buckets.
3. 789.767 789.767 ↓ 1.0 34,568 1

Seq Scan on s_art_ext (cost=0.00..437.26 rows=34,290 width=8) (actual time=170.651..789.767 rows=34,568 loops=1)

4. 5,477.853 44,108.999 ↓ 6,658,945.0 6,658,945 1

Hash (cost=431.00..431.00 rows=1 width=8) (actual time=44,108.999..44,108.999 rows=6,658,945 loops=1)

5. 29,229.107 38,631.146 ↓ 6,658,945.0 6,658,945 1

Broadcast Motion 24:24 (slice1; segments: 24) (cost=0.00..431.00 rows=1 width=8) (actual time=0.087..38,631.146 rows=6,658,945 loops=1)

6. 9,402.039 9,402.039 ↓ 278,717.0 278,717 1

Seq Scan on t_osa_whs3 (cost=0.00..431.00 rows=1 width=8) (actual time=0.038..9,402.039 rows=278,717 loops=1)

Planning time : 41.804 ms
Execution time : 272,533.967 ms