explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cZEY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3,423.061 ↑ 21.1 8 1

Finalize GroupAggregate (cost=1,513,498.53..1,513,519.59 rows=169 width=12) (actual time=3,422.578..3,423.061 rows=8 loops=1)

  • Group Key: fk_usuario
2. 30.696 3,450.277 ↑ 6.2 24 1

Gather Merge (cost=1,513,498.53..1,513,517.15 rows=150 width=12) (actual time=3,422.515..3,450.277 rows=24 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.231 3,419.581 ↑ 9.4 8 3 / 3

Partial GroupAggregate (cost=1,512,498.50..1,512,499.81 rows=75 width=12) (actual time=3,419.207..3,419.581 rows=8 loops=3)

  • Group Key: fk_usuario
4. 0.541 3,419.350 ↓ 5.5 409 3 / 3

Sort (cost=1,512,498.50..1,512,498.69 rows=75 width=12) (actual time=3,419.142..3,419.350 rows=409 loops=3)

  • Sort Key: fk_usuario
  • Sort Method: quicksort Memory: 47kB
5. 3,418.809 3,418.809 ↓ 5.5 409 3 / 3

Parallel Seq Scan on "RastreamentoDetalhamento" (cost=0.00..1,512,496.17 rows=75 width=12) (actual time=109.779..3,418.809 rows=409 loops=3)

  • Filter: ((data_hora_ocorrencia >= '2019-09-05 00:00:00-03'::timestamp with time zone) AND (data_hora_ocorrencia <= '2019-09-05 23:59:00-03'::timestamp with time zone) AND (fk_usuario = ANY ('{177,445,1274,3291,2251,4683,4263,4883}'::integer[])))
  • Rows Removed by Filter: 18,526,330