#	exclusive	inclusive	rows x	rows	loops	node
1.	219.461	1,499.047	↓ 6.1	227,929	1	→ Sort (cost=85,836.23..85,929.08 rows=37,141 width=20) (actual time=1,446.052..1,499.047 rows=227,929 loops=1) Sort Key: ce1.start_time, ce1.last_event_seating_asked_at Sort Method: quicksort Memory: 23951kB
2.	78.172	1,279.586	↓ 6.1	227,929	1	→ Nested Loop Anti Join (cost=2.11..83,017.09 rows=37,141 width=20) (actual time=0.071..1,279.586 rows=227,929 loops=1) Join Filter: (eslq1.event_id = ce1.id)
3.	58.872	1,201.414	↓ 6.1	227,929	1	→ Nested Loop (cost=0.98..82,457.84 rows=37,141 width=20) (actual time=0.027..1,201.414 rows=227,929 loops=1) Join Filter: (ce1.consecutive_unsuccessful_event_seating_lookup_count < c1.maximum_consecutive_unsuccessful_event_seating_lookup_count)
4.	1.012	7.786	↑ 1.3	2,212	1	→ Nested Loop (cost=0.56..2,527.29 rows=2,870 width=8) (actual time=0.011..7.786 rows=2,212 loops=1)
5.	1.614	1.614	↑ 1.0	430	1	→ Index Scan using cinema_pkey on cinema c1 (cost=0.28..567.64 rows=430 width=8) (actual time=0.005..1.614 rows=430 loops=1) Filter: (data_aggregation_disabled_at IS NULL) Rows Removed by Filter: 386
6.	5.160	5.160	↓ 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.004..0.012 rows=5 loops=430) Index Cond: (cinema_id = c1.id)
7.	1,134.756	1,134.756	↑ 1.1	103	2,212	→ Index Scan using current_event_venue_id_idx on current_event ce1 (cost=0.42..26.41 rows=115 width=28) (actual time=0.056..0.513 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,929	→ Materialize (cost=1.13..2.15 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=227,929)
9.	0.024	0.042	↓ 0.0	0	1	→ Bitmap Heap Scan on event_seating_lookup_queue eslq1 (cost=1.13..2.14 rows=1 width=4) (actual time=0.042..0.042 rows=0 loops=1) Recheck Cond: (attempted_at IS NULL) Heap Blocks: exact=6
10.	0.018	0.018	↓ 250.0	250	1	→ Bitmap Index Scan on event_seating_lookup_queue_id_idx (cost=0.00..1.13 rows=1 width=0) (actual time=0.018..0.018 rows=250 loops=1)

Planning time	:	1.125 ms
Execution time	:	1,513.598 ms

Sort  (cost=85836.23..85929.08 rows=37141 width=20) (actual time=1446.052..1499.047 rows=227929 loops=1)
  Sort Key: ce1.start_time, ce1.last_event_seating_asked_at
  Sort Method: quicksort  Memory: 23951kB
  ->  Nested Loop Anti Join  (cost=2.11..83017.09 rows=37141 width=20) (actual time=0.071..1279.586 rows=227929 loops=1)
        Join Filter: (eslq1.event_id = ce1.id)
        ->  Nested Loop  (cost=0.98..82457.84 rows=37141 width=20) (actual time=0.027..1201.414 rows=227929 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.011..7.786 rows=2212 loops=1)
                    ->  Index Scan using cinema_pkey on cinema c1  (cost=0.28..567.64 rows=430 width=8) (actual time=0.005..1.614 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.004..0.012 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.41 rows=115 width=28) (actual time=0.056..0.513 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=1.13..2.15 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=227929)
              ->  Bitmap Heap Scan on event_seating_lookup_queue eslq1  (cost=1.13..2.14 rows=1 width=4) (actual time=0.042..0.042 rows=0 loops=1)
                    Recheck Cond: (attempted_at IS NULL)
                    Heap Blocks: exact=6
                    ->  Bitmap Index Scan on event_seating_lookup_queue_id_idx  (cost=0.00..1.13 rows=1 width=0) (actual time=0.018..0.018 rows=250 loops=1)
Planning Time: 1.125 ms
Execution Time: 1513.598 ms

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.024 ms	0.0 %
Bitmap Index Scan	1	0.018 ms	0.0 %
Index Scan	3	1,141.530 ms	76.2 %
Materialize	1	0.000 ms	0.0 %
Nested Loop	2	59.884 ms	4.0 %
Nested Loop Anti Join	1	78.172 ms	5.2 %
Sort	1	219.461 ms	14.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
cinema	1	1.614 ms	0.1 %
Index Scan	1	1.614 ms	100.0 %
current_event	1	1,134.756 ms	75.7 %
Index Scan	1	1,134.756 ms	100.0 %
event_seating_lookup_queue	1	0.024 ms	0.0 %
Bitmap Heap Scan	1	0.024 ms	100.0 %
venue	1	5.160 ms	0.3 %
Index Scan	1	5.160 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qum

Color mode:

Visible columns:

Per node type stats

Per table stats