explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4JeM : Optimization for: Optimization for: Optimization for: plan #70jY; plan #Knev; plan #LALi

Settings

Optimization path:

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

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

  • Output: id, pagamento_id, beneficiario_id, status_analise_glosa, numero, data_atendimento_inicio, data_atendimento_fim, senha, valor_total_apresentado, valor_total_pago, diferenca, valor_total_glosa_informada, quantidade_itens, id_tenant, id_nucleo, guia_associada, valor_total_recursado, valor_total_aceito
  • Index Cond: ((guia.data_atendimento_inicio >= '2018-11-10'::date) AND (guia.data_atendimento_inicio <= '2018-11-20'::date))
  • Buffers: shared hit=34,924 read=19,124
  • Functions: 2
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 0.527 ms, Inlining 0.000 ms, Optimization 0.000 ms, Emission 0.000 ms, Total 0.527 ms
Execution time : 158.842 ms