explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t1rJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 293.125 ↑ 1.0 100 1

Limit (cost=1.40..573.48 rows=100 width=20) (actual time=291.644..293.125 rows=100 loops=1)

2. 0.045 293.108 ↑ 770.4 100 1

Nested Loop Anti Join (cost=1.40..440,722.89 rows=77,038 width=20) (actual time=291.643..293.108 rows=100 loops=1)

3. 0.000 292.963 ↑ 770.5 100 1

Nested Loop (cost=1.13..418,900.61 rows=77,047 width=20) (actual time=291.629..292.963 rows=100 loops=1)

4. 9.338 274.997 ↑ 15.0 9,768 1

Nested Loop (cost=0.86..376,093.83 rows=146,211 width=24) (actual time=27.658..274.997 rows=9,768 loops=1)

5. 108.039 108.039 ↑ 5.0 39,405 1

Index Scan using current_event_last_event_seating_asked_at_start_time_idx on current_event ce1 (cost=0.43..159,038.57 rows=196,703 width=28) (actual time=0.047..108.039 rows=39,405 loops=1)

  • Index Cond: (start_time > now())
  • Filter: ((event_seating_updated_at IS NOT NULL) AND (unrecoverable_error IS NULL) AND ((consecutive_unsuccessful_event_seating_lookup_count = 0) OR (last_event_seating_asked_at < (now() - ('00:00:01'::interval * (bound_power((consecutive_unsuccessful_event_seating_lookup_count + 1), 4, 1, 1440))::double precision)))))
  • Rows Removed by Filter: 5348
6. 157.620 157.620 ↓ 0.0 0 39,405

Index Scan using event_pkey on event e1 (cost=0.43..1.09 rows=1 width=22) (actual time=0.004..0.004 rows=0 loops=39,405)

  • Index Cond: (id = ce1.id)
  • Filter: ((auditorium_id IS NOT NULL) AND (timezone_name IS NOT NULL) AND (unlisted_at IS NULL) AND (((to_char(timezone(timezone_name, now()), 'HH24'::text))::smallint < 0) OR ((to_char(timezone(timezone_name, now()), 'HH24'::text))::smallint > 7) OR (ce1.created_at > (now() - '24:00:00'::interval)) OR (ce1.start_time < (now() + '24:00:00'::interval))))
  • Rows Removed by Filter: 1
7. 19.536 19.536 ↓ 0.0 0 9,768

Index Scan using cinema_pkey on cinema c1 (cost=0.28..0.29 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=9,768)

  • Index Cond: (id = e1.cinema_id)
  • Filter: (data_aggregation_disabled_at IS NULL)
  • Rows Removed by Filter: 1
8. 0.100 0.100 ↓ 0.0 0 100

Index Only Scan using event_seating_lookup_queue_event_id_idx on event_seating_lookup_queue eslq1 (cost=0.27..0.28 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=100)

  • Index Cond: (event_id = ce1.id)
  • Heap Fetches: 0
Planning time : 1.119 ms
Execution time : 293.195 ms