# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 219.461 | 1,499.047 | ↓ 6.1 | 227,929 | 1 |
→
Sort (cost=85,836.23..85,929.08 rows=37,141 width=20) (actual time=1,446.052..1,499.047 rows=227,929 loops=1)
|
2. | 78.172 | 1,279.586 | ↓ 6.1 | 227,929 | 1 |
→
Nested Loop Anti Join (cost=2.11..83,017.09 rows=37,141 width=20) (actual time=0.071..1,279.586 rows=227,929 loops=1)
|
3. | 58.872 | 1,201.414 | ↓ 6.1 | 227,929 | 1 |
→
Nested Loop (cost=0.98..82,457.84 rows=37,141 width=20) (actual time=0.027..1,201.414 rows=227,929 loops=1)
|
4. | 1.012 | 7.786 | ↑ 1.3 | 2,212 | 1 |
→
Nested Loop (cost=0.56..2,527.29 rows=2,870 width=8) (actual time=0.011..7.786 rows=2,212 loops=1) |
5. | 1.614 | 1.614 | ↑ 1.0 | 430 | 1 |
→
Index Scan using cinema_pkey on cinema c1 (cost=0.28..567.64 rows=430 width=8) (actual time=0.005..1.614 rows=430 loops=1)
|
6. | 5.160 | 5.160 | ↓ 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.004..0.012 rows=5 loops=430)
|
7. | 1,134.756 | 1,134.756 | ↑ 1.1 | 103 | 2,212 |
→
Index Scan using current_event_venue_id_idx on current_event ce1 (cost=0.42..26.41 rows=115 width=28) (actual time=0.056..0.513 rows=103 loops=2,212)
|
8. | 0.000 | 0.000 | ↓ 0.0 | 0 | 227,929 |
→
Materialize (cost=1.13..2.15 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=227,929) |
9. | 0.024 | 0.042 | ↓ 0.0 | 0 | 1 |
→
Bitmap Heap Scan on event_seating_lookup_queue eslq1 (cost=1.13..2.14 rows=1 width=4) (actual time=0.042..0.042 rows=0 loops=1)
|
10. | 0.018 | 0.018 | ↓ 250.0 | 250 | 1 |
→
Bitmap Index Scan on event_seating_lookup_queue_id_idx (cost=0.00..1.13 rows=1 width=0) (actual time=0.018..0.018 rows=250 loops=1) |
Planning time | : | 1.125 ms |
---|---|---|
Execution time | : | 1,513.598 ms |