explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cZ5F

Settings
# exclusive inclusive rows x rows loops node
1. 16.173 55,236.832 ↑ 120.3 4,163 1

Nested Loop (cost=0.25..58,967.98 rows=501,000 width=8) (actual time=539.996..55,236.832 rows=4,163 loops=1)

2. 2,178.109 2,178.109 ↓ 6.8 3,410 1

Seq Scan on movimentofinanceiro mf (cost=0.00..48,947.73 rows=501 width=8) (actual time=473.836..2,178.109 rows=3,410 loops=1)

  • Filter: ((databaixa >= '2019-05-01'::date) AND (databaixa <= '2019-05-31'::date) AND (tipofinanceiro = 3))
  • Rows Removed by Filter: 1041700
3. 53,042.550 53,042.550 ↑ 1,000.0 1 3,410

Function Scan on agregados_rc ag (cost=0.25..10.25 rows=1,000 width=0) (actual time=15.555..15.555 rows=1 loops=3,410)

Planning time : 0.671 ms
Execution time : 55,237.937 ms