explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nKDk : Making changes to support

Settings
# exclusive inclusive rows x rows loops node
1. 42.805 1,322.004 ↓ 1.1 59,493 1

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

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

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 87.754 1,236.078 ↑ 2.8 19,831 3 / 3

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

  • Group Key: l.rpt_orgn_lnp_key, 'Program Selection 2'::text
4. 252.604 1,148.324 ↓ 2.2 181,816 3 / 3

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

  • Sort Key: l.rpt_orgn_lnp_key
  • Sort Method: external merge Disk: 6872kB
5. 86.243 895.720 ↓ 2.2 181,816 3 / 3

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

  • Hash Cond: (l.orgn_dstr_id = org.orgn_dstr_id)
6. 776.333 807.013 ↑ 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=103.802..807.013 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=19348 lossy=32629
7. 30.680 30.680 ↓ 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=92.040..92.041 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)))
8. 1.350 2.464 ↑ 1.0 2,278 3 / 3

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

  • Buckets: 4096 Batches: 1 Memory Usage: 117kB
9. 1.114 1.114 ↑ 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..1.114 rows=2,278 loops=3)