explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N85w : fat

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

Sort (cost=6,801.47..6,801.48 rows=2 width=886) (actual rows= loops=)

  • Sort Key: faturamento.vinculo, faturamento.veic_placa
2. 0.000 0.000 ↓ 0.0

Subquery Scan on faturamento (cost=4,168.42..6,801.46 rows=2 width=886) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Append (cost=4,168.42..6,801.28 rows=2 width=890) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=4,168.42..4,169.51 rows=1 width=391) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=4,168.42..4,169.49 rows=1 width=410) (actual rows= loops=)

  • Group Key: veiculo.veic_placa, veiculo.veic_frota, veiculo.tfat_valor, veiculo.tfat_tipo_cobranca, veiculo.equipamento, veiculo.vinculo, veiculo.codempresa, veiculo.completarcobranca, veiculo.diascomproblema, veiculo.tipocobrancafixo, veiculo.cobrancafixo, veiculo.tipocobrancaagregado, veiculo.cobrancaagregado, veiculo.tipocobrancaterceiro, veiculo.cobrancaterceiro, veiculo.proprietario, veiculo.diasproporcional, veiculo.diasmescontabil, veiculo.fger_valor, veiculo.diasacobrar, veiculo.fger_tipo_cobranca
  • Filter: (count(veiculo.datateste) > 0)
6. 0.000 0.000 ↓ 0.0

Sort (cost=4,168.42..4,168.42 rows=1 width=242) (actual rows= loops=)

  • Sort Key: veiculo.veic_placa, veiculo.veic_frota, veiculo.tfat_valor, veiculo.tfat_tipo_cobranca, veiculo.equipamento, veiculo.vinculo, veiculo.completarcobranca, veiculo.diascomproblema, veiculo.tipocobrancafixo, veiculo.cobrancafixo, veiculo.tipocobrancaagregado, veiculo.cobrancaagregado, veiculo.tipocobrancaterceiro, veiculo.cobrancaterceiro, veiculo.proprietario, veiculo.diasproporcional, veiculo.diasmescontabil, veiculo.fger_valor, veiculo.diasacobrar, veiculo.fger_tipo_cobranca
7. 0.000 0.000 ↓ 0.0

Subquery Scan on veiculo (cost=3,711.83..4,168.41 rows=1 width=242) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Group (cost=3,711.83..4,168.40 rows=1 width=253) (actual rows= loops=)

  • Group Key: veic.veic_placa, veic.veic_frota, tpfa.tpfa_data_posicao, tfat.tfat_dias_cobranca_proporcional, tfat.tfat_tipo_cobranca, tfat.tfat_valor, tecn.tecn_descricao, tvco.tvco_descricao, tran.tran_pess_oras_codigo, tfat.tfat_completar_cobranca, f.tfat_tipo_cobranca, f.tfat_valor, a.tfat_tipo_cobranca, a.tfat_valor, t.tfat_tipo_cobranca, t.tfat_valor, pesspropri.pess_nome, term.term_numero_terminal, tfat.tfat_dias_mes_contabil, fger.fger_valor, ((SubPlan 1)), fger.fger_tipo_cobranca
9. 0.000 0.000 ↓ 0.0

Sort (cost=3,711.83..3,711.83 rows=1 width=245) (actual rows= loops=)

  • Sort Key: veic.veic_placa, veic.veic_frota, tpfa.tpfa_data_posicao, tfat.tfat_dias_cobranca_proporcional, tfat.tfat_tipo_cobranca, tfat.tfat_valor, tecn.tecn_descricao, tvco.tvco_descricao, tfat.tfat_completar_cobranca, f.tfat_tipo_cobranca, f.tfat_valor, a.tfat_tipo_cobranca, a.tfat_valor, t.tfat_tipo_cobranca, t.tfat_valor, pesspropri.pess_nome, term.term_numero_terminal, tfat.tfat_dias_mes_contabil, fger.fger_valor, ((SubPlan 1)), fger.fger_tipo_cobranca
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=405.03..3,711.82 rows=1 width=245) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=404.89..3,255.35 rows=1 width=241) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=404.61..3,255.06 rows=1 width=241) (actual rows= loops=)

  • Join Filter: (orte.orte_term_codigo = tpfa.tpfa_term_codigo)
13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=404.19..3,254.47 rows=1 width=245) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Nested Loop (cost=403.77..3,253.48 rows=1 width=226) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Nested Loop (cost=403.50..3,245.18 rows=1 width=218) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=403.21..3,244.45 rows=2 width=218) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Nested Loop (cost=402.92..3,243.62 rows=2 width=198) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..20.91 rows=1 width=20) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..12.60 rows=1 width=12) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Index Only Scan using tran_transportador_dx_1001 on tran_transportador tran (cost=0.28..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (tran_pess_oras_codigo = 158220)
21. 0.000 0.000 ↓ 0.0

Index Scan using tfat_transportador_f_idx_70451 on tfat_transportador_faturamento f (cost=0.28..8.29 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((tfat_tran_pess_oras_codigo = 158220) AND (tfat_tvco_codigo = 1))
22. 0.000 0.000 ↓ 0.0

Index Scan using tfat_transportador_f_idx_70451 on tfat_transportador_faturamento a (cost=0.28..8.29 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((tfat_tran_pess_oras_codigo = 158220) AND (tfat_tvco_codigo = 2))
23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=402.09..3,222.69 rows=2 width=182) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Nested Loop (cost=401.80..3,201.44 rows=3 width=160) (actual rows= loops=)

  • Join Filter: (tvco.tvco_codigo = fger.fger_tvco_codigo)
25. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.30..12.56 rows=3 width=148) (actual rows= loops=)

  • Join Filter: (tvco.tvco_codigo = tfat.tfat_tvco_codigo)
26. 0.000 0.000 ↓ 0.0

Seq Scan on tvco_tipo_vinculo_contratual tvco (cost=0.00..1.03 rows=3 width=122) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Materialize (cost=4.30..11.42 rows=3 width=26) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on tfat_transportador_faturamento tfat (cost=4.30..11.41 rows=3 width=26) (actual rows= loops=)

  • Recheck Cond: (tfat_tran_pess_oras_codigo = 158220)
29. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on beg_tfat_transportador_faturamento_tfat_tran_pess_oras_codigo_i (cost=0.00..4.30 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (tfat_tran_pess_oras_codigo = 158220)
30. 0.000 0.000 ↓ 0.0

Materialize (cost=397.50..3,184.72 rows=98 width=20) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Append (cost=397.50..3,184.23 rows=98 width=20) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora fger (cost=397.50..589.02 rows=1 width=68) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
33. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=397.50..397.50 rows=49 width=0) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02 (cost=0.00..186.31 rows=9,851 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
35. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05 (cost=0.00..210.94 rows=9,851 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
36. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_01 fger_1 (cost=80.53..95.86 rows=3 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
37. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=80.53..80.53 rows=4 width=0) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_01 (cost=0.00..4.82 rows=70 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
39. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_01 (cost=0.00..75.46 rows=3,117 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
40. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_02 fger_2 (cost=79.90..95.26 rows=3 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
41. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=79.90..79.90 rows=4 width=0) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_02 (cost=0.00..4.88 rows=78 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
43. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_02 (cost=0.00..74.77 rows=3,048 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
44. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg05_03 on fger_faturamento_gerenciadora_03 fger_3 (cost=0.29..8.32 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_pess_oras_codigo = 158220) AND ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[])))
45. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_04 fger_4 (cost=88.67..104.00 rows=4 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
46. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=88.67..88.67 rows=4 width=0) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_04 (cost=0.00..4.84 rows=74 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
48. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_04 (cost=0.00..83.57 rows=3,528 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
49. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_05 fger_5 (cost=87.48..102.84 rows=4 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
50. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=87.48..87.48 rows=4 width=0) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_05 (cost=0.00..4.87 rows=77 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
52. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_05 (cost=0.00..82.36 rows=3,407 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
53. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_06 fger_6 (cost=86.87..102.24 rows=4 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
54. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=86.87..86.87 rows=4 width=0) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_06 (cost=0.00..4.91 rows=82 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
56. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_06 (cost=0.00..81.71 rows=3,342 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
57. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_07 fger_7 (cost=88.33..107.39 rows=4 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
58. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=88.33..88.33 rows=5 width=0) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_07 (cost=0.00..4.86 rows=76 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
60. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_07 (cost=0.00..83.22 rows=3,493 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
61. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_08 fger_8 (cost=88.23..103.57 rows=4 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
62. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=88.23..88.23 rows=4 width=0) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_08 (cost=0.00..4.84 rows=73 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
64. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_08 (cost=0.00..83.14 rows=3,485 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
65. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_09 fger_9 (cost=88.10..107.15 rows=4 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
66. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=88.10..88.10 rows=5 width=0) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_09 (cost=0.00..4.87 rows=77 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
68. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_09 (cost=0.00..82.98 rows=3,469 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
69. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_10 fger_10 (cost=81.42..96.78 rows=3 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
70. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=81.42..81.42 rows=4 width=0) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_10 (cost=0.00..4.89 rows=80 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
72. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_10 (cost=0.00..76.28 rows=3,199 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
73. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_11 fger_11 (cost=89.61..104.95 rows=4 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
74. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=89.61..89.61 rows=4 width=0) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_11 (cost=0.00..4.83 rows=72 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
76. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_11 (cost=0.00..84.53 rows=3,624 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
77. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_12 fger_12 (cost=93.86..112.92 rows=5 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
78. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=93.86..93.86 rows=5 width=0) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_12 (cost=0.00..4.88 rows=79 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
80. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_12 (cost=0.00..88.72 rows=3,643 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
81. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_13 fger_13 (cost=88.49..103.84 rows=4 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
82. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=88.49..88.49 rows=4 width=0) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_13 (cost=0.00..4.87 rows=77 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
84. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_13 (cost=0.00..83.37 rows=3,508 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
85. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_14 fger_14 (cost=92.93..108.30 rows=4 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
86. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=92.93..92.93 rows=4 width=0) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_14 (cost=0.00..4.89 rows=80 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
88. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_14 (cost=0.00..87.79 rows=3,550 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
89. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_15 fger_15 (cost=93.85..112.95 rows=4 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
90. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=93.85..93.85 rows=5 width=0) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_15 (cost=0.00..4.91 rows=83 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
92. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_15 (cost=0.00..88.69 rows=3,640 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
93. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_16 fger_16 (cost=89.27..104.64 rows=4 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
94. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=89.27..89.27 rows=4 width=0) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_16 (cost=0.00..4.85 rows=75 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
96. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_16 (cost=0.00..84.17 rows=3,588 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
97. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg05_17 on fger_faturamento_gerenciadora_17 fger_17 (cost=0.29..8.32 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_pess_oras_codigo = 158220) AND ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[])))
98. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg05_18 on fger_faturamento_gerenciadora_18 fger_18 (cost=0.29..8.32 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_pess_oras_codigo = 158220) AND ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[])))
99. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_19 fger_19 (cost=88.35..103.72 rows=4 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
100. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=88.35..88.35 rows=4 width=0) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_19 (cost=0.00..4.90 rows=81 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
102. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_19 (cost=0.00..83.20 rows=3,491 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
103. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_20 fger_20 (cost=80.27..95.63 rows=3 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
104. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=80.27..80.27 rows=4 width=0) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_20 (cost=0.00..4.86 rows=76 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
106. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_20 (cost=0.00..75.16 rows=3,087 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
107. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg05_21 on fger_faturamento_gerenciadora_21 fger_21 (cost=0.29..8.32 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_pess_oras_codigo = 158220) AND ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[])))
108. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_22 fger_22 (cost=82.22..97.57 rows=4 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
109. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=82.22..82.22 rows=4 width=0) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_22 (cost=0.00..4.87 rows=77 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
111. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_22 (cost=0.00..77.10 rows=3,281 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
112. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_23 fger_23 (cost=81.56..96.91 rows=3 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
113. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=81.56..81.56 rows=4 width=0) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_23 (cost=0.00..4.86 rows=76 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
115. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_23 (cost=0.00..76.45 rows=3,216 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
116. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_24 fger_24 (cost=80.93..96.30 rows=3 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
117. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=80.93..80.93 rows=4 width=0) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_24 (cost=0.00..4.86 rows=76 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
119. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_24 (cost=0.00..75.82 rows=3,153 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
120. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_25 fger_25 (cost=81.47..96.84 rows=3 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
121. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=81.47..81.47 rows=4 width=0) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_25 (cost=0.00..4.90 rows=81 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
123. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_25 (cost=0.00..76.32 rows=3,203 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
124. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg05_26 on fger_faturamento_gerenciadora_26 fger_26 (cost=0.29..8.32 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_pess_oras_codigo = 158220) AND ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[])))
125. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_27 fger_27 (cost=82.35..97.72 rows=3 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
126. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=82.35..82.35 rows=4 width=0) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_27 (cost=0.00..4.90 rows=81 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
128. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_27 (cost=0.00..77.20 rows=3,291 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
129. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_28 fger_28 (cost=82.50..97.87 rows=3 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
130. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=82.50..82.50 rows=4 width=0) (actual rows= loops=)

131. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_28 (cost=0.00..4.89 rows=80 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
132. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_28 (cost=0.00..77.36 rows=3,307 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
133. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_29 fger_29 (cost=82.61..97.96 rows=3 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
134. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=82.61..82.61 rows=4 width=0) (actual rows= loops=)

135. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_29 (cost=0.00..4.86 rows=76 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
136. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_29 (cost=0.00..77.50 rows=3,321 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
137. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora_30 fger_30 (cost=86.84..102.09 rows=4 width=20) (actual rows= loops=)

  • Recheck Cond: ((fger_pess_oras_codigo = 158220) AND (fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[]))
138. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=86.84..86.84 rows=4 width=0) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg02_30 (cost=0.00..4.73 rows=59 width=0) (actual rows= loops=)

  • Index Cond: (fger_pess_oras_codigo = 158220)
140. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg05_30 (cost=0.00..81.86 rows=3,357 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
141. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg05_31 on fger_faturamento_gerenciadora_31 fger_31 (cost=0.29..8.31 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_pess_oras_codigo = 158220) AND ((fger_tipo_cobranca)::text = ANY ('{ME,DP,DPT,VI}'::text[])))
142. 0.000 0.000 ↓ 0.0

Index Scan using veic_veiculo_idx_10000 on veic_veiculo veic (cost=0.29..7.09 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (veic_oras_codigo = fger.fger_oras_codigo)
  • Filter: (veic_tvei_codigo <> 1)
143. 0.000 0.000 ↓ 0.0

Index Scan using pess_oras_codigo_idx on pess_pessoa pesspropri (cost=0.29..0.42 rows=1 width=28) (actual rows= loops=)

  • Index Cond: (veic.veic_pess_oras_codigo_propri = pess_oras_codigo)
144. 0.000 0.000 ↓ 0.0

Index Only Scan using orte_objeto_rastreado_termina_idx1 on orte_objeto_rastreado_termina orte (cost=0.29..0.35 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((orte_oras_codigo = veic.veic_oras_codigo) AND (orte_sequencia = 'P'::text))
145. 0.000 0.000 ↓ 0.0

Index Scan using tfat_transportador_f_idx_70451 on tfat_transportador_faturamento t (cost=0.28..8.29 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((tfat_tran_pess_oras_codigo = 158220) AND (tfat_tvco_codigo = 3))
146. 0.000 0.000 ↓ 0.0

Index Scan using term_terminal_pkey on term_terminal term (cost=0.42..0.99 rows=1 width=19) (actual rows= loops=)

  • Index Cond: (term_codigo = orte.orte_term_codigo)
147. 0.000 0.000 ↓ 0.0

Index Only Scan using tpfa_terminal_posicao_faturamento_idx_70356 on tpfa_terminal_posicao_faturamento tpfa (cost=0.42..0.58 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((tpfa_term_codigo = term.term_codigo) AND (tpfa_data_posicao >= '2020-04-20'::date) AND (tpfa_data_posicao <= '2020-05-20'::date))
148. 0.000 0.000 ↓ 0.0

Index Scan using vtec_versao_tecnolog_idx_70503 on vtec_versao_tecnologia (cost=0.27..0.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (vtec_codigo = term.term_vtec_codigo)
149. 0.000 0.000 ↓ 0.0

Index Scan using tecn_tecnologia_pkey on tecn_tecnologia tecn (cost=0.14..0.20 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (tecn_codigo = vtec_versao_tecnologia.vtec_tecn_codigo)
150.          

SubPlan (for Nested Loop)

151. 0.000 0.000 ↓ 0.0

Aggregate (cost=456.25..456.26 rows=1 width=8) (actual rows= loops=)

152. 0.000 0.000 ↓ 0.0

Append (cost=191.48..456.17 rows=32 width=0) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on fger_faturamento_gerenciadora (cost=191.48..195.50 rows=1 width=0) (actual rows= loops=)

  • Recheck Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text))
154. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=191.48..191.48 rows=1 width=0) (actual rows= loops=)

155. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg07 (cost=0.00..4.92 rows=49 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
156. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_fger_faturamento_gerenciadora_beg03 (cost=0.00..186.31 rows=9,851 width=0) (actual rows= loops=)

  • Index Cond: (fger_tvco_codigo = fger.fger_tvco_codigo)
157. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_01 on fger_faturamento_gerenciadora_01 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
158. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_02 on fger_faturamento_gerenciadora_02 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
159. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg05_03 on fger_faturamento_gerenciadora_03 (cost=0.29..8.32 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
160. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_04 on fger_faturamento_gerenciadora_04 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
161. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_05 on fger_faturamento_gerenciadora_05 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
162. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_06 on fger_faturamento_gerenciadora_06 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
163. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_07 on fger_faturamento_gerenciadora_07 (cost=0.29..8.32 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
164. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_08 on fger_faturamento_gerenciadora_08 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
165. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_09 on fger_faturamento_gerenciadora_09 (cost=0.29..8.32 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
166. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_10 on fger_faturamento_gerenciadora_10 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
167. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_11 on fger_faturamento_gerenciadora_11 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
168. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_12 on fger_faturamento_gerenciadora_12 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
169. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_13 on fger_faturamento_gerenciadora_13 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
170. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_14 on fger_faturamento_gerenciadora_14 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
171. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_15 on fger_faturamento_gerenciadora_15 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
172. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_16 on fger_faturamento_gerenciadora_16 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
173. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg05_17 on fger_faturamento_gerenciadora_17 (cost=0.29..8.32 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
174. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg05_18 on fger_faturamento_gerenciadora_18 (cost=0.29..8.32 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
175. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_19 on fger_faturamento_gerenciadora_19 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
176. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_20 on fger_faturamento_gerenciadora_20 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
177. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg05_21 on fger_faturamento_gerenciadora_21 (cost=0.29..8.32 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
178. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_22 on fger_faturamento_gerenciadora_22 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
179. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_23 on fger_faturamento_gerenciadora_23 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
180. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_24 on fger_faturamento_gerenciadora_24 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
181. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_25 on fger_faturamento_gerenciadora_25 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
182. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg05_26 on fger_faturamento_gerenciadora_26 (cost=0.29..8.32 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
183. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_27 on fger_faturamento_gerenciadora_27 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
184. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_28 on fger_faturamento_gerenciadora_28 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
185. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_29 on fger_faturamento_gerenciadora_29 (cost=0.41..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
186. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_30 on fger_faturamento_gerenciadora_30 (cost=0.29..8.32 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
187. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg05_31 on fger_faturamento_gerenciadora_31 (cost=0.29..8.32 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone))
  • Filter: ((fger_oras_codigo = fger.fger_oras_codigo) AND (fger_pess_oras_codigo = fger.fger_pess_oras_codigo) AND ((fger_tipo_cobranca)::text = (fger.fger_tipo_cobranca)::text) AND (fger_tvco_codigo = fger.fger_tvco_codigo))
188. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=2,630.42..2,631.78 rows=1 width=499) (actual rows= loops=)

189. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=2,630.42..2,631.77 rows=1 width=563) (actual rows= loops=)

  • Group Key: veic_1.veic_placa, veic_1.veic_frota, tfat_1.tfat_tipo_cobranca, tfat_1.tfat_valor, tecn_1.tecn_descricao, tvco_1.tvco_descricao, tran_1.tran_pess_oras_codigo, tfat_1.tfat_dias_cobranca_proporcional, tfat_1.tfat_completar_cobranca, f_1.tfat_tipo_cobranca, f_1.tfat_valor, a_1.tfat_tipo_cobranca, a_1.tfat_valor, t_1.tfat_tipo_cobranca, t_1.tfat_valor, term_1.term_numero_terminal, pesspropri_1.pess_nome, tfat_1.tfat_dias_mes_contabil, fger_32.fger_valor, fger_32.fger_tipo_cobranca, viag.viag_internacional, tfat_1.tfat_valor_viag_internacional, f_1.tfat_valor_viag_internacional, a_1.tfat_valor_viag_internacional, t_1.tfat_valor_viag_internacional
190. 0.000 0.000 ↓ 0.0

Sort (cost=2,630.42..2,630.42 rows=1 width=261) (actual rows= loops=)

  • Sort Key: veic_1.veic_placa, veic_1.veic_frota, tfat_1.tfat_tipo_cobranca, tfat_1.tfat_valor, tecn_1.tecn_descricao, tvco_1.tvco_descricao, tfat_1.tfat_dias_cobranca_proporcional, tfat_1.tfat_completar_cobranca, f_1.tfat_tipo_cobranca, f_1.tfat_valor, a_1.tfat_tipo_cobranca, a_1.tfat_valor, t_1.tfat_tipo_cobranca, t_1.tfat_valor, term_1.term_numero_terminal, pesspropri_1.pess_nome, tfat_1.tfat_dias_mes_contabil, fger_32.fger_valor, viag.viag_internacional, tfat_1.tfat_valor_viag_internacional, f_1.tfat_valor_viag_internacional, a_1.tfat_valor_viag_internacional, t_1.tfat_valor_viag_internacional
191. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,317.32..2,630.41 rows=1 width=261) (actual rows= loops=)

  • Filter: (vest.vest_codigo IS NULL)
192. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,317.03..2,621.50 rows=1 width=265) (actual rows= loops=)

193. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,316.74..2,621.08 rows=1 width=269) (actual rows= loops=)

194. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,316.45..2,620.22 rows=1 width=277) (actual rows= loops=)

195. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,316.16..2,619.80 rows=1 width=281) (actual rows= loops=)

196. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,315.87..2,618.93 rows=1 width=273) (actual rows= loops=)

197. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,315.73..2,618.73 rows=1 width=265) (actual rows= loops=)

198. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,315.45..2,618.44 rows=1 width=265) (actual rows= loops=)

199. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,315.04..2,616.63 rows=1 width=254) (actual rows= loops=)

200. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,314.75..2,616.14 rows=1 width=246) (actual rows= loops=)

201. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,314.48..2,607.83 rows=1 width=234) (actual rows= loops=)

202. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,314.20..2,599.53 rows=1 width=222) (actual rows= loops=)

203. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,313.93..2,591.22 rows=1 width=210) (actual rows= loops=)

204. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,313.65..2,590.89 rows=1 width=196) (actual rows= loops=)

  • Join Filter: (fger_32.fger_tvco_codigo = tvco_1.tvco_codigo)
205. 0.000 0.000 ↓ 0.0

Index Scan using tvco_tipo_vinculo_contratual_pkey on tvco_tipo_vinculo_contratual tvco_1 (cost=0.13..12.18 rows=3 width=122) (actual rows= loops=)

206. 0.000 0.000 ↓ 0.0

Materialize (cost=1,313.52..2,578.67 rows=1 width=74) (actual rows= loops=)

207. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,313.52..2,578.67 rows=1 width=74) (actual rows= loops=)

208. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,313.23..2,578.29 rows=1 width=54) (actual rows= loops=)

209. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,312.95..2,573.98 rows=1 width=58) (actual rows= loops=)

210. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,312.52..2,030.91 rows=3 width=54) (actual rows= loops=)

211. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,312.23..2,027.47 rows=4 width=32) (actual rows= loops=)

212. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,311.94..1,956.12 rows=109 width=24) (actual rows= loops=)

  • Hash Cond: (vvei.vvei_viag_codigo = viag.viag_codigo)
213. 0.000 0.000 ↓ 0.0

Seq Scan on vvei_viagem_veiculo vvei (cost=0.00..620.18 rows=9,142 width=8) (actual rows= loops=)

  • Filter: (((vvei_precedencia)::text = '1'::text) AND ((vvei_ativo)::text = 'S'::text))
214. 0.000 0.000 ↓ 0.0

Hash (cost=1,303.75..1,303.75 rows=655 width=16) (actual rows= loops=)

215. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on viag_viagem viag (cost=21.37..1,303.75 rows=655 width=16) (actual rows= loops=)

  • Recheck Cond: (viag_tran_pess_oras_codigo = 158220)
216. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on beg_viag_viagem_viag_tran_pess_oras_codigo_i (cost=0.00..21.20 rows=655 width=0) (actual rows= loops=)

  • Index Cond: (viag_tran_pess_oras_codigo = 158220)
217. 0.000 0.000 ↓ 0.0

Index Only Scan using vtra_veiculo_transportador_idx on vtra_veiculo_transportador (cost=0.29..0.65 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((vtra_tran_pess_oras_codigo = 158220) AND (vtra_veic_oras_codigo = vvei.vvei_veic_oras_codigo))
218. 0.000 0.000 ↓ 0.0

Index Scan using veic_veiculo_idx_10000 on veic_veiculo veic_1 (cost=0.29..0.86 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (veic_oras_codigo = vvei.vvei_veic_oras_codigo)
219. 0.000 0.000 ↓ 0.0

Append (cost=0.43..180.70 rows=32 width=21) (actual rows= loops=)

220. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07 on fger_faturamento_gerenciadora fger_32 (cost=0.43..142.62 rows=1 width=68) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
221. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_01 on fger_faturamento_gerenciadora_01 fger_33 (cost=0.41..1.22 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
222. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_02 on fger_faturamento_gerenciadora_02 fger_34 (cost=0.41..1.29 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
223. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_03 on fger_faturamento_gerenciadora_03 fger_35 (cost=0.41..1.28 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
224. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_04 on fger_faturamento_gerenciadora_04 fger_36 (cost=0.41..1.22 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
225. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_05 on fger_faturamento_gerenciadora_05 fger_37 (cost=0.41..1.26 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
226. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_06 on fger_faturamento_gerenciadora_06 fger_38 (cost=0.41..1.30 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
227. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_07 on fger_faturamento_gerenciadora_07 fger_39 (cost=0.29..1.09 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
228. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_08 on fger_faturamento_gerenciadora_08 fger_40 (cost=0.41..1.22 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
229. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_09 on fger_faturamento_gerenciadora_09 fger_41 (cost=0.29..1.08 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
230. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_10 on fger_faturamento_gerenciadora_10 fger_42 (cost=0.41..1.27 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
231. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_11 on fger_faturamento_gerenciadora_11 fger_43 (cost=0.41..1.23 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
232. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_12 on fger_faturamento_gerenciadora_12 fger_44 (cost=0.41..1.24 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
233. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_13 on fger_faturamento_gerenciadora_13 fger_45 (cost=0.41..1.25 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
234. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_14 on fger_faturamento_gerenciadora_14 fger_46 (cost=0.41..1.28 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
235. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_15 on fger_faturamento_gerenciadora_15 fger_47 (cost=0.41..1.28 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
236. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_16 on fger_faturamento_gerenciadora_16 fger_48 (cost=0.41..1.29 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
237. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_17 on fger_faturamento_gerenciadora_17 fger_49 (cost=0.41..1.23 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
238. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_18 on fger_faturamento_gerenciadora_18 fger_50 (cost=0.41..1.29 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
239. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_19 on fger_faturamento_gerenciadora_19 fger_51 (cost=0.41..1.30 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
240. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_20 on fger_faturamento_gerenciadora_20 fger_52 (cost=0.41..1.26 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
241. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_21 on fger_faturamento_gerenciadora_21 fger_53 (cost=0.41..1.26 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
242. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_22 on fger_faturamento_gerenciadora_22 fger_54 (cost=0.41..1.26 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
243. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_23 on fger_faturamento_gerenciadora_23 fger_55 (cost=0.41..1.26 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
244. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_24 on fger_faturamento_gerenciadora_24 fger_56 (cost=0.41..1.28 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
245. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_25 on fger_faturamento_gerenciadora_25 fger_57 (cost=0.41..1.29 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
246. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_26 on fger_faturamento_gerenciadora_26 fger_58 (cost=0.41..1.30 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
247. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_27 on fger_faturamento_gerenciadora_27 fger_59 (cost=0.41..1.31 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
248. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_28 on fger_faturamento_gerenciadora_28 fger_60 (cost=0.41..1.31 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
249. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_29 on fger_faturamento_gerenciadora_29 fger_61 (cost=0.41..1.26 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
250. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_30 on fger_faturamento_gerenciadora_30 fger_62 (cost=0.29..0.96 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
251. 0.000 0.000 ↓ 0.0

Index Scan using idx_fger_faturamento_gerenciadora_beg07_31 on fger_faturamento_gerenciadora_31 fger_63 (cost=0.29..0.73 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((fger_oras_codigo = vvei.vvei_veic_oras_codigo) AND (fger_viag_codigo = vvei.vvei_viag_codigo) AND (fger_viag_codigo IS NOT NULL))
  • Filter: ((fger_data_cadastro >= '2020-04-20 00:00:00'::timestamp without time zone) AND (fger_data_cadastro <= '2020-05-20 23:59:59'::timestamp without time zone) AND ((fger_tipo_cobranca)::text = 'VI'::text))
252. 0.000 0.000 ↓ 0.0

Index Only Scan using tran_transportador_dx_1001 on tran_transportador tran_1 (cost=0.28..4.30 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (tran_pess_oras_codigo = 158220)
253. 0.000 0.000 ↓ 0.0

Index Scan using pess_oras_codigo_idx on pess_pessoa pesspropri_1 (cost=0.29..0.37 rows=1 width=28) (actual rows= loops=)

  • Index Cond: (veic_1.veic_pess_oras_codigo_propri = pess_oras_codigo)
254. 0.000 0.000 ↓ 0.0

Index Scan using tfat_transportador_f_idx_70451 on tfat_transportador_faturamento tfat_1 (cost=0.28..0.31 rows=1 width=30) (actual rows= loops=)

  • Index Cond: ((tfat_tran_pess_oras_codigo = 158220) AND (tfat_tvco_codigo = fger_32.fger_tvco_codigo))
255. 0.000 0.000 ↓ 0.0

Index Scan using tfat_transportador_f_idx_70451 on tfat_transportador_faturamento f_1 (cost=0.28..8.29 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((tfat_tran_pess_oras_codigo = 158220) AND (tfat_tvco_codigo = 1))
256. 0.000 0.000 ↓ 0.0

Index Scan using tfat_transportador_f_idx_70451 on tfat_transportador_faturamento a_1 (cost=0.28..8.29 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((tfat_tran_pess_oras_codigo = 158220) AND (tfat_tvco_codigo = 2))
257. 0.000 0.000 ↓ 0.0

Index Scan using tfat_transportador_f_idx_70451 on tfat_transportador_faturamento t_1 (cost=0.28..8.29 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((tfat_tran_pess_oras_codigo = 158220) AND (tfat_tvco_codigo = 3))
258. 0.000 0.000 ↓ 0.0

Index Scan using vter_viagem_terminal_idx1 on vter_viagem_terminal vter (cost=0.29..0.48 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((vter_viag_codigo = vvei.vvei_viag_codigo) AND (vter_ativo = 'S'::bpchar))
  • Filter: ((vter_precedencia)::text = '1'::text)
259. 0.000 0.000 ↓ 0.0

Index Scan using term_terminal_pkey on term_terminal term_1 (cost=0.42..1.81 rows=1 width=19) (actual rows= loops=)

  • Index Cond: (term_codigo = vter.vter_term_codigo)
260. 0.000 0.000 ↓ 0.0

Index Scan using vtec_versao_tecnolog_idx_70503 on vtec_versao_tecnologia vtec_versao_tecnologia_1 (cost=0.27..0.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (vtec_codigo = term_1.term_vtec_codigo)
261. 0.000 0.000 ↓ 0.0

Index Scan using tecn_tecnologia_pkey on tecn_tecnologia tecn_1 (cost=0.14..0.20 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (tecn_codigo = vtec_versao_tecnologia_1.vtec_tecn_codigo)
262. 0.000 0.000 ↓ 0.0

Index Scan using vloc_viagem_local_idx_70497 on vloc_viagem_local vlocorigem (cost=0.29..0.86 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (vloc_viag_codigo = vvei.vvei_viag_codigo)
  • Filter: (vloc_tpar_codigo = 4)
263. 0.000 0.000 ↓ 0.0

Index Only Scan using refe_codigo_idx on refe_referencia refeorigem (cost=0.29..0.41 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (refe_codigo = vlocorigem.vloc_refe_codigo)
264. 0.000 0.000 ↓ 0.0

Index Scan using vloc_viagem_local_idx_70497 on vloc_viagem_local vlocdestino (cost=0.29..0.86 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (vloc_viag_codigo = vvei.vvei_viag_codigo)
  • Filter: (vloc_tpar_codigo = 5)
265. 0.000 0.000 ↓ 0.0

Index Only Scan using refe_codigo_idx on refe_referencia refedestino (cost=0.29..0.41 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (refe_codigo = vlocdestino.vloc_refe_codigo)
266. 0.000 0.000 ↓ 0.0

Index Scan using vest_viagem_estatus_idx_10002 on vest_viagem_estatus vest (cost=0.29..8.90 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (viag.viag_codigo = vest_viag_codigo)
  • Filter: ((vest_estatus)::text = '2'::text)