explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MWcV : Optimization for: Optimization for: plan #PlA2; plan #ENM

Settings

Optimization path:

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

Bitmap Heap Scan on item_2018_11 (cost=12,383.93..53,693.57 rows=582,976 width=93) (actual time=31.211..146.046 rows=579,540 loops=1)

  • Recheck Cond: ((data_pagamento >= '2018-11-10'::date) AND (data_pagamento <= '2018-11-20'::date))
  • Heap Blocks: exact=19513
2. 28.781 28.781 ↑ 1.0 579,540 1

Bitmap Index Scan on item_2018_11_data_pagamento (cost=0.00..12,238.19 rows=582,976 width=0) (actual time=28.781..28.781 rows=579,540 loops=1)

  • Index Cond: ((data_pagamento >= '2018-11-10'::date) AND (data_pagamento <= '2018-11-20'::date))
Planning time : 0.331 ms
Execution time : 161.658 ms