explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YJWI

Settings
# exclusive inclusive rows x rows loops node
1. 31.534 1,796.995 ↑ 1.0 1 1

Aggregate (cost=607,288.00..607,288.01 rows=1 width=8) (actual time=1,796.994..1,796.995 rows=1 loops=1)

2. 79.727 1,765.461 ↓ 1.1 119,604 1

Group (cost=594,125.87..605,869.58 rows=113,474 width=41) (actual time=1,539.444..1,765.461 rows=119,604 loops=1)

  • Group Key: l.rpt_orgn_lnp_key, ('Program Selection 2'::text)
3. 104.661 1,685.734 ↓ 1.3 119,604 1

Gather Merge (cost=594,125.87..605,396.71 rows=94,574 width=41) (actual time=1,539.439..1,685.734 rows=119,604 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 31.814 1,581.073 ↑ 1.2 39,868 3 / 3

Group (cost=593,125.85..593,480.50 rows=47,287 width=41) (actual time=1,536.369..1,581.073 rows=39,868 loops=3)

  • Group Key: l.rpt_orgn_lnp_key, 'Program Selection 2'::text
5. 38.178 1,549.259 ↑ 1.2 39,868 3 / 3

Sort (cost=593,125.85..593,244.06 rows=47,287 width=41) (actual time=1,536.366..1,549.259 rows=39,868 loops=3)

  • Sort Key: l.rpt_orgn_lnp_key
  • Sort Method: quicksort Memory: 4041kB
6. 94.055 1,511.081 ↑ 1.2 39,868 3 / 3

Hash Left Join (cost=44,169.94..589,454.21 rows=47,287 width=41) (actual time=164.853..1,511.081 rows=39,868 loops=3)

  • Hash Cond: (l.orgn_dstr_id = org.orgn_dstr_id)
  • Join Filter: ((l.ntv_bcast_date >= org.effective_start_date) AND (l.ntv_bcast_date <= org.effective_end_date))
  • Rows Removed by Join Filter: 326966
7. 1,364.703 1,415.118 ↑ 1.2 39,868 3 / 3

Parallel Bitmap Heap Scan on rpt_orgn_lnp_backupmay19 l (cost=44,072.69..583,077.54 rows=47,287 width=27) (actual time=162.897..1,415.118 rows=39,868 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: 446836
  • 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: 582775
  • Heap Blocks: exact=18781 lossy=66013
8. 50.415 50.415 ↓ 1.0 1,867,928 1 / 3

Bitmap Index Scan on idx_rol_ntv_date (cost=0.00..44,044.32 rows=1,835,188 width=0) (actual time=151.244..151.245 rows=1,867,928 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)))
9. 1.008 1.908 ↑ 1.0 2,278 3 / 3

Hash (cost=68.78..68.78 rows=2,278 width=13) (actual time=1.907..1.908 rows=2,278 loops=3)

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

Seq Scan on national_tv_content_originator org (cost=0.00..68.78 rows=2,278 width=13) (actual time=0.011..0.900 rows=2,278 loops=3)