explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VL0

Settings
# exclusive inclusive rows x rows loops node
1. 57,071.206 450,115.017 ↓ 1,060,939.0 7,426,573 1

Nested Loop (cost=15,380.51..525,482.86 rows=7 width=433) (actual time=445.769..450,115.017 rows=7,426,573 loops=1)

2. 8,843.133 21,715.161 ↓ 1,060,939.0 7,426,573 1

Hash Join (cost=15,380.07..525,477.61 rows=7 width=156) (actual time=443.499..21,715.161 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. 12,435.884 12,435.884 ↓ 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=6.712..12,435.884 rows=7,426,573 loops=1)

4. 99.846 436.144 ↑ 1.0 175,239 1

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

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

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

6. 371,328.650 371,328.650 ↑ 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.049..0.050 rows=1 loops=7,426,573)

  • Index Cond: (spot_id = s.spot_id)
Planning time : 47.972 ms
Execution time : 489,463.932 ms