#	exclusive	inclusive	rows x	rows	loops	node
1.	404.409	906.221	↑ 4.0	82,472	1	→ GroupAggregate (cost=112,959.84..121,207.04 rows=329,888 width=69) (actual time=476.949..906.221 rows=82,472 loops=1)
2.	501.812	501.812	↑ 1.0	329,888	1	→ Sort (cost=112,959.84..113,784.56 rows=329,888 width=44) (actual time=476.785..501.812 rows=329,888 loops=1) Sort Key: pro3.cod, pro2.dsc

GroupAggregate  (cost=112959.84..121207.04 rows=329888 width=69) (actual time=476.949..906.221 rows=82472 loops=1)
Group Key: pro3.cod, pro2.dsc
  ->  Sort  (cost=112959.84..113784.56 rows=329888 width=44) (actual time=476.785..501.812 rows=329888 loops=1)
        Sort Key: pro3.cod, pro2.dsc

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	1	404.409 ms	44.6 %
Sort	1	501.812 ms	55.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rgC3 : teste

Color mode:

Visible columns:

Per node type stats

Per table stats