explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CcO

Settings
# exclusive inclusive rows x rows loops node
1. 145.807 673.351 ↓ 0.0 0 1

GroupAggregate (cost=127,950.05..147,941.93 rows=296,176 width=16) (actual time=673.351..673.351 rows=0 loops=1)

  • Group Key: "Posicao
  • Filter: (count(*) > 1)
  • Rows Removed by Filter: 888606
2. 332.439 527.544 ↓ 1.0 888,606 1

Sort (cost=127,950.05..130,171.37 rows=888,528 width=8) (actual time=455.244..527.544 rows=888,606 loops=1)

  • Sort Key: "Posicao
  • Sort Method: external merge Disk: 15736kB
3. 195.105 195.105 ↓ 1.0 888,606 1

Seq Scan on "Socios" (cost=0.00..28,010.28 rows=888,528 width=8) (actual time=0.053..195.105 rows=888,606 loops=1)

Planning time : 0.088 ms
Execution time : 679.887 ms