explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7dID

Settings
# exclusive inclusive rows x rows loops node
1. 3.314 39,425.199 ↑ 6.0 1,005 1

Finalize GroupAggregate (cost=233,263.51..233,459.71 rows=6,037 width=36) (actual time=39,414.463..39,425.199 rows=1,005 loops=1)

  • Group Key: localidade_id
2. 8.876 39,421.885 ↑ 5.6 2,168 1

Sort (cost=233,263.51..233,293.69 rows=12,074 width=36) (actual time=39,414.450..39,421.885 rows=2,168 loops=1)

  • Sort Key: localidade_id
  • Sort Method: quicksort Memory: 266kB
3. 7.450 39,413.009 ↑ 5.6 2,168 1

Gather (cost=231,162.05..232,444.91 rows=12,074 width=36) (actual time=39,410.457..39,413.009 rows=2,168 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 2,347.825 39,405.559 ↑ 8.3 723 3 / 3

Partial HashAggregate (cost=230,162.05..230,237.51 rows=6,037 width=36) (actual time=39,404.742..39,405.559 rows=723 loops=3)

  • Group Key: localidade_id
5. 37,057.734 37,057.734 ↑ 1.3 1,153,964 3 / 3

Parallel Seq Scan on viewvotosporbairro (cost=0.00..222,890.16 rows=1,454,378 width=9) (actual time=30,251.932..37,057.734 rows=1,153,964 loops=3)

  • Filter: (municipio_id = 563)
  • Rows Removed by Filter: 3078495