explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZQ8x : 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. 171.227 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
  • Sort Method: quicksort Memory: 45774kB
3. 146.798 330.585 ↑ 1.0 329,888 1

Merge Join (cost=1.88..82,722.94 rows=329,888 width=44) (actual time=0.015..330.585 rows=329,888 loops=1)

  • Merge Cond: (pro2.cod = pro3.cod)
4. 41.740 41.740 ↑ 2.4 82,472 1

Index Scan using gcepro02_pkey on gcepro02 pro2 (cost=0.42..39,852.07 rows=194,776 width=37) (actual time=0.007..41.740 rows=82,472 loops=1)

5. 142.047 142.047 ↑ 1.0 329,888 1

Index Scan using gcepro03_002 on gcepro03 pro3 (cost=0.42..38,260.92 rows=329,888 width=13) (actual time=0.003..142.047 rows=329,888 loops=1)