explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pbpr

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

Limit (cost=1.53..738.50 rows=100 width=20) (actual time=820.266..821.968 rows=100 loops=1)

2. 0.071 821.951 ↑ 755.4 100 1

Nested Loop Anti Join (cost=1.53..556,716.00 rows=75,541 width=20) (actual time=820.265..821.951 rows=100 loops=1)

3. 0.000 821.780 ↑ 756.3 100 1

Nested Loop (cost=1.25..534,511.32 rows=75,634 width=20) (actual time=820.252..821.780 rows=100 loops=1)

4. 29.285 803.034 ↑ 14.7 9,768 1

Nested Loop (cost=0.98..492,490.05 rows=143,528 width=24) (actual time=146.695..803.034 rows=9,768 loops=1)

5. 616.129 616.129 ↑ 4.9 39,405 1

Index Scan using current_event_event_seating_asked_at_idx on current_event ce1 (cost=0.55..279,225.85 rows=191,881 width=28) (actual time=0.027..616.129 rows=39,405 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: 251274
6. 157.620 157.620 ↓ 0.0 0 39,405

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,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.28..0.29 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.922 ms
Execution time : 822.040 ms