explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7uPk

Settings
# exclusive inclusive rows x rows loops node
1. 110,371.011 117,217.063 ↑ 1.0 9,830,389 1

Hash Right Join (cost=1,148,459.48..4,163,907.74 rows=9,836,599 width=31) (actual time=4,637.357..117,217.063 rows=9,830,389 loops=1)

  • Hash Cond: (lh_spot_to_deal.usn = os.spot_id)
2. 2,213.505 2,213.505 ↓ 1.0 5,612,137 1

Seq Scan on lh_spot_to_deal (cost=0.00..302,561.04 rows=5,602,179 width=17) (actual time=0.123..2,213.505 rows=5,612,137 loops=1)

  • Filter: (row_num = 1)
  • Rows Removed by Filter: 1647706
3. 1,914.254 4,632.547 ↑ 1.0 9,830,389 1

Hash (cost=977,470.99..977,470.99 rows=9,836,599 width=10) (actual time=4,632.547..4,632.547 rows=9,830,389 loops=1)

  • Buckets: 131072 Batches: 256 Memory Usage: 2670kB
4. 2,718.293 2,718.293 ↑ 1.0 9,830,389 1

Seq Scan on vw_spot_and_header os (cost=0.00..977,470.99 rows=9,836,599 width=10) (actual time=0.129..2,718.293 rows=9,830,389 loops=1)

Planning time : 0.339 ms
Execution time : 123,488.252 ms