#	exclusive	inclusive	rows x	rows	loops	node
1.	0.442	3.954	↑ 4.0	50	1	→ GroupAggregate (cost=31.23..34.73 rows=200 width=105) (actual time=3.316..3.954 rows=50 loops=1)
2.	1.979	3.512	↑ 1.0	200	1	→ Sort (cost=31.23..31.73 rows=200 width=105) (actual time=3.297..3.512 rows=200 loops=1) Sort Key: goods.name Sort Method: quicksort Memory: 53kB
3.	0.554	1.533	↑ 1.0	200	1	→ Merge Join (cost=17.64..23.58 rows=200 width=105) (actual time=0.693..1.533 rows=200 loops=1) Merge Cond: (goods.id = goodsoperations.goods_id)
4.	0.092	0.092	↑ 19.6	51	1	→ Index Scan using goods_pkey on goods (cost=0.00..56.25 rows=1000 width=105) (actual time=0.016..0.092 rows=51 loops=1)
5.	0.599	0.887	↑ 1.0	200	1	→ Sort (cost=17.64..18.14 rows=200 width=8) (actual time=0.666..0.887 rows=200 loops=1) Sort Key: goodsoperations.goods_id Sort Method: quicksort Memory: 34kB
6.	0.288	0.288	↑ 1.0	200	1	→ Seq Scan on goodsoperations (cost=0.00..10.00 rows=200 width=8) (actual time=0.008..0.288 rows=200 loops=1)

 GroupAggregate  (cost=31.23..34.73 rows=200 width=105) (actual time=3.316..3.954 rows=50 loops=1) 
   ->  Sort  (cost=31.23..31.73 rows=200 width=105) (actual time=3.297..3.512 rows=200 loops=1) 
         Sort Key: goods.name 
         Sort Method: quicksort  Memory: 53kB 
         ->  Merge Join  (cost=17.64..23.58 rows=200 width=105) (actual time=0.693..1.533 rows=200 loops=1) 
               Merge Cond: (goods.id = goodsoperations.goods_id) 
               ->  Index Scan using goods_pkey on goods  (cost=0.00..56.25 rows=1000 width=105) (actual time=0.016..0.092 rows=51 loops=1) 
               ->  Sort  (cost=17.64..18.14 rows=200 width=8) (actual time=0.666..0.887 rows=200 loops=1) 
                     Sort Key: goodsoperations.goods_id 
                     Sort Method: quicksort  Memory: 34kB 
                     ->  Seq Scan on goodsoperations  (cost=0.00..10.00 rows=200 width=8) (actual time=0.008..0.288 rows=200 loops=1) 
 Total runtime: 4.163 ms

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	1	0.442 ms	11.2 %
Index Scan	1	0.092 ms	2.3 %
Merge Join	1	0.554 ms	14.0 %
Seq Scan	1	0.288 ms	7.3 %
Sort	2	2.578 ms	65.2 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
goods	1	0.092 ms	2.3 %
Index Scan	1	0.092 ms	100.0 %
goodsoperations	1	0.288 ms	7.3 %
Seq Scan	1	0.288 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: f26

Colorize:

Columns visibility:

Per node type stats

Per table stats