explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3hza

Settings
# exclusive inclusive rows x rows loops node
1. 62,344.211 87,550.470 ↑ 1.0 5,443,151 1

Hash Join (cost=1,148,459.48..3,105,302.74 rows=5,602,179 width=31) (actual time=22,945.152..87,550.470 rows=5,443,151 loops=1)

  • Hash Cond: (lh_spot_to_deal.usn = os.spot_id)
2. 2,265.954 2,265.954 ↓ 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.171..2,265.954 rows=5,612,137 loops=1)

  • Filter: (row_num = 1)
  • Rows Removed by Filter: 1647706
3. 2,328.536 22,940.305 ↑ 1.0 9,830,389 1

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

  • Buckets: 131072 Batches: 256 Memory Usage: 2670kB
4. 20,611.769 20,611.769 ↑ 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=7.555..20,611.769 rows=9,830,389 loops=1)

Planning time : 19.105 ms
Execution time : 91,269.499 ms