explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DWA9

Settings
# exclusive inclusive rows x rows loops node
1. 196.575 593.251 ↓ 6.8 3,410 1

Gather (cost=1,000.00..39,315.78 rows=501 width=8) (actual time=37.355..593.251 rows=3,410 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 396.676 396.676 ↓ 5.4 1,137 3

Parallel Seq Scan on movimentofinanceiro mf (cost=0.00..38,265.68 rows=209 width=8) (actual time=18.808..396.676 rows=1,137 loops=3)

  • Filter: ((databaixa >= '2019-05-01'::date) AND (databaixa <= '2019-05-31'::date) AND (tipofinanceiro = 3))
  • Rows Removed by Filter: 347236
Planning time : 0.563 ms
Execution time : 593.482 ms