Realmente Fabrízio, funcionou normalmente.. Não entendo a lógica do type cast alterar a leitura indexada, mas enfim, agradeço !!! Obrigado.
Renato Becker 2012/6/26 Fabrízio de Royes Mello <[email protected]> > > > Em 26 de junho de 2012 16:27, Renato Augusto <[email protected]>escreveu: > > Olá Flávio.. >> Sim, já rodei o ANALYZE, VACUUM e REINDEX, mas o EXPLAIN continua com >> essa diferença absurda.. >> A tabela tem 66.000 registros, segue o SQL: >> >> EXPLAIN ANALYZE >> SELECT hist.endterminal AS "hist.endterminal", >> hist.indice, >> hist.funcao, >> hist.numos, >> hist.codfunc, >> hist.fase, >> hist.maquina, >> hist.datahoraini, >> hist.datahorafim, >> hist.qtdeproduzida, >> hist.qtderejeitada, >> hist.apontamnumerico, >> hist.horimetro, >> hist.atualizado >> FROM autech.thistprod hist >> WHERE ( ( hist.datahorafim >= '06/20/2012' AND hist.datahorafim <= >> '06/26/2012')) >> --WHERE ( ( hist.datahorafim::date between '06/20/2012' and >> '06/26/2012')) >> ORDER BY 1,1 >> >> > Retire aquele "::date" do teu WHERE com BETWEEN e repita o teste. > > Att, > > -- > Fabrízio de Royes Mello > Consultoria/Coaching PostgreSQL > >> Blog sobre TI: http://fabriziomello.blogspot.com > >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello > >> Twitter: http://twitter.com/fabriziomello > > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > >
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
