explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W6Gi

Settings
# exclusive inclusive rows x rows loops node
1. 6.514 14,419.504 ↑ 6.0 1,005 1

Finalize GroupAggregate (cost=123,303.01..123,499.22 rows=6,037 width=36) (actual time=14,411.603..14,419.504 rows=1,005 loops=1)

  • Group Key: localidade_id
2. 3.187 14,412.990 ↑ 4.6 2,639 1

Sort (cost=123,303.01..123,333.20 rows=12,074 width=36) (actual time=14,411.586..14,412.990 rows=2,639 loops=1)

  • Sort Key: localidade_id
  • Sort Method: quicksort Memory: 303kB
3. 15.918 14,409.803 ↑ 4.6 2,639 1

Gather (cost=121,201.56..122,484.42 rows=12,074 width=36) (actual time=14,395.705..14,409.803 rows=2,639 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 1,182.069 14,393.885 ↑ 6.9 880 3 / 3

Partial HashAggregate (cost=120,201.56..120,277.02 rows=6,037 width=36) (actual time=14,392.310..14,393.885 rows=880 loops=3)

  • Group Key: localidade_id
5. 13,211.816 13,211.816 ↑ 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=1.015..13,211.816 rows=1,153,964 loops=3)