explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Qt

Settings
# exclusive inclusive rows x rows loops node
1. 10,131.988 566,727.932 ↑ 3.1 3,179,865 1

Merge Right Join (cost=25,616,897.00..26,829,889.01 rows=9,990,245 width=164) (actual time=458,263.787..566,727.932 rows=3,179,865 loops=1)

  • Merge Cond: ((cseven.audience_sk = ld.audience_sk) AND (cseven.program_rank_id = ld.program_rank_id))
2. 206,437.731 228,085.348 ↑ 1.0 54,782,325 1

Sort (cost=11,361,054.98..11,498,011.09 rows=54,782,444 width=18) (actual time=190,256.169..228,085.348 rows=54,782,325 loops=1)

  • Sort Key: cseven.audience_sk, cseven.program_rank_id
  • Sort Method: external merge Disk: 1606608kB
3. 21,647.617 21,647.617 ↑ 1.0 54,782,325 1

Seq Scan on c7_delivery cseven (cost=0.00..949,130.44 rows=54,782,444 width=18) (actual time=0.020..21,647.617 rows=54,782,325 loops=1)

4. 1,690.595 328,510.596 ↑ 1.8 3,179,865 1

Materialize (cost=14,255,842.02..14,897,112.27 rows=5,590,344 width=158) (actual time=267,784.760..328,510.596 rows=3,179,865 loops=1)

5. 11,050.295 326,820.001 ↑ 1.8 3,179,865 1

Merge Left Join (cost=14,255,842.02..14,883,136.41 rows=5,590,344 width=158) (actual time=267,784.751..326,820.001 rows=3,179,865 loops=1)

  • Merge Cond: ((ld.audience_sk = cthree.audience_sk) AND (ld.program_rank_id = cthree.program_rank_id))
6. 9,330.314 77,962.862 ↓ 1.0 3,179,865 1

Sort (cost=2,894,828.61..2,902,684.68 rows=3,142,431 width=152) (actual time=75,051.618..77,962.862 rows=3,179,865 loops=1)

  • Sort Key: ld.audience_sk, ld.program_rank_id
  • Sort Method: external merge Disk: 517736kB
7. 68,632.548 68,632.548 ↓ 1.0 3,179,865 1

Seq Scan on live_delivery ld (cost=0.00..2,083,108.10 rows=3,142,431 width=152) (actual time=59,623.130..68,632.548 rows=3,179,865 loops=1)

  • Filter: (broadcast_date_sk >= 20181130)
  • Rows Removed by Filter: 55079505
8. 9,853.665 237,806.844 ↓ 1.0 54,782,325 1

Materialize (cost=11,361,013.41..11,634,924.77 rows=54,782,272 width=18) (actual time=192,465.160..237,806.844 rows=54,782,325 loops=1)

9. 202,402.586 227,953.179 ↓ 1.0 54,782,325 1

Sort (cost=11,361,013.41..11,497,969.09 rows=54,782,272 width=18) (actual time=192,465.146..227,953.179 rows=54,782,325 loops=1)

  • Sort Key: cthree.audience_sk, cthree.program_rank_id
  • Sort Method: external merge Disk: 1606616kB
10. 25,550.593 25,550.593 ↓ 1.0 54,782,325 1

Seq Scan on c3_delivery cthree (cost=0.00..949,122.72 rows=54,782,272 width=18) (actual time=0.025..25,550.593 rows=54,782,325 loops=1)