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
