explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qum

Settings
# 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)

  • Sort Key: ce1.start_time, ce1.last_event_seating_asked_at
  • Sort Method: quicksort Memory: 23951kB
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)

  • Join Filter: (eslq1.event_id = ce1.id)
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)

  • Join Filter: (ce1.consecutive_unsuccessful_event_seating_lookup_count < c1.maximum_consecutive_unsuccessful_event_seating_lookup_count)
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)

  • Filter: (data_aggregation_disabled_at IS NULL)
  • Rows Removed by Filter: 386
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)

  • Index Cond: (cinema_id = c1.id)
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)

  • Index Cond: (venue_id = v1.id)
  • Filter: ((event_seating_updated_at IS NOT NULL) AND (unrecoverable_error IS NULL) AND (start_time > now()))
  • Rows Removed by Filter: 127
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)

  • Recheck Cond: (attempted_at IS NULL)
  • Heap Blocks: exact=6
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