explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FQGE

Settings
# exclusive inclusive rows x rows loops node
1. 0.072 3,342.925 ↑ 2,380.7 64 1

Finalize GroupAggregate (cost=1,160,356.73..1,242,091.73 rows=152,366 width=22) (actual time=3,329.088..3,342.925 rows=64 loops=1)

  • Group Key: tipo, (date_trunc('month'::text, timezone('America/Sao_Paulo'::text, timezone('UTC'::text, create_date))))
  • Functions: 48
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 9.936 ms, Inlining 270.658 ms, Optimization 529.242 ms, Emission 342.547 ms, Total 1152.384 ms
2. 40.246 3,342.853 ↑ 1,904.6 320 1

Gather Merge (cost=1,160,356.73..1,233,330.68 rows=609,464 width=22) (actual time=3,329.070..3,342.853 rows=320 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 0.094 3,302.607 ↑ 2,380.7 64 5 / 5

Sort (cost=1,155,356.67..1,155,737.59 rows=152,366 width=22) (actual time=3,302.602..3,302.607 rows=64 loops=5)

  • Sort Key: tipo, (date_trunc('month'::text, timezone('America/Sao_Paulo'::text, timezone('UTC'::text, create_date))))
  • Sort Method: quicksort Memory: 30kB
  • Worker 0: Sort Method: quicksort Memory: 30kB
  • Worker 1: Sort Method: quicksort Memory: 30kB
  • Worker 2: Sort Method: quicksort Memory: 30kB
  • Worker 3: Sort Method: quicksort Memory: 30kB
4. 524.369 3,302.513 ↑ 2,380.7 64 5 / 5

Partial HashAggregate (cost=1,139,573.70..1,142,240.11 rows=152,366 width=22) (actual time=3,301.467..3,302.513 rows=64 loops=5)

  • Group Key: tipo, date_trunc('month'::text, timezone('America/Sao_Paulo'::text, timezone('UTC'::text, create_date)))
5. 2,778.144 2,778.144 ↑ 1.3 2,335,201 5 / 5

Parallel Seq Scan on dossie_movimentacao (cost=0.00..1,110,051.75 rows=2,952,195 width=14) (actual time=228.823..2,778.144 rows=2,335,201 loops=5)

  • Filter: (active AND (tipo IS NOT NULL) AND (tipo_movimentacao_id IS NOT NULL))
  • Rows Removed by Filter: 215,899
Planning time : 0.493 ms
Execution time : 3,351.442 ms