explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DKHE : Optimization for: plan #PlA2

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 459.024 459.024 ↑ 1.0 2,136,225 1

Seq Scan on item_2018_11 (cost=0.00..64,608.38 rows=2,136,225 width=93) (actual time=0.016..459.024 rows=2,136,225 loops=1)

  • Filter: ((data_pagamento >= '2018-11-01'::date) AND (data_pagamento <= '2018-11-30'::date))
Planning time : 0.204 ms
Execution time : 517.201 ms