# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 206.545 | 1,532.419 | ↓ 6.2 | 227,790 | 1 |
→
Sort (cost=85,931.86..86,023.86 rows=36,798 width=20) (actual time=1,482.729..1,532.419 rows=227,790 loops=1)
|
2. | 79.459 | 1,325.874 | ↓ 6.2 | 227,790 | 1 |
→
Nested Loop Anti Join (cost=1.23..83,141.22 rows=36,798 width=20) (actual time=0.278..1,325.874 rows=227,790 loops=1)
|
3. | 58.184 | 1,246.415 | ↓ 6.2 | 227,790 | 1 |
→
Nested Loop (cost=0.98..82,586.99 rows=36,798 width=20) (actual time=0.042..1,246.415 rows=227,790 loops=1)
|
4. | 0.928 | 7.023 | ↑ 1.3 | 2,212 | 1 |
→
Nested Loop (cost=0.56..2,527.29 rows=2,870 width=8) (actual time=0.028..7.023 rows=2,212 loops=1) |
5. | 1.365 | 1.365 | ↑ 1.0 | 430 | 1 |
→
Index Scan using cinema_pkey on cinema c1 (cost=0.28..567.64 rows=430 width=8) (actual time=0.023..1.365 rows=430 loops=1)
|
6. | 4.730 | 4.730 | ↓ 1.2 | 5 | 430 |
→
Index Scan using public_venue_cinema_id0_idx on venue v1 (cost=0.28..4.52 rows=4 width=8) (actual time=0.003..0.011 rows=5 loops=430)
|
7. | 1,181.208 | 1,181.208 | ↑ 1.1 | 103 | 2,212 |
→
Index Scan using current_event_venue_id_idx on current_event ce1 (cost=0.42..26.46 rows=115 width=28) (actual time=0.049..0.534 rows=103 loops=2,212)
|
8. | 0.000 | 0.000 | ↓ 0.0 | 0 | 227,790 |
→
Materialize (cost=0.25..2.27 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=227,790) |
9. | 0.233 | 0.233 | ↓ 0.0 | 0 | 1 |
→
Index Only Scan using event_seating_lookup_queue_event_id_idx on event_seating_lookup_queue eslq1 (cost=0.25..2.27 rows=1 width=4) (actual time=0.233..0.233 rows=0 loops=1)
|
Planning time | : | 1.212 ms |
---|---|---|
Execution time | : | 1,546.911 ms |