explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OYeEA

Settings
# exclusive inclusive rows x rows loops node
1. 31.427 1,814.757 ↑ 1.0 1 1

Aggregate (cost=592,341.12..592,341.13 rows=1 width=8) (actual time=1,814.756..1,814.757 rows=1 loops=1)

2. 78.984 1,783.330 ↓ 1.1 119,604 1

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

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

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

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

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

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

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

  • Sort Key: l.rpt_orgn_lnp_key
  • Sort Method: quicksort Memory: 4045kB
6. 95.454 1,530.104 ↑ 1.2 39,868 3 / 3

Hash Left Join (cost=32,728.88..574,506.94 rows=47,288 width=41) (actual time=150.037..1,530.104 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,387.240 1,432.730 ↑ 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=148.067..1,432.730 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=19244 lossy=55105
8. 45.490 45.490 ↓ 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=136.469..136.470 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)))
9. 1.026 1.920 ↑ 1.0 2,278 3 / 3

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

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