#	exclusive	inclusive	rows x	rows	loops	node
1.	0.005	4274.779	↑ 1.0	10	1	→ Limit (cost=0.00..22241.91 rows=10 width=4) (actual time=4166.847..4274.779 rows=10 loops=1)
2.	0.017	4274.774	↑ 20.0	10	1	→ Group (cost=0.00..444838.14 rows=200 width=4) (actual time=4166.845..4274.774 rows=10 loops=1)
3.	40.222	4274.757	↑ 122.3	20	1	→ Nested Loop (cost=0.00..444832.02 rows=2446 width=4) (actual time=4166.843..4274.757 rows=20 loops=1) Join Filter: (cp.product_id = bp.id)
4.	0.044	0.235	↑ 26.0	20	1	→ Nested Loop (cost=0.00..1678.46 rows=520 width=4) (actual time=0.117..0.235 rows=20 loops=1)
5.	0.095	0.095	↑ 155.7	32	1	→ Index Scan using channels_products_product_id_idx on channels_products cp (cost=0.00..218.64 rows=4982 width=8) (actual time=0.036..0.095 rows=32 loops=1)
6.	0.096	0.096	↑ 1.0	1	32	→ Index Scan using channels_pkey on channels (cost=0.00..0.28 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=32) Index Cond: (id = cp.channel_id) Filter: (site_id = 2)
7.	27.984	4234.300	↑ 1.0	17638	20	→ Materialize (cost=0.00..305106.63 rows=17704 width=4) (actual time=0.199..211.715 rows=17638 loops=20)
8.	6.549	4206.316	↑ 1.0	17704	1	→ Subquery Scan on bp (cost=0.00..305018.11 rows=17704 width=4) (actual time=3.971..4206.316 rows=17704 loops=1)
9.	4111.247	4199.767	↑ 1.0	17704	1	→ Seq Scan on products p (cost=0.00..304841.07 rows=17704 width=750) (actual time=3.969..4199.767 rows=17704 loops=1)
10.						SubPlan (forSeq Scan)
11.	17.704	88.520	↑ 1.0	1	17704	→ Aggregate (cost=16.56..16.57 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=17704)
12.	2.758	70.816	↓ 0.0	0	17704	→ Nested Loop (cost=0.00..16.56 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=17704)
13.	53.112	53.112	↓ 0.0	0	17704	→ Index Scan using channels_products_product_id_idx on channels_products cp (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=17704) Index Cond: (product_id = p.id)
14.	14.946	14.946	↓ 0.0	0	4982	→ Index Scan using channels_pkey on channels (cost=0.00..8.28 rows=1 width=12) (actual time=0.003..0.003 rows=0 loops=4982) Index Cond: (id = cp.channel_id) Filter: ((start_at < now()) AND ((end_at IS NULL) OR (end_at > now())))

 Limit  (cost=0.00..22241.91 rows=10 width=4) (actual time=4166.847..4274.779 rows=10 loops=1)
   ->  Group  (cost=0.00..444838.14 rows=200 width=4) (actual time=4166.845..4274.774 rows=10 loops=1)
         ->  Nested Loop  (cost=0.00..444832.02 rows=2446 width=4) (actual time=4166.843..4274.757 rows=20 loops=1)
               Join Filter: (cp.product_id = bp.id)
               ->  Nested Loop  (cost=0.00..1678.46 rows=520 width=4) (actual time=0.117..0.235 rows=20 loops=1)
                     ->  Index Scan using channels_products_product_id_idx on channels_products cp  (cost=0.00..218.64 rows=4982 width=8) (actual time=0.036..0.095 rows=32 loops=1)
                     ->  Index Scan using channels_pkey on channels  (cost=0.00..0.28 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=32)
                           Index Cond: (id = cp.channel_id)
                           Filter: (site_id = 2)
               ->  Materialize  (cost=0.00..305106.63 rows=17704 width=4) (actual time=0.199..211.715 rows=17638 loops=20)
                     ->  Subquery Scan on bp  (cost=0.00..305018.11 rows=17704 width=4) (actual time=3.971..4206.316 rows=17704 loops=1)
                           ->  Seq Scan on products p  (cost=0.00..304841.07 rows=17704 width=750) (actual time=3.969..4199.767 rows=17704 loops=1)
                                 SubPlan 1
                                   ->  Aggregate  (cost=16.56..16.57 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=17704)
                                         ->  Nested Loop  (cost=0.00..16.56 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=17704)
                                               ->  Index Scan using channels_products_product_id_idx on channels_products cp  (cost=0.00..8.27 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=17704)
                                                     Index Cond: (product_id = p.id)
                                               ->  Index Scan using channels_pkey on channels  (cost=0.00..8.28 rows=1 width=12) (actual time=0.003..0.003 rows=0 loops=4982)
                                                     Index Cond: (id = cp.channel_id)
                                                     Filter: ((start_at < now()) AND ((end_at IS NULL) OR (end_at > now())))

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	17.704 ms	0.4 %
Group	1	0.017 ms	0.0 %
Index Scan	4	68.249 ms	1.6 %
Limit	1	0.005 ms	0.0 %
Materialize	1	27.984 ms	0.7 %
Nested Loop	3	43.024 ms	1.0 %
Seq Scan	1	4111.247 ms	96.2 %
Subquery Scan on bp	1	6.549 ms	0.2 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
channels	2	15.042 ms	0.4 %
Index Scan	2	15.042 ms	100.0 %
channels_products	2	53.207 ms	1.2 %
Index Scan	2	53.207 ms	100.0 %
products	1	4111.247 ms	96.2 %
Seq Scan	1	4111.247 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: nh5B

Colorize:

Columns visibility:

Per node type stats

Per table stats