explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eXpF : Optimization for: Making changes to support; plan #9DUI

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 36.779 2,460.231 ↑ 1.0 1 1

Aggregate (cost=639,675.46..639,675.47 rows=1 width=8) (actual time=2,460.231..2,460.231 rows=1 loops=1)

2. 90.941 2,423.452 ↓ 1.1 119,604 1

Group (cost=609,649.09..638,257.04 rows=113,474 width=41) (actual time=1,888.374..2,423.452 rows=119,604 loops=1)

  • Group Key: l.rpt_orgn_lnp_key, ('Program Selection 2'::text)
3. 87.123 2,332.511 ↑ 1.9 119,604 1

Gather Merge (cost=609,649.09..637,122.30 rows=226,948 width=41) (actual time=1,888.370..2,332.511 rows=119,604 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 175.304 2,245.388 ↑ 2.8 39,868 3 / 3

Group (cost=608,649.07..609,926.85 rows=113,474 width=41) (actual time=1,882.965..2,245.388 rows=39,868 loops=3)

  • Group Key: l.rpt_orgn_lnp_key, 'Program Selection 2'::text
5. 469.335 2,070.084 ↓ 2.2 366,834 3 / 3

Sort (cost=608,649.07..609,075.00 rows=170,370 width=41) (actual time=1,882.963..2,070.084 rows=366,834 loops=3)

  • Sort Key: l.rpt_orgn_lnp_key
  • Sort Method: external merge Disk: 13928kB
6. 163.440 1,600.749 ↓ 2.2 366,834 3 / 3

Hash Left Join (cost=44,169.94..588,602.36 rows=170,370 width=41) (actual time=167.133..1,600.749 rows=366,834 loops=3)

  • Hash Cond: (l.orgn_dstr_id = org.orgn_dstr_id)
7. 1,384.319 1,435.471 ↑ 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=23) (actual time=165.231..1,435.471 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=19539 lossy=65973
8. 51.152 51.152 ↓ 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=153.455..153.455 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. 0.996 1.838 ↑ 1.0 2,278 3 / 3

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

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

Planning time : 1.800 ms