On 22-04-2014 19:22, Luiz Carlos L. Nogueira Jr. wrote: > Complementando com o log > > 2014-04-22 07:19:03 BRT [2324]: [3-1] db=pje_jud1g_descanso_p,user= > [email protected](50419) 0:34/128715 LOG: temporary file: path > "base/pgsql_tmp/pgsql_tmp2324.0", size 23199744 > 2014-04-22 07:19:03 BRT [2324]: [4-1] db=pje_jud1g_descanso_p,user= > [email protected](50419) 0:34/128715 STATEMENT: select > processo0_.id_processo as id1_488_0_, processo0_.nm_actor_id as nm2_488_0_, > processo0_.id_caixa as id11_488_0_, processo0_.ds_complemento as > ds3_488_0_, processo0_.dt_fim as dt4_488_0_, processo0_.dt_inicio as > dt5_488_0_, processo0_.nr_duracao as nr6_488_0_, processo0_.id_fluxo as > id12_488_0_, processo0_.id_jbpm as id7_488_0_, > processo0_.ds_nm_usu_cadastro_processo as ds8_488_0_, > processo0_.nr_processo as nr9_488_0_, processo0_.nr_processo_origem as > nr10_488_0_, processo0_.id_status as id13_488_0_, > processo0_.id_usuario_cadastro_processo as id14_488_0_ from tb_processo > processo0_ where processo0_.id_processo=$1 >
Qual o valor do seu work_mem? Rode um EXPLAIN ANALYZE da sua query setando os seguintes parametros e poste aqui o resultado: SET trace_sort=true; SET client_min_messages=log; SET log_temp_files=0; EXPLAIN ANALYZE ... Att, -- Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
