explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ddWYm : Making changes to support

Settings
# exclusive inclusive rows x rows loops node
1. 36.036 6,359.599 ↑ 1.0 1 1

Aggregate (cost=2,636,562.53..2,636,562.54 rows=1 width=8) (actual time=6,359.599..6,359.599 rows=1 loops=1)

2. 107.061 6,323.563 ↓ 1.4 119,604 1

Group (cost=2,612,111.48..2,635,529.35 rows=82,654 width=41) (actual time=5,716.962..6,323.563 rows=119,604 loops=1)

  • Group Key: l.rpt_orgn_lnp_key, ('Program Selection 2'::text)
3. 139.095 6,216.502 ↑ 1.1 156,902 1

Gather Merge (cost=2,612,111.48..2,634,702.81 rows=165,308 width=41) (actual time=5,716.960..6,216.502 rows=156,902 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 176.698 6,077.407 ↑ 1.6 52,301 3 / 3

Group (cost=2,611,111.46..2,614,622.14 rows=82,654 width=41) (actual time=5,711.304..6,077.407 rows=52,301 loops=3)

  • Group Key: l.rpt_orgn_lnp_key, 'Program Selection 2'::text
5. 488.279 5,900.709 ↑ 1.3 366,834 3 / 3

Sort (cost=2,611,111.46..2,612,281.69 rows=468,091 width=41) (actual time=5,711.302..5,900.709 rows=366,834 loops=3)

  • Sort Key: l.rpt_orgn_lnp_key
  • Sort Method: external merge Disk: 13872kB
6. 5,161.599 5,412.430 ↑ 1.3 366,834 3 / 3

Parallel Bitmap Heap Scan on rpt_orgn_lnp_itn_new_mv l (cost=294,728.63..2,552,623.14 rows=468,091 width=41) (actual time=763.979..5,412.430 rows=366,834 loops=3)

  • Recheck Cond: ((ntv_bcast_date >= to_date('10/10/2017'::text, 'mm/dd/yyyy'::text)) AND (ntv_bcast_date <= to_date('10/10/2018'::text, 'mm/dd/yyyy'::text)))
  • Rows Removed by Index Recheck: 1140797
  • Filter: ((rpt_daypart_code)::text = 'EF'::text)
  • Rows Removed by Filter: 4232677
  • Heap Blocks: exact=18572 lossy=210175
7. 250.831 250.831 ↑ 1.0 13,798,533 1 / 3

Bitmap Index Scan on idx_rolmv_ntv_date (cost=0.00..294,447.78 rows=14,042,721 width=0) (actual time=752.492..752.492 rows=13,798,533 loops=1)

  • Index Cond: ((ntv_bcast_date >= to_date('10/10/2017'::text, 'mm/dd/yyyy'::text)) AND (ntv_bcast_date <= to_date('10/10/2018'::text, 'mm/dd/yyyy'::text)))