explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3x3R

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 399.449 ↑ 1.0 100 1

Limit (cost=1.40..1,039.13 rows=100 width=20) (actual time=397.190..399.449 rows=100 loops=1)

2. 0.087 399.431 ↑ 271.7 100 1

Nested Loop Anti Join (cost=1.40..281,963.04 rows=27,171 width=20) (actual time=397.189..399.431 rows=100 loops=1)

3. 0.000 399.244 ↑ 271.7 100 1

Nested Loop (cost=1.13..274,228.65 rows=27,174 width=20) (actual time=397.178..399.244 rows=100 loops=1)

4. 37.938 379.902 ↑ 5.3 9,756 1

Nested Loop (cost=0.86..259,130.88 rows=51,568 width=24) (actual time=40.246..379.902 rows=9,756 loops=1)

5. 184.944 184.944 ↑ 1.8 39,255 1

Index Scan using current_event_test_idx on current_event ce1 (cost=0.43..157,564.33 rows=69,221 width=28) (actual time=0.198..184.944 rows=39,255 loops=1)

  • Index Cond: (start_time > now())
  • Filter: ((event_seating_updated_at IS NOT NULL) AND (unrecoverable_error IS NULL) AND (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: 5344
6. 157.020 157.020 ↓ 0.0 0 39,255

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

  • 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.512 19.512 ↓ 0.0 0 9,756

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,756)

  • 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 : 0.866 ms
Execution time : 399.522 ms