explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DQmQ : Making changes to support

Settings
# exclusive inclusive rows x rows loops node
1. 576.041 1,917.764 ↓ 2.7 1,451,917 1

Hash Left Join (cost=59,438.44..638,141.06 rows=541,305 width=67) (actual time=209.711..1,917.764 rows=1,451,917 loops=1)

  • Hash Cond: (l.orgn_dstr_id = org.orgn_dstr_id)
2. 0.000 1,339.863 ↓ 1.1 157,789 1

Gather (cost=59,341.19..620,799.28 rows=150,241 width=43) (actual time=207.835..1,339.863 rows=157,789 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,790.985 1,856.033 ↑ 1.2 52,596 3 / 3

Parallel Bitmap Heap Scan on rpt_orgn_lnp_backupmay19 l (cost=58,341.19..604,775.18 rows=62,600 width=43) (actual time=205.353..1,856.033 rows=52,596 loops=3)

  • Recheck Cond: ((ntv_bcast_date >= to_date('10/01/2017'::text, 'mm/dd/yyyy'::text)) AND (ntv_bcast_date <= to_date('01/28/2019'::text, 'mm/dd/yyyy'::text)))
  • Rows Removed by Index Recheck: 530890
  • 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: 774369
  • Heap Blocks: exact=9644 lossy=56053
4. 65.048 65.048 ↓ 1.0 2,480,897 1 / 3

Bitmap Index Scan on idx_rol_ntv_date (cost=0.00..58,303.63 rows=2,429,519 width=0) (actual time=195.145..195.145 rows=2,480,897 loops=1)

  • Index Cond: ((ntv_bcast_date >= to_date('10/01/2017'::text, 'mm/dd/yyyy'::text)) AND (ntv_bcast_date <= to_date('01/28/2019'::text, 'mm/dd/yyyy'::text)))
5. 0.982 1.860 ↑ 1.0 2,278 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 117kB
6. 0.878 0.878 ↑ 1.0 2,278 1

Seq Scan on national_tv_content_originator org (cost=0.00..68.78 rows=2,278 width=5) (actual time=0.005..0.878 rows=2,278 loops=1)