explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lonM

Settings
# exclusive inclusive rows x rows loops node
1. 0.064 146.429 ↓ 52.5 420 1

Subquery Scan on sga_view_svg_unidades_agenda_mes_calendario (cost=1,203.98..1,204.44 rows=8 width=60) (actual time=145.632..146.429 rows=420 loops=1)

  • Output: sga_view_svg_unidades_agenda_mes_calendario.cod_servico_dgp, sga_view_svg_unidades_agenda_mes_calendario.und_codigo, sga_view_svg_unidades_agenda_mes_calendario.und_descricao, sga_view_svg_unidades_agenda_mes_calendario.svg_data, sga_view_svg_uni (...)
  • Buffers: shared hit=34835
2. 0.661 146.365 ↓ 52.5 420 1

GroupAggregate (cost=1,203.98..1,204.36 rows=8 width=70) (actual time=145.630..146.365 rows=420 loops=1)

  • Output: svd.svd_id_svp, ((und_1.und_seq_und)::integer), (CASE WHEN ((svt.svt_id_tipo = 6) AND (und_1.und_seq_tip_und = 7)) THEN 'CIOB'::character varying ELSE und_1.und_abrev END), ((((((((svd.svd_ano)::character varying)::text || '-'::text) || ((s (...)
  • Group Key: ((((((((svd.svd_ano)::character varying)::text || '-'::text) || ((svd.svd_mes)::character varying)::text) || '-'::text) || lpad(((sud.sud_dia)::character varying)::text, 2, '0'::text)))::date), und.und_index, und.und_abrev, svd.svd_id_sv (...)
  • Buffers: shared hit=34835
3. 1.832 145.704 ↓ 105.0 840 1

Sort (cost=1,203.98..1,204.00 rows=8 width=70) (actual time=145.613..145.704 rows=840 loops=1)

  • Output: svd.svd_id_svp, ((und_1.und_seq_und)::integer), (CASE WHEN ((svt.svt_id_tipo = 6) AND (und_1.und_seq_tip_und = 7)) THEN 'CIOB'::character varying ELSE und_1.und_abrev END), ((((((((svd.svd_ano)::character varying)::text || '-'::text) (...)
  • Sort Key: ((((((((svd.svd_ano)::character varying)::text || '-'::text) || ((svd.svd_mes)::character varying)::text) || '-'::text) || lpad(((sud.sud_dia)::character varying)::text, 2, '0'::text)))::date), und.und_index, und.und_abrev, svd.svd_ (...)
  • Sort Method: quicksort Memory: 90kB
  • Buffers: shared hit=34835
4. 0.966 143.872 ↓ 105.0 840 1

Nested Loop (cost=858.25..1,203.86 rows=8 width=70) (actual time=71.159..143.872 rows=840 loops=1)

  • Output: svd.svd_id_svp, ((und_1.und_seq_und)::integer), (CASE WHEN ((svt.svt_id_tipo = 6) AND (und_1.und_seq_tip_und = 7)) THEN 'CIOB'::character varying ELSE und_1.und_abrev END), ((((((((svd.svd_ano)::character varying)::text || '-':: (...)
  • Buffers: shared hit=34835
5. 10.859 139.546 ↓ 105.0 840 1

HashAggregate (cost=858.11..1,194.70 rows=8 width=54) (actual time=71.150..139.546 rows=840 loops=1)

  • Output: svd.svd_id_svp, (und_1.und_seq_und)::integer, CASE WHEN ((svt.svt_id_tipo = 6) AND (und_1.und_seq_tip_und = 7)) THEN 'CIOB'::character varying ELSE und_1.und_abrev END, (((((((svd.svd_ano)::character varying)::text || '-': (...)
  • Group Key: svd.svd_id_svp, und_1.und_seq_und, svd.svd_ano, svd.svd_mes, sud.sud_dia, udt.udt_qtd_vagas, udt.id_udt, fnp.id_funcionario, svt.svt_id_tipo
  • Filter: ((SubPlan 15) > 0)
  • Buffers: shared hit=33155
6. 0.378 69.887 ↓ 105.0 840 1

Nested Loop (cost=45.68..857.93 rows=8 width=54) (actual time=0.913..69.887 rows=840 loops=1)

  • Output: svd.svd_id_svp, svd.svd_ano, svd.svd_mes, sud.sud_dia, udt.udt_qtd_vagas, udt.id_udt, und_1.und_seq_und, und_1.und_seq_tip_und, und_1.und_abrev, fnp.id_funcionario, fnp.fnc_id_cargo, svt.svt_id_tipo
  • Join Filter: (svu.svu_id_tipo = svt.id_svt)
  • Buffers: shared hit=5921
7. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on public.t_adm_controle_sv_tipos svt (cost=0.00..1.01 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=1)

  • Output: svt.id_svt, svt.svt_id_svp, svt.svt_id_tipo, svt.svt_usr_ins, svt.svt_usr_upd, svt.svt_usr_dt_ins, svt.svt_usr_dt_upd, svt.reg_exclusao
  • Buffers: shared hit=1
8. 13.747 69.503 ↓ 105.0 840 1

Hash Join (cost=45.68..856.82 rows=8 width=54) (actual time=0.900..69.503 rows=840 loops=1)

  • Output: svd.svd_id_svp, svd.svd_ano, svd.svd_mes, svu.svu_id_tipo, sud.sud_dia, udt.udt_qtd_vagas, udt.id_udt, und_1.und_seq_und, und_1.und_seq_tip_und, und_1.und_abrev, fnp.id_funcionario, fnp.fnc_id_cargo
  • Hash Cond: (svp.svp_id_svh = svh.id_svh)
  • Join Filter: (((svc.reg_exclusao = 0) AND CASE WHEN (svu.svu_id_escala = 1) THEN (((to_char(now(), 'YYYY-mm-dd HH24:MI'::text))::timestamp without time zone >= (((((svu.svu_dt_publicacao)::character varying)::text || ' (...)
  • Buffers: shared hit=5920
9. 1.479 9.526 ↓ 76.4 840 1

Nested Loop (cost=43.60..142.78 rows=11 width=90) (actual time=0.756..9.526 rows=840 loops=1)

  • Output: svc.reg_exclusao, svp.svp_id_svh, svp.svp_und_dia_ate, svp.svp_und_ext_dia_de, svp.svp_und_ext_dia_ate, svd.svd_id_svp, svd.svd_ano, svd.svd_mes, svu.svu_id_tipo, svu.svu_id_escala, svu.svu_dt_publicacao, (...)
  • Buffers: shared hit=1719
10. 0.774 3.847 ↓ 76.4 840 1

Hash Join (cost=43.46..137.43 rows=11 width=76) (actual time=0.746..3.847 rows=840 loops=1)

  • Output: svc.reg_exclusao, svp.svp_id_svh, svp.svp_und_dia_ate, svp.svp_und_ext_dia_de, svp.svp_und_ext_dia_ate, svd.svd_id_svp, svd.svd_ano, svd.svd_mes, sdu.sdu_id_und, svu.svu_id_tipo, svu.svu_id_escala, (...)
  • Hash Cond: (cgo.id_cgo = fnp.fnc_id_cargo)
  • Buffers: shared hit=39
11. 1.006 3.049 ↑ 1.0 2,520 1

Hash Join (cost=38.57..122.82 rows=2,562 width=68) (actual time=0.715..3.049 rows=2,520 loops=1)

  • Output: svc.svc_id_cargo, svc.reg_exclusao, cgo.id_cgo, svp.svp_id_svh, svp.svp_und_dia_ate, svp.svp_und_ext_dia_de, svp.svp_und_ext_dia_ate, svd.svd_id_svp, svd.svd_ano, svd.svd_mes, sdu.sdu_id_und, (...)
  • Hash Cond: (sdu.sdu_id_svd = svd.id_svd)
  • Buffers: shared hit=34
12. 0.667 1.958 ↑ 1.0 840 1

Hash Join (cost=34.85..88.15 rows=854 width=32) (actual time=0.624..1.958 rows=840 loops=1)

  • Output: sdu.sdu_id_svd, sdu.sdu_id_und, svu.svu_id_tipo, svu.svu_id_escala, svu.svu_dt_publicacao, sud.sud_dia, udt.udt_qtd_vagas, udt.id_udt
  • Hash Cond: (udt.udt_id_sud = sud.id_sud)
  • Buffers: shared hit=27
13. 0.681 0.681 ↑ 1.0 1,708 1

Seq Scan on public.t_adm_sv_unidades_dias_turnos udt (cost=0.00..38.35 rows=1,708 width=12) (actual time=0.006..0.681 rows=1,708 loops=1)

  • Output: udt.id_udt, udt.udt_id_sud, udt.udt_id_turno, udt.udt_id_horario, udt.udt_qtd_vagas, udt.udt_usr_ins, udt.udt_usr_upd, udt.udt_usr_dt_ins, udt.udt_usr_dt_upd, udt.reg_exclusao
  • Filter: (udt.reg_exclusao = 0)
  • Buffers: shared hit=17
14. 0.109 0.610 ↑ 1.0 420 1

Hash (cost=29.51..29.51 rows=427 width=28) (actual time=0.610..0.610 rows=420 loops=1)

  • Output: sdu.sdu_id_svd, sdu.sdu_id_und, svu.svu_id_tipo, svu.svu_id_escala, svu.svu_dt_publicacao, sud.sud_dia, sud.id_sud
  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
  • Buffers: shared hit=10
15. 0.231 0.501 ↑ 1.0 420 1

Hash Join (cost=3.37..29.51 rows=427 width=28) (actual time=0.057..0.501 rows=420 loops=1)

  • Output: sdu.sdu_id_svd, sdu.sdu_id_und, svu.svu_id_tipo, svu.svu_id_escala, svu.svu_dt_publicacao, sud.sud_dia, sud.id_sud
  • Hash Cond: (sud.sud_id_svu = svu.id_svu)
  • Buffers: shared hit=10
16. 0.225 0.225 ↑ 1.0 854 1

Seq Scan on public.t_adm_sv_unidades_dias sud (cost=0.00..18.68 rows=854 width=12) (actual time=0.006..0.225 rows=854 loops=1)

  • Output: sud.id_sud, sud.sud_id_svu, sud.sud_dia, sud.sud_feriado, sud.sud_usr_ins, sud.sud_usr_upd, sud.sud_usr_dt_ins, sud.sud_usr_dt_upd, sud.reg_exclusao
  • Filter: (sud.reg_exclusao = 0)
  • Buffers: shared hit=8
17. 0.004 0.045 ↑ 1.0 14 1

Hash (cost=3.19..3.19 rows=14 width=24) (actual time=0.045..0.045 rows=14 loops=1)

  • Output: sdu.sdu_id_svd, sdu.sdu_id_und, svu.id_svu, svu.svu_id_tipo, svu.svu_id_escala, svu.svu_dt_publicacao
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
18. 0.009 0.041 ↑ 1.0 14 1

Hash Join (cost=1.59..3.19 rows=14 width=24) (actual time=0.027..0.041 rows=14 loops=1)

  • Output: sdu.sdu_id_svd, sdu.sdu_id_und, svu.id_svu, svu.svu_id_tipo, svu.svu_id_escala, svu.svu_dt_publicacao
  • Hash Cond: (sdu.id_sdu = svu.svu_id_sdu)
  • Buffers: shared hit=2
19. 0.014 0.014 ↑ 1.0 28 1

Seq Scan on public.t_adm_sv_departamento_unidades sdu (cost=0.00..1.35 rows=28 width=12) (actual time=0.004..0.014 rows=28 loops=1)

  • Output: sdu.id_sdu, sdu.sdu_id_svd, sdu.sdu_id_und, sdu.sdu_hor_qtd_total, sdu.sdu_usr_depto_liberacao, sdu.sdu_dta_depto_liberacao, sdu.sdu_usr_ins, sdu.sdu_usr_up (...)
  • Filter: ((sdu.sdu_dta_depto_liberacao IS NOT NULL) AND (sdu.reg_exclusao = 0))
  • Buffers: shared hit=1
20. 0.004 0.018 ↑ 1.0 14 1

Hash (cost=1.42..1.42 rows=14 width=20) (actual time=0.018..0.018 rows=14 loops=1)

  • Output: svu.svu_id_sdu, svu.id_svu, svu.svu_id_tipo, svu.svu_id_escala, svu.svu_dt_publicacao
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
21. 0.014 0.014 ↑ 1.0 14 1

Seq Scan on public.t_adm_sv_unidades svu (cost=0.00..1.42 rows=14 width=20) (actual time=0.004..0.014 rows=14 loops=1)

  • Output: svu.svu_id_sdu, svu.id_svu, svu.svu_id_tipo, svu.svu_id_escala, svu.svu_dt_publicacao
  • Filter: ((svu.svu_dta_und_liberacao IS NOT NULL) AND (svu.svu_dta_depto_deferimento IS NOT NULL) AND (svu.svu_id_situacao <> 3) AND (svu.reg_exclusao = 0))
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
22. 0.003 0.085 ↑ 1.0 6 1

Hash (cost=3.64..3.64 rows=6 width=44) (actual time=0.085..0.085 rows=6 loops=1)

  • Output: svc.svc_id_cargo, svc.reg_exclusao, cgo.id_cgo, svp.svp_id_svh, svp.svp_und_dia_ate, svp.svp_und_ext_dia_de, svp.svp_und_ext_dia_ate, svd.svd_id_svp, svd.svd_ano, svd.svd_mes, svd.id_svd
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=7
23. 0.005 0.082 ↑ 1.0 6 1

Nested Loop (cost=1.24..3.64 rows=6 width=44) (actual time=0.067..0.082 rows=6 loops=1)

  • Output: svc.svc_id_cargo, svc.reg_exclusao, cgo.id_cgo, svp.svp_id_svh, svp.svp_und_dia_ate, svp.svp_und_ext_dia_de, svp.svp_und_ext_dia_ate, svd.svd_id_svp, svd.svd_ano, svd.svd_mes, svd. (...)
  • Join Filter: (svc.svc_id_svp = svp.id_svp)
  • Buffers: shared hit=7
24. 0.007 0.059 ↑ 1.0 3 1

Merge Join (cost=1.24..1.48 rows=3 width=16) (actual time=0.051..0.059 rows=3 loops=1)

  • Output: svc.svc_id_cargo, svc.svc_id_svp, svc.reg_exclusao, cgo.id_cgo
  • Merge Cond: (cgo.id_cgo = svc.svc_id_cargo)
  • Buffers: shared hit=5
25. 0.039 0.039 ↑ 30.0 8 1

Index Only Scan using idx_id_cgo on public.t_tipo_adm_agente_cargo cgo (cost=0.14..9.16 rows=240 width=4) (actual time=0.034..0.039 rows=8 loops=1)

  • Output: cgo.id_cgo
  • Heap Fetches: 8
  • Buffers: shared hit=4
26. 0.011 0.013 ↑ 1.0 3 1

Sort (cost=1.05..1.06 rows=3 width=12) (actual time=0.012..0.013 rows=3 loops=1)

  • Output: svc.svc_id_cargo, svc.svc_id_svp, svc.reg_exclusao
  • Sort Key: svc.svc_id_cargo
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
27. 0.002 0.002 ↑ 1.0 3 1

Seq Scan on public.t_adm_controle_sv_cargos svc (cost=0.00..1.03 rows=3 width=12) (actual time=0.002..0.002 rows=3 loops=1)

  • Output: svc.svc_id_cargo, svc.svc_id_svp, svc.reg_exclusao
  • Buffers: shared hit=1
28. 0.004 0.018 ↑ 1.0 2 3

Materialize (cost=0.00..2.07 rows=2 width=36) (actual time=0.005..0.006 rows=2 loops=3)

  • Output: svp.id_svp, svp.svp_id_svh, svp.svp_und_dia_ate, svp.svp_und_ext_dia_de, svp.svp_und_ext_dia_ate, svd.svd_id_svp, svd.svd_ano, svd.svd_mes, svd.id_svd
  • Buffers: shared hit=2
29. 0.004 0.014 ↑ 1.0 2 1

Nested Loop (cost=0.00..2.06 rows=2 width=36) (actual time=0.012..0.014 rows=2 loops=1)

  • Output: svp.id_svp, svp.svp_id_svh, svp.svp_und_dia_ate, svp.svp_und_ext_dia_de, svp.svp_und_ext_dia_ate, svd.svd_id_svp, svd.svd_ano, svd.svd_mes, svd.id_svd
  • Join Filter: (svp.id_svp = svd.svd_id_svp)
  • Buffers: shared hit=2
30. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on public.t_adm_controle_sv_parametros svp (cost=0.00..1.01 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=1)

  • Output: svp.id_svp, svp.svp_descricao, svp.svp_hor_qtd_geral, svp.svp_hor_individual_min, svp.svp_hor_individual_max, svp.svp_hor_vlr, svp.svp_hor_excepcional, svp.svp_ct (...)
  • Filter: (svp.reg_exclusao = 0)
  • Buffers: shared hit=1
31. 0.006 0.006 ↑ 1.0 2 1

Seq Scan on public.t_adm_controle_sv_departamentos svd (cost=0.00..1.02 rows=2 width=16) (actual time=0.004..0.006 rows=2 loops=1)

  • Output: svd.svd_id_svp, svd.svd_ano, svd.svd_mes, svd.id_svd
  • Filter: ((svd.svd_dta_coord_liberacao IS NOT NULL) AND (svd.svd_id_svp IS NOT NULL) AND (svd.reg_exclusao = 0))
  • Buffers: shared hit=1
32. 0.001 0.024 ↑ 1.0 1 1

Hash (cost=4.88..4.88 rows=1 width=16) (actual time=0.024..0.024 rows=1 loops=1)

  • Output: fnp.id_funcionario, fnp.fnc_id_cargo, fnp.fnc_seq_und, unp.und_tipo_unidades
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=5
33. 0.003 0.023 ↑ 1.0 1 1

Nested Loop (cost=0.43..4.88 rows=1 width=16) (actual time=0.022..0.023 rows=1 loops=1)

  • Output: fnp.id_funcionario, fnp.fnc_id_cargo, fnp.fnc_seq_und, unp.und_tipo_unidades
  • Buffers: shared hit=5
34. 0.013 0.013 ↑ 1.0 1 1

Index Scan using idx_id_funcionario on public.t_adm_funcionario fnp (cost=0.28..2.51 rows=1 width=12) (actual time=0.013..0.013 rows=1 loops=1)

  • Output: fnp.id_funcionario, fnp.fnc_nome, fnp.fnc_nome_guerra, fnp.fnc_matricula, fnp.fnc_nro_funcional, fnp.fnc_probatorio, fnp.fnc_estudante, fnp.fnc_email, fnp.fnc_nacionalidade, fnp.fn (...)
  • Index Cond: (fnp.id_funcionario = 1935)
  • Filter: ((fnp.fnc_tipo_registro = 0) AND (fnp.fnc_status = 1))
  • Buffers: shared hit=3
35. 0.007 0.007 ↑ 1.0 1 1

Index Scan using idx_und_seq_und on public.t_unidade unp (cost=0.14..2.36 rows=1 width=12) (actual time=0.006..0.007 rows=1 loops=1)

  • Output: unp.und_seq_und, unp.und_nome, unp.und_endereco, unp.und_fone, unp.und_bairro, unp.und_cidade, unp.und_cep, unp.und_diretor, unp.und_capacidade, unp.und_vagas, unp.und_contato, unp (...)
  • Index Cond: (unp.und_seq_und = fnp.fnc_seq_und)
  • Buffers: shared hit=2
36. 4.200 4.200 ↑ 1.0 1 840

Index Scan using idx_und_seq_und on public.t_unidade und_1 (cost=0.14..0.48 rows=1 width=18) (actual time=0.004..0.005 rows=1 loops=840)

  • Output: und_1.und_seq_und, und_1.und_nome, und_1.und_endereco, und_1.und_fone, und_1.und_bairro, und_1.und_cidade, und_1.und_cep, und_1.und_diretor, und_1.und_capacidade, und_1.und_vagas, und_1.und_contato, (...)
  • Index Cond: (und_1.und_seq_und = sdu.sdu_id_und)
  • Buffers: shared hit=1680
37. 0.013 0.030 ↑ 1.0 48 1

Hash (cost=1.48..1.48 rows=48 width=10) (actual time=0.030..0.030 rows=48 loops=1)

  • Output: svh.id_svh, svh.svh_descricao
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
38. 0.017 0.017 ↑ 1.0 48 1

Seq Scan on public.t_tipo_adm_sv_horarios svh (cost=0.00..1.48 rows=48 width=10) (actual time=0.007..0.017 rows=48 loops=1)

  • Output: svh.id_svh, svh.svh_descricao
  • Buffers: shared hit=1
39.          

SubPlan (forHash Join)

40. 0.840 4.200 ↑ 1.0 1 840

Aggregate (cost=2.37..2.38 rows=1 width=0) (actual time=0.005..0.005 rows=1 loops=840)

  • Output: count(1)
  • Buffers: shared hit=1680
41. 3.360 3.360 ↓ 0.0 0 840

Index Scan using idx_und_seq_und on public.t_unidade x (cost=0.14..2.37 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=840)

  • Output: x.und_seq_und, x.und_nome, x.und_endereco, x.und_fone, x.und_bairro, x.und_cidade, x.und_cep, x.und_diretor, x.und_capacidade, x.und_vagas, x.und_contato, x.und_dat_inclu, x.und_hor_inclu, x.und_d (...)
  • Index Cond: (x.und_seq_und = fnp.fnc_seq_und)
  • Filter: ((x.und_seq_tip_und <> 7) AND (x.und_tipo_unidades = 2))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1680
42. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=8.75..8.90 rows=15 width=4) (never executed)

  • Output: dusxx.dus_id_und
  • Group Key: dusxx.dus_id_und
43. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=4.21..8.44 rows=123 width=4) (never executed)

  • Output: dusxx.dus_id_und
  • Hash Cond: (usgxx.usg_id_dus = dusxx.id_dus)
44. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamento_unidades_servico_grupo usgxx (cost=0.00..2.54 rows=123 width=4) (never executed)

  • Output: usgxx.id_usg, usgxx.usg_id_dus, usgxx.usg_id_und, usgxx.usg_usr_ins, usgxx.usg_usr_upd, usgxx.usg_usr_dt_ins, usgxx.usg_usr_dt_upd, usgxx.reg_exclusao
  • Filter: (usgxx.reg_exclusao = 0)
45. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.85..3.85 rows=29 width=8) (never executed)

  • Output: dusxx.dus_id_und, dusxx.id_dus
46. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2.09..3.85 rows=29 width=8) (never executed)

  • Output: dusxx.dus_id_und, dusxx.id_dus
  • Hash Cond: (dusxx.dus_id_svd = svdxx.id_svd)
47. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamento_unidades_servico dusxx (cost=0.00..1.36 rows=29 width=12) (never executed)

  • Output: dusxx.id_dus, dusxx.dus_id_svd, dusxx.dus_id_und, dusxx.dus_usr_ins, dusxx.dus_usr_upd, dusxx.dus_usr_dt_ins, dusxx.dus_usr_dt_upd, dusxx.reg_exclusao
  • Filter: (dusxx.reg_exclusao = 0)
48. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.06..2.06 rows=2 width=4) (never executed)

  • Output: svdxx.id_svd
49. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..2.06 rows=2 width=4) (never executed)

  • Output: svdxx.id_svd
50. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_parametros svpxx (cost=0.00..1.01 rows=1 width=4) (never executed)

  • Output: svpxx.id_svp, svpxx.svp_descricao, svpxx.svp_hor_qtd_geral, svpxx.svp_hor_individual_min, svpxx.svp_hor_individual_max, svpxx.svp_hor_vlr, svpxx.svp_hor_excepcional, (...)
  • Filter: (svpxx.id_svp = svd.svd_id_svp)
51. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamentos svdxx (cost=0.00..1.03 rows=2 width=8) (never executed)

  • Output: svdxx.svd_id_svp, svdxx.id_svd
  • Filter: ((svdxx.svd_dta_coord_liberacao IS NOT NULL) AND (svdxx.svd_id_svp = svd.svd_id_svp) AND (svdxx.reg_exclusao = 0))
52. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=8.75..8.90 rows=15 width=4) (never executed)

  • Output: dusxx_1.dus_id_und
  • Group Key: dusxx_1.dus_id_und
53. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=4.21..8.44 rows=123 width=4) (never executed)

  • Output: dusxx_1.dus_id_und
  • Hash Cond: (usgxx_1.usg_id_dus = dusxx_1.id_dus)
54. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamento_unidades_servico_grupo usgxx_1 (cost=0.00..2.54 rows=123 width=4) (never executed)

  • Output: usgxx_1.id_usg, usgxx_1.usg_id_dus, usgxx_1.usg_id_und, usgxx_1.usg_usr_ins, usgxx_1.usg_usr_upd, usgxx_1.usg_usr_dt_ins, usgxx_1.usg_usr_dt_upd, usgxx_1.reg_exclusao
  • Filter: (usgxx_1.reg_exclusao = 0)
55. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.85..3.85 rows=29 width=8) (never executed)

  • Output: dusxx_1.dus_id_und, dusxx_1.id_dus
56. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2.09..3.85 rows=29 width=8) (never executed)

  • Output: dusxx_1.dus_id_und, dusxx_1.id_dus
  • Hash Cond: (dusxx_1.dus_id_svd = svdxx_1.id_svd)
57. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamento_unidades_servico dusxx_1 (cost=0.00..1.36 rows=29 width=12) (never executed)

  • Output: dusxx_1.id_dus, dusxx_1.dus_id_svd, dusxx_1.dus_id_und, dusxx_1.dus_usr_ins, dusxx_1.dus_usr_upd, dusxx_1.dus_usr_dt_ins, dusxx_1.dus_usr_dt_upd, dusxx_1.reg_exclusao
  • Filter: (dusxx_1.reg_exclusao = 0)
58. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.06..2.06 rows=2 width=4) (never executed)

  • Output: svdxx_1.id_svd
59. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..2.06 rows=2 width=4) (never executed)

  • Output: svdxx_1.id_svd
60. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_parametros svpxx_1 (cost=0.00..1.01 rows=1 width=4) (never executed)

  • Output: svpxx_1.id_svp, svpxx_1.svp_descricao, svpxx_1.svp_hor_qtd_geral, svpxx_1.svp_hor_individual_min, svpxx_1.svp_hor_individual_max, svpxx_1.svp_hor_vlr, svpxx_1.svp_hor (...)
  • Filter: (svpxx_1.id_svp = svd.svd_id_svp)
61. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamentos svdxx_1 (cost=0.00..1.03 rows=2 width=8) (never executed)

  • Output: svdxx_1.svd_id_svp, svdxx_1.id_svd
  • Filter: ((svdxx_1.svd_dta_coord_liberacao IS NOT NULL) AND (svdxx_1.svd_id_svp = svd.svd_id_svp) AND (svdxx_1.reg_exclusao = 0))
62. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=8.75..8.90 rows=15 width=4) (never executed)

  • Output: dusxx_2.dus_id_und
  • Group Key: dusxx_2.dus_id_und
63. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=4.21..8.44 rows=123 width=4) (never executed)

  • Output: dusxx_2.dus_id_und
  • Hash Cond: (usgxx_2.usg_id_dus = dusxx_2.id_dus)
64. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamento_unidades_servico_grupo usgxx_2 (cost=0.00..2.54 rows=123 width=4) (never executed)

  • Output: usgxx_2.id_usg, usgxx_2.usg_id_dus, usgxx_2.usg_id_und, usgxx_2.usg_usr_ins, usgxx_2.usg_usr_upd, usgxx_2.usg_usr_dt_ins, usgxx_2.usg_usr_dt_upd, usgxx_2.reg_exclusao
  • Filter: (usgxx_2.reg_exclusao = 0)
65. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.85..3.85 rows=29 width=8) (never executed)

  • Output: dusxx_2.dus_id_und, dusxx_2.id_dus
66. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2.09..3.85 rows=29 width=8) (never executed)

  • Output: dusxx_2.dus_id_und, dusxx_2.id_dus
  • Hash Cond: (dusxx_2.dus_id_svd = svdxx_2.id_svd)
67. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamento_unidades_servico dusxx_2 (cost=0.00..1.36 rows=29 width=12) (never executed)

  • Output: dusxx_2.id_dus, dusxx_2.dus_id_svd, dusxx_2.dus_id_und, dusxx_2.dus_usr_ins, dusxx_2.dus_usr_upd, dusxx_2.dus_usr_dt_ins, dusxx_2.dus_usr_dt_upd, dusxx_2.reg_exclusao
  • Filter: (dusxx_2.reg_exclusao = 0)
68. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.06..2.06 rows=2 width=4) (never executed)

  • Output: svdxx_2.id_svd
69. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..2.06 rows=2 width=4) (never executed)

  • Output: svdxx_2.id_svd
70. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_parametros svpxx_2 (cost=0.00..1.01 rows=1 width=4) (never executed)

  • Output: svpxx_2.id_svp, svpxx_2.svp_descricao, svpxx_2.svp_hor_qtd_geral, svpxx_2.svp_hor_individual_min, svpxx_2.svp_hor_individual_max, svpxx_2.svp_hor_vlr, svpxx_2.svp_hor (...)
  • Filter: (svpxx_2.id_svp = svd.svd_id_svp)
71. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamentos svdxx_2 (cost=0.00..1.03 rows=2 width=8) (never executed)

  • Output: svdxx_2.svd_id_svp, svdxx_2.id_svd
  • Filter: ((svdxx_2.svd_dta_coord_liberacao IS NOT NULL) AND (svdxx_2.svd_id_svp = svd.svd_id_svp) AND (svdxx_2.reg_exclusao = 0))
72. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=8.75..8.90 rows=15 width=4) (never executed)

  • Output: dusxx_3.dus_id_und
  • Group Key: dusxx_3.dus_id_und
73. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=4.21..8.44 rows=123 width=4) (never executed)

  • Output: dusxx_3.dus_id_und
  • Hash Cond: (usgxx_3.usg_id_dus = dusxx_3.id_dus)
74. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamento_unidades_servico_grupo usgxx_3 (cost=0.00..2.54 rows=123 width=4) (never executed)

  • Output: usgxx_3.id_usg, usgxx_3.usg_id_dus, usgxx_3.usg_id_und, usgxx_3.usg_usr_ins, usgxx_3.usg_usr_upd, usgxx_3.usg_usr_dt_ins, usgxx_3.usg_usr_dt_upd, usgxx_3.reg_exclusao
  • Filter: (usgxx_3.reg_exclusao = 0)
75. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.85..3.85 rows=29 width=8) (never executed)

  • Output: dusxx_3.dus_id_und, dusxx_3.id_dus
76. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2.09..3.85 rows=29 width=8) (never executed)

  • Output: dusxx_3.dus_id_und, dusxx_3.id_dus
  • Hash Cond: (dusxx_3.dus_id_svd = svdxx_3.id_svd)
77. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamento_unidades_servico dusxx_3 (cost=0.00..1.36 rows=29 width=12) (never executed)

  • Output: dusxx_3.id_dus, dusxx_3.dus_id_svd, dusxx_3.dus_id_und, dusxx_3.dus_usr_ins, dusxx_3.dus_usr_upd, dusxx_3.dus_usr_dt_ins, dusxx_3.dus_usr_dt_upd, dusxx_3.reg_exclusao
  • Filter: (dusxx_3.reg_exclusao = 0)
78. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.06..2.06 rows=2 width=4) (never executed)

  • Output: svdxx_3.id_svd
79. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..2.06 rows=2 width=4) (never executed)

  • Output: svdxx_3.id_svd
80. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_parametros svpxx_3 (cost=0.00..1.01 rows=1 width=4) (never executed)

  • Output: svpxx_3.id_svp, svpxx_3.svp_descricao, svpxx_3.svp_hor_qtd_geral, svpxx_3.svp_hor_individual_min, svpxx_3.svp_hor_individual_max, svpxx_3.svp_hor_vlr, svpxx_3.svp_hor (...)
  • Filter: (svpxx_3.id_svp = svd.svd_id_svp)
81. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamentos svdxx_3 (cost=0.00..1.03 rows=2 width=8) (never executed)

  • Output: svdxx_3.svd_id_svp, svdxx_3.id_svd
  • Filter: ((svdxx_3.svd_dta_coord_liberacao IS NOT NULL) AND (svdxx_3.svd_id_svp = svd.svd_id_svp) AND (svdxx_3.reg_exclusao = 0))
82. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=8.75..8.90 rows=15 width=4) (never executed)

  • Output: dusxx_4.dus_id_und
  • Group Key: dusxx_4.dus_id_und
83. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=4.21..8.44 rows=123 width=4) (never executed)

  • Output: dusxx_4.dus_id_und
  • Hash Cond: (usgxx_4.usg_id_dus = dusxx_4.id_dus)
84. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamento_unidades_servico_grupo usgxx_4 (cost=0.00..2.54 rows=123 width=4) (never executed)

  • Output: usgxx_4.id_usg, usgxx_4.usg_id_dus, usgxx_4.usg_id_und, usgxx_4.usg_usr_ins, usgxx_4.usg_usr_upd, usgxx_4.usg_usr_dt_ins, usgxx_4.usg_usr_dt_upd, usgxx_4.reg_exclusao
  • Filter: (usgxx_4.reg_exclusao = 0)
85. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.85..3.85 rows=29 width=8) (never executed)

  • Output: dusxx_4.dus_id_und, dusxx_4.id_dus
86. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2.09..3.85 rows=29 width=8) (never executed)

  • Output: dusxx_4.dus_id_und, dusxx_4.id_dus
  • Hash Cond: (dusxx_4.dus_id_svd = svdxx_4.id_svd)
87. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamento_unidades_servico dusxx_4 (cost=0.00..1.36 rows=29 width=12) (never executed)

  • Output: dusxx_4.id_dus, dusxx_4.dus_id_svd, dusxx_4.dus_id_und, dusxx_4.dus_usr_ins, dusxx_4.dus_usr_upd, dusxx_4.dus_usr_dt_ins, dusxx_4.dus_usr_dt_upd, dusxx_4.reg_exclusao
  • Filter: (dusxx_4.reg_exclusao = 0)
88. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.06..2.06 rows=2 width=4) (never executed)

  • Output: svdxx_4.id_svd
89. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..2.06 rows=2 width=4) (never executed)

  • Output: svdxx_4.id_svd
90. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_parametros svpxx_4 (cost=0.00..1.01 rows=1 width=4) (never executed)

  • Output: svpxx_4.id_svp, svpxx_4.svp_descricao, svpxx_4.svp_hor_qtd_geral, svpxx_4.svp_hor_individual_min, svpxx_4.svp_hor_individual_max, svpxx_4.svp_hor_vlr, svpxx_4.svp_hor (...)
  • Filter: (svpxx_4.id_svp = svd.svd_id_svp)
91. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamentos svdxx_4 (cost=0.00..1.03 rows=2 width=8) (never executed)

  • Output: svdxx_4.svd_id_svp, svdxx_4.id_svd
  • Filter: ((svdxx_4.svd_dta_coord_liberacao IS NOT NULL) AND (svdxx_4.svd_id_svp = svd.svd_id_svp) AND (svdxx_4.reg_exclusao = 0))
92. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=8.75..8.90 rows=15 width=4) (never executed)

  • Output: dusxx_5.dus_id_und
  • Group Key: dusxx_5.dus_id_und
93. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=4.21..8.44 rows=123 width=4) (never executed)

  • Output: dusxx_5.dus_id_und
  • Hash Cond: (usgxx_5.usg_id_dus = dusxx_5.id_dus)
94. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamento_unidades_servico_grupo usgxx_5 (cost=0.00..2.54 rows=123 width=4) (never executed)

  • Output: usgxx_5.id_usg, usgxx_5.usg_id_dus, usgxx_5.usg_id_und, usgxx_5.usg_usr_ins, usgxx_5.usg_usr_upd, usgxx_5.usg_usr_dt_ins, usgxx_5.usg_usr_dt_upd, usgxx_5.reg_exclusao
  • Filter: (usgxx_5.reg_exclusao = 0)
95. 0.000 0.000 ↓ 0.0 0

Hash (cost=3.85..3.85 rows=29 width=8) (never executed)

  • Output: dusxx_5.dus_id_und, dusxx_5.id_dus
96. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2.09..3.85 rows=29 width=8) (never executed)

  • Output: dusxx_5.dus_id_und, dusxx_5.id_dus
  • Hash Cond: (dusxx_5.dus_id_svd = svdxx_5.id_svd)
97. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamento_unidades_servico dusxx_5 (cost=0.00..1.36 rows=29 width=12) (never executed)

  • Output: dusxx_5.id_dus, dusxx_5.dus_id_svd, dusxx_5.dus_id_und, dusxx_5.dus_usr_ins, dusxx_5.dus_usr_upd, dusxx_5.dus_usr_dt_ins, dusxx_5.dus_usr_dt_upd, dusxx_5.reg_exclusao
  • Filter: (dusxx_5.reg_exclusao = 0)
98. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.06..2.06 rows=2 width=4) (never executed)

  • Output: svdxx_5.id_svd
99. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..2.06 rows=2 width=4) (never executed)

  • Output: svdxx_5.id_svd
100. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_parametros svpxx_5 (cost=0.00..1.01 rows=1 width=4) (never executed)

  • Output: svpxx_5.id_svp, svpxx_5.svp_descricao, svpxx_5.svp_hor_qtd_geral, svpxx_5.svp_hor_individual_min, svpxx_5.svp_hor_individual_max, svpxx_5.svp_hor_vlr, svpxx_5.svp_hor (...)
  • Filter: (svpxx_5.id_svp = svd.svd_id_svp)
101. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_departamentos svdxx_5 (cost=0.00..1.03 rows=2 width=8) (never executed)

  • Output: svdxx_5.svd_id_svp, svdxx_5.id_svd
  • Filter: ((svdxx_5.svd_dta_coord_liberacao IS NOT NULL) AND (svdxx_5.svd_id_svp = svd.svd_id_svp) AND (svdxx_5.reg_exclusao = 0))
102. 10.920 42.000 ↑ 1.9 8 840

HashAggregate (cost=3.92..4.07 rows=15 width=4) (actual time=0.049..0.050 rows=8 loops=840)

  • Output: dusxx_6.dus_id_und
  • Group Key: dusxx_6.dus_id_und
  • Buffers: shared hit=2520
103. 11.760 31.080 ↑ 1.0 29 840

Hash Join (cost=2.09..3.85 rows=29 width=4) (actual time=0.023..0.037 rows=29 loops=840)

  • Output: dusxx_6.dus_id_und
  • Hash Cond: (dusxx_6.dus_id_svd = svdxx_6.id_svd)
  • Buffers: shared hit=2520
104. 6.720 6.720 ↑ 1.0 29 840

Seq Scan on public.t_adm_controle_sv_departamento_unidades_servico dusxx_6 (cost=0.00..1.36 rows=29 width=8) (actual time=0.002..0.008 rows=29 loops=840)

  • Output: dusxx_6.id_dus, dusxx_6.dus_id_svd, dusxx_6.dus_id_und, dusxx_6.dus_usr_ins, dusxx_6.dus_usr_upd, dusxx_6.dus_usr_dt_ins, dusxx_6.dus_usr_dt_upd, dusxx_6.reg_exclusao
  • Filter: (dusxx_6.reg_exclusao = 0)
  • Buffers: shared hit=840
105. 1.680 12.600 ↑ 1.0 2 840

Hash (cost=2.06..2.06 rows=2 width=4) (actual time=0.015..0.015 rows=2 loops=840)

  • Output: svdxx_6.id_svd
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1680
106. 4.200 10.920 ↑ 1.0 2 840

Nested Loop (cost=0.00..2.06 rows=2 width=4) (actual time=0.012..0.013 rows=2 loops=840)

  • Output: svdxx_6.id_svd
  • Buffers: shared hit=1680
107. 3.360 3.360 ↑ 1.0 1 840

Seq Scan on public.t_adm_controle_sv_parametros svpxx_6 (cost=0.00..1.01 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=840)

  • Output: svpxx_6.id_svp, svpxx_6.svp_descricao, svpxx_6.svp_hor_qtd_geral, svpxx_6.svp_hor_individual_min, svpxx_6.svp_hor_individual_max, svpxx_6.svp_hor_vlr, svpxx_6.svp_hor_excepcional (...)
  • Filter: (svpxx_6.id_svp = svd.svd_id_svp)
  • Buffers: shared hit=840
108. 3.360 3.360 ↑ 1.0 2 840

Seq Scan on public.t_adm_controle_sv_departamentos svdxx_6 (cost=0.00..1.03 rows=2 width=8) (actual time=0.003..0.004 rows=2 loops=840)

  • Output: svdxx_6.svd_id_svp, svdxx_6.id_svd
  • Filter: ((svdxx_6.svd_dta_coord_liberacao IS NOT NULL) AND (svdxx_6.svd_id_svp = svd.svd_id_svp) AND (svdxx_6.reg_exclusao = 0))
  • Buffers: shared hit=840
109. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.33..6.73 rows=1 width=4) (never executed)

  • Output: udtx_3.id_udt
110. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3.05..6.40 rows=1 width=4) (never executed)

  • Output: sucx_3.suc_id_udt
111. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on public.t_adm_sv_unidades_dias_turnos_cargos_servidores dcsx_2 (cost=2.78..3.90 rows=1 width=4) (never executed)

  • Output: dcsx_2.id_dcs, dcsx_2.dcs_id_suc, dcsx_2.dcs_id_funcionario, dcsx_2.dcs_id_funcionario_cgo, dcsx_2.dcs_id_funcionario_sub, dcsx_2.dcs_id_funcionario_sub_cgo, dcsx_2.dcs_id_situacao, dcsx_2.d (...)
  • Recheck Cond: ((dcsx_2.dcs_id_funcionario = fnp.id_funcionario) OR (dcsx_2.dcs_id_funcionario_sub = fnp.id_funcionario))
  • Filter: ((dcsx_2.dcs_dt_desistencia IS NULL) AND (dcsx_2.reg_exclusao = 0) AND (dcsx_2.dcs_id_situacao = 2))
112. 0.000 0.000 ↓ 0.0 0

BitmapOr (cost=2.78..2.78 rows=1 width=0) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_dcs_id_funcionario (cost=0.00..1.39 rows=1 width=0) (never executed)

  • Index Cond: (dcsx_2.dcs_id_funcionario = fnp.id_funcionario)
114. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_dcs_id_funcionario_sub (cost=0.00..1.39 rows=1 width=0) (never executed)

  • Index Cond: (dcsx_2.dcs_id_funcionario_sub = fnp.id_funcionario)
115. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_id_suc on public.t_adm_sv_unidades_dias_turnos_cargos sucx_3 (cost=0.28..2.50 rows=1 width=8) (never executed)

  • Output: sucx_3.id_suc, sucx_3.suc_id_udt, sucx_3.suc_tipo_vaga, sucx_3.suc_id_jornada, sucx_3.suc_id_cargo, sucx_3.suc_qtd_vagas_cargo, sucx_3.suc_obs_vagas, sucx_3.suc_usr_ins, sucx_3.suc_usr_upd, (...)
  • Index Cond: (sucx_3.id_suc = dcsx_2.dcs_id_suc)
  • Filter: (sucx_3.reg_exclusao = 0)
116. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_id_udt on public.t_adm_sv_unidades_dias_turnos udtx_3 (cost=0.28..0.31 rows=1 width=4) (never executed)

  • Output: udtx_3.id_udt, udtx_3.udt_id_sud, udtx_3.udt_id_turno, udtx_3.udt_id_horario, udtx_3.udt_qtd_vagas, udtx_3.udt_usr_ins, udtx_3.udt_usr_upd, udtx_3.udt_usr_dt_ins, udtx_3.udt_usr_dt_upd, udtx_3.reg (...)
  • Index Cond: (udtx_3.id_udt = sucx_3.suc_id_udt)
  • Filter: (udtx_3.reg_exclusao = 0)
117.          

SubPlan (forHashAggregate)

118. 5.040 13.440 ↑ 1.0 1 840

Nested Loop Left Join (cost=0.56..12.41 rows=1 width=16) (actual time=0.015..0.016 rows=1 loops=840)

  • Output: CASE WHEN (sucx.suc_tipo_vaga = 1) THEN CASE WHEN (sucx.suc_qtd_vagas_cargo IS NOT NULL) THEN sucx.suc_qtd_vagas_cargo ELSE 0 END WHEN (sucx.suc_tipo_vaga = 2) THEN (SubPlan 1) WHEN (sucx.suc_tipo_vaga = 3) THEN CA (...)
  • Join Filter: (svx.id_svc = sucx.suc_id_cargo)
  • Rows Removed by Join Filter: 3
  • Filter: CASE WHEN (sucx.suc_tipo_vaga = ANY ('{1,2}'::integer[])) THEN (svx.svc_id_cargo = fnp.fnc_id_cargo) ELSE true END
  • Buffers: shared hit=5888
119. 0.840 6.720 ↑ 1.0 1 840

Nested Loop (cost=0.56..5.00 rows=1 width=20) (actual time=0.007..0.008 rows=1 loops=840)

  • Output: udtx.udt_qtd_vagas, sucx.suc_tipo_vaga, sucx.suc_qtd_vagas_cargo, sucx.id_suc, sucx.suc_id_cargo
  • Buffers: shared hit=5048
120. 3.360 3.360 ↑ 1.0 1 840

Index Scan using idx_id_udt on public.t_adm_sv_unidades_dias_turnos udtx (cost=0.28..2.50 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=840)

  • Output: udtx.id_udt, udtx.udt_id_sud, udtx.udt_id_turno, udtx.udt_id_horario, udtx.udt_qtd_vagas, udtx.udt_usr_ins, udtx.udt_usr_upd, udtx.udt_usr_dt_ins, udtx.udt_usr_dt_upd, udtx.reg_exclusao
  • Index Cond: (udtx.id_udt = udt.id_udt)
  • Buffers: shared hit=2524
121. 2.520 2.520 ↑ 1.0 1 840

Index Scan using idx_suc_id_udt on public.t_adm_sv_unidades_dias_turnos_cargos sucx (cost=0.28..2.50 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=840)

  • Output: sucx.id_suc, sucx.suc_id_udt, sucx.suc_tipo_vaga, sucx.suc_id_jornada, sucx.suc_id_cargo, sucx.suc_qtd_vagas_cargo, sucx.suc_obs_vagas, sucx.suc_usr_ins, sucx.suc_usr_upd, sucx.suc_usr_dt_ins, sucx.suc_ (...)
  • Index Cond: (sucx.suc_id_udt = udt.id_udt)
  • Filter: (sucx.reg_exclusao = 0)
  • Buffers: shared hit=2524
122. 1.680 1.680 ↑ 1.0 3 840

Seq Scan on public.t_adm_controle_sv_cargos svx (cost=0.00..1.03 rows=3 width=8) (actual time=0.002..0.002 rows=3 loops=840)

  • Output: svx.id_svc, svx.svc_id_svp, svx.svc_id_cargo, svx.svc_usr_ins, svx.svc_usr_upd, svx.svc_usr_dt_ins, svx.svc_usr_dt_upd, svx.reg_exclusao
  • Buffers: shared hit=840
123.          

SubPlan (forNested Loop Left Join)

124. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..6.32 rows=1 width=4) (never executed)

  • Output: (CASE WHEN (txx.udt_qtd_vagas IS NOT NULL) THEN txx.udt_qtd_vagas ELSE 0 END)
125. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..6.32 rows=1 width=4) (never executed)

  • Output: CASE WHEN (txx.udt_qtd_vagas IS NOT NULL) THEN txx.udt_qtd_vagas ELSE 0 END
  • Join Filter: (cxx.suc_id_cargo = svcx.id_svc)
126. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..5.27 rows=1 width=8) (never executed)

  • Output: cxx.suc_id_cargo, txx.udt_qtd_vagas
127. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..4.22 rows=1 width=12) (never executed)

  • Output: cxx.suc_tipo_vaga, cxx.suc_id_cargo, txx.udt_qtd_vagas
128. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..3.91 rows=1 width=16) (never executed)

  • Output: cxx.suc_tipo_vaga, cxx.suc_id_cargo, txx.udt_qtd_vagas, txx.udt_id_sud
129. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_suc_tipo_vaga on public.t_adm_sv_unidades_dias_turnos_cargos cxx (cost=0.28..1.40 rows=1 width=12) (never executed)

  • Output: cxx.id_suc, cxx.suc_id_udt, cxx.suc_tipo_vaga, cxx.suc_id_jornada, cxx.suc_id_cargo, cxx.suc_qtd_vagas_cargo, cxx.suc_obs_vagas, cxx.suc_usr_ins, cxx.suc_usr_upd, cxx.suc_usr_d (...)
  • Index Cond: (cxx.suc_tipo_vaga = 2)
  • Filter: ((cxx.reg_exclusao = 0) AND (cxx.id_suc = sucx.id_suc))
130. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_id_udt on public.t_adm_sv_unidades_dias_turnos txx (cost=0.28..2.50 rows=1 width=12) (never executed)

  • Output: txx.id_udt, txx.udt_id_sud, txx.udt_id_turno, txx.udt_id_horario, txx.udt_qtd_vagas, txx.udt_usr_ins, txx.udt_usr_upd, txx.udt_usr_dt_ins, txx.udt_usr_dt_upd, txx.reg_exclusao
  • Index Cond: (txx.id_udt = cxx.suc_id_udt)
  • Filter: (txx.reg_exclusao = 0)
131. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_id_sud on public.t_adm_sv_unidades_dias dxx (cost=0.28..0.30 rows=1 width=4) (never executed)

  • Output: dxx.id_sud, dxx.sud_id_svu, dxx.sud_dia, dxx.sud_feriado, dxx.sud_usr_ins, dxx.sud_usr_upd, dxx.sud_usr_dt_ins, dxx.sud_usr_dt_upd, dxx.reg_exclusao
  • Index Cond: (dxx.id_sud = txx.udt_id_sud)
  • Filter: (dxx.reg_exclusao = 0)
132. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_tipo_adm_sv_vagas vxx (cost=0.00..1.04 rows=1 width=4) (never executed)

  • Output: vxx.id_svv, vxx.svv_descricao, vxx.svv_usr_ins, vxx.svv_usr_upd, vxx.svv_usr_dt_ins, vxx.svv_usr_dt_upd, vxx.reg_exclusao
  • Filter: (vxx.id_svv = 2)
133. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_cargos svcx (cost=0.00..1.04 rows=1 width=4) (never executed)

  • Output: svcx.id_svc, svcx.svc_id_svp, svcx.svc_id_cargo, svcx.svc_usr_ins, svcx.svc_usr_upd, svcx.svc_usr_dt_ins, svcx.svc_usr_dt_upd, svcx.reg_exclusao
  • Filter: (svcx.svc_id_cargo = fnp.fnc_id_cargo)
134. 1.680 23.520 ↑ 1.0 1 840

Aggregate (cost=9.67..9.68 rows=1 width=0) (actual time=0.027..0.028 rows=1 loops=840)

  • Output: count(1)
  • Buffers: shared hit=8730
135. 4.200 21.840 ↓ 2.0 2 840

Nested Loop (cost=1.96..9.67 rows=1 width=0) (actual time=0.022..0.026 rows=2 loops=840)

  • Buffers: shared hit=8730
136. 0.840 6.720 ↑ 1.0 1 840

Nested Loop (cost=0.56..5.00 rows=1 width=4) (actual time=0.007..0.008 rows=1 loops=840)

  • Output: sucx_1.id_suc
  • Buffers: shared hit=5048
137. 3.360 3.360 ↑ 1.0 1 840

Index Only Scan using idx_id_udt on public.t_adm_sv_unidades_dias_turnos udtx_1 (cost=0.28..2.50 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=840)

  • Output: udtx_1.id_udt
  • Index Cond: (udtx_1.id_udt = udt.id_udt)
  • Heap Fetches: 840
  • Buffers: shared hit=2524
138. 2.520 2.520 ↑ 1.0 1 840

Index Scan using idx_suc_id_udt on public.t_adm_sv_unidades_dias_turnos_cargos sucx_1 (cost=0.28..2.50 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=840)

  • Output: sucx_1.id_suc, sucx_1.suc_id_udt, sucx_1.suc_tipo_vaga, sucx_1.suc_id_jornada, sucx_1.suc_id_cargo, sucx_1.suc_qtd_vagas_cargo, sucx_1.suc_obs_vagas, sucx_1.suc_usr_ins, sucx_1.suc_usr_upd, sucx_1 (...)
  • Index Cond: (sucx_1.suc_id_udt = udt.id_udt)
  • Filter: (sucx_1.reg_exclusao = 0)
  • Buffers: shared hit=2524
139. 5.880 10.920 ↓ 2.0 2 840

Bitmap Heap Scan on public.t_adm_sv_unidades_dias_turnos_cargos_servidores dcsx (cost=1.40..4.66 rows=1 width=4) (actual time=0.011..0.013 rows=2 loops=840)

  • Output: dcsx.id_dcs, dcsx.dcs_id_suc, dcsx.dcs_id_funcionario, dcsx.dcs_id_funcionario_cgo, dcsx.dcs_id_funcionario_sub, dcsx.dcs_id_funcionario_sub_cgo, dcsx.dcs_id_situacao, dcsx.dcs_dt_solicitacao, dcsx.dcs_ (...)
  • Recheck Cond: (dcsx.dcs_id_suc = sucx_1.id_suc)
  • Filter: (CASE WHEN (dcsx.dcs_id_situacao <> ALL ('{4,5}'::integer[])) THEN (dcsx.dcs_dt_desistencia IS NULL) ELSE false END AND (dcsx.reg_exclusao = 0))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=1995
  • Buffers: shared hit=3682
140. 5.040 5.040 ↑ 1.0 3 840

Bitmap Index Scan on idx_dcs_id_suc (cost=0.00..1.40 rows=3 width=0) (actual time=0.006..0.006 rows=3 loops=840)

  • Index Cond: (dcsx.dcs_id_suc = sucx_1.id_suc)
  • Buffers: shared hit=1687
141. 0.840 8.400 ↓ 0.0 0 840

Nested Loop (cost=0.84..7.52 rows=1 width=0) (actual time=0.010..0.010 rows=0 loops=840)

  • Output: 1
  • Join Filter: (sucx_2.id_suc = dcsx_1.dcs_id_suc)
  • Buffers: shared hit=6728
142. 0.840 5.880 ↑ 1.0 1 840

Nested Loop (cost=0.56..5.00 rows=1 width=4) (actual time=0.006..0.007 rows=1 loops=840)

  • Output: sucx_2.id_suc
  • Buffers: shared hit=5048
143. 2.520 2.520 ↑ 1.0 1 840

Index Only Scan using idx_id_udt on public.t_adm_sv_unidades_dias_turnos udtx_2 (cost=0.28..2.50 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=840)

  • Output: udtx_2.id_udt
  • Index Cond: (udtx_2.id_udt = udt.id_udt)
  • Heap Fetches: 840
  • Buffers: shared hit=2524
144. 2.520 2.520 ↑ 1.0 1 840

Index Scan using idx_suc_id_udt on public.t_adm_sv_unidades_dias_turnos_cargos sucx_2 (cost=0.28..2.50 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=840)

  • Output: sucx_2.id_suc, sucx_2.suc_id_udt, sucx_2.suc_tipo_vaga, sucx_2.suc_id_jornada, sucx_2.suc_id_cargo, sucx_2.suc_qtd_vagas_cargo, sucx_2.suc_obs_vagas, sucx_2.suc_usr_ins, sucx_2.suc_usr_upd, sucx_2.suc_u (...)
  • Index Cond: (sucx_2.suc_id_udt = udt.id_udt)
  • Filter: (sucx_2.reg_exclusao = 0)
  • Buffers: shared hit=2524
145. 1.680 1.680 ↓ 0.0 0 840

Index Scan using idx_dcs_id_funcionario on public.t_adm_sv_unidades_dias_turnos_cargos_servidores dcsx_1 (cost=0.28..2.50 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=840)

  • Output: dcsx_1.id_dcs, dcsx_1.dcs_id_suc, dcsx_1.dcs_id_funcionario, dcsx_1.dcs_id_funcionario_cgo, dcsx_1.dcs_id_funcionario_sub, dcsx_1.dcs_id_funcionario_sub_cgo, dcsx_1.dcs_id_situacao, dcsx_1.dcs_dt_solicitacao, (...)
  • Index Cond: (dcsx_1.dcs_id_funcionario = fnp.id_funcionario)
  • Filter: (CASE WHEN (dcsx_1.dcs_id_situacao <> ALL ('{4,5}'::integer[])) THEN (dcsx_1.dcs_dt_desistencia IS NULL) ELSE false END AND (dcsx_1.reg_exclusao = 0))
  • Buffers: shared hit=1680
146. 5.040 13.440 ↑ 1.0 1 840

Nested Loop Left Join (cost=0.56..12.41 rows=1 width=16) (actual time=0.015..0.016 rows=1 loops=840)

  • Output: CASE WHEN (sucx_4.suc_tipo_vaga = 1) THEN CASE WHEN (sucx_4.suc_qtd_vagas_cargo IS NOT NULL) THEN sucx_4.suc_qtd_vagas_cargo ELSE 0 END WHEN (sucx_4.suc_tipo_vaga = 2) THEN (SubPlan 14) WHEN (sucx_4.suc_tipo_vaga = (...)
  • Join Filter: (svx_1.id_svc = sucx_4.suc_id_cargo)
  • Rows Removed by Join Filter: 3
  • Filter: CASE WHEN (sucx_4.suc_tipo_vaga = ANY ('{1,2}'::integer[])) THEN (svx_1.svc_id_cargo = fnp.fnc_id_cargo) ELSE true END
  • Buffers: shared hit=5888
147. 0.840 5.880 ↑ 1.0 1 840

Nested Loop (cost=0.56..5.00 rows=1 width=20) (actual time=0.006..0.007 rows=1 loops=840)

  • Output: udtx_4.udt_qtd_vagas, sucx_4.suc_tipo_vaga, sucx_4.suc_qtd_vagas_cargo, sucx_4.id_suc, sucx_4.suc_id_cargo
  • Buffers: shared hit=5048
148. 2.520 2.520 ↑ 1.0 1 840

Index Scan using idx_id_udt on public.t_adm_sv_unidades_dias_turnos udtx_4 (cost=0.28..2.50 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=840)

  • Output: udtx_4.id_udt, udtx_4.udt_id_sud, udtx_4.udt_id_turno, udtx_4.udt_id_horario, udtx_4.udt_qtd_vagas, udtx_4.udt_usr_ins, udtx_4.udt_usr_upd, udtx_4.udt_usr_dt_ins, udtx_4.udt_usr_dt_upd, udtx_4.reg_exclu (...)
  • Index Cond: (udtx_4.id_udt = udt.id_udt)
  • Buffers: shared hit=2524
149. 2.520 2.520 ↑ 1.0 1 840

Index Scan using idx_suc_id_udt on public.t_adm_sv_unidades_dias_turnos_cargos sucx_4 (cost=0.28..2.50 rows=1 width=20) (actual time=0.002..0.003 rows=1 loops=840)

  • Output: sucx_4.id_suc, sucx_4.suc_id_udt, sucx_4.suc_tipo_vaga, sucx_4.suc_id_jornada, sucx_4.suc_id_cargo, sucx_4.suc_qtd_vagas_cargo, sucx_4.suc_obs_vagas, sucx_4.suc_usr_ins, sucx_4.suc_usr_upd, sucx_4.suc_u (...)
  • Index Cond: (sucx_4.suc_id_udt = udt.id_udt)
  • Filter: (sucx_4.reg_exclusao = 0)
  • Buffers: shared hit=2524
150. 2.520 2.520 ↑ 1.0 3 840

Seq Scan on public.t_adm_controle_sv_cargos svx_1 (cost=0.00..1.03 rows=3 width=8) (actual time=0.003..0.003 rows=3 loops=840)

  • Output: svx_1.id_svc, svx_1.svc_id_svp, svx_1.svc_id_cargo, svx_1.svc_usr_ins, svx_1.svc_usr_upd, svx_1.svc_usr_dt_ins, svx_1.svc_usr_dt_upd, svx_1.reg_exclusao
  • Buffers: shared hit=840
151.          

SubPlan (forNested Loop Left Join)

152. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..6.32 rows=1 width=4) (never executed)

  • Output: (CASE WHEN (txx_1.udt_qtd_vagas IS NOT NULL) THEN txx_1.udt_qtd_vagas ELSE 0 END)
153. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..6.32 rows=1 width=4) (never executed)

  • Output: CASE WHEN (txx_1.udt_qtd_vagas IS NOT NULL) THEN txx_1.udt_qtd_vagas ELSE 0 END
  • Join Filter: (cxx_1.suc_id_cargo = svcx_1.id_svc)
154. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..5.27 rows=1 width=8) (never executed)

  • Output: cxx_1.suc_id_cargo, txx_1.udt_qtd_vagas
155. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..4.22 rows=1 width=12) (never executed)

  • Output: cxx_1.suc_tipo_vaga, cxx_1.suc_id_cargo, txx_1.udt_qtd_vagas
156. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..3.91 rows=1 width=16) (never executed)

  • Output: cxx_1.suc_tipo_vaga, cxx_1.suc_id_cargo, txx_1.udt_qtd_vagas, txx_1.udt_id_sud
157. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_suc_tipo_vaga on public.t_adm_sv_unidades_dias_turnos_cargos cxx_1 (cost=0.28..1.40 rows=1 width=12) (never executed)

  • Output: cxx_1.id_suc, cxx_1.suc_id_udt, cxx_1.suc_tipo_vaga, cxx_1.suc_id_jornada, cxx_1.suc_id_cargo, cxx_1.suc_qtd_vagas_cargo, cxx_1.suc_obs_vagas, cxx_1.suc_usr_ins, cxx_1.suc_usr_ (...)
  • Index Cond: (cxx_1.suc_tipo_vaga = 2)
  • Filter: ((cxx_1.reg_exclusao = 0) AND (cxx_1.id_suc = sucx_4.id_suc))
158. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_id_udt on public.t_adm_sv_unidades_dias_turnos txx_1 (cost=0.28..2.50 rows=1 width=12) (never executed)

  • Output: txx_1.id_udt, txx_1.udt_id_sud, txx_1.udt_id_turno, txx_1.udt_id_horario, txx_1.udt_qtd_vagas, txx_1.udt_usr_ins, txx_1.udt_usr_upd, txx_1.udt_usr_dt_ins, txx_1.udt_usr_dt_upd, (...)
  • Index Cond: (txx_1.id_udt = cxx_1.suc_id_udt)
  • Filter: (txx_1.reg_exclusao = 0)
159. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_id_sud on public.t_adm_sv_unidades_dias dxx_1 (cost=0.28..0.30 rows=1 width=4) (never executed)

  • Output: dxx_1.id_sud, dxx_1.sud_id_svu, dxx_1.sud_dia, dxx_1.sud_feriado, dxx_1.sud_usr_ins, dxx_1.sud_usr_upd, dxx_1.sud_usr_dt_ins, dxx_1.sud_usr_dt_upd, dxx_1.reg_exclusao
  • Index Cond: (dxx_1.id_sud = txx_1.udt_id_sud)
  • Filter: (dxx_1.reg_exclusao = 0)
160. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_tipo_adm_sv_vagas vxx_1 (cost=0.00..1.04 rows=1 width=4) (never executed)

  • Output: vxx_1.id_svv, vxx_1.svv_descricao, vxx_1.svv_usr_ins, vxx_1.svv_usr_upd, vxx_1.svv_usr_dt_ins, vxx_1.svv_usr_dt_upd, vxx_1.reg_exclusao
  • Filter: (vxx_1.id_svv = 2)
161. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.t_adm_controle_sv_cargos svcx_1 (cost=0.00..1.04 rows=1 width=4) (never executed)

  • Output: svcx_1.id_svc, svcx_1.svc_id_svp, svcx_1.svc_id_cargo, svcx_1.svc_usr_ins, svcx_1.svc_usr_upd, svcx_1.svc_usr_dt_ins, svcx_1.svc_usr_dt_upd, svcx_1.reg_exclusao
  • Filter: (svcx_1.svc_id_cargo = fnp.fnc_id_cargo)
162. 3.360 3.360 ↑ 1.0 1 840

Index Scan using idx_und_seq_und on public.t_unidade und (cost=0.14..1.12 rows=1 width=18) (actual time=0.004..0.004 rows=1 loops=840)

  • Output: und.und_seq_und, und.und_nome, und.und_endereco, und.und_fone, und.und_bairro, und.und_cidade, und.und_cep, und.und_diretor, und.und_capacidade, und.und_vagas, und.und_contato, und.und_dat_inclu, und.und_hor_inclu, und.und (...)
  • Index Cond: (und.und_seq_und = ((und_1.und_seq_und)::integer))
  • Buffers: shared hit=1680