explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4XTa

Settings
# exclusive inclusive rows x rows loops node
1. 213,047.096 247,374.183 ↓ 1,060,939.0 7,426,573 1

Nested Loop (cost=15,380.51..525,484.61 rows=7 width=441) (actual time=176.662..247,374.183 rows=7,426,573 loops=1)

2. 9,794.369 12,047.368 ↓ 1,060,939.0 7,426,573 1

Hash Join (cost=15,380.07..525,477.61 rows=7 width=156) (actual time=176.255..12,047.368 rows=7,426,573 loops=1)

  • Hash Cond: ((s.bias_number = sb.bias_number) AND ((s.bias_entry_date)::text = (sb.bias_entry_date)::text) AND ((s.network_cd)::text = (sb.network_cd)::text))
3. 2,077.614 2,077.614 ↓ 1.0 7,426,573 1

Seq Scan on spot s (cost=0.00..306,875.75 rows=7,421,575 width=38) (actual time=0.159..2,077.614 rows=7,426,573 loops=1)

4. 98.368 175.385 ↑ 1.0 175,239 1

Hash (cost=8,548.39..8,548.39 rows=175,239 width=146) (actual time=175.385..175.385 rows=175,239 loops=1)

  • Buckets: 32,768 Batches: 16 Memory Usage: 2,254kB
5. 77.017 77.017 ↑ 1.0 175,239 1

Seq Scan on booked_order sb (cost=0.00..8,548.39 rows=175,239 width=146) (actual time=0.165..77.017 rows=175,239 loops=1)

6. 22,279.719 22,279.719 ↑ 1.0 1 7,426,573

Index Scan using idx_lh_vwspot_spotid on vw_spot vs (cost=0.43..0.62 rows=1 width=161) (actual time=0.003..0.003 rows=1 loops=7,426,573)

  • Index Cond: (spot_id = s.spot_id)
Planning time : 1.119 ms
Execution time : 298,153.268 ms