explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dbBU

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 746.257 ↑ 1.0 1 1

Finalize Aggregate (cost=575,560.18..575,560.19 rows=1 width=8) (actual time=746.257..746.257 rows=1 loops=1)

2. 9.125 751.699 ↓ 1.5 3 1

Gather (cost=575,559.97..575,560.18 rows=2 width=8) (actual time=745.120..751.699 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 10.789 742.574 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=574,559.97..574,559.98 rows=1 width=8) (actual time=742.573..742.574 rows=1 loops=3)

4. 102.200 731.785 ↓ 2.1 39,868 3 / 3

Hash Join (cost=32,734.57..574,512.64 rows=18,931 width=0) (actual time=222.377..731.785 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
5. 573.230 627.555 ↑ 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=15) (actual time=220.286..627.555 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))
  • Filter: ((rpt_daypart_code)::text = 'EF'::text)
  • Rows Removed by Filter: 489203
  • Heap Blocks: exact=75829
6. 54.325 54.325 ↓ 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=162.974..162.975 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)))
7. 0.973 2.030 ↑ 1.0 2,278 3 / 3

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

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

Seq Scan on national_tv_content_originator org (cost=0.00..74.47 rows=2,278 width=13) (actual time=0.008..1.057 rows=2,278 loops=3)

  • Filter: (released_for_processing_flag = 'Y'::bpchar)