explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9DUI : Making changes to support

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 17.890 1,342.789 ↑ 1.0 1 1

Aggregate (cost=592,018.38..592,018.39 rows=1 width=8) (actual time=1,342.788..1,342.789 rows=1 loops=1)

2. 42.563 1,324.899 ↓ 1.1 59,493 1

Group (cost=577,457.19..591,330.51 rows=55,029 width=41) (actual time=1,061.997..1,324.899 rows=59,493 loops=1)

  • Group Key: l.rpt_orgn_lnp_key, ('Program Selection 2'::text)
3. 51.658 1,282.336 ↑ 1.8 59,493 1

Gather Merge (cost=577,457.19..590,780.22 rows=110,058 width=41) (actual time=1,061.995..1,282.336 rows=59,493 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 85.448 1,230.678 ↑ 2.8 19,831 3 / 3

Group (cost=576,457.16..577,076.78 rows=55,029 width=41) (actual time=1,055.727..1,230.678 rows=19,831 loops=3)

  • Group Key: l.rpt_orgn_lnp_key, 'Program Selection 2'::text
5. 262.733 1,145.230 ↓ 2.2 181,816 3 / 3

Sort (cost=576,457.16..576,663.70 rows=82,615 width=41) (actual time=1,055.724..1,145.230 rows=181,816 loops=3)

  • Sort Key: l.rpt_orgn_lnp_key
  • Sort Method: external merge Disk: 6992kB
6. 87.981 882.497 ↓ 2.2 181,816 3 / 3

Hash Left Join (cost=21,470.50..567,165.45 rows=82,615 width=41) (actual time=104.044..882.497 rows=181,816 loops=3)

  • Hash Cond: (l.orgn_dstr_id = org.orgn_dstr_id)
7. 762.680 792.695 ↑ 1.2 19,831 3 / 3

Parallel Bitmap Heap Scan on rpt_orgn_lnp_backupmay19 l (cost=21,373.25..564,436.31 rows=22,930 width=23) (actual time=102.163..792.695 rows=19,831 loops=3)

  • Recheck Cond: ((ntv_bcast_date >= to_date('10/10/2017'::text, 'mm/dd/yyyy'::text)) AND (ntv_bcast_date <= to_date('04/10/2018'::text, 'mm/dd/yyyy'::text)))
  • Rows Removed by Index Recheck: 276655
  • Filter: ((lnp_release_type_code = ANY ('{1,3}'::numeric[])) AND ((rpt_daypart_code)::text = 'EF'::text) AND (released_for_processing_flg = 'Y'::bpchar) AND (complex_id = '0'::numeric))
  • Rows Removed by Filter: 286395
  • Heap Blocks: exact=19990 lossy=33690
8. 30.015 30.015 ↓ 1.0 918,678 1 / 3

Bitmap Index Scan on idx_rol_ntv_date (cost=0.00..21,359.49 rows=889,905 width=0) (actual time=90.045..90.045 rows=918,678 loops=1)

  • Index Cond: ((ntv_bcast_date >= to_date('10/10/2017'::text, 'mm/dd/yyyy'::text)) AND (ntv_bcast_date <= to_date('04/10/2018'::text, 'mm/dd/yyyy'::text)))
9. 0.975 1.821 ↑ 1.0 2,278 3 / 3

Hash (cost=68.78..68.78 rows=2,278 width=5) (actual time=1.821..1.821 rows=2,278 loops=3)

  • Buckets: 4096 Batches: 1 Memory Usage: 117kB
10. 0.846 0.846 ↑ 1.0 2,278 3 / 3

Seq Scan on national_tv_content_originator org (cost=0.00..68.78 rows=2,278 width=5) (actual time=0.012..0.846 rows=2,278 loops=3)

Planning time : 1.267 ms