explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RyjB

Settings
# exclusive inclusive rows x rows loops node
1. 64,949.854 75,114.299 ↑ 1.0 5,443,310 1

Hash Join (cost=1,198,341.03..3,249,477.09 rows=5,602,179 width=31) (actual time=7,880.255..75,114.299 rows=5,443,310 loops=1)

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

  • Filter: (row_num = 1)
  • Rows Removed by Filter: 1647706
3. 3,550.551 7,872.282 ↑ 1.0 17,674,446 1

Hash (cost=891,108.46..891,108.46 rows=17,674,446 width=10) (actual time=7,872.282..7,872.282 rows=17,674,446 loops=1)

  • Buckets: 131072 Batches: 512 Memory Usage: 2495kB
4. 4,321.731 4,321.731 ↑ 1.0 17,674,446 1

Seq Scan on order_spot os (cost=0.00..891,108.46 rows=17,674,446 width=10) (actual time=0.126..4,321.731 rows=17,674,446 loops=1)

Planning time : 0.346 ms
Execution time : 78,671.574 ms