explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rgC3 : teste

Settings
# 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