#	exclusive	inclusive	rows x	rows	loops	node
1.	0.001	1437.590	↓ 0.0	0	1	→ Subquery Scan on seatlist (cost=121287.87..121298.13 rows=342 width=40) (actual time=1437.590..1437.590 rows=0 loops=1)
2.	1.469	1437.589	↓ 0.0	0	1	→ HashAggregate (cost=121287.87..121294.71 rows=342 width=20) (actual time=1437.589..1437.589 rows=0 loops=1) Filter: (array_length(array_agg(foo.seat_location), 1) < 4)
3.	108.946	1436.120	↑ 1.9	1833	1	→ Subquery Scan on foo (cost=0.00..121245.18 rows=3415 width=20) (actual time=50.987..1436.120 rows=1833 loops=1) Filter: (foo.section_id = 115176)
4.	704.634	1327.174	↑ 1.0	682969	1	→ WindowAgg (cost=0.00..112708.07 rows=682969 width=12) (actual time=0.032..1327.174 rows=682969 loops=1)
5.	622.540	622.540	↑ 1.0	682969	1	→ Index Scan using seating_seats_search on seating_seats (cost=0.00..93926.42 rows=682969 width=12) (actual time=0.019..622.540 rows=682969 loops=1)

 Subquery Scan on seatlist  (cost=121287.87..121298.13 rows=342 width=40) (actual time=1437.590..1437.590 rows=0 loops=1)
   ->  HashAggregate  (cost=121287.87..121294.71 rows=342 width=20) (actual time=1437.589..1437.589 rows=0 loops=1)
         Filter: (array_length(array_agg(foo.seat_location), 1) < 4)
         ->  Subquery Scan on foo  (cost=0.00..121245.18 rows=3415 width=20) (actual time=50.987..1436.120 rows=1833 loops=1)
               Filter: (foo.section_id = 115176)
               ->  WindowAgg  (cost=0.00..112708.07 rows=682969 width=12) (actual time=0.032..1327.174 rows=682969 loops=1)
                     ->  Index Scan using seating_seats_search on seating_seats  (cost=0.00..93926.42 rows=682969 width=12) (actual time=0.019..622.540 rows=682969 loops=1)

Per node type stats

node type	count	sum of times	% of query
HashAggregate	1	1.469 ms	0.1 %
Index Scan	1	622.540 ms	43.3 %
Subquery Scan on foo	1	108.946 ms	7.6 %
Subquery Scan on seatlist	1	0.001 ms	0.0 %
WindowAgg	1	704.634 ms	49.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
seating_seats	1	622.540 ms	43.3 %
Index Scan	1	622.540 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 9Tk

Colorize:

Columns visibility:

Per node type stats

Per table stats