explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9f39

Settings
# exclusive inclusive rows x rows loops node
1. 13.785 13.785 ↓ 0.0 0 1

Index Scan using all_tb_toa_hist_dt_hr_fech_idx on all_tb_toa_hist (cost=0.56..299.50 rows=1 width=10,356) (actual time=13.784..13.785 rows=0 loops=1)

  • Index Cond: (("DT_HR_Fech" >= (now() - '15 days'::interval)) AND (("ServiceID")::text = '146788778'::text) AND (("Estado")::text = 'Concluída'::text))
  • Filter: (("TipoAtiv")::text = ANY ('{Instalação,"Instalação Banda Larga + VoIP","Instalação Bundle GPON + VoIP","Instalação GPON"}'::text[]))
Planning time : 24.681 ms
Execution time : 13.862 ms