explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 078k

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 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. 0.000 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)

4. 1,850.260 1,850.260 ↑ 1.0 1 1

Wo"Aggregate (cost=592,341.12..592,341.13 rows=1 width=8) (actual time=1,850.251..1,850.260 rows=1 loops=1)

5. 80.868 1,818.777 ↓ 1.1 119,604 1

Group (cost=579,178.69..590,922.64 rows=113,478 width=41) (actual time=1,591.627..1,818.777 rows=119,604 loops=1)

  • Group Key: l.rpt_orgn_lnp_key, ('Program Selection 2'::text)
6. 0.000 1,737.909 ↓ 1.3 119,604 1

Gather Merge (cost=579,178.69..590,449.76 rows=94,576 width=41) (actual time=1,591.625..1,737.909 rows=119,604 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Workers Launched: 2
7. 31.012 1,624.875 ↑ 1.2 39,868 3 / 3

Group (cost=578,178.66..578,533.32 rows=47,288 width=41) (actual time=1,581.009..1,624.875 rows=39,868 loops=3)

  • Group Key: l.rpt_orgn_lnp_key, 'Program Selection 2'::text
8. 43.138 1,593.863 ↑ 1.2 39,868 3 / 3

Sort (cost=578,178.66..578,296.88 rows=47,288 width=41) (actual time=1,581.007..1,593.863 rows=39,868 loops=3)

  • Sort Key: l.rpt_orgn_lnp_key
  • Sort Method: external merge Disk: 1568kB
9. 99.290 1,550.725 ↑ 1.2 39,868 3 / 3

Hash Left Join (cost=32,728.88..574,506.94 rows=47,288 width=41) (actual time=147.591..1,550.725 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
10. 1,404.704 1,449.497 ↑ 1.2 39,868 3 / 3

Parallel Bitmap Heap Scan on rpt_orgn_lnp_backupmay19 l (cost=32,631.62..568,130.13 rows=47,288 width=27) (actual time=145.607..1,449.497 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)) AND (released_for_processing_flg = 'Y'::bpchar) AND (lnp_release_type_code = ANY ('{1,3}'::numeric[])) AND (complex_id = '0'::numeric))
  • Rows Removed by Index Recheck: 382617
  • Filter: ((rpt_daypart_code)::text = 'EF'::text)
  • Rows Removed by Filter: 489203
  • Heap Blocks: exact=19858 lossy=56153
11. 44.793 44.793 ↓ 1.0 1,587,213 1 / 3

Bitmap Index Scan on idx_rol_ntv_date (cost=0.00..32,603.25 rows=1,554,681 width=0) (actual time=134.379..134.379 rows=1,587,213 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)))
12. 1.035 1.938 ↑ 1.0 2,278 3 / 3

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

  • Buckets: 4096 Batches: 1 Memory Usage: 139kB
13. 0.903 0.903 ↑ 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.903 rows=2,278 loops=3)

14. 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
15. 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
16. 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
17. 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
18. 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)))
19. 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
20. 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)

Planning time : 1.219 ms