explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lvW

Settings
# exclusive inclusive rows x rows loops node
1. 36.516 2,540.456 ↑ 1.0 1 1

Aggregate (cost=624,729.80..624,729.81 rows=1 width=8) (actual time=2,540.456..2,540.456 rows=1 loops=1)

2. 93.551 2,503.940 ↓ 1.1 119,604 1

Group (cost=594,702.37..623,311.33 rows=113,478 width=41) (actual time=1,945.362..2,503.940 rows=119,604 loops=1)

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

Gather Merge (cost=594,702.37..622,176.55 rows=226,956 width=41) (actual time=1,945.360..2,410.389 rows=119,604 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 181.475 2,315.592 ↑ 2.8 39,868 3 / 3

Group (cost=593,702.35..594,980.17 rows=113,478 width=41) (actual time=1,940.064..2,315.592 rows=39,868 loops=3)

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

Sort (cost=593,702.35..594,128.29 rows=170,376 width=41) (actual time=1,940.062..2,134.117 rows=366,834 loops=3)

  • Sort Key: l.rpt_orgn_lnp_key
  • Sort Method: external merge Disk: 14264kB
6. 171.880 1,658.395 ↓ 2.2 366,834 3 / 3

Hash Left Join (cost=32,728.88..573,655.07 rows=170,376 width=41) (actual time=150.895..1,658.395 rows=366,834 loops=3)

  • Hash Cond: (l.orgn_dstr_id = org.orgn_dstr_id)
7. 1,438.395 1,484.047 ↑ 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=23) (actual time=148.372..1,484.047 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=19052 lossy=55753
8. 45.652 45.652 ↓ 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.957..136.957 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.347 2.468 ↑ 1.0 2,278 3 / 3

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

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