explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tced

Settings
# exclusive inclusive rows x rows loops node
1. 31.585 1,866.686 ↑ 1.0 1 1

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

2. 79.395 1,835.101 ↓ 1.1 119,604 1

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

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

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

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

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

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

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

  • Sort Key: l.rpt_orgn_lnp_key
  • Sort Method: quicksort Memory: 4084kB
6. 98.727 1,578.113 ↑ 1.2 39,868 3 / 3

Hash Left Join (cost=32,728.88..574,506.94 rows=47,288 width=41) (actual time=154.909..1,578.113 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,430.582 1,477.450 ↑ 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=152.918..1,477.450 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=19710 lossy=55726
8. 46.868 46.868 ↓ 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=140.604..140.604 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.038 1.936 ↑ 1.0 2,278 3 / 3

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

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