#	exclusive	inclusive	rows x	rows	loops	node
1.	206.545	1,532.419	↓ 6.2	227,790	1	→ Sort (cost=85,931.86..86,023.86 rows=36,798 width=20) (actual time=1,482.729..1,532.419 rows=227,790 loops=1) Sort Key: ce1.start_time, ce1.last_event_seating_asked_at Sort Method: quicksort Memory: 23941kB
2.	79.459	1,325.874	↓ 6.2	227,790	1	→ Nested Loop Anti Join (cost=1.23..83,141.22 rows=36,798 width=20) (actual time=0.278..1,325.874 rows=227,790 loops=1) Join Filter: (eslq1.event_id = ce1.id)
3.	58.184	1,246.415	↓ 6.2	227,790	1	→ Nested Loop (cost=0.98..82,586.99 rows=36,798 width=20) (actual time=0.042..1,246.415 rows=227,790 loops=1) Join Filter: (ce1.consecutive_unsuccessful_event_seating_lookup_count < c1.maximum_consecutive_unsuccessful_event_seating_lookup_count)
4.	0.928	7.023	↑ 1.3	2,212	1	→ Nested Loop (cost=0.56..2,527.29 rows=2,870 width=8) (actual time=0.028..7.023 rows=2,212 loops=1)
5.	1.365	1.365	↑ 1.0	430	1	→ Index Scan using cinema_pkey on cinema c1 (cost=0.28..567.64 rows=430 width=8) (actual time=0.023..1.365 rows=430 loops=1) Filter: (data_aggregation_disabled_at IS NULL) Rows Removed by Filter: 386
6.	4.730	4.730	↓ 1.2	5	430	→ Index Scan using public_venue_cinema_id0_idx on venue v1 (cost=0.28..4.52 rows=4 width=8) (actual time=0.003..0.011 rows=5 loops=430) Index Cond: (cinema_id = c1.id)
7.	1,181.208	1,181.208	↑ 1.1	103	2,212	→ Index Scan using current_event_venue_id_idx on current_event ce1 (cost=0.42..26.46 rows=115 width=28) (actual time=0.049..0.534 rows=103 loops=2,212) Index Cond: (venue_id = v1.id) Filter: ((event_seating_updated_at IS NOT NULL) AND (unrecoverable_error IS NULL) AND (start_time > now())) Rows Removed by Filter: 127
8.	0.000	0.000	↓ 0.0	0	227,790	→ Materialize (cost=0.25..2.27 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=227,790)
9.	0.233	0.233	↓ 0.0	0	1	→ Index Only Scan using event_seating_lookup_queue_event_id_idx on event_seating_lookup_queue eslq1 (cost=0.25..2.27 rows=1 width=4) (actual time=0.233..0.233 rows=0 loops=1) Heap Fetches: 689

Planning time	:	1.212 ms
Execution time	:	1,546.911 ms

Sort  (cost=85931.86..86023.86 rows=36798 width=20) (actual time=1482.729..1532.419 rows=227790 loops=1)
  Sort Key: ce1.start_time, ce1.last_event_seating_asked_at
  Sort Method: quicksort  Memory: 23941kB
  ->  Nested Loop Anti Join  (cost=1.23..83141.22 rows=36798 width=20) (actual time=0.278..1325.874 rows=227790 loops=1)
        Join Filter: (eslq1.event_id = ce1.id)
        ->  Nested Loop  (cost=0.98..82586.99 rows=36798 width=20) (actual time=0.042..1246.415 rows=227790 loops=1)
              Join Filter: (ce1.consecutive_unsuccessful_event_seating_lookup_count < c1.maximum_consecutive_unsuccessful_event_seating_lookup_count)
              ->  Nested Loop  (cost=0.56..2527.29 rows=2870 width=8) (actual time=0.028..7.023 rows=2212 loops=1)
                    ->  Index Scan using cinema_pkey on cinema c1  (cost=0.28..567.64 rows=430 width=8) (actual time=0.023..1.365 rows=430 loops=1)
                          Filter: (data_aggregation_disabled_at IS NULL)
                          Rows Removed by Filter: 386
                    ->  Index Scan using public_venue_cinema_id0_idx on venue v1  (cost=0.28..4.52 rows=4 width=8) (actual time=0.003..0.011 rows=5 loops=430)
                          Index Cond: (cinema_id = c1.id)
              ->  Index Scan using current_event_venue_id_idx on current_event ce1  (cost=0.42..26.46 rows=115 width=28) (actual time=0.049..0.534 rows=103 loops=2212)
                    Index Cond: (venue_id = v1.id)
                    Filter: ((event_seating_updated_at IS NOT NULL) AND (unrecoverable_error IS NULL) AND (start_time > now()))
                    Rows Removed by Filter: 127
        ->  Materialize  (cost=0.25..2.27 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=227790)
              ->  Index Only Scan using event_seating_lookup_queue_event_id_idx on event_seating_lookup_queue eslq1  (cost=0.25..2.27 rows=1 width=4) (actual time=0.233..0.233 rows=0 loops=1)
                    Heap Fetches: 689
Planning Time: 1.212 ms
Execution Time: 1546.911 ms

Per node type stats

node type	count	sum of times	% of query
Index Only Scan	1	0.233 ms	0.0 %
Index Scan	3	1,187.303 ms	77.5 %
Materialize	1	0.000 ms	0.0 %
Nested Loop	2	59.112 ms	3.9 %
Nested Loop Anti Join	1	79.459 ms	5.2 %
Sort	1	206.545 ms	13.5 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
cinema	1	1.365 ms	0.1 %
Index Scan	1	1.365 ms	100.0 %
current_event	1	1,181.208 ms	77.1 %
Index Scan	1	1,181.208 ms	100.0 %
event_seating_lookup_queue	1	0.233 ms	0.0 %
Index Only Scan	1	0.233 ms	100.0 %
venue	1	4.730 ms	0.3 %
Index Scan	1	4.730 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rsyZ

Color mode:

Visible columns:

Per node type stats

Per table stats