explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hsjn

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 60,910.745 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.13..2,243,170.72 rows=17,847 width=164) (actual time=60,910.745..60,910.745 rows=0 loops=1)

2. 0.002 60,910.745 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..2,140,706.43 rows=9,987 width=158) (actual time=60,910.745..60,910.745 rows=0 loops=1)

3. 60,910.743 60,910.743 ↓ 0.0 0 1

Seq Scan on live_delivery ld (cost=0.00..2,083,108.10 rows=5,614 width=152) (actual time=60,910.743..60,910.743 rows=0 loops=1)

  • Filter: (broadcast_date_sk >= 20191130)
  • Rows Removed by Filter: 58259370
4. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_c3_del_cover on c3_delivery cthree (cost=0.56..10.24 rows=2 width=18) (never executed)

  • Index Cond: ((ld.program_rank_id = program_rank_id) AND (ld.audience_sk = audience_sk))
5. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_c7_del_cover on c7_delivery cseven (cost=0.56..10.24 rows=2 width=18) (never executed)

  • Index Cond: ((ld.program_rank_id = program_rank_id) AND (ld.audience_sk = audience_sk))