explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mVwF

Settings
# exclusive inclusive rows x rows loops node
1. 3.774 4,924.657 ↑ 6.0 1,005 1

Finalize GroupAggregate (cost=123,303.01..123,499.22 rows=6,037 width=36) (actual time=4,919.822..4,924.657 rows=1,005 loops=1)

  • Group Key: localidade_id
2. 2.388 4,920.883 ↑ 5.5 2,191 1

Sort (cost=123,303.01..123,333.20 rows=12,074 width=36) (actual time=4,919.813..4,920.883 rows=2,191 loops=1)

  • Sort Key: localidade_id
  • Sort Method: quicksort Memory: 268kB
3. 18.404 4,918.495 ↑ 5.5 2,191 1

Gather (cost=121,201.56..122,484.42 rows=12,074 width=36) (actual time=4,904.614..4,918.495 rows=2,191 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 2,340.440 4,900.091 ↑ 8.3 730 3 / 3

Partial HashAggregate (cost=120,201.56..120,277.02 rows=6,037 width=36) (actual time=4,898.043..4,900.091 rows=730 loops=3)

  • Group Key: localidade_id
5. 2,559.651 2,559.651 ↑ 1.3 1,153,964 3 / 3

Parallel Index Scan using idxviewvotosporbairromuncustom on viewvotosporbairro (cost=0.43..112,929.67 rows=1,454,378 width=9) (actual time=0.039..2,559.651 rows=1,153,964 loops=3)