> > >
Segue resultado do pgbadger RankSizeQuery176.05 MiB SELECT processo0_.id_processo AS id1_189_0_, processo0_.nm_actor_id AS nm2_189_0_, processo0_.id_caixa ASid12_189_0_, processo0_.ds_complemento AS ds3_189_0_, processo0_.dt_fim AS dt4_189_0_, processo0_.dt_inicio AS dt5_189_0_, processo0_.nr_duracao AS nr6_189_0_, processo0_.id_fluxo AS id13_189_0_, processo0_.id_jbpm ASid7_189_0_, processo0_. ds_nm_usu_cadastro_processo AS ds8_189_0_, processo0_.nr_processo AS nr9_189_0_,processo0_.nr_processo_origem AS nr10_189_0_, processo0_. nr_processo_temp AS nr11_189_0_, processo0_.id_status ASid14_189_0_, processo0_.id_usuario_cadastro_processo AS id15_189_0_ FROM tb_processo processo0_ WHEREprocesso0_.id_processo = $1; -- Aqui é uma PK [ *Date:* 2015-02-18 21:09:24 - *Database:* xxx - *User:* xxxxxxx (49926) 0:60/522437 ] Segue Log 2015-02-18 21:09:16 BRT [13660]: [5-1] db=pxxx...xxx (49926) 0:60/522437 LOG: duration: 5306.735 ms execute <unnamed>: select count(distinct processopa0_.id_processo_trf) as col_0_0_ from tb_proc_parte_expediente processopa0_ left outer join tb_processo_trf processotr1_ on processopa0_.id_processo_trf=processotr1_.id_processo_trf left outer join tb_processo_caixa_adv_proc caixasrepr2_ on processotr1_.id_processo_trf=caixasrepr2_.id_processo_trf inner join tb_processo_parte processopa4_ on processotr1_.id_processo_trf=processopa4_.id_processo_trf left outer join tb_proc_parte_represntante processopa5_ on processopa4_.id_processo_parte=processopa5_.id_processo_parte, tb_pessoa pessoa8_ inner join tb_usuario pessoa8_1_ on pessoa8_.id_pessoa=pessoa8_1_.id_usuario inner join tb_usuario_login pessoa8_2_ on pessoa8_.id_pessoa=pessoa8_2_.id_usuario, tb_orgao_julgador orgaojulga10_ where processopa4_.id_pessoa=pessoa8_.id_pessoa and processotr1_.id_orgao_julgador=orgaojulga10_.id_orgao_julgador and (processopa5_.id_representante=$1 and processopa4_.id_pessoa=processopa0_.id_pessoa_parte or processopa0_.id_pessoa_parte in ($2)) and (processopa0_.id_resposta is null) and ( not (exists (select processopa7_.id_proc_parte_representante from tb_proc_parte_represntante processopa7_ where processopa4_.id_processo_parte=processopa7_.id_processo_parte)) or processopa5_.in_situacao=$3 or pessoa8_.id_pessoa=$4) and orgaojulga10_.id_jurisdicao=$5 and (caixasrepr2_.id_caixa_adv_proc is null) and processopa0_.in_fechado=$6 and processotr1_.cd_processo_status=$7 and processopa4_.in_situacao=$8 and (processopa0_.dt_ciencia_parte is not null) limit $9 2015-02-18 21:09:16 BRT [13660]: [6-1] db=pxxx...xxx (49926) 0:60/522437 DETAIL: parameters: $1 = '144859', $2 = '144859', $3 = 'A', $4 = '144859', $5 = '2', $6 = 'f', $7 = 'D', $8 = 'A', $9 = '1' 2015-02-18 21:09:24 BRT [13660]: [7-1] db=pxxx...xxx (49926) 0:60/522437 LOG: duration: 7384.559 ms execute <unnamed>: select distinct processotr1_.id_processo_trf as id1_6_, processotr1_.nr_ano as nr2_6_, processotr1_.in_apreciado_justica_gratuita as in3_6_, processotr1_.in_apreciado_segredo as in4_6_, processotr1_.in_apreciado_sigilo as in5_6_, processotr1_.in_apreciado_tutela_liminar as in6_6_, processotr1_.id_cargo as id36_6_, processotr1_.id_classe_judicial as id37_6_, processotr1_.id_cl_judicial_outra_instancia as id38_6_, processotr1_.id_competencia as id39_6_, processotr1_.dt_autuacao as dt7_6_, processotr1_.dt_distribuicao as dt8_6_, processotr1_.dt_sugestao_sessao as dt9_6_, processotr1_.ds_proc_referencia as ds10_6_, processotr1_.in_deve_marcar_audiencia as in11_6_, processotr1_.dt_transitado_julgado as dt12_6_, processotr1_.id_endereco_wsdl as id40_6_, processotr1_.id_estrutura_inicial as id41_6_, processotr1_.in_outra_instancia as in13_6_, processotr1_.in_inicial as in14_6_, processotr1_.nr_instancia as nr15_6_, processotr1_.in_incidente as in16_6_, processotr1_.id_jurisdicao as id42_6_, processotr1_.in_justica_gratuita as in17_6_, processotr1_.id_localizacao_inicial as id43_6_, processotr1_.in_mandado_devolvido as in18_6_, processotr1_.id_municipio_fato_principal as id44_6_, processotr1_.nr_digito_verificador as nr19_6_, processotr1_.nr_identificacao_orgao_justica as nr20_6_, processotr1_.nr_origem_processo as nr21_6_, processotr1_.nr_sequencia as nr22_6_, processotr1_.ds_observacao_segredo as ds24_6_, processotr1_.id_orgao_julgador as id45_6_, processotr1_.id_orgao_julgador_cargo as id46_6_, processotr1_.id_orgao_julgador_colegiado as id47_6_, processotr1_.id_orgao_julgador_revisor as id48_6_, processotr1_.id_pes_apreciou_jus_gratuita as id49_6_, processotr1_.id_pessoa_marcou_julgamento as id50_6_, processotr1_.id_pessoa_marcou_pauta as id51_6_, processotr1_.id_pessoa_marcou_revisado as id52_6_, processotr1_.id_pessoa_relator_processo as id53_6_, processotr1_.id_proc_referencia as id54_6_, processotr1_.cd_processo_status as cd25_6_, processotr1_.in_pronto_revisao as in26_6_, processotr1_.in_revisado as in27_6_, processotr1_.in_segredo_justica as in28_6_, processotr1_.in_selecionado_julgamento as in29_6_, processotr1_.in_selecionado_pauta as in30_6_, processotr1_.id_sessao_sugerida as id55_6_, processotr1_.in_tutela_liminar as in31_6_, processotr1_.vl_causa as vl32_6_, processotr1_.vl_peso_distribuicao as vl33_6_, processotr1_.vl_peso_processual as vl34_6_, processotr1_.in_violacao_faixa_valores as in35_6_ from tb_proc_parte_expediente processopa0_ left outer join tb_processo_trf processotr1_ on processopa0_.id_processo_trf=processotr1_.id_processo_trf left outer join tb_processo_caixa_adv_proc caixasrepr2_ on processotr1_.id_processo_trf=caixasrepr2_.id_processo_trf inner join tb_processo_parte processopa4_ on processotr1_.id_processo_trf=processopa4_.id_processo_trf left outer join tb_proc_parte_represntante processopa5_ on processopa4_.id_processo_parte=processopa5_.id_processo_parte, tb_pessoa pessoa8_ inner join tb_usuario pessoa8_1_ on pessoa8_.id_pessoa=pessoa8_1_.id_usuario inner join tb_usuario_login pessoa8_2_ on pessoa8_.id_pessoa=pessoa8_2_.id_usuario, tb_orgao_julgador orgaojulga10_ where processopa4_.id_pessoa=pessoa8_.id_pessoa and processotr1_.id_orgao_julgador=orgaojulga10_.id_orgao_julgador and (processopa5_.id_representante=$1 and processopa4_.id_pessoa=processopa0_.id_pessoa_parte or processopa0_.id_pessoa_parte in ($2)) and (processopa0_.id_resposta is null) and ( not (exists (select processopa7_.id_proc_parte_representante from tb_proc_parte_represntante processopa7_ where processopa4_.id_processo_parte=processopa7_.id_processo_parte)) or processopa5_.in_situacao=$3 or pessoa8_.id_pessoa=$4) and orgaojulga10_.id_jurisdicao=$5 and (caixasrepr2_.id_caixa_adv_proc is null) and processopa0_.in_fechado=$6 and processotr1_.cd_processo_status=$7 and processopa4_.in_situacao=$8 and (processopa0_.dt_ciencia_parte is not null) limit $9 2015-02-18 21:09:24 BRT [13660]: [8-1] db=pxxx...xxx (49926) 0:60/522437 DETAIL: parameters: $1 = '144859', $2 = '144859', $3 = 'A', $4 = '144859', $5 = '2', $6 = 'f', $7 = 'D', $8 = 'A', $9 = '5' 2015-02-18 21:09:24 BRT [13660]: [9-1] db=pxxx...xxx (49926) 0:60/522437 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp13660.0", size 79749120 2015-02-18 21:09:24 BRT [13660]: [10-1] db=pxxx...xxx (49926) 0:60/522437 STATEMENT: select processo0_.id_processo as id1_189_0_, processo0_.nm_actor_id as nm2_189_0_, processo0_.id_caixa as id12_189_0_, processo0_.ds_complemento as ds3_189_0_, processo0_.dt_fim as dt4_189_0_, processo0_.dt_inicio as dt5_189_0_, processo0_.nr_duracao as nr6_189_0_, processo0_.id_fluxo as id13_189_0_, processo0_.id_jbpm as id7_189_0_, processo0_.ds_nm_usu_cadastro_processo as ds8_189_0_, processo0_.nr_processo as nr9_189_0_, processo0_.nr_processo_origem as nr10_189_0_, processo0_.nr_processo_temp as nr11_189_0_, processo0_.id_status as id14_189_0_, processo0_.id_usuario_cadastro_processo as id15_189_0_ from tb_processo processo0_ where processo0_.id_processo=$1 A query que gerou o temp foi o select distinct (Acima) e não a que apareceu no pgbadger (abaixo da criação do temp)
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
