explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ENM : Optimization for: plan #PlA2

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 361.267 361.267 ↑ 1.0 579,540 1

Seq Scan on item_2018_11 (cost=0.00..64,608.38 rows=582,976 width=93) (actual time=0.012..361.267 rows=579,540 loops=1)

  • Filter: ((data_pagamento >= '2018-11-10'::date) AND (data_pagamento <= '2018-11-20'::date))
  • Rows Removed by Filter: 1556685
Planning time : 0.126 ms
Execution time : 377.150 ms