# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 88.057 | 160,537.497 | ↓ 699,215.0 | 699,215 | 1 |
→
Unique (cost=7,407.35..7,407.36 rows=1 width=8) (actual time=160,412.617..160,537.497 rows=699,215 loops=1) |
2. | 228.732 | 160,449.440 | ↓ 699,215.0 | 699,215 | 1 |
→
Sort (cost=7,407.35..7,407.36 rows=1 width=8) (actual time=160,412.615..160,449.440 rows=699,215 loops=1)
|
3. | 14,335.238 | 160,220.708 | ↓ 699,215.0 | 699,215 | 1 |
→
Nested Loop (cost=644.12..7,407.34 rows=1 width=8) (actual time=194.263..160,220.708 rows=699,215 loops=1)
|
4. | 5,094.422 | 5,291.766 | ↓ 14,743.5 | 35,148,426 | 1 |
→
Hash Join (cost=643.57..2,153.74 rows=2,384 width=75) (actual time=184.293..5,291.766 rows=35,148,426 loops=1)
|
5. | 13.072 | 13.072 | ↑ 1.0 | 36,679 | 1 |
→
Seq Scan on relevant_theater t (cost=0.00..1,348.79 rows=36,679 width=14) (actual time=0.009..13.072 rows=36,679 loops=1) |
6. | 8.900 | 184.272 | ↓ 2,403.5 | 31,245 | 1 |
→
Hash (cost=643.40..643.40 rows=13 width=73) (actual time=184.272..184.272 rows=31,245 loops=1)
|
7. | 22.954 | 175.372 | ↓ 2,403.5 | 31,245 | 1 |
→
Nested Loop (cost=0.42..643.40 rows=13 width=73) (actual time=0.345..175.372 rows=31,245 loops=1) |
8. | 58.683 | 58.683 | ↓ 2,403.5 | 31,245 | 1 |
→
Seq Scan on relevant_release rr (cost=0.00..608.99 rows=13 width=40) (actual time=0.287..58.683 rows=31,245 loops=1)
|
9. | 93.735 | 93.735 | ↑ 1.0 | 1 | 31,245 |
→
Index Only Scan using relevant_movie_idx on relevant_movie m (cost=0.42..2.64 rows=1 width=45) (actual time=0.003..0.003 rows=1 loops=31,245)
|
10. | 140,593.704 | 140,593.704 | ↓ 0.0 | 0 | 35,148,426 |
→
Index Scan using relevant_showtime_idx on relevant_showtime s (cost=0.56..2.18 rows=1 width=59) (actual time=0.004..0.004 rows=0 loops=35,148,426)
|