explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YjDr

Settings
# exclusive inclusive rows x rows loops node
1. 205.361 1,439.112 ↓ 6.2 227,975 1

Sort (cost=85,832.60..85,924.81 rows=36,883 width=20) (actual time=1,388.490..1,439.112 rows=227,975 loops=1)

  • Sort Key: ce1.start_time, ce1.last_event_seating_asked_at
  • Sort Method: quicksort Memory: 23955kB
2. 61.435 1,233.751 ↓ 6.2 227,975 1

Hash Anti Join (cost=47.81..83,034.90 rows=36,883 width=20) (actual time=0.159..1,233.751 rows=227,975 loops=1)

  • Hash Cond: (ce1.id = eslq1.event_id)
3. 63.088 1,172.185 ↓ 6.2 227,975 1

Nested Loop (cost=0.98..82,522.41 rows=36,886 width=20) (actual time=0.024..1,172.185 rows=227,975 loops=1)

  • Join Filter: (ce1.consecutive_unsuccessful_event_seating_lookup_count < c1.maximum_consecutive_unsuccessful_event_seating_lookup_count)
4. 0.704 7.521 ↑ 1.3 2,212 1

Nested Loop (cost=0.56..2,527.29 rows=2,870 width=8) (actual time=0.010..7.521 rows=2,212 loops=1)

5. 1.657 1.657 ↑ 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.657 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,101.576 1,101.576 ↑ 1.1 103 2,212

Index Scan using current_event_venue_id_idx on current_event ce1 (cost=0.42..26.44 rows=115 width=28) (actual time=0.054..0.498 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: 126
8. 0.001 0.131 ↓ 0.0 0 1

Hash (cost=46.37..46.37 rows=37 width=4) (actual time=0.130..0.131 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
9. 0.130 0.130 ↓ 0.0 0 1

Seq Scan on event_seating_lookup_queue eslq1 (cost=0.00..46.37 rows=37 width=4) (actual time=0.130..0.130 rows=0 loops=1)

  • Filter: (attempted_at IS NULL)
Planning time : 0.694 ms
Execution time : 1,453.174 ms