explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GBGz

Settings
# exclusive inclusive rows x rows loops node
1. 0.471 282.264 ↑ 1.0 2 1

Limit (cost=358,916.14..358,916.26 rows=2 width=573) (actual time=281.791..282.264 rows=2 loops=1)

  • Output: ((ptrf.id_processo_trf)::integer), p.nr_processo, ptrf.in_segredo_justica, ((ptrf.id_classe_judicial)::integer), ((cj.ds_classe_judicial_sigla)::text), ((ptrf.id_orgao_julgador)::integer), ((oj.ds_orgao_julgador)::text), ((ptrf.id_orgao_julgador_colegiado)::integer), ((ojc.ds_orgao_julgador_colegiado)::text), ((oj.ds_sigla)::text), ((ojc.ds_sigla)::text), tarefa.id_tarefa, tarefa.ds_tarefa, tarefa.in_visivel_oj, tarefa.in_visivel_ojc, ((SubPlan 1)), ((SubPlan 2)), ((SubPlan 3)), ((SubPlan 4)), tul.id_usuario, ((tul.ds_nome)::text)
  • Buffers: shared hit=272070
2. 0.004 281.793 ↑ 11.0 2 1

Unique (cost=358,916.14..358,917.29 rows=22 width=573) (actual time=281.790..281.793 rows=2 loops=1)

  • Output: ((ptrf.id_processo_trf)::integer), p.nr_processo, ptrf.in_segredo_justica, ((ptrf.id_classe_judicial)::integer), ((cj.ds_classe_judicial_sigla)::text), ((ptrf.id_orgao_julgador)::integer), ((oj.ds_orgao_julgador)::text), ((ptrf.id_orgao_julgador_colegiado)::integer), ((ojc.ds_orgao_julgador_colegiado)::text), ((oj.ds_sigla)::text), ((ojc.ds_sigla)::text), tarefa.id_tarefa, tarefa.ds_tarefa, tarefa.in_visivel_oj, tarefa.in_visivel_ojc, ((SubPlan 1)), ((SubPlan 2)), ((SubPlan 3)), ((SubPlan 4)), tul.id_usuario, ((tul.ds_nome)::text)
  • Buffers: shared hit=272070
3. 4.724 281.789 ↑ 11.0 2 1

Sort (cost=358,916.14..358,916.19 rows=22 width=573) (actual time=281.789..281.789 rows=2 loops=1)

  • Output: ((ptrf.id_processo_trf)::integer), p.nr_processo, ptrf.in_segredo_justica, ((ptrf.id_classe_judicial)::integer), ((cj.ds_classe_judicial_sigla)::text), ((ptrf.id_orgao_julgador)::integer), ((oj.ds_orgao_julgador)::text), ((ptrf.id_orgao_julgador_colegiado)::integer), ((ojc.ds_orgao_julgador_colegiado)::text), ((oj.ds_sigla)::text), ((ojc.ds_sigla)::text), tarefa.id_tarefa, tarefa.ds_tarefa, tarefa.in_visivel_oj, tarefa.in_visivel_ojc, ((SubPlan 1)), ((SubPlan 2)), ((SubPlan 3)), ((SubPlan 4)), tul.id_usuario, ((tul.ds_nome)::text)
  • Sort Key: ((ptrf.id_processo_trf)::integer), p.nr_processo, ptrf.in_segredo_justica, ((ptrf.id_classe_judicial)::integer), ((cj.ds_classe_judicial_sigla)::text), ((oj.ds_orgao_julgador)::text), ((ptrf.id_orgao_julgador_colegiado)::integer), ((ojc.ds_orgao_julgador_colegiado)::text), ((oj.ds_sigla)::text), ((ojc.ds_sigla)::text), tarefa.id_tarefa, tarefa.ds_tarefa, tarefa.in_visivel_oj, tarefa.in_visivel_ojc, ((SubPlan 1)), ((SubPlan 2)), ((SubPlan 3)), ((SubPlan 4)), tul.id_usuario, ((tul.ds_nome)::text)
  • Sort Method: quicksort Memory: 914kB
  • Buffers: shared hit=272070
4. 7.944 277.065 ↓ 108.3 2,383 1

Nested Loop Left Join (cost=1,232.78..358,915.64 rows=22 width=573) (actual time=7.533..277.065 rows=2,383 loops=1)

  • Output: (ptrf.id_processo_trf)::integer, p.nr_processo, ptrf.in_segredo_justica, (ptrf.id_classe_judicial)::integer, (cj.ds_classe_judicial_sigla)::text, (ptrf.id_orgao_julgador)::integer, (oj.ds_orgao_julgador)::text, (ptrf.id_orgao_julgador_colegiado)::integer, (ojc.ds_orgao_julgador_colegiado)::text, (oj.ds_sigla)::text, (ojc.ds_sigla)::text, tarefa.id_tarefa, tarefa.ds_tarefa, tarefa.in_visivel_oj, tarefa.in_visivel_ojc, (SubPlan 1), (SubPlan 2), (SubPlan 3), (SubPlan 4), tul.id_usuario, (tul.ds_nome)::text
  • Inner Unique: true
  • Join Filter: ((ptrf.id_orgao_julgador_colegiado)::integer = (ojc.id_orgao_julgador_colegiado)::integer)
  • Buffers: shared hit=272070
5. 0.805 178.567 ↓ 108.3 2,383 1

Nested Loop (cost=1,232.78..358,100.66 rows=22 width=161) (actual time=7.434..178.567 rows=2,383 loops=1)

  • Output: tul.id_usuario, tul.ds_nome, ptrf.id_processo_trf, ptrf.in_segredo_justica, ptrf.id_classe_judicial, ptrf.id_orgao_julgador, ptrf.id_orgao_julgador_colegiado, tarefa.id_tarefa, tarefa.ds_tarefa, tarefa.in_visivel_oj, tarefa.in_visivel_ojc, p.nr_processo, cj.ds_classe_judicial_sigla, oj.ds_orgao_julgador, oj.ds_sigla
  • Buffers: shared hit=222930
6. 0.017 0.017 ↑ 1.0 1 1

Seq Scan on pje.tb_orgao_julgador oj (cost=0.00..2.58 rows=1 width=46) (actual time=0.011..0.017 rows=1 loops=1)

  • Output: oj.ds_orgao_julgador, oj.ds_sigla, oj.id_orgao_julgador
  • Filter: ((oj.id_orgao_julgador)::integer = 14)
  • Rows Removed by Filter: 45
  • Buffers: shared hit=2
7. 2.353 177.745 ↓ 108.3 2,383 1

Nested Loop (cost=1,232.78..358,097.86 rows=22 width=119) (actual time=7.421..177.745 rows=2,383 loops=1)

  • Output: tul.id_usuario, tul.ds_nome, ptrf.id_processo_trf, ptrf.in_segredo_justica, ptrf.id_classe_judicial, ptrf.id_orgao_julgador, ptrf.id_orgao_julgador_colegiado, tarefa.id_tarefa, tarefa.ds_tarefa, tarefa.in_visivel_oj, tarefa.in_visivel_ojc, p.nr_processo, cj.ds_classe_judicial_sigla
  • Inner Unique: true
  • Buffers: shared hit=222928
8. 2.525 170.626 ↓ 108.3 2,383 1

Nested Loop (cost=1,232.50..358,090.57 rows=22 width=113) (actual time=7.413..170.626 rows=2,383 loops=1)

  • Output: tul.id_usuario, tul.ds_nome, ptrf.id_processo_trf, ptrf.in_segredo_justica, ptrf.id_classe_judicial, ptrf.id_orgao_julgador, ptrf.id_orgao_julgador_colegiado, tarefa.id_tarefa, tarefa.ds_tarefa, tarefa.in_visivel_oj, tarefa.in_visivel_ojc, p.nr_processo
  • Inner Unique: true
  • Join Filter: (ipu.id_processo_trf = (p.id_processo)::integer)
  • Buffers: shared hit=215779
9. 1.603 156.186 ↓ 108.3 2,383 1

Nested Loop (cost=1,232.08..358,079.88 rows=22 width=96) (actual time=7.398..156.186 rows=2,383 loops=1)

  • Output: ipu.id_processo_trf, tul.id_usuario, tul.ds_nome, ptrf.id_processo_trf, ptrf.in_segredo_justica, ptrf.id_classe_judicial, ptrf.id_orgao_julgador, ptrf.id_orgao_julgador_colegiado, ptarefa.id_processo_trf, tarefa.id_tarefa, tarefa.ds_tarefa, tarefa.in_visivel_oj, tarefa.in_visivel_ojc
  • Inner Unique: true
  • Buffers: shared hit=206245
10. 41.175 147.434 ↓ 108.3 2,383 1

Hash Join (cost=1,231.65..358,041.87 rows=22 width=66) (actual time=7.387..147.434 rows=2,383 loops=1)

  • Output: ipu.id_usuario, ipu.id_processo_trf, ptrf.id_processo_trf, ptrf.in_segredo_justica, ptrf.id_classe_judicial, ptrf.id_orgao_julgador, ptrf.id_orgao_julgador_colegiado, ptarefa.id_processo_trf, tarefa.id_tarefa, tarefa.ds_tarefa, tarefa.in_visivel_oj, tarefa.in_visivel_ojc
  • Inner Unique: true
  • Hash Cond: (ptarefa.id_tarefa = (tarefa.id_tarefa)::integer)
  • Join Filter: (((tarefa.in_visivel_oj = 'S'::bpchar) AND ((ptrf.id_orgao_julgador)::integer = ipu.id_orgao_julgador) AND (alternatives: SubPlan 5 or hashed SubPlan 6)) OR ((tarefa.in_visivel_ojc = 'S'::bpchar) AND ((ptrf.id_orgao_julgador_colegiado)::integer = ipu.id_orgao_julgador_colegiado) AND (ipu.id_orgao_julgador IS NULL) AND (alternatives: SubPlan 7 or hashed SubPlan 8)))
  • Buffers: shared hit=196713
11. 7.169 106.062 ↓ 2.8 2,383 1

Nested Loop (cost=1,215.85..358,023.88 rows=837 width=46) (actual time=7.169..106.062 rows=2,383 loops=1)

  • Output: ipu.id_usuario, ipu.id_processo_trf, ipu.id_orgao_julgador, ipu.id_orgao_julgador_colegiado, ptrf.id_processo_trf, ptrf.in_segredo_justica, ptrf.id_classe_judicial, ptrf.id_orgao_julgador, ptrf.id_orgao_julgador_colegiado, ptarefa.id_processo_trf, ptarefa.id_tarefa, pat.id_tarefa
  • Inner Unique: true
  • Join Filter: ((ptrf.id_processo_trf)::integer = ipu.id_processo_trf)
  • Buffers: shared hit=134459
12. 3.341 32.892 ↑ 2.5 5,077 1

Hash Join (cost=1,215.56..18,903.29 rows=12,534 width=30) (actual time=7.057..32.892 rows=5,077 loops=1)

  • Output: ptrf.id_processo_trf, ptrf.in_segredo_justica, ptrf.id_classe_judicial, ptrf.id_orgao_julgador, ptrf.id_orgao_julgador_colegiado, ptarefa.id_processo_trf, ptarefa.id_tarefa, pat.id_tarefa
  • Inner Unique: true
  • Hash Cond: (pat.id_pnl_agrupamento = pa.id_pnl_agrupamento)
  • Buffers: shared hit=59659
13. 0.000 29.538 ↓ 1.2 15,873 1

Gather (cost=1,213.95..18,859.01 rows=13,728 width=34) (actual time=7.010..29.538 rows=15,873 loops=1)

  • Output: ptrf.id_processo_trf, ptrf.in_segredo_justica, ptrf.id_classe_judicial, ptrf.id_orgao_julgador, ptrf.id_orgao_julgador_colegiado, ptarefa.id_processo_trf, ptarefa.id_tarefa, pat.id_tarefa, pat.id_pnl_agrupamento
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=59658
14. 2.102 36.225 ↑ 1.1 5,291 3

Hash Join (cost=213.95..16,486.21 rows=5,720 width=34) (actual time=2.009..36.225 rows=5,291 loops=3)

  • Output: ptrf.id_processo_trf, ptrf.in_segredo_justica, ptrf.id_classe_judicial, ptrf.id_orgao_julgador, ptrf.id_orgao_julgador_colegiado, ptarefa.id_processo_trf, ptarefa.id_tarefa, pat.id_tarefa, pat.id_pnl_agrupamento
  • Hash Cond: (ptarefa.id_tarefa = pat.id_tarefa)
  • Buffers: shared hit=59658
  • Worker 0: actual time=0.450..16.986 rows=2516 loops=1
  • Buffers: shared hit=9241
  • Worker 1: actual time=0.488..86.133 rows=13285 loops=1
  • Buffers: shared hit=50097
15. 21.057 33.909 ↑ 1.1 5,067 3

Nested Loop (cost=195.30..16,375.67 rows=5,550 width=26) (actual time=1.707..33.909 rows=5,067 loops=3)

  • Output: ptrf.id_processo_trf, ptrf.in_segredo_justica, ptrf.id_classe_judicial, ptrf.id_orgao_julgador, ptrf.id_orgao_julgador_colegiado, ptarefa.id_processo_trf, ptarefa.id_tarefa
  • Buffers: shared hit=59549
  • Worker 0: actual time=0.087..15.786 rows=2484 loops=1
  • Buffers: shared hit=9190
  • Worker 1: actual time=0.132..80.600 rows=12649 loops=1
  • Buffers: shared hit=50046
16. 9.481 12.849 ↑ 1.2 5,102 3

Parallel Bitmap Heap Scan on pje.tb_processo_trf ptrf (cost=194.88..10,444.88 rows=6,046 width=18) (actual time=1.652..12.849 rows=5,102 loops=3)

  • Output: ptrf.id_processo_trf, ptrf.nr_sequencia, ptrf.nr_digito_verificador, ptrf.nr_ano, ptrf.nr_identificacao_orgao_justica, ptrf.id_jurisdicao, ptrf.in_inicial, ptrf.cd_processo_status, ptrf.vl_causa, ptrf.dt_autuacao, ptrf.nr_origem_processo, ptrf.in_segredo_justica, ptrf.ds_observacao_segredo, ptrf.in_justica_gratuita, ptrf.id_classe_judicial, ptrf.id_orgao_julgador, ptrf.dt_transitado_julgado, ptrf.id_localizacao_inicial, ptrf.id_estrutura_inicial, ptrf.in_apreciado_segredo, ptrf.dt_distribuicao, ptrf.in_apreciado_sigilo, ptrf.in_selecionado_pauta, ptrf.in_revisado, ptrf.id_orgao_julgador_revisor, ptrf.id_pessoa_marcou_revisado, ptrf.id_pessoa_marcou_pauta, ptrf.id_cargo, ptrf.in_outra_instancia, ptrf.id_endereco_wsdl, ptrf.id_orgao_julgador_colegiado, ptrf.id_proc_referencia, ptrf.ds_proc_referencia, ptrf.in_selecionado_julgamento, ptrf.id_pessoa_marcou_julgamento, ptrf.id_cl_judicial_outra_instancia, ptrf.nr_instancia, ptrf.id_pessoa_relator_processo, ptrf.in_apreciado_justica_gratuita, ptrf.id_pes_apreciou_jus_gratuita, ptrf.dt_sugestao_sessao, ptrf.in_pronto_revisao, ptrf.in_tutela_liminar, ptrf.in_apreciado_tutela_liminar, ptrf.id_sessao_sugerida, ptrf.id_municipio_fato_principal, ptrf.vl_peso_processual, ptrf.vl_peso_distribuicao, ptrf.id_orgao_julgador_cargo, ptrf.in_violacao_faixa_valores, ptrf.in_incidente, ptrf.in_mandado_devolvido, ptrf.in_deve_marcar_audiencia, ptrf.in_revisao, ptrf.acao_revisor
  • Recheck Cond: ((ptrf.id_orgao_julgador)::integer = 14)
  • Heap Blocks: exact=41
  • Buffers: shared hit=8156
  • Worker 0: actual time=0.037..5.708 rows=2513 loops=1
  • Buffers: shared hit=1304
  • Worker 1: actual time=0.043..27.825 rows=12724 loops=1
  • Buffers: shared hit=6765
17. 3.368 3.368 ↓ 1.1 15,381 1

Bitmap Index Scan on tb_processo_trf_in09 (cost=0.00..191.25 rows=14,510 width=0) (actual time=3.368..3.368 rows=15,381 loops=1)

  • Index Cond: ((ptrf.id_orgao_julgador)::integer = 14)
  • Buffers: shared hit=46
18. 0.003 0.003 ↑ 1.0 1 15,307

Index Only Scan using tb_processo_tarefa_in05 on pje.tb_processo_tarefa ptarefa (cost=0.42..0.97 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=15,307)

  • Output: ptarefa.id_processo_trf, ptarefa.id_tarefa
  • Index Cond: (ptarefa.id_processo_trf = (ptrf.id_processo_trf)::integer)
  • Heap Fetches: 15
  • Buffers: shared hit=51393
  • Worker 0: actual time=0.003..0.003 rows=1 loops=2513
  • Buffers: shared hit=7886
  • Worker 1: actual time=0.003..0.003 rows=1 loops=12724
  • Buffers: shared hit=43281
19. 0.086 0.214 ↑ 1.0 518 3

Hash (cost=12.18..12.18 rows=518 width=8) (actual time=0.214..0.214 rows=518 loops=3)

  • Output: pat.id_tarefa, pat.id_pnl_agrupamento
  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
  • Buffers: shared hit=21
  • Worker 0: actual time=0.234..0.234 rows=518 loops=1
  • Buffers: shared hit=7
  • Worker 1: actual time=0.231..0.231 rows=518 loops=1
  • Buffers: shared hit=7
20. 0.128 0.128 ↑ 1.0 518 3

Seq Scan on pje.tb_pnl_agrupamento_tarefa pat (cost=0.00..12.18 rows=518 width=8) (actual time=0.022..0.128 rows=518 loops=3)

  • Output: pat.id_tarefa, pat.id_pnl_agrupamento
  • Buffers: shared hit=21
  • Worker 0: actual time=0.025..0.144 rows=518 loops=1
  • Buffers: shared hit=7
  • Worker 1: actual time=0.030..0.141 rows=518 loops=1
  • Buffers: shared hit=7
21. 0.005 0.013 ↓ 1.0 22 1

Hash (cost=1.34..1.34 rows=21 width=4) (actual time=0.013..0.013 rows=22 loops=1)

  • Output: pa.id_pnl_agrupamento
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
22. 0.008 0.008 ↓ 1.0 22 1

Seq Scan on pje.tb_pnl_agrupamento pa (cost=0.00..1.34 rows=21 width=4) (actual time=0.004..0.008 rows=22 loops=1)

  • Output: pa.id_pnl_agrupamento
  • Filter: (((pa.nm_pnl_agrupamento)::text <> 'Baixados/Arquivados'::text) AND ((pa.nm_pnl_agrupamento)::text <> 'Arquivados'::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1
23. 0.000 66.001 ↓ 0.0 0 5,077

Index Scan using tb_int_processo_usuario_in09 on pje.tb_int_processo_usuario ipu (cost=0.29..27.04 rows=1 width=16) (actual time=0.013..0.013 rows=0 loops=5,077)

  • Output: ipu.id_int_processo_usuario, ipu.id_processo_trf, ipu.dh_inclusao, ipu.id_usuario_inclusao, ipu.id_orgao_julgador, ipu.id_orgao_julgador_colegiado, ipu.id_tarefa, ipu.id_usuario, ipu.in_inclusao_automatica, ipu.in_ultima_informacao, ipu.id_usuario_atribuicao_temporaria
  • Index Cond: (ipu.id_processo_trf = ptarefa.id_processo_trf)
  • Filter: ((alternatives: SubPlan 5 or hashed SubPlan 6) OR ((ipu.id_orgao_julgador IS NULL) AND (alternatives: SubPlan 7 or hashed SubPlan 8)))
  • Buffers: shared hit=74800
24.          

SubPlan (forIndex Scan)

25. 4.766 90.554 ↑ 1.0 1 4,766

Nested Loop (cost=1.14..13.31 rows=1 width=0) (actual time=0.019..0.019 rows=1 loops=4,766)

  • Inner Unique: true
  • Buffers: shared hit=124498
26. 0.026 76.256 ↑ 1.0 1 4,766

Nested Loop (cost=0.85..9.00 rows=1 width=4) (actual time=0.016..0.016 rows=1 loops=4,766)

  • Output: uloc.id_localizacao
  • Inner Unique: true
  • Join Filter: ((uloc.id_usuario_localizacao)::integer = (ulms.id_usu_local_mgstrado_servidor)::integer)
  • Buffers: shared hit=110200
27. 20.990 61.958 ↑ 1.0 1 4,766

Nested Loop (cost=0.57..8.62 rows=1 width=12) (actual time=0.005..0.013 rows=1 loops=4,766)

  • Output: uloc.id_usuario_localizacao, uloc.id_localizacao, ulv.id_usu_local_mgstrado_servidor
  • Buffers: shared hit=88792
28. 19.064 19.064 ↓ 5.0 5 4,766

Index Scan using tb_usuario_localizacao_in02 on pje.tb_usuario_localizacao uloc (cost=0.29..4.31 rows=1 width=8) (actual time=0.002..0.004 rows=5 loops=4,766)

  • Output: uloc.id_usuario_localizacao, uloc.id_usuario, uloc.in_responsavel_localizacao, uloc.id_localizacao, uloc.id_papel, uloc.id_estrutura
  • Index Cond: ((uloc.id_usuario)::integer = ipu.id_usuario)
  • Buffers: shared hit=29146
29. 21.904 21.904 ↓ 0.0 0 21,904

Index Scan using tb_usu_local_visibilidade_in01 on pje.tb_usu_local_visibilidade ulv (cost=0.28..4.31 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=21,904)

  • Output: ulv.id_usu_localzacao_visibilidade, ulv.id_usu_local_mgstrado_servidor, ulv.id_org_julg_cargo_visibilidade, ulv.dt_inicio, ulv.dt_final, ulv.id_ojc_cargo
  • Index Cond: ((ulv.id_usu_local_mgstrado_servidor)::integer = (uloc.id_usuario_localizacao)::integer)
  • Filter: (((ulv.dt_inicio)::timestamp without time zone <= CURRENT_DATE) AND ((ulv.dt_final IS NULL) OR ((ulv.dt_final)::timestamp without time zone >= CURRENT_DATE)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=59646
30. 14.272 14.272 ↑ 1.0 1 7,136

Index Scan using tb_usu_local_mgtdo_servdor_pk on pje.tb_usu_local_mgtdo_servdor ulms (cost=0.28..0.36 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=7,136)

  • Output: ulms.id_usu_local_mgstrado_servidor, ulms.dt_inicio, ulms.dt_final, ulms.ds_norma, ulms.id_orgao_julgador_cargo, ulms.id_orgao_julgador_colegiado, ulms.id_orgao_julgador, ulms.id_pessoa_magistrado, ulms.id_ojc_cargo, ulms.in_magistrado_titular
  • Index Cond: ((ulms.id_usu_local_mgstrado_servidor)::integer = (ulv.id_usu_local_mgstrado_servidor)::integer)
  • Filter: (((ulms.id_orgao_julgador)::integer = ipu.id_orgao_julgador) AND ((ulms.dt_inicio)::timestamp without time zone <= CURRENT_DATE) AND ((ulms.dt_final IS NULL) OR ((ulms.dt_final)::timestamp without time zone >= CURRENT_DATE)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=21408
31. 9.532 9.532 ↑ 1.0 1 4,766

Index Scan using tb_localizacao_pk on pje.tb_localizacao loc (cost=0.29..4.31 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=4,766)

  • Output: loc.id_localizacao, loc.ds_localizacao, loc.in_ativo, loc.id_endereco, loc.id_localizacao_pai, loc.id_estrutura, loc.in_estrutura
  • Index Cond: ((loc.id_localizacao)::integer = (uloc.id_localizacao)::integer)
  • Filter: ((loc.in_ativo)::bpchar = 'S'::bpchar)
  • Buffers: shared hit=14298
32. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=283.46..2,594.75 rows=1,650 width=8) (never executed)

  • Output: uloc_1.id_usuario, ulms_1.id_orgao_julgador
  • Inner Unique: true
33. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=283.17..2,019.61 rows=1,651 width=12) (never executed)

  • Output: uloc_1.id_usuario, uloc_1.id_localizacao, ulms_1.id_orgao_julgador
  • Hash Cond: ((ulms_1.id_usu_local_mgstrado_servidor)::integer = (ulv_1.id_usu_local_mgstrado_servidor)::integer)
34. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=158.69..1,861.57 rows=2,727 width=20) (never executed)

  • Output: uloc_1.id_usuario, uloc_1.id_usuario_localizacao, uloc_1.id_localizacao, ulms_1.id_orgao_julgador, ulms_1.id_usu_local_mgstrado_servidor
  • Inner Unique: true
  • Hash Cond: ((uloc_1.id_usuario_localizacao)::integer = (ulms_1.id_usu_local_mgstrado_servidor)::integer)
35. 0.000 0.000 ↓ 0.0 0

Seq Scan on pje.tb_usuario_localizacao uloc_1 (cost=0.00..1,561.10 rows=54,010 width=12) (never executed)

  • Output: uloc_1.id_usuario_localizacao, uloc_1.id_usuario, uloc_1.in_responsavel_localizacao, uloc_1.id_localizacao, uloc_1.id_papel, uloc_1.id_estrutura
36. 0.000 0.000 ↓ 0.0 0

Hash (cost=124.60..124.60 rows=2,727 width=8) (never executed)

  • Output: ulms_1.id_orgao_julgador, ulms_1.id_usu_local_mgstrado_servidor
37. 0.000 0.000 ↓ 0.0 0

Seq Scan on pje.tb_usu_local_mgtdo_servdor ulms_1 (cost=0.00..124.60 rows=2,727 width=8) (never executed)

  • Output: ulms_1.id_orgao_julgador, ulms_1.id_usu_local_mgstrado_servidor
  • Filter: (((ulms_1.dt_inicio)::timestamp without time zone <= CURRENT_DATE) AND ((ulms_1.dt_final IS NULL) OR ((ulms_1.dt_final)::timestamp without time zone >= CURRENT_DATE)))
38. 0.000 0.000 ↓ 0.0 0

Hash (cost=94.74..94.74 rows=2,379 width=4) (never executed)

  • Output: ulv_1.id_usu_local_mgstrado_servidor
39. 0.000 0.000 ↓ 0.0 0

Seq Scan on pje.tb_usu_local_visibilidade ulv_1 (cost=0.00..94.74 rows=2,379 width=4) (never executed)

  • Output: ulv_1.id_usu_local_mgstrado_servidor
  • Filter: (((ulv_1.dt_inicio)::timestamp without time zone <= CURRENT_DATE) AND ((ulv_1.dt_final IS NULL) OR ((ulv_1.dt_final)::timestamp without time zone >= CURRENT_DATE)))
40. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_localizacao_pk on pje.tb_localizacao loc_1 (cost=0.29..0.35 rows=1 width=4) (never executed)

  • Output: loc_1.id_localizacao, loc_1.ds_localizacao, loc_1.in_ativo, loc_1.id_endereco, loc_1.id_localizacao_pai, loc_1.id_estrutura, loc_1.in_estrutura
  • Index Cond: ((loc_1.id_localizacao)::integer = (uloc_1.id_localizacao)::integer)
  • Filter: ((loc_1.in_ativo)::bpchar = 'S'::bpchar)
41. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.14..13.31 rows=1 width=0) (never executed)

  • Inner Unique: true
42. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..9.00 rows=1 width=4) (never executed)

  • Output: uloc_2.id_localizacao
  • Inner Unique: true
  • Join Filter: ((uloc_2.id_usuario_localizacao)::integer = (ulms_2.id_usu_local_mgstrado_servidor)::integer)
43. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.57..8.62 rows=1 width=12) (never executed)

  • Output: uloc_2.id_usuario_localizacao, uloc_2.id_localizacao, ulv_2.id_usu_local_mgstrado_servidor
44. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_usuario_localizacao_in02 on pje.tb_usuario_localizacao uloc_2 (cost=0.29..4.31 rows=1 width=8) (never executed)

  • Output: uloc_2.id_usuario_localizacao, uloc_2.id_usuario, uloc_2.in_responsavel_localizacao, uloc_2.id_localizacao, uloc_2.id_papel, uloc_2.id_estrutura
  • Index Cond: ((uloc_2.id_usuario)::integer = ipu.id_usuario)
45. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_usu_local_visibilidade_in01 on pje.tb_usu_local_visibilidade ulv_2 (cost=0.28..4.31 rows=1 width=4) (never executed)

  • Output: ulv_2.id_usu_localzacao_visibilidade, ulv_2.id_usu_local_mgstrado_servidor, ulv_2.id_org_julg_cargo_visibilidade, ulv_2.dt_inicio, ulv_2.dt_final, ulv_2.id_ojc_cargo
  • Index Cond: ((ulv_2.id_usu_local_mgstrado_servidor)::integer = (uloc_2.id_usuario_localizacao)::integer)
  • Filter: (((ulv_2.dt_inicio)::timestamp without time zone <= CURRENT_DATE) AND ((ulv_2.dt_final IS NULL) OR ((ulv_2.dt_final)::timestamp without time zone >= CURRENT_DATE)))
46. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_usu_local_mgtdo_servdor_pk on pje.tb_usu_local_mgtdo_servdor ulms_2 (cost=0.28..0.36 rows=1 width=4) (never executed)

  • Output: ulms_2.id_usu_local_mgstrado_servidor, ulms_2.dt_inicio, ulms_2.dt_final, ulms_2.ds_norma, ulms_2.id_orgao_julgador_cargo, ulms_2.id_orgao_julgador_colegiado, ulms_2.id_orgao_julgador, ulms_2.id_pessoa_magistrado, ulms_2.id_ojc_cargo, ulms_2.in_magistrado_titular
  • Index Cond: ((ulms_2.id_usu_local_mgstrado_servidor)::integer = (ulv_2.id_usu_local_mgstrado_servidor)::integer)
  • Filter: ((ulms_2.id_orgao_julgador IS NULL) AND ((ulms_2.id_orgao_julgador_colegiado)::integer = ipu.id_orgao_julgador_colegiado) AND ((ulms_2.dt_inicio)::timestamp without time zone <= CURRENT_DATE) AND ((ulms_2.dt_final IS NULL) OR ((ulms_2.dt_final)::timestamp without time zone >= CURRENT_DATE)))
47. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_localizacao_pk on pje.tb_localizacao loc_2 (cost=0.29..4.31 rows=1 width=4) (never executed)

  • Output: loc_2.id_localizacao, loc_2.ds_localizacao, loc_2.in_ativo, loc_2.id_endereco, loc_2.id_localizacao_pai, loc_2.id_estrutura, loc_2.in_estrutura
  • Index Cond: ((loc_2.id_localizacao)::integer = (uloc_2.id_localizacao)::integer)
  • Filter: ((loc_2.in_ativo)::bpchar = 'S'::bpchar)
48. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=54.09..255.38 rows=61 width=8) (never executed)

  • Output: uloc_3.id_usuario, ulms_3.id_orgao_julgador_colegiado
  • Inner Unique: true
49. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=53.80..234.13 rows=61 width=12) (never executed)

  • Output: uloc_3.id_usuario, uloc_3.id_localizacao, ulms_3.id_orgao_julgador_colegiado
  • Inner Unique: true
  • Join Filter: ((ulms_3.id_usu_local_mgstrado_servidor)::integer = (uloc_3.id_usuario_localizacao)::integer)
50. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=53.52..154.51 rows=61 width=12) (never executed)

  • Output: ulms_3.id_orgao_julgador_colegiado, ulms_3.id_usu_local_mgstrado_servidor, ulv_3.id_usu_local_mgstrado_servidor
  • Inner Unique: true
  • Hash Cond: ((ulv_3.id_usu_local_mgstrado_servidor)::integer = (ulms_3.id_usu_local_mgstrado_servidor)::integer)
51. 0.000 0.000 ↓ 0.0 0

Seq Scan on pje.tb_usu_local_visibilidade ulv_3 (cost=0.00..94.74 rows=2,379 width=4) (never executed)

  • Output: ulv_3.id_usu_localzacao_visibilidade, ulv_3.id_usu_local_mgstrado_servidor, ulv_3.id_org_julg_cargo_visibilidade, ulv_3.dt_inicio, ulv_3.dt_final, ulv_3.id_ojc_cargo
  • Filter: (((ulv_3.dt_inicio)::timestamp without time zone <= CURRENT_DATE) AND ((ulv_3.dt_final IS NULL) OR ((ulv_3.dt_final)::timestamp without time zone >= CURRENT_DATE)))
52. 0.000 0.000 ↓ 0.0 0

Hash (cost=52.27..52.27 rows=100 width=8) (never executed)

  • Output: ulms_3.id_orgao_julgador_colegiado, ulms_3.id_usu_local_mgstrado_servidor
53. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on pje.tb_usu_local_mgtdo_servdor ulms_3 (cost=3.38..52.27 rows=100 width=8) (never executed)

  • Output: ulms_3.id_orgao_julgador_colegiado, ulms_3.id_usu_local_mgstrado_servidor
  • Recheck Cond: (ulms_3.id_orgao_julgador IS NULL)
  • Filter: (((ulms_3.dt_inicio)::timestamp without time zone <= CURRENT_DATE) AND ((ulms_3.dt_final IS NULL) OR ((ulms_3.dt_final)::timestamp without time zone >= CURRENT_DATE)))
54. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on tb_usu_local_mgtdo_srvdor_in05 (cost=0.00..3.36 rows=144 width=0) (never executed)

  • Index Cond: (ulms_3.id_orgao_julgador IS NULL)
55. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_usuario_localizacao_pk on pje.tb_usuario_localizacao uloc_3 (cost=0.29..1.29 rows=1 width=12) (never executed)

  • Output: uloc_3.id_usuario_localizacao, uloc_3.id_usuario, uloc_3.in_responsavel_localizacao, uloc_3.id_localizacao, uloc_3.id_papel, uloc_3.id_estrutura
  • Index Cond: ((uloc_3.id_usuario_localizacao)::integer = (ulv_3.id_usu_local_mgstrado_servidor)::integer)
56. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_localizacao_pk on pje.tb_localizacao loc_3 (cost=0.29..0.35 rows=1 width=4) (never executed)

  • Output: loc_3.id_localizacao, loc_3.ds_localizacao, loc_3.in_ativo, loc_3.id_endereco, loc_3.id_localizacao_pai, loc_3.id_estrutura, loc_3.in_estrutura
  • Index Cond: ((loc_3.id_localizacao)::integer = (uloc_3.id_localizacao)::integer)
  • Filter: ((loc_3.in_ativo)::bpchar = 'S'::bpchar)
57. 0.105 0.197 ↑ 1.0 480 1

Hash (cost=9.80..9.80 rows=480 width=36) (actual time=0.197..0.197 rows=480 loops=1)

  • Output: tarefa.id_tarefa, tarefa.ds_tarefa, tarefa.in_visivel_oj, tarefa.in_visivel_ojc
  • Buckets: 1024 Batches: 1 Memory Usage: 41kB
  • Buffers: shared hit=5
58. 0.092 0.092 ↑ 1.0 480 1

Seq Scan on pje.tb_tarefa tarefa (cost=0.00..9.80 rows=480 width=36) (actual time=0.007..0.092 rows=480 loops=1)

  • Output: tarefa.id_tarefa, tarefa.ds_tarefa, tarefa.in_visivel_oj, tarefa.in_visivel_ojc
  • Buffers: shared hit=5
59. 7.149 7.149 ↑ 1.0 1 2,383

Index Scan using tb_usuario_login_pk on pje.tb_usuario_login tul (cost=0.42..1.73 rows=1 width=34) (actual time=0.003..0.003 rows=1 loops=2,383)

  • Output: tul.id_usuario, tul.ds_nome
  • Index Cond: (tul.id_usuario = ipu.id_usuario)
  • Buffers: shared hit=9532
60. 11.915 11.915 ↑ 1.0 1 2,383

Index Scan using tb_processo_pk on pje.tb_processo p (cost=0.42..0.47 rows=1 width=29) (actual time=0.005..0.005 rows=1 loops=2,383)

  • Output: p.nr_processo, p.id_processo
  • Index Cond: ((p.id_processo)::integer = ptarefa.id_processo_trf)
  • Buffers: shared hit=9534
61. 4.766 4.766 ↑ 1.0 1 2,383

Index Scan using tb_classe_judicial_pk on pje.tb_classe_judicial cj (cost=0.28..0.33 rows=1 width=10) (actual time=0.002..0.002 rows=1 loops=2,383)

  • Output: cj.ds_classe_judicial_sigla, cj.id_classe_judicial
  • Index Cond: ((cj.id_classe_judicial)::integer = (ptrf.id_classe_judicial)::integer)
  • Buffers: shared hit=7149
62. 0.000 0.000 ↓ 0.0 0 2,383

Materialize (cost=0.00..12.40 rows=160 width=50) (actual time=0.000..0.000 rows=0 loops=2,383)

  • Output: ojc.ds_orgao_julgador_colegiado, ojc.ds_sigla, ojc.id_orgao_julgador_colegiado
63. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on pje.tb_orgao_julgador_colgiado ojc (cost=0.00..11.60 rows=160 width=50) (actual time=0.004..0.004 rows=0 loops=1)

  • Output: ojc.ds_orgao_julgador_colegiado, ojc.ds_sigla, ojc.id_orgao_julgador_colegiado
64.          

SubPlan (forNested Loop Left Join)

65. 2.383 26.213 ↑ 1.0 1 2,383

Limit (cost=0.85..10.09 rows=1 width=30) (actual time=0.010..0.011 rows=1 loops=2,383)

  • Output: u.ds_nome
  • Buffers: shared hit=19128
66. 4.766 23.830 ↑ 1.0 1 2,383

Nested Loop (cost=0.85..10.09 rows=1 width=30) (actual time=0.010..0.010 rows=1 loops=2,383)

  • Output: u.ds_nome
  • Inner Unique: true
  • Buffers: shared hit=19128
67. 9.532 9.532 ↑ 1.0 1 2,383

Index Scan using tb_processo_parte_in06 on pje.tb_processo_parte pp (cost=0.42..5.65 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=2,383)

  • Output: pp.id_processo_parte, pp.id_processo_trf, pp.id_pessoa, pp.id_tipo_parte, pp.in_participacao, pp.in_segredo, pp.id_pessoa_doc_identificacao, pp.in_parte_principal, pp.in_endereco_desconhecido, pp.in_situacao, pp.nr_ordem
  • Index Cond: ((pp.id_processo_trf)::integer = (ptrf.id_processo_trf)::integer)
  • Filter: (pp.nr_ordem = 1)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=9594
68. 9.532 9.532 ↑ 1.0 1 2,383

Index Scan using tb_usuario_login_pk on pje.tb_usuario_login u (cost=0.42..4.44 rows=1 width=34) (actual time=0.004..0.004 rows=1 loops=2,383)

  • Output: u.ds_nome, u.id_usuario
  • Index Cond: (u.id_usuario = (pp.id_pessoa)::integer)
  • Buffers: shared hit=9534
69. 2.383 23.830 ↑ 1.0 1 2,383

Limit (cost=0.85..10.09 rows=1 width=30) (actual time=0.009..0.010 rows=1 loops=2,383)

  • Output: u_1.ds_nome
  • Buffers: shared hit=19420
70. 2.383 21.447 ↑ 1.0 1 2,383

Nested Loop (cost=0.85..10.09 rows=1 width=30) (actual time=0.009..0.009 rows=1 loops=2,383)

  • Output: u_1.ds_nome
  • Inner Unique: true
  • Buffers: shared hit=19420
71. 9.532 9.532 ↑ 1.0 1 2,383

Index Scan using tb_processo_parte_in05 on pje.tb_processo_parte pp_1 (cost=0.42..5.65 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=2,383)

  • Output: pp_1.id_processo_parte, pp_1.id_processo_trf, pp_1.id_pessoa, pp_1.id_tipo_parte, pp_1.in_participacao, pp_1.in_segredo, pp_1.id_pessoa_doc_identificacao, pp_1.in_parte_principal, pp_1.in_endereco_desconhecido, pp_1.in_situacao, pp_1.nr_ordem
  • Index Cond: ((pp_1.id_processo_trf)::integer = (ptrf.id_processo_trf)::integer)
  • Filter: (pp_1.nr_ordem = 1)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=9880
72. 9.532 9.532 ↑ 1.0 1 2,383

Index Scan using tb_usuario_login_pk on pje.tb_usuario_login u_1 (cost=0.42..4.44 rows=1 width=34) (actual time=0.004..0.004 rows=1 loops=2,383)

  • Output: u_1.ds_nome, u_1.id_usuario
  • Index Cond: (u_1.id_usuario = (pp_1.id_pessoa)::integer)
  • Buffers: shared hit=9540
73. 2.383 28.596 ↑ 1.0 1 2,383

Aggregate (cost=6.95..6.96 rows=1 width=4) (actual time=0.012..0.012 rows=1 loops=2,383)

  • Output: min(at.dt_atividade)
  • Buffers: shared hit=5603
74. 6.739 26.213 ↓ 0.0 0 2,383

Nested Loop (cost=4.47..6.95 rows=1 width=4) (actual time=0.010..0.011 rows=0 loops=2,383)

  • Output: at.dt_atividade
  • Inner Unique: true
  • Buffers: shared hit=5603
75. 9.865 19.064 ↓ 0.0 0 2,383

Hash Join (cost=4.33..6.72 rows=1 width=8) (actual time=0.007..0.008 rows=0 loops=2,383)

  • Output: at.dt_atividade, tai.id_gig_tipo_atividade
  • Hash Cond: (tai.id_gig_tipo_atividade_instancia = at.id_gig_tipo_atividade_instancia)
  • Buffers: shared hit=5193
76. 2.050 2.050 ↑ 1.0 101 205

Seq Scan on pje_gig.tb_gig_tipo_atividade_instancia tai (cost=0.00..2.01 rows=101 width=8) (actual time=0.002..0.010 rows=101 loops=205)

  • Output: tai.id_gig_tipo_atividade_instancia, tai.id_gig_tipo_atividade, tai.id_instancia, tai.in_atvio
  • Buffers: shared hit=205
77. 0.000 7.149 ↓ 0.0 0 2,383

Hash (cost=4.31..4.31 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=2,383)

  • Output: at.dt_atividade, at.id_gig_tipo_atividade_instancia
  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=4988
78. 7.149 7.149 ↓ 0.0 0 2,383

Index Scan using tb_gig_processo_atividade_in09 on pje_gig.tb_gig_processo_atividade at (cost=0.29..4.31 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=2,383)

  • Output: at.dt_atividade, at.id_gig_tipo_atividade_instancia
  • Index Cond: (at.id_processo_trf = (ptrf.id_processo_trf)::integer)
  • Filter: (((at.id_orgao_julgador_colegiado IS NULL) OR (at.id_orgao_julgador_colegiado = (ptrf.id_orgao_julgador_colegiado)::integer)) AND (at.id_orgao_julgador = (ptrf.id_orgao_julgador)::integer))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4988
79. 0.410 0.410 ↑ 1.0 1 205

Index Scan using tb_gig_tipo_atividade_pk on pje_gig.tb_gig_tipo_atividade ta (cost=0.14..0.22 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=205)

  • Output: ta.id_gig_tipo_atividade, ta.nm_tipo_atividade, ta.cd_classificacao_atividade, ta.in_ativo
  • Index Cond: (ta.id_gig_tipo_atividade = tai.id_gig_tipo_atividade)
  • Filter: (ta.cd_classificacao_atividade <> 2)
  • Buffers: shared hit=410
80. 0.000 11.915 ↑ 1.0 1 2,383

Aggregate (cost=6.95..6.96 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=2,383)

  • Output: min(at_1.dt_atividade)
  • Buffers: shared hit=4989
81. 2.383 11.915 ↓ 0.0 0 2,383

Nested Loop (cost=4.47..6.95 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=2,383)

  • Output: at_1.dt_atividade
  • Inner Unique: true
  • Buffers: shared hit=4989
82. 4.763 9.532 ↓ 0.0 0 2,383

Hash Join (cost=4.32..6.72 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=2,383)

  • Output: at_1.dt_atividade, tai_1.id_gig_tipo_atividade
  • Hash Cond: (tai_1.id_gig_tipo_atividade_instancia = at_1.id_gig_tipo_atividade_instancia)
  • Buffers: shared hit=4989
83. 0.003 0.003 ↑ 101.0 1 1

Seq Scan on pje_gig.tb_gig_tipo_atividade_instancia tai_1 (cost=0.00..2.01 rows=101 width=8) (actual time=0.003..0.003 rows=1 loops=1)

  • Output: tai_1.id_gig_tipo_atividade_instancia, tai_1.id_gig_tipo_atividade, tai_1.id_instancia, tai_1.in_atvio
  • Buffers: shared hit=1
84. 0.000 4.766 ↓ 0.0 0 2,383

Hash (cost=4.31..4.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=2,383)

  • Output: at_1.dt_atividade, at_1.id_gig_tipo_atividade_instancia
  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=4988
85. 4.766 4.766 ↓ 0.0 0 2,383

Index Scan using tb_gig_processo_atividade_in09 on pje_gig.tb_gig_processo_atividade at_1 (cost=0.29..4.31 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=2,383)

  • Output: at_1.dt_atividade, at_1.id_gig_tipo_atividade_instancia
  • Index Cond: (at_1.id_processo_trf = (ptrf.id_processo_trf)::integer)
  • Filter: ((at_1.id_orgao_julgador IS NULL) AND (at_1.id_orgao_julgador_colegiado = (ptrf.id_orgao_julgador_colegiado)::integer))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4988
86. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_gig_tipo_atividade_pk on pje_gig.tb_gig_tipo_atividade ta_1 (cost=0.14..0.22 rows=1 width=4) (never executed)

  • Output: ta_1.id_gig_tipo_atividade, ta_1.nm_tipo_atividade, ta_1.cd_classificacao_atividade, ta_1.in_ativo
  • Index Cond: (ta_1.id_gig_tipo_atividade = tai_1.id_gig_tipo_atividade)
  • Filter: (ta_1.cd_classificacao_atividade <> 2)
Planning time : 25.686 ms
Execution time : 282.772 ms