explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Knev : Optimization for: plan #70jY

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 172.261 172.261 ↑ 1.2 316,875 1

Index Scan using item_data_atendimento on guia (cost=0.43..101,124.71 rows=382,373 width=102) (actual time=0.022..172.261 rows=316,875 loops=1)

  • Index Cond: ((data_atendimento_inicio >= '2018-11-10'::date) AND (data_atendimento_inicio <= '2018-11-20'::date))
  • Functions: 2
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 0.326 ms, Inlining 0.000 ms, Optimization 0.000 ms, Emission 0.000 ms, Total 0.326 ms
Execution time : 181.834 ms