explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6xdg

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

Limit (cost=1.40..997.49 rows=100 width=20) (actual time=389.380..391.353 rows=100 loops=1)

2. 0.087 391.336 ↑ 270.5 100 1

Nested Loop Anti Join (cost=1.40..269,404.02 rows=27,046 width=20) (actual time=389.380..391.336 rows=100 loops=1)

3. 0.000 391.149 ↑ 270.5 100 1

Nested Loop (cost=1.13..261,698.22 rows=27,050 width=20) (actual time=389.368..391.149 rows=100 loops=1)

4. 6.426 372.062 ↑ 5.3 9,756 1

Nested Loop (cost=0.85..246,669.26 rows=51,333 width=24) (actual time=37.824..372.062 rows=9,756 loops=1)

5. 169.356 169.356 ↑ 1.8 39,256 1

Index Scan using current_event_test_idx on current_event ce1 (cost=0.42..145,604.36 rows=68,758 width=28) (actual time=0.062..169.356 rows=39,256 loops=1)

  • Index Cond: (start_time > now())
  • Filter: (last_event_seating_asked_at < (now() - ('00:00:01'::interval * (bound_power((consecutive_unsuccessful_event_seating_lookup_count + 1), 4, 1, 1440))::double precision)))
6. 196.280 196.280 ↓ 0.0 0 39,256

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

  • 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.933 ms
Execution time : 391.426 ms