explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GOe

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 785.610 ↑ 1.0 100 1

Limit (cost=1.52..735.56 rows=100 width=20) (actual time=784.076..785.610 rows=100 loops=1)

2. 0.045 785.594 ↑ 757.2 100 1

Nested Loop Anti Join (cost=1.52..555,833.89 rows=75,722 width=20) (actual time=784.075..785.594 rows=100 loops=1)

3. 0.095 785.449 ↑ 757.3 100 1

Nested Loop (cost=1.25..534,383.17 rows=75,731 width=20) (actual time=784.065..785.449 rows=100 loops=1)

4. 33.618 765.842 ↑ 14.7 9,756 1

Nested Loop (cost=0.98..492,308.04 rows=143,712 width=24) (actual time=139.570..765.842 rows=9,756 loops=1)

5. 575.204 575.204 ↑ 4.9 39,255 1

Index Scan using current_event_event_seating_asked_at_idx on current_event ce1 (cost=0.55..278,470.01 rows=192,609 width=28) (actual time=0.024..575.204 rows=39,255 loops=1)

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

Index Scan using event_pkey on event e1 (cost=0.43..1.10 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 : 1.217 ms
Execution time : 785.683 ms