explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Kwe

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

Sort (cost=6,836.71..6,836.71 rows=1 width=1,925) (actual rows= loops=)

  • Output: activityhi0_.hps_codigo, schedule1_.tar_codigo, activity2_.pes_codigo, client3_.cli_codigo, items4_.hpi_codigo, section5_.sec_codigo, item6_.ite_codigo, sectionfie7_.spq_codigo, field8_.crp_codigo, activityhi0_.pes_codigo, activityhi0_.age_codigopda, activityhi0_.hps_statusexpbi, activityhi0_.hps_cli_codigo, activityhi0_.hps_origemdados, activityhi0_.hps_datahorasincronismo, activityhi0_.hps_arquivoexportacao, activityhi0_.hps_statusexpexec, activityhi0_.hps_datahorafiminform, activityhi0_.hps_datahorafimsistema, activityhi0_.hps_codigopda, activityhi0_.hps_totalfotosrecebidas, activityhi0_.hps_totalfotos, activityhi0_.hps_datahorafoto, activityhi0_.tar_codigo, activityhi0_.hps_datahorainicioinform, activityhi0_.hps_datahorainiciosistema, activityhi0_.hps_status, activityhi0_.hps_statusaprovacao, activityhi0_.hps_tokenimpressao, schedule1_.tar_tokenacesso, schedule1_.tar_ativo, schedule1_.tar_origematividade, schedule1_.age_codigo, schedule1_.age_codigoinclusao, schedule1_.tar_ageultimaatualizacao, schedule1_.tar_identificadoralternativo, schedule1_.tar_cli_codigo, schedule1_.tar_complementoregistro1, schedule1_.tar_complementoregistro10, schedule1_.tar_complementoregistro2, schedule1_.tar_complementoregistro3, schedule1_.tar_complementoregistro4, schedule1_.tar_complementoregistro5, schedule1_.tar_complementoregistro6, schedule1_.tar_complementoregistro7, schedule1_.tar_complementoregistro8, schedule1_.tar_complementoregistro9, schedule1_.tar_data, schedule1_.tar_dataexecucao, schedule1_.tar_datafimreal, schedule1_.tar_horafimreal, schedule1_.tar_datafimprev, schedule1_.tar_horafimprev, schedule1_.tar_horaexecucao, schedule1_.tar_datainicioreal, schedule1_.tar_horainicioreal, schedule1_.tar_dtprevcomtoleranciapos, schedule1_.tar_situacaoexportacao, schedule1_.tar_grupo, schedule1_.tar_hora, schedule1_.mid_codigo, schedule1_.tar_datahorainclusao, schedule1_.tar_moduloinclusao, schedule1_.tar_ultimaatualizacao, schedule1_.tar_observacao, schedule1_.tar_origem, schedule1_.tar_codigotarefaorigem, schedule1_.tar_prioridade, schedule1_.tar_duplicanopda, schedule1_.tpt_codigo, schedule1_.tar_envianotificacao, schedule1_.loc_codigo, schedule1_.sit_codigo, schedule1_.tar_finalizadoautomatico, schedule1_.tar_dataultimosinc, schedule1_.tar_horaultimosinc, schedule1_.eqp_codigo, schedule1_.tar_execucaoequipe, schedule1_.tar_alertaposfim, schedule1_.tar_alertaposinicio, schedule1_.tar_alertaprefim, schedule1_.tar_alertapreinicio, schedule1_.tar_bloqueioposinicio, schedule1_.tar_bloqueiopreinicio, schedule1_.tar_moduloultimaedicao, schedule1_.tar_validadatahorainicio, schedule1_.tar_tempoespera, activity2_.pes_gpsobrigatorio, activity2_.pes_execucaoacelerada, activity2_.pes_ativo, activity2_.tpq_codigo, activity2_.age_codigoinclusao, activity2_.age_codigoultimaedicao, activity2_.pes_identificadoralternativo, activity2_.pes_codpesqantecessora, activity2_.pes_tipoexecpesimpeditiva, activity2_.pes_tipoexecpesantecessora, activity2_.pes_cancelamentoseguro, activity2_.pes_capturagps, activity2_.pes_cli_codigo, activity2_.pes_tipocomunicacao, activity2_.pes_confirmaencerramento, activity2_.pes_confirmasemgps, activity2_.pes_descricao, activity2_.pes_exibetelaconferencia, activity2_.pes_ordemexibicao, activity2_.pes_documentacao, activity2_.pes_compartilhadados, activity2_.pes_mensagemfinalizadora, activity2_.pes_exclusivo, activity2_.pes_tipoexecucao, activity2_.lei_codigo, activity2_.lei_codigoexecucao, activity2_.pes_funcaoestrutural, activity2_.mid_codigo, activity2_.pes_dthorainclusao, activity2_.pes_moduloinclusao, activity2_.pes_ultatualizacao, activity2_.pes_bloqueiaedicao, activity2_.pes_execucaoemloop, activity2_.pes_quantidademaximafoto, activity2_.pes_podesuspenderexecucao, activity2_.pes_quantidademinimafoto, activity2_.pes_execucaonegativa, activity2_.pes_dicafoto, activity2_.pes_raioexecucaoautomatica, activity2_.pes_informadataexecucao, activity2_.pes_informadataexecucaomob, activity2_.pes_exibemsgcancelamento, activity2_.pes_exibesecaoemformweb, activity2_.pes_estrutural, activity2_.pes_capturaaudio, activity2_.pes_capturafoto, activity2_.pes_moduloultimaedicao, activity2_.pes_obrigatorio, client3_.cli_aceitetermosdeuso, client3_.cli_datahoradoaceite, client3_.cli_ativo, client3_.cli_informacoescontrato, client3_.cli_alias, client3_.cli_atualizacaoapp, client3_.vap_codigo, client3_.tau_codigo, client3_.cli_tipoautenticacao, client3_.cli_fatura, client3_.cli_cidade, client3_.cli_codigogrupo, client3_.cli_cnpj, client3_.cli_razaosocial, client3_.cli_complementologradouro, client3_.cli_emailcontato, client3_.cli_contato, client3_.cli_telefone, client3_.cli_pais, client3_.cli_descricao, client3_.dic_codigo, client3_.tem_codigo, client3_.cli_habilitatermosdeuso, client3_.cli_statusdadoscompl, client3_.cli_resetouambiente, client3_.cli_tipoambiente, client3_.cli_feztour, client3_.cli_possuidatalimite, client3_.cli_ultatualizacao, client3_.cli_qtdelicencastmp, client3_.cli_datalimite, client3_.cli_centralizador, client3_.cli_bairro, client3_.cli_numerologradouro, client3_.cli_observacao, client3_.cli_pedido, client3_.prc_codigo, client3_.cli_codclienteparceiro, client3_.cli_tipoplanocomprado, client3_.cli_modorelacionamento, client3_.cli_tipoenviocodigoverificador, client3_.prc_codigoparceiroservico, client3_.cli_origemaplicacao, client3_.cli_datacriacaoambiente, client3_.cli_estado, client3_.cli_logradouro, client3_.cli_usainputweb, client3_.cli_website, client3_.cli_cep, items4_.hpi_cli_codigo, items4_.hpi_agrupacampos, items4_.hps_codigo, items4_.ite_codigo, items4_.sec_codigo, items4_.spq_codigo, items4_.hpi_status, items4_.hpi_valor, items4_.hpi_valorexibicao, items4_.hps_codigo, items4_.hpi_codigo, section5_.sec_ativo, section5_.pes_codigo, section5_.sec_tipovercamposrelatorio, section5_.sec_mudavisualizaitens, section5_.sec_duplicaitem, section5_.sec_identificadoralternativo, section5_.sec_codsecaoantecessora, section5_.sec_avancoautomaticoitem, section5_.sec_avancoautomaticosecao, section5_.sec_alertaitens, section5_.sec_limpafiltrobuscaitem, section5_.sec_cli_codigo, section5_.sec_padrao, section5_.sec_descricao, section5_.sec_origemitem, section5_.sec_consulta, section5_.sec_exibeitemunico, section5_.sec_documentacao, section5_.sec_formaexecucaoitem, section5_.sec_iconefinalizacaosecao, section5_.sec_buscaitensporcodalt, section5_.sec_fococampoeditavel, section5_.sec_exibelistagrupoitem, section5_.mid_codigo, section5_.sec_preencheitemunico, section5_.sec_bloqueiaedicao, section5_.sec_obrigatorio, section5_.sec_marcagrupocompleto, section5_.sec_formaexibiritemmobile, section5_.sec_numcamposquiz, section5_.sec_ordemexibicao, section5_.sec_ordenacaoitem, section5_.sec_ordemitemrelatorio, section5_.sec_formapagamento, section5_.sec_modoquiz, section5_.sec_salvadadoscartao, section5_.sec_formabuscaitempda, section5_.sec_autoexibeitemcoletado, section5_.sec_trocaitemcampos, section5_.sec_tipoleiturabuscaitem, section5_.sec_usaitem, item6_.ite_ativo, item6_.age_codigoinclusao, item6_.age_codigoultimaedicao, item6_.ite_identificadoralternativo, item6_.ite_cli_codigo, item6_.ite_complementoregistro1, item6_.ite_complementoregistro10, item6_.ite_complementoregistro2, item6_.ite_complementoregistro3, item6_.ite_complementoregistro4, item6_.ite_complementoregistro5, item6_.ite_complementoregistro6, item6_.ite_complementoregistro7, item6_.ite_complementoregistro8, item6_.ite_complementoregistro9, item6_.ite_descricao, item6_.mid_codigo, item6_.ite_dthorainclusao, item6_.ite_moduloinclusao, item6_.cat_codigo, item6_.ite_ultatualizacao, item6_.ite_bloqueiaedicao, item6_.ite_exibenocenterweb, item6_.gru_codigo, item6_.ite_tags, item6_.ite_moduloultimaedicao, sectionfie7_.spq_ativo, sectionfie7_.spq_identificadoralternativo, sectionfie7_.spq_atalhodiscagempda, sectionfie7_.spq_cli_codigo, sectionfie7_.con_codigo, sectionfie7_.cad_codigo, sectionfie7_.spq_campoexternolista, sectionfie7_.spq_campointernolista, sectionfie7_.spq_ordemregistromobile, sectionfie7_.cac_codigo, sectionfie7_.spq_qtdcasadecimal, sectionfie7_.spq_descricao, sectionfie7_.spq_documentacao, sectionfie7_.spq_executatelaitens, sectionfie7_.spq_valorfalso, sectionfie7_.crp_codigo, sectionfie7_.spq_preenchezeroesquerda, sectionfie7_.spq_formatofonte, sectionfie7_.spq_tamanhofonte, sectionfie7_.spq_escondevazio, sectionfie7_.spq_tipolista, sectionfie7_.spq_bloqueiaedicao, sectionfie7_.spq_aplicamascara, sectionfie7_.spq_tamanhominimocampo, sectionfie7_.spq_indicetela, sectionfie7_.spq_aceitanulo, sectionfie7_.spq_ordemexibicao, sectionfie7_.spq_persistirdados, sectionfie7_.spq_processaformulaslistaitens, sectionfie7_.spq_arredondanumero, sectionfie7_.spq_regraentradadados, sectionfie7_.sec_codigo, sectionfie7_.sec_codigoreferencia, sectionfie7_.spq_compartilha, sectionfie7_.spq_mostravalornaconferencia, sectionfie7_.spq_mostrarelatoriocenter, sectionfie7_.spq_mostravalornomobile, sectionfie7_.spq_tamanhocampo, sectionfie7_.spq_origemvalor, sectionfie7_.spq_funcaoestrutural, sectionfie7_.spq_tipocampomultimidia, sectionfie7_.spq_dica, sectionfie7_.spq_enquadrarimagem, sectionfie7_.spq_valorverdadeiro, sectionfie7_.spq_tipocampo, sectionfie7_.spq_tipoentradadados, sectionfie7_.spq_chaveunica, sectionfie7_.spq_campounico, sectionfie7_.spq_editavel, sectionfie7_.spq_modoaberturaweb, sectionfie7_.spq_validasomentevisivel, sectionfie7_.spq_visivel, field8_.crp_ativo, field8_.crp_cli_codigo, field8_.cad_codigo, field8_.crp_campoexternolista, field8_.crp_campointernolista, field8_.cac_codigo, field8_.crp_qtdcasadecimal, field8_.crp_descricao, field8_.crp_documentacao, field8_.crp_valorfalso, field8_.crp_tipolista, field8_.crp_tamanhominimocampo, field8_.crp_regraentradadados, field8_.crp_tamanhocampo, field8_.crp_origemvalor, field8_.crp_subtipocampo, field8_.crp_dica, field8_.crp_valorverdadeiro, field8_.crp_tipocampo, field8_.crp_tipoentradadados
  • Sort Key: activity2_.pes_ordemexibicao, activityhi0_.hps_codigo, section5_.sec_ordemexibicao, item6_.ite_descricao, items4_.hpi_agrupacampos, sectionfie7_.spq_ordemexibicao, items4_.sec_codigo, items4_.ite_codigo, sectionfie7_.spq_codigo
2. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=989.24..6,836.70 rows=1 width=1,925) (actual rows= loops=)

  • Output: activityhi0_.hps_codigo, schedule1_.tar_codigo, activity2_.pes_codigo, client3_.cli_codigo, items4_.hpi_codigo, section5_.sec_codigo, item6_.ite_codigo, sectionfie7_.spq_codigo, field8_.crp_codigo, activityhi0_.pes_codigo, activityhi0_.age_codigopda, activityhi0_.hps_statusexpbi, activityhi0_.hps_cli_codigo, activityhi0_.hps_origemdados, activityhi0_.hps_datahorasincronismo, activityhi0_.hps_arquivoexportacao, activityhi0_.hps_statusexpexec, activityhi0_.hps_datahorafiminform, activityhi0_.hps_datahorafimsistema, activityhi0_.hps_codigopda, activityhi0_.hps_totalfotosrecebidas, activityhi0_.hps_totalfotos, activityhi0_.hps_datahorafoto, activityhi0_.tar_codigo, activityhi0_.hps_datahorainicioinform, activityhi0_.hps_datahorainiciosistema, activityhi0_.hps_status, activityhi0_.hps_statusaprovacao, activityhi0_.hps_tokenimpressao, schedule1_.tar_tokenacesso, schedule1_.tar_ativo, schedule1_.tar_origematividade, schedule1_.age_codigo, schedule1_.age_codigoinclusao, schedule1_.tar_ageultimaatualizacao, schedule1_.tar_identificadoralternativo, schedule1_.tar_cli_codigo, schedule1_.tar_complementoregistro1, schedule1_.tar_complementoregistro10, schedule1_.tar_complementoregistro2, schedule1_.tar_complementoregistro3, schedule1_.tar_complementoregistro4, schedule1_.tar_complementoregistro5, schedule1_.tar_complementoregistro6, schedule1_.tar_complementoregistro7, schedule1_.tar_complementoregistro8, schedule1_.tar_complementoregistro9, schedule1_.tar_data, schedule1_.tar_dataexecucao, schedule1_.tar_datafimreal, schedule1_.tar_horafimreal, schedule1_.tar_datafimprev, schedule1_.tar_horafimprev, schedule1_.tar_horaexecucao, schedule1_.tar_datainicioreal, schedule1_.tar_horainicioreal, schedule1_.tar_dtprevcomtoleranciapos, schedule1_.tar_situacaoexportacao, schedule1_.tar_grupo, schedule1_.tar_hora, schedule1_.mid_codigo, schedule1_.tar_datahorainclusao, schedule1_.tar_moduloinclusao, schedule1_.tar_ultimaatualizacao, schedule1_.tar_observacao, schedule1_.tar_origem, schedule1_.tar_codigotarefaorigem, schedule1_.tar_prioridade, schedule1_.tar_duplicanopda, schedule1_.tpt_codigo, schedule1_.tar_envianotificacao, schedule1_.loc_codigo, schedule1_.sit_codigo, schedule1_.tar_finalizadoautomatico, schedule1_.tar_dataultimosinc, schedule1_.tar_horaultimosinc, schedule1_.eqp_codigo, schedule1_.tar_execucaoequipe, schedule1_.tar_alertaposfim, schedule1_.tar_alertaposinicio, schedule1_.tar_alertaprefim, schedule1_.tar_alertapreinicio, schedule1_.tar_bloqueioposinicio, schedule1_.tar_bloqueiopreinicio, schedule1_.tar_moduloultimaedicao, schedule1_.tar_validadatahorainicio, schedule1_.tar_tempoespera, activity2_.pes_gpsobrigatorio, activity2_.pes_execucaoacelerada, activity2_.pes_ativo, activity2_.tpq_codigo, activity2_.age_codigoinclusao, activity2_.age_codigoultimaedicao, activity2_.pes_identificadoralternativo, activity2_.pes_codpesqantecessora, activity2_.pes_tipoexecpesimpeditiva, activity2_.pes_tipoexecpesantecessora, activity2_.pes_cancelamentoseguro, activity2_.pes_capturagps, activity2_.pes_cli_codigo, activity2_.pes_tipocomunicacao, activity2_.pes_confirmaencerramento, activity2_.pes_confirmasemgps, activity2_.pes_descricao, activity2_.pes_exibetelaconferencia, activity2_.pes_ordemexibicao, activity2_.pes_documentacao, activity2_.pes_compartilhadados, activity2_.pes_mensagemfinalizadora, activity2_.pes_exclusivo, activity2_.pes_tipoexecucao, activity2_.lei_codigo, activity2_.lei_codigoexecucao, activity2_.pes_funcaoestrutural, activity2_.mid_codigo, activity2_.pes_dthorainclusao, activity2_.pes_moduloinclusao, activity2_.pes_ultatualizacao, activity2_.pes_bloqueiaedicao, activity2_.pes_execucaoemloop, activity2_.pes_quantidademaximafoto, activity2_.pes_podesuspenderexecucao, activity2_.pes_quantidademinimafoto, activity2_.pes_execucaonegativa, activity2_.pes_dicafoto, activity2_.pes_raioexecucaoautomatica, activity2_.pes_informadataexecucao, activity2_.pes_informadataexecucaomob, activity2_.pes_exibemsgcancelamento, activity2_.pes_exibesecaoemformweb, activity2_.pes_estrutural, activity2_.pes_capturaaudio, activity2_.pes_capturafoto, activity2_.pes_moduloultimaedicao, activity2_.pes_obrigatorio, client3_.cli_aceitetermosdeuso, client3_.cli_datahoradoaceite, client3_.cli_ativo, client3_.cli_informacoescontrato, client3_.cli_alias, client3_.cli_atualizacaoapp, client3_.vap_codigo, client3_.tau_codigo, client3_.cli_tipoautenticacao, client3_.cli_fatura, client3_.cli_cidade, client3_.cli_codigogrupo, client3_.cli_cnpj, client3_.cli_razaosocial, client3_.cli_complementologradouro, client3_.cli_emailcontato, client3_.cli_contato, client3_.cli_telefone, client3_.cli_pais, client3_.cli_descricao, client3_.dic_codigo, client3_.tem_codigo, client3_.cli_habilitatermosdeuso, client3_.cli_statusdadoscompl, client3_.cli_resetouambiente, client3_.cli_tipoambiente, client3_.cli_feztour, client3_.cli_possuidatalimite, client3_.cli_ultatualizacao, client3_.cli_qtdelicencastmp, client3_.cli_datalimite, client3_.cli_centralizador, client3_.cli_bairro, client3_.cli_numerologradouro, client3_.cli_observacao, client3_.cli_pedido, client3_.prc_codigo, client3_.cli_codclienteparceiro, client3_.cli_tipoplanocomprado, client3_.cli_modorelacionamento, client3_.cli_tipoenviocodigoverificador, client3_.prc_codigoparceiroservico, client3_.cli_origemaplicacao, client3_.cli_datacriacaoambiente, client3_.cli_estado, client3_.cli_logradouro, client3_.cli_usainputweb, client3_.cli_website, client3_.cli_cep, items4_.hpi_cli_codigo, items4_.hpi_agrupacampos, items4_.hps_codigo, items4_.ite_codigo, items4_.sec_codigo, items4_.spq_codigo, items4_.hpi_status, items4_.hpi_valor, items4_.hpi_valorexibicao, items4_.hps_codigo, items4_.hpi_codigo, section5_.sec_ativo, section5_.pes_codigo, section5_.sec_tipovercamposrelatorio, section5_.sec_mudavisualizaitens, section5_.sec_duplicaitem, section5_.sec_identificadoralternativo, section5_.sec_codsecaoantecessora, section5_.sec_avancoautomaticoitem, section5_.sec_avancoautomaticosecao, section5_.sec_alertaitens, section5_.sec_limpafiltrobuscaitem, section5_.sec_cli_codigo, section5_.sec_padrao, section5_.sec_descricao, section5_.sec_origemitem, section5_.sec_consulta, section5_.sec_exibeitemunico, section5_.sec_documentacao, section5_.sec_formaexecucaoitem, section5_.sec_iconefinalizacaosecao, section5_.sec_buscaitensporcodalt, section5_.sec_fococampoeditavel, section5_.sec_exibelistagrupoitem, section5_.mid_codigo, section5_.sec_preencheitemunico, section5_.sec_bloqueiaedicao, section5_.sec_obrigatorio, section5_.sec_marcagrupocompleto, section5_.sec_formaexibiritemmobile, section5_.sec_numcamposquiz, section5_.sec_ordemexibicao, section5_.sec_ordenacaoitem, section5_.sec_ordemitemrelatorio, section5_.sec_formapagamento, section5_.sec_modoquiz, section5_.sec_salvadadoscartao, section5_.sec_formabuscaitempda, section5_.sec_autoexibeitemcoletado, section5_.sec_trocaitemcampos, section5_.sec_tipoleiturabuscaitem, section5_.sec_usaitem, item6_.ite_ativo, item6_.age_codigoinclusao, item6_.age_codigoultimaedicao, item6_.ite_identificadoralternativo, item6_.ite_cli_codigo, item6_.ite_complementoregistro1, item6_.ite_complementoregistro10, item6_.ite_complementoregistro2, item6_.ite_complementoregistro3, item6_.ite_complementoregistro4, item6_.ite_complementoregistro5, item6_.ite_complementoregistro6, item6_.ite_complementoregistro7, item6_.ite_complementoregistro8, item6_.ite_complementoregistro9, item6_.ite_descricao, item6_.mid_codigo, item6_.ite_dthorainclusao, item6_.ite_moduloinclusao, item6_.cat_codigo, item6_.ite_ultatualizacao, item6_.ite_bloqueiaedicao, item6_.ite_exibenocenterweb, item6_.gru_codigo, item6_.ite_tags, item6_.ite_moduloultimaedicao, sectionfie7_.spq_ativo, sectionfie7_.spq_identificadoralternativo, sectionfie7_.spq_atalhodiscagempda, sectionfie7_.spq_cli_codigo, sectionfie7_.con_codigo, sectionfie7_.cad_codigo, sectionfie7_.spq_campoexternolista, sectionfie7_.spq_campointernolista, sectionfie7_.spq_ordemregistromobile, sectionfie7_.cac_codigo, sectionfie7_.spq_qtdcasadecimal, sectionfie7_.spq_descricao, sectionfie7_.spq_documentacao, sectionfie7_.spq_executatelaitens, sectionfie7_.spq_valorfalso, sectionfie7_.crp_codigo, sectionfie7_.spq_preenchezeroesquerda, sectionfie7_.spq_formatofonte, sectionfie7_.spq_tamanhofonte, sectionfie7_.spq_escondevazio, sectionfie7_.spq_tipolista, sectionfie7_.spq_bloqueiaedicao, sectionfie7_.spq_aplicamascara, sectionfie7_.spq_tamanhominimocampo, sectionfie7_.spq_indicetela, sectionfie7_.spq_aceitanulo, sectionfie7_.spq_ordemexibicao, sectionfie7_.spq_persistirdados, sectionfie7_.spq_processaformulaslistaitens, sectionfie7_.spq_arredondanumero, sectionfie7_.spq_regraentradadados, sectionfie7_.sec_codigo, sectionfie7_.sec_codigoreferencia, sectionfie7_.spq_compartilha, sectionfie7_.spq_mostravalornaconferencia, sectionfie7_.spq_mostrarelatoriocenter, sectionfie7_.spq_mostravalornomobile, sectionfie7_.spq_tamanhocampo, sectionfie7_.spq_origemvalor, sectionfie7_.spq_funcaoestrutural, sectionfie7_.spq_tipocampomultimidia, sectionfie7_.spq_dica, sectionfie7_.spq_enquadrarimagem, sectionfie7_.spq_valorverdadeiro, sectionfie7_.spq_tipocampo, sectionfie7_.spq_tipoentradadados, sectionfie7_.spq_chaveunica, sectionfie7_.spq_campounico, sectionfie7_.spq_editavel, sectionfie7_.spq_modoaberturaweb, sectionfie7_.spq_validasomentevisivel, sectionfie7_.spq_visivel, field8_.crp_ativo, field8_.crp_cli_codigo, field8_.cad_codigo, field8_.crp_campoexternolista, field8_.crp_campointernolista, field8_.cac_codigo, field8_.crp_qtdcasadecimal, field8_.crp_descricao, field8_.crp_documentacao, field8_.crp_valorfalso, field8_.crp_tipolista, field8_.crp_tamanhominimocampo, field8_.crp_regraentradadados, field8_.crp_tamanhocampo, field8_.crp_origemvalor, field8_.crp_subtipocampo, field8_.crp_dica, field8_.crp_valorverdadeiro, field8_.crp_tipocampo, field8_.crp_tipoentradadados
  • Hash Cond: (activityhi0_.hps_codigo = "ANY_subquery".y0_)
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=822.94..6,670.39 rows=1 width=1,925) (actual rows= loops=)

  • Output: activityhi0_.hps_codigo, activityhi0_.pes_codigo, activityhi0_.age_codigopda, activityhi0_.hps_statusexpbi, activityhi0_.hps_cli_codigo, activityhi0_.hps_origemdados, activityhi0_.hps_datahorasincronismo, activityhi0_.hps_arquivoexportacao, activityhi0_.hps_statusexpexec, activityhi0_.hps_datahorafiminform, activityhi0_.hps_datahorafimsistema, activityhi0_.hps_codigopda, activityhi0_.hps_totalfotosrecebidas, activityhi0_.hps_totalfotos, activityhi0_.hps_datahorafoto, activityhi0_.tar_codigo, activityhi0_.hps_datahorainicioinform, activityhi0_.hps_datahorainiciosistema, activityhi0_.hps_status, activityhi0_.hps_statusaprovacao, activityhi0_.hps_tokenimpressao, schedule1_.tar_codigo, schedule1_.tar_tokenacesso, schedule1_.tar_ativo, schedule1_.tar_origematividade, schedule1_.age_codigo, schedule1_.age_codigoinclusao, schedule1_.tar_ageultimaatualizacao, schedule1_.tar_identificadoralternativo, schedule1_.tar_cli_codigo, schedule1_.tar_complementoregistro1, schedule1_.tar_complementoregistro10, schedule1_.tar_complementoregistro2, schedule1_.tar_complementoregistro3, schedule1_.tar_complementoregistro4, schedule1_.tar_complementoregistro5, schedule1_.tar_complementoregistro6, schedule1_.tar_complementoregistro7, schedule1_.tar_complementoregistro8, schedule1_.tar_complementoregistro9, schedule1_.tar_data, schedule1_.tar_dataexecucao, schedule1_.tar_datafimreal, schedule1_.tar_horafimreal, schedule1_.tar_datafimprev, schedule1_.tar_horafimprev, schedule1_.tar_horaexecucao, schedule1_.tar_datainicioreal, schedule1_.tar_horainicioreal, schedule1_.tar_dtprevcomtoleranciapos, schedule1_.tar_situacaoexportacao, schedule1_.tar_grupo, schedule1_.tar_hora, schedule1_.mid_codigo, schedule1_.tar_datahorainclusao, schedule1_.tar_moduloinclusao, schedule1_.tar_ultimaatualizacao, schedule1_.tar_observacao, schedule1_.tar_origem, schedule1_.tar_codigotarefaorigem, schedule1_.tar_prioridade, schedule1_.tar_duplicanopda, schedule1_.tpt_codigo, schedule1_.tar_envianotificacao, schedule1_.loc_codigo, schedule1_.sit_codigo, schedule1_.tar_finalizadoautomatico, schedule1_.tar_dataultimosinc, schedule1_.tar_horaultimosinc, schedule1_.eqp_codigo, schedule1_.tar_execucaoequipe, schedule1_.tar_alertaposfim, schedule1_.tar_alertaposinicio, schedule1_.tar_alertaprefim, schedule1_.tar_alertapreinicio, schedule1_.tar_bloqueioposinicio, schedule1_.tar_bloqueiopreinicio, schedule1_.tar_moduloultimaedicao, schedule1_.tar_validadatahorainicio, schedule1_.tar_tempoespera, activity2_.pes_codigo, activity2_.pes_gpsobrigatorio, activity2_.pes_execucaoacelerada, activity2_.pes_ativo, activity2_.tpq_codigo, activity2_.age_codigoinclusao, activity2_.age_codigoultimaedicao, activity2_.pes_identificadoralternativo, activity2_.pes_codpesqantecessora, activity2_.pes_tipoexecpesimpeditiva, activity2_.pes_tipoexecpesantecessora, activity2_.pes_cancelamentoseguro, activity2_.pes_capturagps, activity2_.pes_cli_codigo, activity2_.pes_tipocomunicacao, activity2_.pes_confirmaencerramento, activity2_.pes_confirmasemgps, activity2_.pes_descricao, activity2_.pes_exibetelaconferencia, activity2_.pes_ordemexibicao, activity2_.pes_documentacao, activity2_.pes_compartilhadados, activity2_.pes_mensagemfinalizadora, activity2_.pes_exclusivo, activity2_.pes_tipoexecucao, activity2_.lei_codigo, activity2_.lei_codigoexecucao, activity2_.pes_funcaoestrutural, activity2_.mid_codigo, activity2_.pes_dthorainclusao, activity2_.pes_moduloinclusao, activity2_.pes_ultatualizacao, activity2_.pes_bloqueiaedicao, activity2_.pes_execucaoemloop, activity2_.pes_quantidademaximafoto, activity2_.pes_podesuspenderexecucao, activity2_.pes_quantidademinimafoto, activity2_.pes_execucaonegativa, activity2_.pes_dicafoto, activity2_.pes_raioexecucaoautomatica, activity2_.pes_informadataexecucao, activity2_.pes_informadataexecucaomob, activity2_.pes_exibemsgcancelamento, activity2_.pes_exibesecaoemformweb, activity2_.pes_estrutural, activity2_.pes_capturaaudio, activity2_.pes_capturafoto, activity2_.pes_moduloultimaedicao, activity2_.pes_obrigatorio, client3_.cli_codigo, client3_.cli_aceitetermosdeuso, client3_.cli_datahoradoaceite, client3_.cli_ativo, client3_.cli_informacoescontrato, client3_.cli_alias, client3_.cli_atualizacaoapp, client3_.vap_codigo, client3_.tau_codigo, client3_.cli_tipoautenticacao, client3_.cli_fatura, client3_.cli_cidade, client3_.cli_codigogrupo, client3_.cli_cnpj, client3_.cli_razaosocial, client3_.cli_complementologradouro, client3_.cli_emailcontato, client3_.cli_contato, client3_.cli_telefone, client3_.cli_pais, client3_.cli_descricao, client3_.dic_codigo, client3_.tem_codigo, client3_.cli_habilitatermosdeuso, client3_.cli_statusdadoscompl, client3_.cli_resetouambiente, client3_.cli_tipoambiente, client3_.cli_feztour, client3_.cli_possuidatalimite, client3_.cli_ultatualizacao, client3_.cli_qtdelicencastmp, client3_.cli_datalimite, client3_.cli_centralizador, client3_.cli_bairro, client3_.cli_numerologradouro, client3_.cli_observacao, client3_.cli_pedido, client3_.prc_codigo, client3_.cli_codclienteparceiro, client3_.cli_tipoplanocomprado, client3_.cli_modorelacionamento, client3_.cli_tipoenviocodigoverificador, client3_.prc_codigoparceiroservico, client3_.cli_origemaplicacao, client3_.cli_datacriacaoambiente, client3_.cli_estado, client3_.cli_logradouro, client3_.cli_usainputweb, client3_.cli_website, client3_.cli_cep, items4_.hpi_codigo, items4_.hpi_cli_codigo, items4_.hpi_agrupacampos, items4_.hps_codigo, items4_.ite_codigo, items4_.sec_codigo, items4_.spq_codigo, items4_.hpi_status, items4_.hpi_valor, items4_.hpi_valorexibicao, section5_.sec_codigo, section5_.sec_ativo, section5_.pes_codigo, section5_.sec_tipovercamposrelatorio, section5_.sec_mudavisualizaitens, section5_.sec_duplicaitem, section5_.sec_identificadoralternativo, section5_.sec_codsecaoantecessora, section5_.sec_avancoautomaticoitem, section5_.sec_avancoautomaticosecao, section5_.sec_alertaitens, section5_.sec_limpafiltrobuscaitem, section5_.sec_cli_codigo, section5_.sec_padrao, section5_.sec_descricao, section5_.sec_origemitem, section5_.sec_consulta, section5_.sec_exibeitemunico, section5_.sec_documentacao, section5_.sec_formaexecucaoitem, section5_.sec_iconefinalizacaosecao, section5_.sec_buscaitensporcodalt, section5_.sec_fococampoeditavel, section5_.sec_exibelistagrupoitem, section5_.mid_codigo, section5_.sec_preencheitemunico, section5_.sec_bloqueiaedicao, section5_.sec_obrigatorio, section5_.sec_marcagrupocompleto, section5_.sec_formaexibiritemmobile, section5_.sec_numcamposquiz, section5_.sec_ordemexibicao, section5_.sec_ordenacaoitem, section5_.sec_ordemitemrelatorio, section5_.sec_formapagamento, section5_.sec_modoquiz, section5_.sec_salvadadoscartao, section5_.sec_formabuscaitempda, section5_.sec_autoexibeitemcoletado, section5_.sec_trocaitemcampos, section5_.sec_tipoleiturabuscaitem, section5_.sec_usaitem, item6_.ite_codigo, item6_.ite_ativo, item6_.age_codigoinclusao, item6_.age_codigoultimaedicao, item6_.ite_identificadoralternativo, item6_.ite_cli_codigo, item6_.ite_complementoregistro1, item6_.ite_complementoregistro10, item6_.ite_complementoregistro2, item6_.ite_complementoregistro3, item6_.ite_complementoregistro4, item6_.ite_complementoregistro5, item6_.ite_complementoregistro6, item6_.ite_complementoregistro7, item6_.ite_complementoregistro8, item6_.ite_complementoregistro9, item6_.ite_descricao, item6_.mid_codigo, item6_.ite_dthorainclusao, item6_.ite_moduloinclusao, item6_.cat_codigo, item6_.ite_ultatualizacao, item6_.ite_bloqueiaedicao, item6_.ite_exibenocenterweb, item6_.gru_codigo, item6_.ite_tags, item6_.ite_moduloultimaedicao, sectionfie7_.spq_codigo, sectionfie7_.spq_ativo, sectionfie7_.spq_identificadoralternativo, sectionfie7_.spq_atalhodiscagempda, sectionfie7_.spq_cli_codigo, sectionfie7_.con_codigo, sectionfie7_.cad_codigo, sectionfie7_.spq_campoexternolista, sectionfie7_.spq_campointernolista, sectionfie7_.spq_ordemregistromobile, sectionfie7_.cac_codigo, sectionfie7_.spq_qtdcasadecimal, sectionfie7_.spq_descricao, sectionfie7_.spq_documentacao, sectionfie7_.spq_executatelaitens, sectionfie7_.spq_valorfalso, sectionfie7_.crp_codigo, sectionfie7_.spq_preenchezeroesquerda, sectionfie7_.spq_formatofonte, sectionfie7_.spq_tamanhofonte, sectionfie7_.spq_escondevazio, sectionfie7_.spq_tipolista, sectionfie7_.spq_bloqueiaedicao, sectionfie7_.spq_aplicamascara, sectionfie7_.spq_tamanhominimocampo, sectionfie7_.spq_indicetela, sectionfie7_.spq_aceitanulo, sectionfie7_.spq_ordemexibicao, sectionfie7_.spq_persistirdados, sectionfie7_.spq_processaformulaslistaitens, sectionfie7_.spq_arredondanumero, sectionfie7_.spq_regraentradadados, sectionfie7_.sec_codigo, sectionfie7_.sec_codigoreferencia, sectionfie7_.spq_compartilha, sectionfie7_.spq_mostravalornaconferencia, sectionfie7_.spq_mostrarelatoriocenter, sectionfie7_.spq_mostravalornomobile, sectionfie7_.spq_tamanhocampo, sectionfie7_.spq_origemvalor, sectionfie7_.spq_funcaoestrutural, sectionfie7_.spq_tipocampomultimidia, sectionfie7_.spq_dica, sectionfie7_.spq_enquadrarimagem, sectionfie7_.spq_valorverdadeiro, sectionfie7_.spq_tipocampo, sectionfie7_.spq_tipoentradadados, sectionfie7_.spq_chaveunica, sectionfie7_.spq_campounico, sectionfie7_.spq_editavel, sectionfie7_.spq_modoaberturaweb, sectionfie7_.spq_validasomentevisivel, sectionfie7_.spq_visivel, field8_.crp_codigo, field8_.crp_ativo, field8_.crp_cli_codigo, field8_.cad_codigo, field8_.crp_campoexternolista, field8_.crp_campointernolista, field8_.cac_codigo, field8_.crp_qtdcasadecimal, field8_.crp_descricao, field8_.crp_documentacao, field8_.crp_valorfalso, field8_.crp_tipolista, field8_.crp_tamanhominimocampo, field8_.crp_regraentradadados, field8_.crp_tamanhocampo, field8_.crp_origemvalor, field8_.crp_subtipocampo, field8_.crp_dica, field8_.crp_valorverdadeiro, field8_.crp_tipocampo, field8_.crp_tipoentradadados
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=822.52..6,667.79 rows=1 width=1,816) (actual rows= loops=)

  • Output: activityhi0_.hps_codigo, activityhi0_.pes_codigo, activityhi0_.age_codigopda, activityhi0_.hps_statusexpbi, activityhi0_.hps_cli_codigo, activityhi0_.hps_origemdados, activityhi0_.hps_datahorasincronismo, activityhi0_.hps_arquivoexportacao, activityhi0_.hps_statusexpexec, activityhi0_.hps_datahorafiminform, activityhi0_.hps_datahorafimsistema, activityhi0_.hps_codigopda, activityhi0_.hps_totalfotosrecebidas, activityhi0_.hps_totalfotos, activityhi0_.hps_datahorafoto, activityhi0_.tar_codigo, activityhi0_.hps_datahorainicioinform, activityhi0_.hps_datahorainiciosistema, activityhi0_.hps_status, activityhi0_.hps_statusaprovacao, activityhi0_.hps_tokenimpressao, schedule1_.tar_codigo, schedule1_.tar_tokenacesso, schedule1_.tar_ativo, schedule1_.tar_origematividade, schedule1_.age_codigo, schedule1_.age_codigoinclusao, schedule1_.tar_ageultimaatualizacao, schedule1_.tar_identificadoralternativo, schedule1_.tar_cli_codigo, schedule1_.tar_complementoregistro1, schedule1_.tar_complementoregistro10, schedule1_.tar_complementoregistro2, schedule1_.tar_complementoregistro3, schedule1_.tar_complementoregistro4, schedule1_.tar_complementoregistro5, schedule1_.tar_complementoregistro6, schedule1_.tar_complementoregistro7, schedule1_.tar_complementoregistro8, schedule1_.tar_complementoregistro9, schedule1_.tar_data, schedule1_.tar_dataexecucao, schedule1_.tar_datafimreal, schedule1_.tar_horafimreal, schedule1_.tar_datafimprev, schedule1_.tar_horafimprev, schedule1_.tar_horaexecucao, schedule1_.tar_datainicioreal, schedule1_.tar_horainicioreal, schedule1_.tar_dtprevcomtoleranciapos, schedule1_.tar_situacaoexportacao, schedule1_.tar_grupo, schedule1_.tar_hora, schedule1_.mid_codigo, schedule1_.tar_datahorainclusao, schedule1_.tar_moduloinclusao, schedule1_.tar_ultimaatualizacao, schedule1_.tar_observacao, schedule1_.tar_origem, schedule1_.tar_codigotarefaorigem, schedule1_.tar_prioridade, schedule1_.tar_duplicanopda, schedule1_.tpt_codigo, schedule1_.tar_envianotificacao, schedule1_.loc_codigo, schedule1_.sit_codigo, schedule1_.tar_finalizadoautomatico, schedule1_.tar_dataultimosinc, schedule1_.tar_horaultimosinc, schedule1_.eqp_codigo, schedule1_.tar_execucaoequipe, schedule1_.tar_alertaposfim, schedule1_.tar_alertaposinicio, schedule1_.tar_alertaprefim, schedule1_.tar_alertapreinicio, schedule1_.tar_bloqueioposinicio, schedule1_.tar_bloqueiopreinicio, schedule1_.tar_moduloultimaedicao, schedule1_.tar_validadatahorainicio, schedule1_.tar_tempoespera, activity2_.pes_codigo, activity2_.pes_gpsobrigatorio, activity2_.pes_execucaoacelerada, activity2_.pes_ativo, activity2_.tpq_codigo, activity2_.age_codigoinclusao, activity2_.age_codigoultimaedicao, activity2_.pes_identificadoralternativo, activity2_.pes_codpesqantecessora, activity2_.pes_tipoexecpesimpeditiva, activity2_.pes_tipoexecpesantecessora, activity2_.pes_cancelamentoseguro, activity2_.pes_capturagps, activity2_.pes_cli_codigo, activity2_.pes_tipocomunicacao, activity2_.pes_confirmaencerramento, activity2_.pes_confirmasemgps, activity2_.pes_descricao, activity2_.pes_exibetelaconferencia, activity2_.pes_ordemexibicao, activity2_.pes_documentacao, activity2_.pes_compartilhadados, activity2_.pes_mensagemfinalizadora, activity2_.pes_exclusivo, activity2_.pes_tipoexecucao, activity2_.lei_codigo, activity2_.lei_codigoexecucao, activity2_.pes_funcaoestrutural, activity2_.mid_codigo, activity2_.pes_dthorainclusao, activity2_.pes_moduloinclusao, activity2_.pes_ultatualizacao, activity2_.pes_bloqueiaedicao, activity2_.pes_execucaoemloop, activity2_.pes_quantidademaximafoto, activity2_.pes_podesuspenderexecucao, activity2_.pes_quantidademinimafoto, activity2_.pes_execucaonegativa, activity2_.pes_dicafoto, activity2_.pes_raioexecucaoautomatica, activity2_.pes_informadataexecucao, activity2_.pes_informadataexecucaomob, activity2_.pes_exibemsgcancelamento, activity2_.pes_exibesecaoemformweb, activity2_.pes_estrutural, activity2_.pes_capturaaudio, activity2_.pes_capturafoto, activity2_.pes_moduloultimaedicao, activity2_.pes_obrigatorio, client3_.cli_codigo, client3_.cli_aceitetermosdeuso, client3_.cli_datahoradoaceite, client3_.cli_ativo, client3_.cli_informacoescontrato, client3_.cli_alias, client3_.cli_atualizacaoapp, client3_.vap_codigo, client3_.tau_codigo, client3_.cli_tipoautenticacao, client3_.cli_fatura, client3_.cli_cidade, client3_.cli_codigogrupo, client3_.cli_cnpj, client3_.cli_razaosocial, client3_.cli_complementologradouro, client3_.cli_emailcontato, client3_.cli_contato, client3_.cli_telefone, client3_.cli_pais, client3_.cli_descricao, client3_.dic_codigo, client3_.tem_codigo, client3_.cli_habilitatermosdeuso, client3_.cli_statusdadoscompl, client3_.cli_resetouambiente, client3_.cli_tipoambiente, client3_.cli_feztour, client3_.cli_possuidatalimite, client3_.cli_ultatualizacao, client3_.cli_qtdelicencastmp, client3_.cli_datalimite, client3_.cli_centralizador, client3_.cli_bairro, client3_.cli_numerologradouro, client3_.cli_observacao, client3_.cli_pedido, client3_.prc_codigo, client3_.cli_codclienteparceiro, client3_.cli_tipoplanocomprado, client3_.cli_modorelacionamento, client3_.cli_tipoenviocodigoverificador, client3_.prc_codigoparceiroservico, client3_.cli_origemaplicacao, client3_.cli_datacriacaoambiente, client3_.cli_estado, client3_.cli_logradouro, client3_.cli_usainputweb, client3_.cli_website, client3_.cli_cep, items4_.hpi_codigo, items4_.hpi_cli_codigo, items4_.hpi_agrupacampos, items4_.hps_codigo, items4_.ite_codigo, items4_.sec_codigo, items4_.spq_codigo, items4_.hpi_status, items4_.hpi_valor, items4_.hpi_valorexibicao, section5_.sec_codigo, section5_.sec_ativo, section5_.pes_codigo, section5_.sec_tipovercamposrelatorio, section5_.sec_mudavisualizaitens, section5_.sec_duplicaitem, section5_.sec_identificadoralternativo, section5_.sec_codsecaoantecessora, section5_.sec_avancoautomaticoitem, section5_.sec_avancoautomaticosecao, section5_.sec_alertaitens, section5_.sec_limpafiltrobuscaitem, section5_.sec_cli_codigo, section5_.sec_padrao, section5_.sec_descricao, section5_.sec_origemitem, section5_.sec_consulta, section5_.sec_exibeitemunico, section5_.sec_documentacao, section5_.sec_formaexecucaoitem, section5_.sec_iconefinalizacaosecao, section5_.sec_buscaitensporcodalt, section5_.sec_fococampoeditavel, section5_.sec_exibelistagrupoitem, section5_.mid_codigo, section5_.sec_preencheitemunico, section5_.sec_bloqueiaedicao, section5_.sec_obrigatorio, section5_.sec_marcagrupocompleto, section5_.sec_formaexibiritemmobile, section5_.sec_numcamposquiz, section5_.sec_ordemexibicao, section5_.sec_ordenacaoitem, section5_.sec_ordemitemrelatorio, section5_.sec_formapagamento, section5_.sec_modoquiz, section5_.sec_salvadadoscartao, section5_.sec_formabuscaitempda, section5_.sec_autoexibeitemcoletado, section5_.sec_trocaitemcampos, section5_.sec_tipoleiturabuscaitem, section5_.sec_usaitem, item6_.ite_codigo, item6_.ite_ativo, item6_.age_codigoinclusao, item6_.age_codigoultimaedicao, item6_.ite_identificadoralternativo, item6_.ite_cli_codigo, item6_.ite_complementoregistro1, item6_.ite_complementoregistro10, item6_.ite_complementoregistro2, item6_.ite_complementoregistro3, item6_.ite_complementoregistro4, item6_.ite_complementoregistro5, item6_.ite_complementoregistro6, item6_.ite_complementoregistro7, item6_.ite_complementoregistro8, item6_.ite_complementoregistro9, item6_.ite_descricao, item6_.mid_codigo, item6_.ite_dthorainclusao, item6_.ite_moduloinclusao, item6_.cat_codigo, item6_.ite_ultatualizacao, item6_.ite_bloqueiaedicao, item6_.ite_exibenocenterweb, item6_.gru_codigo, item6_.ite_tags, item6_.ite_moduloultimaedicao, sectionfie7_.spq_codigo, sectionfie7_.spq_ativo, sectionfie7_.spq_identificadoralternativo, sectionfie7_.spq_atalhodiscagempda, sectionfie7_.spq_cli_codigo, sectionfie7_.con_codigo, sectionfie7_.cad_codigo, sectionfie7_.spq_campoexternolista, sectionfie7_.spq_campointernolista, sectionfie7_.spq_ordemregistromobile, sectionfie7_.cac_codigo, sectionfie7_.spq_qtdcasadecimal, sectionfie7_.spq_descricao, sectionfie7_.spq_documentacao, sectionfie7_.spq_executatelaitens, sectionfie7_.spq_valorfalso, sectionfie7_.crp_codigo, sectionfie7_.spq_preenchezeroesquerda, sectionfie7_.spq_formatofonte, sectionfie7_.spq_tamanhofonte, sectionfie7_.spq_escondevazio, sectionfie7_.spq_tipolista, sectionfie7_.spq_bloqueiaedicao, sectionfie7_.spq_aplicamascara, sectionfie7_.spq_tamanhominimocampo, sectionfie7_.spq_indicetela, sectionfie7_.spq_aceitanulo, sectionfie7_.spq_ordemexibicao, sectionfie7_.spq_persistirdados, sectionfie7_.spq_processaformulaslistaitens, sectionfie7_.spq_arredondanumero, sectionfie7_.spq_regraentradadados, sectionfie7_.sec_codigo, sectionfie7_.sec_codigoreferencia, sectionfie7_.spq_compartilha, sectionfie7_.spq_mostravalornaconferencia, sectionfie7_.spq_mostrarelatoriocenter, sectionfie7_.spq_mostravalornomobile, sectionfie7_.spq_tamanhocampo, sectionfie7_.spq_origemvalor, sectionfie7_.spq_funcaoestrutural, sectionfie7_.spq_tipocampomultimidia, sectionfie7_.spq_dica, sectionfie7_.spq_enquadrarimagem, sectionfie7_.spq_valorverdadeiro, sectionfie7_.spq_tipocampo, sectionfie7_.spq_tipoentradadados, sectionfie7_.spq_chaveunica, sectionfie7_.spq_campounico, sectionfie7_.spq_editavel, sectionfie7_.spq_modoaberturaweb, sectionfie7_.spq_validasomentevisivel, sectionfie7_.spq_visivel
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=822.09..6,665.16 rows=1 width=1,595) (actual rows= loops=)

  • Output: activityhi0_.hps_codigo, activityhi0_.pes_codigo, activityhi0_.age_codigopda, activityhi0_.hps_statusexpbi, activityhi0_.hps_cli_codigo, activityhi0_.hps_origemdados, activityhi0_.hps_datahorasincronismo, activityhi0_.hps_arquivoexportacao, activityhi0_.hps_statusexpexec, activityhi0_.hps_datahorafiminform, activityhi0_.hps_datahorafimsistema, activityhi0_.hps_codigopda, activityhi0_.hps_totalfotosrecebidas, activityhi0_.hps_totalfotos, activityhi0_.hps_datahorafoto, activityhi0_.tar_codigo, activityhi0_.hps_datahorainicioinform, activityhi0_.hps_datahorainiciosistema, activityhi0_.hps_status, activityhi0_.hps_statusaprovacao, activityhi0_.hps_tokenimpressao, schedule1_.tar_codigo, schedule1_.tar_tokenacesso, schedule1_.tar_ativo, schedule1_.tar_origematividade, schedule1_.age_codigo, schedule1_.age_codigoinclusao, schedule1_.tar_ageultimaatualizacao, schedule1_.tar_identificadoralternativo, schedule1_.tar_cli_codigo, schedule1_.tar_complementoregistro1, schedule1_.tar_complementoregistro10, schedule1_.tar_complementoregistro2, schedule1_.tar_complementoregistro3, schedule1_.tar_complementoregistro4, schedule1_.tar_complementoregistro5, schedule1_.tar_complementoregistro6, schedule1_.tar_complementoregistro7, schedule1_.tar_complementoregistro8, schedule1_.tar_complementoregistro9, schedule1_.tar_data, schedule1_.tar_dataexecucao, schedule1_.tar_datafimreal, schedule1_.tar_horafimreal, schedule1_.tar_datafimprev, schedule1_.tar_horafimprev, schedule1_.tar_horaexecucao, schedule1_.tar_datainicioreal, schedule1_.tar_horainicioreal, schedule1_.tar_dtprevcomtoleranciapos, schedule1_.tar_situacaoexportacao, schedule1_.tar_grupo, schedule1_.tar_hora, schedule1_.mid_codigo, schedule1_.tar_datahorainclusao, schedule1_.tar_moduloinclusao, schedule1_.tar_ultimaatualizacao, schedule1_.tar_observacao, schedule1_.tar_origem, schedule1_.tar_codigotarefaorigem, schedule1_.tar_prioridade, schedule1_.tar_duplicanopda, schedule1_.tpt_codigo, schedule1_.tar_envianotificacao, schedule1_.loc_codigo, schedule1_.sit_codigo, schedule1_.tar_finalizadoautomatico, schedule1_.tar_dataultimosinc, schedule1_.tar_horaultimosinc, schedule1_.eqp_codigo, schedule1_.tar_execucaoequipe, schedule1_.tar_alertaposfim, schedule1_.tar_alertaposinicio, schedule1_.tar_alertaprefim, schedule1_.tar_alertapreinicio, schedule1_.tar_bloqueioposinicio, schedule1_.tar_bloqueiopreinicio, schedule1_.tar_moduloultimaedicao, schedule1_.tar_validadatahorainicio, schedule1_.tar_tempoespera, activity2_.pes_codigo, activity2_.pes_gpsobrigatorio, activity2_.pes_execucaoacelerada, activity2_.pes_ativo, activity2_.tpq_codigo, activity2_.age_codigoinclusao, activity2_.age_codigoultimaedicao, activity2_.pes_identificadoralternativo, activity2_.pes_codpesqantecessora, activity2_.pes_tipoexecpesimpeditiva, activity2_.pes_tipoexecpesantecessora, activity2_.pes_cancelamentoseguro, activity2_.pes_capturagps, activity2_.pes_cli_codigo, activity2_.pes_tipocomunicacao, activity2_.pes_confirmaencerramento, activity2_.pes_confirmasemgps, activity2_.pes_descricao, activity2_.pes_exibetelaconferencia, activity2_.pes_ordemexibicao, activity2_.pes_documentacao, activity2_.pes_compartilhadados, activity2_.pes_mensagemfinalizadora, activity2_.pes_exclusivo, activity2_.pes_tipoexecucao, activity2_.lei_codigo, activity2_.lei_codigoexecucao, activity2_.pes_funcaoestrutural, activity2_.mid_codigo, activity2_.pes_dthorainclusao, activity2_.pes_moduloinclusao, activity2_.pes_ultatualizacao, activity2_.pes_bloqueiaedicao, activity2_.pes_execucaoemloop, activity2_.pes_quantidademaximafoto, activity2_.pes_podesuspenderexecucao, activity2_.pes_quantidademinimafoto, activity2_.pes_execucaonegativa, activity2_.pes_dicafoto, activity2_.pes_raioexecucaoautomatica, activity2_.pes_informadataexecucao, activity2_.pes_informadataexecucaomob, activity2_.pes_exibemsgcancelamento, activity2_.pes_exibesecaoemformweb, activity2_.pes_estrutural, activity2_.pes_capturaaudio, activity2_.pes_capturafoto, activity2_.pes_moduloultimaedicao, activity2_.pes_obrigatorio, client3_.cli_codigo, client3_.cli_aceitetermosdeuso, client3_.cli_datahoradoaceite, client3_.cli_ativo, client3_.cli_informacoescontrato, client3_.cli_alias, client3_.cli_atualizacaoapp, client3_.vap_codigo, client3_.tau_codigo, client3_.cli_tipoautenticacao, client3_.cli_fatura, client3_.cli_cidade, client3_.cli_codigogrupo, client3_.cli_cnpj, client3_.cli_razaosocial, client3_.cli_complementologradouro, client3_.cli_emailcontato, client3_.cli_contato, client3_.cli_telefone, client3_.cli_pais, client3_.cli_descricao, client3_.dic_codigo, client3_.tem_codigo, client3_.cli_habilitatermosdeuso, client3_.cli_statusdadoscompl, client3_.cli_resetouambiente, client3_.cli_tipoambiente, client3_.cli_feztour, client3_.cli_possuidatalimite, client3_.cli_ultatualizacao, client3_.cli_qtdelicencastmp, client3_.cli_datalimite, client3_.cli_centralizador, client3_.cli_bairro, client3_.cli_numerologradouro, client3_.cli_observacao, client3_.cli_pedido, client3_.prc_codigo, client3_.cli_codclienteparceiro, client3_.cli_tipoplanocomprado, client3_.cli_modorelacionamento, client3_.cli_tipoenviocodigoverificador, client3_.prc_codigoparceiroservico, client3_.cli_origemaplicacao, client3_.cli_datacriacaoambiente, client3_.cli_estado, client3_.cli_logradouro, client3_.cli_usainputweb, client3_.cli_website, client3_.cli_cep, items4_.hpi_codigo, items4_.hpi_cli_codigo, items4_.hpi_agrupacampos, items4_.hps_codigo, items4_.ite_codigo, items4_.sec_codigo, items4_.spq_codigo, items4_.hpi_status, items4_.hpi_valor, items4_.hpi_valorexibicao, section5_.sec_codigo, section5_.sec_ativo, section5_.pes_codigo, section5_.sec_tipovercamposrelatorio, section5_.sec_mudavisualizaitens, section5_.sec_duplicaitem, section5_.sec_identificadoralternativo, section5_.sec_codsecaoantecessora, section5_.sec_avancoautomaticoitem, section5_.sec_avancoautomaticosecao, section5_.sec_alertaitens, section5_.sec_limpafiltrobuscaitem, section5_.sec_cli_codigo, section5_.sec_padrao, section5_.sec_descricao, section5_.sec_origemitem, section5_.sec_consulta, section5_.sec_exibeitemunico, section5_.sec_documentacao, section5_.sec_formaexecucaoitem, section5_.sec_iconefinalizacaosecao, section5_.sec_buscaitensporcodalt, section5_.sec_fococampoeditavel, section5_.sec_exibelistagrupoitem, section5_.mid_codigo, section5_.sec_preencheitemunico, section5_.sec_bloqueiaedicao, section5_.sec_obrigatorio, section5_.sec_marcagrupocompleto, section5_.sec_formaexibiritemmobile, section5_.sec_numcamposquiz, section5_.sec_ordemexibicao, section5_.sec_ordenacaoitem, section5_.sec_ordemitemrelatorio, section5_.sec_formapagamento, section5_.sec_modoquiz, section5_.sec_salvadadoscartao, section5_.sec_formabuscaitempda, section5_.sec_autoexibeitemcoletado, section5_.sec_trocaitemcampos, section5_.sec_tipoleiturabuscaitem, section5_.sec_usaitem, item6_.ite_codigo, item6_.ite_ativo, item6_.age_codigoinclusao, item6_.age_codigoultimaedicao, item6_.ite_identificadoralternativo, item6_.ite_cli_codigo, item6_.ite_complementoregistro1, item6_.ite_complementoregistro10, item6_.ite_complementoregistro2, item6_.ite_complementoregistro3, item6_.ite_complementoregistro4, item6_.ite_complementoregistro5, item6_.ite_complementoregistro6, item6_.ite_complementoregistro7, item6_.ite_complementoregistro8, item6_.ite_complementoregistro9, item6_.ite_descricao, item6_.mid_codigo, item6_.ite_dthorainclusao, item6_.ite_moduloinclusao, item6_.cat_codigo, item6_.ite_ultatualizacao, item6_.ite_bloqueiaedicao, item6_.ite_exibenocenterweb, item6_.gru_codigo, item6_.ite_tags, item6_.ite_moduloultimaedicao
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=821.52..6,662.41 rows=1 width=1,386) (actual rows= loops=)

  • Output: activityhi0_.hps_codigo, activityhi0_.pes_codigo, activityhi0_.age_codigopda, activityhi0_.hps_statusexpbi, activityhi0_.hps_cli_codigo, activityhi0_.hps_origemdados, activityhi0_.hps_datahorasincronismo, activityhi0_.hps_arquivoexportacao, activityhi0_.hps_statusexpexec, activityhi0_.hps_datahorafiminform, activityhi0_.hps_datahorafimsistema, activityhi0_.hps_codigopda, activityhi0_.hps_totalfotosrecebidas, activityhi0_.hps_totalfotos, activityhi0_.hps_datahorafoto, activityhi0_.tar_codigo, activityhi0_.hps_datahorainicioinform, activityhi0_.hps_datahorainiciosistema, activityhi0_.hps_status, activityhi0_.hps_statusaprovacao, activityhi0_.hps_tokenimpressao, schedule1_.tar_codigo, schedule1_.tar_tokenacesso, schedule1_.tar_ativo, schedule1_.tar_origematividade, schedule1_.age_codigo, schedule1_.age_codigoinclusao, schedule1_.tar_ageultimaatualizacao, schedule1_.tar_identificadoralternativo, schedule1_.tar_cli_codigo, schedule1_.tar_complementoregistro1, schedule1_.tar_complementoregistro10, schedule1_.tar_complementoregistro2, schedule1_.tar_complementoregistro3, schedule1_.tar_complementoregistro4, schedule1_.tar_complementoregistro5, schedule1_.tar_complementoregistro6, schedule1_.tar_complementoregistro7, schedule1_.tar_complementoregistro8, schedule1_.tar_complementoregistro9, schedule1_.tar_data, schedule1_.tar_dataexecucao, schedule1_.tar_datafimreal, schedule1_.tar_horafimreal, schedule1_.tar_datafimprev, schedule1_.tar_horafimprev, schedule1_.tar_horaexecucao, schedule1_.tar_datainicioreal, schedule1_.tar_horainicioreal, schedule1_.tar_dtprevcomtoleranciapos, schedule1_.tar_situacaoexportacao, schedule1_.tar_grupo, schedule1_.tar_hora, schedule1_.mid_codigo, schedule1_.tar_datahorainclusao, schedule1_.tar_moduloinclusao, schedule1_.tar_ultimaatualizacao, schedule1_.tar_observacao, schedule1_.tar_origem, schedule1_.tar_codigotarefaorigem, schedule1_.tar_prioridade, schedule1_.tar_duplicanopda, schedule1_.tpt_codigo, schedule1_.tar_envianotificacao, schedule1_.loc_codigo, schedule1_.sit_codigo, schedule1_.tar_finalizadoautomatico, schedule1_.tar_dataultimosinc, schedule1_.tar_horaultimosinc, schedule1_.eqp_codigo, schedule1_.tar_execucaoequipe, schedule1_.tar_alertaposfim, schedule1_.tar_alertaposinicio, schedule1_.tar_alertaprefim, schedule1_.tar_alertapreinicio, schedule1_.tar_bloqueioposinicio, schedule1_.tar_bloqueiopreinicio, schedule1_.tar_moduloultimaedicao, schedule1_.tar_validadatahorainicio, schedule1_.tar_tempoespera, activity2_.pes_codigo, activity2_.pes_gpsobrigatorio, activity2_.pes_execucaoacelerada, activity2_.pes_ativo, activity2_.tpq_codigo, activity2_.age_codigoinclusao, activity2_.age_codigoultimaedicao, activity2_.pes_identificadoralternativo, activity2_.pes_codpesqantecessora, activity2_.pes_tipoexecpesimpeditiva, activity2_.pes_tipoexecpesantecessora, activity2_.pes_cancelamentoseguro, activity2_.pes_capturagps, activity2_.pes_cli_codigo, activity2_.pes_tipocomunicacao, activity2_.pes_confirmaencerramento, activity2_.pes_confirmasemgps, activity2_.pes_descricao, activity2_.pes_exibetelaconferencia, activity2_.pes_ordemexibicao, activity2_.pes_documentacao, activity2_.pes_compartilhadados, activity2_.pes_mensagemfinalizadora, activity2_.pes_exclusivo, activity2_.pes_tipoexecucao, activity2_.lei_codigo, activity2_.lei_codigoexecucao, activity2_.pes_funcaoestrutural, activity2_.mid_codigo, activity2_.pes_dthorainclusao, activity2_.pes_moduloinclusao, activity2_.pes_ultatualizacao, activity2_.pes_bloqueiaedicao, activity2_.pes_execucaoemloop, activity2_.pes_quantidademaximafoto, activity2_.pes_podesuspenderexecucao, activity2_.pes_quantidademinimafoto, activity2_.pes_execucaonegativa, activity2_.pes_dicafoto, activity2_.pes_raioexecucaoautomatica, activity2_.pes_informadataexecucao, activity2_.pes_informadataexecucaomob, activity2_.pes_exibemsgcancelamento, activity2_.pes_exibesecaoemformweb, activity2_.pes_estrutural, activity2_.pes_capturaaudio, activity2_.pes_capturafoto, activity2_.pes_moduloultimaedicao, activity2_.pes_obrigatorio, client3_.cli_codigo, client3_.cli_aceitetermosdeuso, client3_.cli_datahoradoaceite, client3_.cli_ativo, client3_.cli_informacoescontrato, client3_.cli_alias, client3_.cli_atualizacaoapp, client3_.vap_codigo, client3_.tau_codigo, client3_.cli_tipoautenticacao, client3_.cli_fatura, client3_.cli_cidade, client3_.cli_codigogrupo, client3_.cli_cnpj, client3_.cli_razaosocial, client3_.cli_complementologradouro, client3_.cli_emailcontato, client3_.cli_contato, client3_.cli_telefone, client3_.cli_pais, client3_.cli_descricao, client3_.dic_codigo, client3_.tem_codigo, client3_.cli_habilitatermosdeuso, client3_.cli_statusdadoscompl, client3_.cli_resetouambiente, client3_.cli_tipoambiente, client3_.cli_feztour, client3_.cli_possuidatalimite, client3_.cli_ultatualizacao, client3_.cli_qtdelicencastmp, client3_.cli_datalimite, client3_.cli_centralizador, client3_.cli_bairro, client3_.cli_numerologradouro, client3_.cli_observacao, client3_.cli_pedido, client3_.prc_codigo, client3_.cli_codclienteparceiro, client3_.cli_tipoplanocomprado, client3_.cli_modorelacionamento, client3_.cli_tipoenviocodigoverificador, client3_.prc_codigoparceiroservico, client3_.cli_origemaplicacao, client3_.cli_datacriacaoambiente, client3_.cli_estado, client3_.cli_logradouro, client3_.cli_usainputweb, client3_.cli_website, client3_.cli_cep, items4_.hpi_codigo, items4_.hpi_cli_codigo, items4_.hpi_agrupacampos, items4_.hps_codigo, items4_.ite_codigo, items4_.sec_codigo, items4_.spq_codigo, items4_.hpi_status, items4_.hpi_valor, items4_.hpi_valorexibicao, section5_.sec_codigo, section5_.sec_ativo, section5_.pes_codigo, section5_.sec_tipovercamposrelatorio, section5_.sec_mudavisualizaitens, section5_.sec_duplicaitem, section5_.sec_identificadoralternativo, section5_.sec_codsecaoantecessora, section5_.sec_avancoautomaticoitem, section5_.sec_avancoautomaticosecao, section5_.sec_alertaitens, section5_.sec_limpafiltrobuscaitem, section5_.sec_cli_codigo, section5_.sec_padrao, section5_.sec_descricao, section5_.sec_origemitem, section5_.sec_consulta, section5_.sec_exibeitemunico, section5_.sec_documentacao, section5_.sec_formaexecucaoitem, section5_.sec_iconefinalizacaosecao, section5_.sec_buscaitensporcodalt, section5_.sec_fococampoeditavel, section5_.sec_exibelistagrupoitem, section5_.mid_codigo, section5_.sec_preencheitemunico, section5_.sec_bloqueiaedicao, section5_.sec_obrigatorio, section5_.sec_marcagrupocompleto, section5_.sec_formaexibiritemmobile, section5_.sec_numcamposquiz, section5_.sec_ordemexibicao, section5_.sec_ordenacaoitem, section5_.sec_ordemitemrelatorio, section5_.sec_formapagamento, section5_.sec_modoquiz, section5_.sec_salvadadoscartao, section5_.sec_formabuscaitempda, section5_.sec_autoexibeitemcoletado, section5_.sec_trocaitemcampos, section5_.sec_tipoleiturabuscaitem, section5_.sec_usaitem
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=821.10..6,659.80 rows=1 width=1,239) (actual rows= loops=)

  • Output: activityhi0_.hps_codigo, activityhi0_.pes_codigo, activityhi0_.age_codigopda, activityhi0_.hps_statusexpbi, activityhi0_.hps_cli_codigo, activityhi0_.hps_origemdados, activityhi0_.hps_datahorasincronismo, activityhi0_.hps_arquivoexportacao, activityhi0_.hps_statusexpexec, activityhi0_.hps_datahorafiminform, activityhi0_.hps_datahorafimsistema, activityhi0_.hps_codigopda, activityhi0_.hps_totalfotosrecebidas, activityhi0_.hps_totalfotos, activityhi0_.hps_datahorafoto, activityhi0_.tar_codigo, activityhi0_.hps_datahorainicioinform, activityhi0_.hps_datahorainiciosistema, activityhi0_.hps_status, activityhi0_.hps_statusaprovacao, activityhi0_.hps_tokenimpressao, schedule1_.tar_codigo, schedule1_.tar_tokenacesso, schedule1_.tar_ativo, schedule1_.tar_origematividade, schedule1_.age_codigo, schedule1_.age_codigoinclusao, schedule1_.tar_ageultimaatualizacao, schedule1_.tar_identificadoralternativo, schedule1_.tar_cli_codigo, schedule1_.tar_complementoregistro1, schedule1_.tar_complementoregistro10, schedule1_.tar_complementoregistro2, schedule1_.tar_complementoregistro3, schedule1_.tar_complementoregistro4, schedule1_.tar_complementoregistro5, schedule1_.tar_complementoregistro6, schedule1_.tar_complementoregistro7, schedule1_.tar_complementoregistro8, schedule1_.tar_complementoregistro9, schedule1_.tar_data, schedule1_.tar_dataexecucao, schedule1_.tar_datafimreal, schedule1_.tar_horafimreal, schedule1_.tar_datafimprev, schedule1_.tar_horafimprev, schedule1_.tar_horaexecucao, schedule1_.tar_datainicioreal, schedule1_.tar_horainicioreal, schedule1_.tar_dtprevcomtoleranciapos, schedule1_.tar_situacaoexportacao, schedule1_.tar_grupo, schedule1_.tar_hora, schedule1_.mid_codigo, schedule1_.tar_datahorainclusao, schedule1_.tar_moduloinclusao, schedule1_.tar_ultimaatualizacao, schedule1_.tar_observacao, schedule1_.tar_origem, schedule1_.tar_codigotarefaorigem, schedule1_.tar_prioridade, schedule1_.tar_duplicanopda, schedule1_.tpt_codigo, schedule1_.tar_envianotificacao, schedule1_.loc_codigo, schedule1_.sit_codigo, schedule1_.tar_finalizadoautomatico, schedule1_.tar_dataultimosinc, schedule1_.tar_horaultimosinc, schedule1_.eqp_codigo, schedule1_.tar_execucaoequipe, schedule1_.tar_alertaposfim, schedule1_.tar_alertaposinicio, schedule1_.tar_alertaprefim, schedule1_.tar_alertapreinicio, schedule1_.tar_bloqueioposinicio, schedule1_.tar_bloqueiopreinicio, schedule1_.tar_moduloultimaedicao, schedule1_.tar_validadatahorainicio, schedule1_.tar_tempoespera, activity2_.pes_codigo, activity2_.pes_gpsobrigatorio, activity2_.pes_execucaoacelerada, activity2_.pes_ativo, activity2_.tpq_codigo, activity2_.age_codigoinclusao, activity2_.age_codigoultimaedicao, activity2_.pes_identificadoralternativo, activity2_.pes_codpesqantecessora, activity2_.pes_tipoexecpesimpeditiva, activity2_.pes_tipoexecpesantecessora, activity2_.pes_cancelamentoseguro, activity2_.pes_capturagps, activity2_.pes_cli_codigo, activity2_.pes_tipocomunicacao, activity2_.pes_confirmaencerramento, activity2_.pes_confirmasemgps, activity2_.pes_descricao, activity2_.pes_exibetelaconferencia, activity2_.pes_ordemexibicao, activity2_.pes_documentacao, activity2_.pes_compartilhadados, activity2_.pes_mensagemfinalizadora, activity2_.pes_exclusivo, activity2_.pes_tipoexecucao, activity2_.lei_codigo, activity2_.lei_codigoexecucao, activity2_.pes_funcaoestrutural, activity2_.mid_codigo, activity2_.pes_dthorainclusao, activity2_.pes_moduloinclusao, activity2_.pes_ultatualizacao, activity2_.pes_bloqueiaedicao, activity2_.pes_execucaoemloop, activity2_.pes_quantidademaximafoto, activity2_.pes_podesuspenderexecucao, activity2_.pes_quantidademinimafoto, activity2_.pes_execucaonegativa, activity2_.pes_dicafoto, activity2_.pes_raioexecucaoautomatica, activity2_.pes_informadataexecucao, activity2_.pes_informadataexecucaomob, activity2_.pes_exibemsgcancelamento, activity2_.pes_exibesecaoemformweb, activity2_.pes_estrutural, activity2_.pes_capturaaudio, activity2_.pes_capturafoto, activity2_.pes_moduloultimaedicao, activity2_.pes_obrigatorio, client3_.cli_codigo, client3_.cli_aceitetermosdeuso, client3_.cli_datahoradoaceite, client3_.cli_ativo, client3_.cli_informacoescontrato, client3_.cli_alias, client3_.cli_atualizacaoapp, client3_.vap_codigo, client3_.tau_codigo, client3_.cli_tipoautenticacao, client3_.cli_fatura, client3_.cli_cidade, client3_.cli_codigogrupo, client3_.cli_cnpj, client3_.cli_razaosocial, client3_.cli_complementologradouro, client3_.cli_emailcontato, client3_.cli_contato, client3_.cli_telefone, client3_.cli_pais, client3_.cli_descricao, client3_.dic_codigo, client3_.tem_codigo, client3_.cli_habilitatermosdeuso, client3_.cli_statusdadoscompl, client3_.cli_resetouambiente, client3_.cli_tipoambiente, client3_.cli_feztour, client3_.cli_possuidatalimite, client3_.cli_ultatualizacao, client3_.cli_qtdelicencastmp, client3_.cli_datalimite, client3_.cli_centralizador, client3_.cli_bairro, client3_.cli_numerologradouro, client3_.cli_observacao, client3_.cli_pedido, client3_.prc_codigo, client3_.cli_codclienteparceiro, client3_.cli_tipoplanocomprado, client3_.cli_modorelacionamento, client3_.cli_tipoenviocodigoverificador, client3_.prc_codigoparceiroservico, client3_.cli_origemaplicacao, client3_.cli_datacriacaoambiente, client3_.cli_estado, client3_.cli_logradouro, client3_.cli_usainputweb, client3_.cli_website, client3_.cli_cep, items4_.hpi_codigo, items4_.hpi_cli_codigo, items4_.hpi_agrupacampos, items4_.hps_codigo, items4_.ite_codigo, items4_.sec_codigo, items4_.spq_codigo, items4_.hpi_status, items4_.hpi_valor, items4_.hpi_valorexibicao
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=820.81..6,657.33 rows=1 width=824) (actual rows= loops=)

  • Output: activityhi0_.hps_codigo, activityhi0_.pes_codigo, activityhi0_.age_codigopda, activityhi0_.hps_statusexpbi, activityhi0_.hps_cli_codigo, activityhi0_.hps_origemdados, activityhi0_.hps_datahorasincronismo, activityhi0_.hps_arquivoexportacao, activityhi0_.hps_statusexpexec, activityhi0_.hps_datahorafiminform, activityhi0_.hps_datahorafimsistema, activityhi0_.hps_codigopda, activityhi0_.hps_totalfotosrecebidas, activityhi0_.hps_totalfotos, activityhi0_.hps_datahorafoto, activityhi0_.tar_codigo, activityhi0_.hps_datahorainicioinform, activityhi0_.hps_datahorainiciosistema, activityhi0_.hps_status, activityhi0_.hps_statusaprovacao, activityhi0_.hps_tokenimpressao, schedule1_.tar_codigo, schedule1_.tar_tokenacesso, schedule1_.tar_ativo, schedule1_.tar_origematividade, schedule1_.age_codigo, schedule1_.age_codigoinclusao, schedule1_.tar_ageultimaatualizacao, schedule1_.tar_identificadoralternativo, schedule1_.tar_cli_codigo, schedule1_.tar_complementoregistro1, schedule1_.tar_complementoregistro10, schedule1_.tar_complementoregistro2, schedule1_.tar_complementoregistro3, schedule1_.tar_complementoregistro4, schedule1_.tar_complementoregistro5, schedule1_.tar_complementoregistro6, schedule1_.tar_complementoregistro7, schedule1_.tar_complementoregistro8, schedule1_.tar_complementoregistro9, schedule1_.tar_data, schedule1_.tar_dataexecucao, schedule1_.tar_datafimreal, schedule1_.tar_horafimreal, schedule1_.tar_datafimprev, schedule1_.tar_horafimprev, schedule1_.tar_horaexecucao, schedule1_.tar_datainicioreal, schedule1_.tar_horainicioreal, schedule1_.tar_dtprevcomtoleranciapos, schedule1_.tar_situacaoexportacao, schedule1_.tar_grupo, schedule1_.tar_hora, schedule1_.mid_codigo, schedule1_.tar_datahorainclusao, schedule1_.tar_moduloinclusao, schedule1_.tar_ultimaatualizacao, schedule1_.tar_observacao, schedule1_.tar_origem, schedule1_.tar_codigotarefaorigem, schedule1_.tar_prioridade, schedule1_.tar_duplicanopda, schedule1_.tpt_codigo, schedule1_.tar_envianotificacao, schedule1_.loc_codigo, schedule1_.sit_codigo, schedule1_.tar_finalizadoautomatico, schedule1_.tar_dataultimosinc, schedule1_.tar_horaultimosinc, schedule1_.eqp_codigo, schedule1_.tar_execucaoequipe, schedule1_.tar_alertaposfim, schedule1_.tar_alertaposinicio, schedule1_.tar_alertaprefim, schedule1_.tar_alertapreinicio, schedule1_.tar_bloqueioposinicio, schedule1_.tar_bloqueiopreinicio, schedule1_.tar_moduloultimaedicao, schedule1_.tar_validadatahorainicio, schedule1_.tar_tempoespera, activity2_.pes_codigo, activity2_.pes_gpsobrigatorio, activity2_.pes_execucaoacelerada, activity2_.pes_ativo, activity2_.tpq_codigo, activity2_.age_codigoinclusao, activity2_.age_codigoultimaedicao, activity2_.pes_identificadoralternativo, activity2_.pes_codpesqantecessora, activity2_.pes_tipoexecpesimpeditiva, activity2_.pes_tipoexecpesantecessora, activity2_.pes_cancelamentoseguro, activity2_.pes_capturagps, activity2_.pes_cli_codigo, activity2_.pes_tipocomunicacao, activity2_.pes_confirmaencerramento, activity2_.pes_confirmasemgps, activity2_.pes_descricao, activity2_.pes_exibetelaconferencia, activity2_.pes_ordemexibicao, activity2_.pes_documentacao, activity2_.pes_compartilhadados, activity2_.pes_mensagemfinalizadora, activity2_.pes_exclusivo, activity2_.pes_tipoexecucao, activity2_.lei_codigo, activity2_.lei_codigoexecucao, activity2_.pes_funcaoestrutural, activity2_.mid_codigo, activity2_.pes_dthorainclusao, activity2_.pes_moduloinclusao, activity2_.pes_ultatualizacao, activity2_.pes_bloqueiaedicao, activity2_.pes_execucaoemloop, activity2_.pes_quantidademaximafoto, activity2_.pes_podesuspenderexecucao, activity2_.pes_quantidademinimafoto, activity2_.pes_execucaonegativa, activity2_.pes_dicafoto, activity2_.pes_raioexecucaoautomatica, activity2_.pes_informadataexecucao, activity2_.pes_informadataexecucaomob, activity2_.pes_exibemsgcancelamento, activity2_.pes_exibesecaoemformweb, activity2_.pes_estrutural, activity2_.pes_capturaaudio, activity2_.pes_capturafoto, activity2_.pes_moduloultimaedicao, activity2_.pes_obrigatorio, items4_.hpi_codigo, items4_.hpi_cli_codigo, items4_.hpi_agrupacampos, items4_.hps_codigo, items4_.ite_codigo, items4_.sec_codigo, items4_.spq_codigo, items4_.hpi_status, items4_.hpi_valor, items4_.hpi_valorexibicao
9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=820.24..6,654.53 rows=1 width=485) (actual rows= loops=)

  • Output: activityhi0_.hps_codigo, activityhi0_.pes_codigo, activityhi0_.age_codigopda, activityhi0_.hps_statusexpbi, activityhi0_.hps_cli_codigo, activityhi0_.hps_origemdados, activityhi0_.hps_datahorasincronismo, activityhi0_.hps_arquivoexportacao, activityhi0_.hps_statusexpexec, activityhi0_.hps_datahorafiminform, activityhi0_.hps_datahorafimsistema, activityhi0_.hps_codigopda, activityhi0_.hps_totalfotosrecebidas, activityhi0_.hps_totalfotos, activityhi0_.hps_datahorafoto, activityhi0_.tar_codigo, activityhi0_.hps_datahorainicioinform, activityhi0_.hps_datahorainiciosistema, activityhi0_.hps_status, activityhi0_.hps_statusaprovacao, activityhi0_.hps_tokenimpressao, activity2_.pes_codigo, activity2_.pes_gpsobrigatorio, activity2_.pes_execucaoacelerada, activity2_.pes_ativo, activity2_.tpq_codigo, activity2_.age_codigoinclusao, activity2_.age_codigoultimaedicao, activity2_.pes_identificadoralternativo, activity2_.pes_codpesqantecessora, activity2_.pes_tipoexecpesimpeditiva, activity2_.pes_tipoexecpesantecessora, activity2_.pes_cancelamentoseguro, activity2_.pes_capturagps, activity2_.pes_cli_codigo, activity2_.pes_tipocomunicacao, activity2_.pes_confirmaencerramento, activity2_.pes_confirmasemgps, activity2_.pes_descricao, activity2_.pes_exibetelaconferencia, activity2_.pes_ordemexibicao, activity2_.pes_documentacao, activity2_.pes_compartilhadados, activity2_.pes_mensagemfinalizadora, activity2_.pes_exclusivo, activity2_.pes_tipoexecucao, activity2_.lei_codigo, activity2_.lei_codigoexecucao, activity2_.pes_funcaoestrutural, activity2_.mid_codigo, activity2_.pes_dthorainclusao, activity2_.pes_moduloinclusao, activity2_.pes_ultatualizacao, activity2_.pes_bloqueiaedicao, activity2_.pes_execucaoemloop, activity2_.pes_quantidademaximafoto, activity2_.pes_podesuspenderexecucao, activity2_.pes_quantidademinimafoto, activity2_.pes_execucaonegativa, activity2_.pes_dicafoto, activity2_.pes_raioexecucaoautomatica, activity2_.pes_informadataexecucao, activity2_.pes_informadataexecucaomob, activity2_.pes_exibemsgcancelamento, activity2_.pes_exibesecaoemformweb, activity2_.pes_estrutural, activity2_.pes_capturaaudio, activity2_.pes_capturafoto, activity2_.pes_moduloultimaedicao, activity2_.pes_obrigatorio, items4_.hpi_codigo, items4_.hpi_cli_codigo, items4_.hpi_agrupacampos, items4_.hps_codigo, items4_.ite_codigo, items4_.sec_codigo, items4_.spq_codigo, items4_.hpi_status, items4_.hpi_valor, items4_.hpi_valorexibicao
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=819.54..6,633.04 rows=2 width=405) (actual rows= loops=)

  • Output: activityhi0_.hps_codigo, activityhi0_.pes_codigo, activityhi0_.age_codigopda, activityhi0_.hps_statusexpbi, activityhi0_.hps_cli_codigo, activityhi0_.hps_origemdados, activityhi0_.hps_datahorasincronismo, activityhi0_.hps_arquivoexportacao, activityhi0_.hps_statusexpexec, activityhi0_.hps_datahorafiminform, activityhi0_.hps_datahorafimsistema, activityhi0_.hps_codigopda, activityhi0_.hps_totalfotosrecebidas, activityhi0_.hps_totalfotos, activityhi0_.hps_datahorafoto, activityhi0_.tar_codigo, activityhi0_.hps_datahorainicioinform, activityhi0_.hps_datahorainiciosistema, activityhi0_.hps_status, activityhi0_.hps_statusaprovacao, activityhi0_.hps_tokenimpressao, activity2_.pes_codigo, activity2_.pes_gpsobrigatorio, activity2_.pes_execucaoacelerada, activity2_.pes_ativo, activity2_.tpq_codigo, activity2_.age_codigoinclusao, activity2_.age_codigoultimaedicao, activity2_.pes_identificadoralternativo, activity2_.pes_codpesqantecessora, activity2_.pes_tipoexecpesimpeditiva, activity2_.pes_tipoexecpesantecessora, activity2_.pes_cancelamentoseguro, activity2_.pes_capturagps, activity2_.pes_cli_codigo, activity2_.pes_tipocomunicacao, activity2_.pes_confirmaencerramento, activity2_.pes_confirmasemgps, activity2_.pes_descricao, activity2_.pes_exibetelaconferencia, activity2_.pes_ordemexibicao, activity2_.pes_documentacao, activity2_.pes_compartilhadados, activity2_.pes_mensagemfinalizadora, activity2_.pes_exclusivo, activity2_.pes_tipoexecucao, activity2_.lei_codigo, activity2_.lei_codigoexecucao, activity2_.pes_funcaoestrutural, activity2_.mid_codigo, activity2_.pes_dthorainclusao, activity2_.pes_moduloinclusao, activity2_.pes_ultatualizacao, activity2_.pes_bloqueiaedicao, activity2_.pes_execucaoemloop, activity2_.pes_quantidademaximafoto, activity2_.pes_podesuspenderexecucao, activity2_.pes_quantidademinimafoto, activity2_.pes_execucaonegativa, activity2_.pes_dicafoto, activity2_.pes_raioexecucaoautomatica, activity2_.pes_informadataexecucao, activity2_.pes_informadataexecucaomob, activity2_.pes_exibemsgcancelamento, activity2_.pes_exibesecaoemformweb, activity2_.pes_estrutural, activity2_.pes_capturaaudio, activity2_.pes_capturafoto, activity2_.pes_moduloultimaedicao, activity2_.pes_obrigatorio
11. 0.000 0.000 ↓ 0.0

Index Scan using idx_pesquisa_pes_cli_codigo on public.pesquisa activity2_ (cost=0.42..8.10 rows=8 width=221) (actual rows= loops=)

  • Output: activity2_.pes_codigo, activity2_.pes_gpsobrigatorio, activity2_.pes_execucaoacelerada, activity2_.pes_ativo, activity2_.tpq_codigo, activity2_.age_codigoinclusao, activity2_.age_codigoultimaedicao, activity2_.pes_identificadoralternativo, activity2_.pes_codpesqantecessora, activity2_.pes_tipoexecpesimpeditiva, activity2_.pes_tipoexecpesantecessora, activity2_.pes_cancelamentoseguro, activity2_.pes_capturagps, activity2_.pes_cli_codigo, activity2_.pes_tipocomunicacao, activity2_.pes_confirmaencerramento, activity2_.pes_confirmasemgps, activity2_.pes_descricao, activity2_.pes_exibetelaconferencia, activity2_.pes_ordemexibicao, activity2_.pes_documentacao, activity2_.pes_compartilhadados, activity2_.pes_mensagemfinalizadora, activity2_.pes_exclusivo, activity2_.pes_tipoexecucao, activity2_.lei_codigo, activity2_.lei_codigoexecucao, activity2_.pes_funcaoestrutural, activity2_.mid_codigo, activity2_.pes_dthorainclusao, activity2_.pes_moduloinclusao, activity2_.pes_ultatualizacao, activity2_.pes_bloqueiaedicao, activity2_.pes_execucaoemloop, activity2_.pes_quantidademaximafoto, activity2_.pes_podesuspenderexecucao, activity2_.pes_quantidademinimafoto, activity2_.pes_execucaonegativa, activity2_.pes_dicafoto, activity2_.pes_raioexecucaoautomatica, activity2_.pes_informadataexecucao, activity2_.pes_informadataexecucaomob, activity2_.pes_exibemsgcancelamento, activity2_.pes_exibesecaoemformweb, activity2_.pes_estrutural, activity2_.pes_capturaaudio, activity2_.pes_capturafoto, activity2_.pes_moduloultimaedicao, activity2_.pes_obrigatorio
  • Index Cond: (activity2_.pes_cli_codigo = 15488)
12. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on public.historicopesquisa activityhi0_ (cost=819.12..828.04 rows=8 width=184) (actual rows= loops=)

  • Output: activityhi0_.hps_codigo, activityhi0_.hps_cli_codigo, activityhi0_.tar_codigo, activityhi0_.pes_codigo, activityhi0_.hps_datahorainiciosistema, activityhi0_.hps_datahorafimsistema, activityhi0_.hps_datahorainicioinform, activityhi0_.hps_datahorafiminform, activityhi0_.hps_datahorafoto, activityhi0_.hps_status, activityhi0_.hps_origemdados, activityhi0_.hps_codigopda, activityhi0_.age_codigopda, activityhi0_.hps_statusexpexec, activityhi0_.hps_statusexpbi, activityhi0_.hps_arquivoexportacao, activityhi0_.hps_totalfotos, activityhi0_.hps_totalfotosrecebidas, activityhi0_.hps_datahorasincronismo, activityhi0_.hps_tokenimpressao, activityhi0_.hps_statusaprovacao, activityhi0_.hps_erropontualidade, activityhi0_.hps_errolocalizacao, activityhi0_.hps_errodados
  • Recheck Cond: ((activityhi0_.pes_codigo = activity2_.pes_codigo) AND (activityhi0_.tar_codigo = 43834869))
13. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=819.12..819.12 rows=8 width=0) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_historicopesquisa_pes_codigo (cost=0.00..190.34 rows=15,330 width=0) (actual rows= loops=)

  • Index Cond: (activityhi0_.pes_codigo = activity2_.pes_codigo)
15. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_historicopesquisa_tar_codigo (cost=0.00..616.14 rows=49,517 width=0) (actual rows= loops=)

  • Index Cond: (activityhi0_.tar_codigo = 43834869)
16. 0.000 0.000 ↓ 0.0

Index Scan using idx_historicopesquisaitem_clicodigo_hpscodigo on public.historicopesquisaitem items4_ (cost=0.70..10.67 rows=8 width=80) (actual rows= loops=)

  • Output: items4_.hpi_codigo, items4_.hpi_cli_codigo, items4_.hps_codigo, items4_.sec_codigo, items4_.ite_codigo, items4_.hpi_valor, items4_.hpi_valorexibicao, items4_.hpi_status, items4_.hpi_valorminimo, items4_.hpi_valormaximo, items4_.spq_codigo, items4_.hpi_identificador, items4_.hpi_agrupacampos
  • Index Cond: ((items4_.hpi_cli_codigo = 15488) AND (items4_.hps_codigo = activityhi0_.hps_codigo))
17. 0.000 0.000 ↓ 0.0

Index Scan using tarefa_pkey on public.tarefa schedule1_ (cost=0.57..2.79 rows=1 width=339) (actual rows= loops=)

  • Output: schedule1_.tar_codigo, schedule1_.tar_tokenacesso, schedule1_.tar_ativo, schedule1_.tar_origematividade, schedule1_.age_codigo, schedule1_.age_codigoinclusao, schedule1_.tar_ageultimaatualizacao, schedule1_.tar_identificadoralternativo, schedule1_.tar_cli_codigo, schedule1_.tar_complementoregistro1, schedule1_.tar_complementoregistro10, schedule1_.tar_complementoregistro2, schedule1_.tar_complementoregistro3, schedule1_.tar_complementoregistro4, schedule1_.tar_complementoregistro5, schedule1_.tar_complementoregistro6, schedule1_.tar_complementoregistro7, schedule1_.tar_complementoregistro8, schedule1_.tar_complementoregistro9, schedule1_.tar_data, schedule1_.tar_dataexecucao, schedule1_.tar_datafimreal, schedule1_.tar_horafimreal, schedule1_.tar_datafimprev, schedule1_.tar_horafimprev, schedule1_.tar_horaexecucao, schedule1_.tar_datainicioreal, schedule1_.tar_horainicioreal, schedule1_.tar_dtprevcomtoleranciapos, schedule1_.tar_situacaoexportacao, schedule1_.tar_grupo, schedule1_.tar_hora, schedule1_.mid_codigo, schedule1_.tar_datahorainclusao, schedule1_.tar_moduloinclusao, schedule1_.tar_ultimaatualizacao, schedule1_.tar_observacao, schedule1_.tar_origem, schedule1_.tar_codigotarefaorigem, schedule1_.tar_prioridade, schedule1_.tar_duplicanopda, schedule1_.tpt_codigo, schedule1_.tar_envianotificacao, schedule1_.loc_codigo, schedule1_.sit_codigo, schedule1_.tar_finalizadoautomatico, schedule1_.tar_dataultimosinc, schedule1_.tar_horaultimosinc, schedule1_.eqp_codigo, schedule1_.tar_execucaoequipe, schedule1_.tar_alertaposfim, schedule1_.tar_alertaposinicio, schedule1_.tar_alertaprefim, schedule1_.tar_alertapreinicio, schedule1_.tar_bloqueioposinicio, schedule1_.tar_bloqueiopreinicio, schedule1_.tar_moduloultimaedicao, schedule1_.tar_validadatahorainicio, schedule1_.tar_tempoespera
  • Index Cond: (schedule1_.tar_codigo = 43834869)
  • Filter: (schedule1_.tar_cli_codigo = 15488)
18. 0.000 0.000 ↓ 0.0

Index Scan using cliente_pkey on public.cliente client3_ (cost=0.29..2.46 rows=1 width=415) (actual rows= loops=)

  • Output: client3_.cli_codigo, client3_.cli_aceitetermosdeuso, client3_.cli_datahoradoaceite, client3_.cli_ativo, client3_.cli_informacoescontrato, client3_.cli_alias, client3_.cli_atualizacaoapp, client3_.vap_codigo, client3_.tau_codigo, client3_.cli_tipoautenticacao, client3_.cli_fatura, client3_.cli_cidade, client3_.cli_codigogrupo, client3_.cli_cnpj, client3_.cli_razaosocial, client3_.cli_complementologradouro, client3_.cli_emailcontato, client3_.cli_contato, client3_.cli_telefone, client3_.cli_pais, client3_.cli_descricao, client3_.dic_codigo, client3_.tem_codigo, client3_.cli_habilitatermosdeuso, client3_.cli_statusdadoscompl, client3_.cli_resetouambiente, client3_.cli_tipoambiente, client3_.cli_feztour, client3_.cli_possuidatalimite, client3_.cli_ultatualizacao, client3_.cli_qtdelicencastmp, client3_.cli_datalimite, client3_.cli_centralizador, client3_.cli_bairro, client3_.cli_numerologradouro, client3_.cli_observacao, client3_.cli_pedido, client3_.prc_codigo, client3_.cli_codclienteparceiro, client3_.cli_tipoplanocomprado, client3_.cli_modorelacionamento, client3_.cli_tipoenviocodigoverificador, client3_.prc_codigoparceiroservico, client3_.cli_origemaplicacao, client3_.cli_datacriacaoambiente, client3_.cli_estado, client3_.cli_logradouro, client3_.cli_usainputweb, client3_.cli_website, client3_.cli_cep
  • Index Cond: (client3_.cli_codigo = activityhi0_.hps_cli_codigo)
19. 0.000 0.000 ↓ 0.0

Index Scan using secao_pkey on public.secao section5_ (cost=0.42..2.60 rows=1 width=147) (actual rows= loops=)

  • Output: section5_.sec_codigo, section5_.pes_codigo, section5_.sec_descricao, section5_.sec_identificadoralternativo, section5_.sec_cli_codigo, section5_.sec_ativo, section5_.sec_obrigatorio, section5_.sec_preencheitemunico, section5_.sec_ordemexibicao, section5_.sec_exibelistagrupoitem, section5_.sec_codsecaoantecessora, section5_.sec_usaitem, section5_.sec_buscaitensporcodalt, section5_.sec_tipovercamposrelatorio, section5_.sec_origemitem, section5_.sec_autoexibeitemcoletado, section5_.sec_modoquiz, section5_.sec_numcamposquiz, section5_.sec_marcagrupocompleto, section5_.sec_bloqueiaedicao, section5_.sec_codigoorigem, section5_.sec_alterado, section5_.sec_ultatualizacao, section5_.sec_dthorainclusao, section5_.sec_documentacao, section5_.sec_formaexecucaoitem, section5_.sec_limpafiltrobuscaitem, section5_.sec_avancoautomaticoitem, section5_.mid_codigo, section5_.sec_consulta, section5_.sec_alertaitens, section5_.sec_formabuscaitempda, section5_.sec_ocultagruposemitem, section5_.sec_fococampoeditavel, section5_.sec_duplicaitem, section5_.sec_finalizadora, section5_.sec_exibeitemunico, section5_.sec_avancoautomaticosecao, section5_.sec_estrutural, section5_.sec_funcaoestrutural, section5_.sec_padrao, section5_.sec_formaexibiritemmobile, section5_.sec_mudavisualizaitens, section5_.sec_trocaitemcampos, section5_.sec_formapagamento, section5_.sec_salvadadoscartao, section5_.sec_ordenacaoitem, section5_.sec_iconefinalizacaosecao, section5_.sec_ordemitemrelatorio, section5_.sec_tipoleiturabuscaitem
  • Index Cond: (items4_.sec_codigo = section5_.sec_codigo)
  • Filter: (15488 = section5_.sec_cli_codigo)
20. 0.000 0.000 ↓ 0.0

Index Scan using item_pkey on public.item item6_ (cost=0.56..2.74 rows=1 width=209) (actual rows= loops=)

  • Output: item6_.ite_codigo, item6_.ite_cli_codigo, item6_.gru_codigo, item6_.ite_descricao, item6_.ite_ativo, item6_.ite_identificadoralternativo, item6_.cat_codigo, item6_.ite_exibenocenterweb, item6_.ite_complementoregistro1, item6_.ite_complementoregistro2, item6_.ite_complementoregistro3, item6_.ite_complementoregistro4, item6_.ite_complementoregistro5, item6_.ite_complementoregistro6, item6_.ite_complementoregistro7, item6_.ite_complementoregistro8, item6_.ite_complementoregistro9, item6_.ite_complementoregistro10, item6_.ite_statusexpcad, item6_.ite_arquivoexportacao, item6_.ite_ativo_aux, item6_.ite_seqalterparamob, item6_.ite_bloqueiaedicao, item6_.ite_codigoorigem, item6_.ite_ultatualizacao, item6_.ite_dthorainclusao, item6_.mid_codigo, item6_.ite_tags, item6_.age_codigoinclusao, item6_.age_codigoultimaedicao, item6_.ite_moduloinclusao, item6_.ite_moduloultimaedicao
  • Index Cond: (items4_.ite_codigo = item6_.ite_codigo)
  • Filter: (15488 = item6_.ite_cli_codigo)
21. 0.000 0.000 ↓ 0.0

Index Scan using criteriosecao_pkey on public.criteriosecao sectionfie7_ (cost=0.43..2.61 rows=1 width=221) (actual rows= loops=)

  • Output: sectionfie7_.spq_codigo, sectionfie7_.spq_ativo, sectionfie7_.spq_identificadoralternativo, sectionfie7_.spq_atalhodiscagempda, sectionfie7_.spq_cli_codigo, sectionfie7_.con_codigo, sectionfie7_.cad_codigo, sectionfie7_.spq_campoexternolista, sectionfie7_.spq_campointernolista, sectionfie7_.spq_ordemregistromobile, sectionfie7_.cac_codigo, sectionfie7_.spq_qtdcasadecimal, sectionfie7_.spq_descricao, sectionfie7_.spq_documentacao, sectionfie7_.spq_executatelaitens, sectionfie7_.spq_valorfalso, sectionfie7_.crp_codigo, sectionfie7_.spq_preenchezeroesquerda, sectionfie7_.spq_formatofonte, sectionfie7_.spq_tamanhofonte, sectionfie7_.spq_escondevazio, sectionfie7_.spq_tipolista, sectionfie7_.spq_bloqueiaedicao, sectionfie7_.spq_aplicamascara, sectionfie7_.spq_tamanhominimocampo, sectionfie7_.spq_indicetela, sectionfie7_.spq_aceitanulo, sectionfie7_.spq_ordemexibicao, sectionfie7_.spq_persistirdados, sectionfie7_.spq_processaformulaslistaitens, sectionfie7_.spq_arredondanumero, sectionfie7_.spq_regraentradadados, sectionfie7_.sec_codigo, sectionfie7_.sec_codigoreferencia, sectionfie7_.spq_compartilha, sectionfie7_.spq_mostravalornaconferencia, sectionfie7_.spq_mostrarelatoriocenter, sectionfie7_.spq_mostravalornomobile, sectionfie7_.spq_tamanhocampo, sectionfie7_.spq_origemvalor, sectionfie7_.spq_funcaoestrutural, sectionfie7_.spq_tipocampomultimidia, sectionfie7_.spq_dica, sectionfie7_.spq_enquadrarimagem, sectionfie7_.spq_valorverdadeiro, sectionfie7_.spq_tipocampo, sectionfie7_.spq_tipoentradadados, sectionfie7_.spq_chaveunica, sectionfie7_.spq_campounico, sectionfie7_.spq_editavel, sectionfie7_.spq_modoaberturaweb, sectionfie7_.spq_validasomentevisivel, sectionfie7_.spq_visivel
  • Index Cond: (sectionfie7_.spq_codigo = items4_.spq_codigo)
  • Filter: (((sectionfie7_.spq_tipocampomultimidia IS NULL) OR (sectionfie7_.spq_tipocampomultimidia <> 'X'::bpchar)) AND (sectionfie7_.spq_cli_codigo = 15488) AND (sectionfie7_.spq_mostrarelatoriocenter = '1'::bpchar) AND (sectionfie7_.spq_ativo = '1'::bpchar))
22. 0.000 0.000 ↓ 0.0

Index Scan using criteriopesquisa_pkey on public.criteriopesquisa field8_ (cost=0.42..2.59 rows=1 width=109) (actual rows= loops=)

  • Output: field8_.crp_codigo, field8_.crp_cli_codigo, field8_.crp_descricao, field8_.crp_tipocampo, field8_.crp_tamanhocampo, field8_.crp_qtdcasadecimal, field8_.crp_ativo, field8_.crp_tipolista, field8_.crp_tipoentradadados, field8_.crp_regraentradadados, field8_.crp_valorverdadeiro, field8_.crp_valorfalso, field8_.crp_dica, field8_.pes_descricao, field8_.crp_origemvalor, field8_.cac_codigo, field8_.crp_subtipocampo, field8_.con_codigo, field8_.crp_modoaberturaweb, field8_.cad_codigo, field8_.crp_campointernolista, field8_.crp_campoexternolista, field8_.crp_documentacao, field8_.crp_tamanhominimocampo
  • Index Cond: (sectionfie7_.crp_codigo = field8_.crp_codigo)
  • Filter: (15488 = field8_.crp_cli_codigo)
23. 0.000 0.000 ↓ 0.0

Hash (cost=166.18..166.18 rows=10 width=8) (actual rows= loops=)

  • Output: "ANY_subquery".y0_
24. 0.000 0.000 ↓ 0.0

Subquery Scan on ANY_subquery (cost=166.05..166.18 rows=10 width=8) (actual rows= loops=)

  • Output: "ANY_subquery".y0_
25. 0.000 0.000 ↓ 0.0

Limit (cost=166.05..166.08 rows=10 width=16) (actual rows= loops=)

  • Output: this_.hps_codigo, this_.hps_datahorainiciosistema
26. 0.000 0.000 ↓ 0.0

Sort (cost=166.05..166.42 rows=146 width=16) (actual rows= loops=)

  • Output: this_.hps_codigo, this_.hps_datahorainiciosistema
  • Sort Key: this_.hps_datahorainiciosistema
27. 0.000 0.000 ↓ 0.0

Index Scan using idx_historicopesquisa_tarefa_cliente_pesquisa_data on public.historicopesquisa this_ (cost=0.57..162.90 rows=146 width=16) (actual rows= loops=)

  • Output: this_.hps_codigo, this_.hps_datahorainiciosistema
  • Index Cond: ((this_.tar_codigo = 43834869) AND (this_.hps_cli_codigo = 15488))