explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5jZr

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.012 0.486 ↑ 5.0 1 1

Sort (cost=96.78..96.79 rows=5 width=28,576) (actual time=0.486..0.486 rows=1 loops=1)

  • Sort Key: itenscarga12_.numero_item
  • Sort Method: quicksort Memory: 27kB
2. 0.002 0.474 ↑ 5.0 1 1

Nested Loop Left Join (cost=9.33..96.72 rows=5 width=28,576) (actual time=0.468..0.474 rows=1 loops=1)

  • Join Filter: (consignata2_.processo_uuid = processo41_.uuid)
  • Rows Removed by Join Filter: 5
3. 0.002 0.467 ↑ 5.0 1 1

Nested Loop Left Join (cost=9.33..95.28 rows=5 width=27,399) (actual time=0.461..0.467 rows=1 loops=1)

  • Join Filter: (entregacar39_.mercadoria_uuid = mercadoria40_.uuid)
  • Rows Removed by Join Filter: 4
4. 0.001 0.457 ↑ 5.0 1 1

Nested Loop Left Join (cost=9.33..94.02 rows=5 width=27,078) (actual time=0.452..0.457 rows=1 loops=1)

  • Join Filter: (mercadoria27_.entrega_carga_uuid = entregacar39_.uuid)
  • Rows Removed by Join Filter: 3
5. 0.003 0.447 ↑ 5.0 1 1

Nested Loop Left Join (cost=9.33..92.76 rows=5 width=26,765) (actual time=0.441..0.447 rows=1 loops=1)

  • Join Filter: (partenotif29_.processo_uuid = processo38_.uuid)
  • Rows Removed by Join Filter: 5
6. 0.003 0.437 ↑ 5.0 1 1

Nested Loop Left Join (cost=9.33..91.32 rows=5 width=25,588) (actual time=0.431..0.437 rows=1 loops=1)

  • Join Filter: (transporta35_.processo_uuid = processo37_.uuid)
  • Rows Removed by Join Filter: 5
7. 0.002 0.425 ↑ 5.0 1 1

Nested Loop Left Join (cost=9.33..89.88 rows=5 width=24,411) (actual time=0.419..0.425 rows=1 loops=1)

  • Join Filter: (transporta35_.conhecimento_embarque_uuid = conhecimen36_.uuid)
  • Rows Removed by Join Filter: 5
8. 0.003 0.420 ↑ 5.0 1 1

Nested Loop Left Join (cost=9.33..88.36 rows=5 width=24,076) (actual time=0.414..0.420 rows=1 loops=1)

  • Join Filter: (transbordo33_.conhecimento_embarque_uuid = conhecimen34_.uuid)
  • Rows Removed by Join Filter: 5
9. 0.002 0.396 ↑ 5.0 1 1

Nested Loop Left Join (cost=8.20..85.61 rows=5 width=23,635) (actual time=0.391..0.396 rows=1 loops=1)

  • Join Filter: (procedenci31_.conhecimento_embarque_uuid = conhecimen32_.uuid)
  • Rows Removed by Join Filter: 5
10. 0.002 0.372 ↑ 5.0 1 1

Nested Loop Left Join (cost=7.06..73.32 rows=5 width=21,704) (actual time=0.367..0.372 rows=1 loops=1)

  • Join Filter: (partenotif29_.conhecimento_embarque_uuid = conhecimen30_.uuid)
  • Rows Removed by Join Filter: 5
11. 0.002 0.347 ↑ 5.0 1 1

Nested Loop Left Join (cost=5.92..70.57 rows=5 width=19,721) (actual time=0.342..0.347 rows=1 loops=1)

  • Join Filter: (conhecimen28_.parte_notificada_uuid = partenotif29_.uuid)
  • Rows Removed by Join Filter: 4
12. 0.002 0.336 ↑ 5.0 1 1

Nested Loop Left Join (cost=5.92..69.31 rows=5 width=19,524) (actual time=0.331..0.336 rows=1 loops=1)

  • Join Filter: (conhecimen10_.mercadoria_uuid = mercadoria27_.uuid)
  • Rows Removed by Join Filter: 4
13. 0.001 0.309 ↑ 5.0 1 1

Nested Loop Left Join (cost=4.86..66.90 rows=5 width=18,868) (actual time=0.304..0.309 rows=1 loops=1)

  • Join Filter: (dadoscompl24_.processo_uuid = processo25_.uuid)
  • Rows Removed by Join Filter: 5
14. 0.002 0.282 ↑ 5.0 1 1

Nested Loop Left Join (cost=3.75..64.28 rows=5 width=17,580) (actual time=0.277..0.282 rows=1 loops=1)

  • Join Filter: (manifestos20_.uuid = listatermi22_.manifesto_maritmo_uuid)
  • Rows Removed by Join Filter: 6
15. 0.002 0.270 ↑ 5.0 1 1

Nested Loop Left Join (cost=3.75..62.75 rows=5 width=17,518) (actual time=0.265..0.270 rows=1 loops=1)

  • Join Filter: (manifestoc19_.processo_uuid = processo23_.uuid)
  • Rows Removed by Join Filter: 5
16. 0.002 0.240 ↑ 5.0 1 1

Nested Loop Left Join (cost=2.63..50.79 rows=5 width=14,736) (actual time=0.235..0.240 rows=1 loops=1)

  • Join Filter: (manifestos20_.uuid = escalas21_.manifesto_maritmo_uuid)
  • Rows Removed by Join Filter: 16
17. 0.002 0.214 ↑ 2.0 1 1

Nested Loop Left Join (cost=2.63..46.11 rows=2 width=13,682) (actual time=0.209..0.214 rows=1 loops=1)

  • Join Filter: (manifestoc19_.uuid = manifestos20_.manifesto_conhecimento_uuid)
  • Rows Removed by Join Filter: 6
18. 0.001 0.201 ↑ 2.0 1 1

Nested Loop Left Join (cost=2.63..44.85 rows=2 width=13,309) (actual time=0.197..0.201 rows=1 loops=1)

  • Join Filter: (conhecimen10_.manifesto_conhecimento_uuid = manifestoc19_.uuid)
  • Rows Removed by Join Filter: 5
19. 0.003 0.191 ↑ 2.0 1 1

Nested Loop Left Join (cost=2.63..43.60 rows=2 width=13,224) (actual time=0.186..0.191 rows=1 loops=1)

  • Join Filter: (tipomercad17_.item_carga_uuid = itemcarga18_.uuid)
  • Rows Removed by Join Filter: 6
20. 0.003 0.181 ↑ 2.0 1 1

Nested Loop Left Join (cost=2.63..42.39 rows=2 width=12,914) (actual time=0.177..0.181 rows=1 loops=1)

  • Join Filter: (lacreconta15_.item_carga_uuid = itemcarga16_.uuid)
  • Rows Removed by Join Filter: 6
21. 0.002 0.147 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.52..38.73 rows=2 width=12,459) (actual time=0.143..0.147 rows=1 loops=1)

  • Join Filter: (itemcarga14_.lacre_container_uuid = lacreconta15_.uuid)
  • Rows Removed by Join Filter: 6
22. 0.008 0.135 ↑ 2.0 1 1

Nested Loop Left Join (cost=1.52..37.39 rows=2 width=12,372) (actual time=0.131..0.135 rows=1 loops=1)

  • Join Filter: (conhecimen10_.uuid = houses11_.conhecimento_embarque_uuid)
  • Rows Removed by Join Filter: 15
23. 0.006 0.123 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.52..35.05 rows=1 width=12,209) (actual time=0.118..0.123 rows=1 loops=1)

  • Join Filter: (declaracao13_.item_carga_uuid = itemcarga14_.uuid)
  • Rows Removed by Join Filter: 6
24. 0.008 0.116 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.52..33.94 rows=1 width=11,899) (actual time=0.111..0.116 rows=1 loops=1)

  • Join Filter: (itenscarga12_.declaracao_transito_container_uuid = declaracao13_.uuid)
  • Rows Removed by Join Filter: 2
25. 0.007 0.107 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.52..32.81 rows=1 width=11,262) (actual time=0.103..0.107 rows=1 loops=1)

  • Join Filter: (conhecimen10_.uuid = itenscarga12_.conhecimento_embarque_uuid)
  • Rows Removed by Join Filter: 6
26. 0.002 0.098 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.52..31.69 rows=1 width=10,952) (actual time=0.094..0.098 rows=1 loops=1)

27. 0.002 0.096 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.39..31.13 rows=1 width=10,617) (actual time=0.092..0.096 rows=1 loops=1)

28. 0.006 0.094 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.25..26.97 rows=1 width=8,493) (actual time=0.090..0.094 rows=1 loops=1)

  • Join Filter: (processo6_.conhecimento_embarque_uuid = conhecimen8_.uuid)
  • Rows Removed by Join Filter: 5
29. 0.008 0.087 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.25..25.83 rows=1 width=8,158) (actual time=0.083..0.087 rows=1 loops=1)

  • Join Filter: (conhecimen3_.desconsolidacao_uuid = desconsoli4_.uuid)
  • Rows Removed by Join Filter: 1
30. 0.002 0.077 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.25..24.77 rows=1 width=7,977) (actual time=0.074..0.077 rows=1 loops=1)

31. 0.007 0.074 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.11..16.60 rows=1 width=5,865) (actual time=0.071..0.074 rows=1 loops=1)

  • Join Filter: (embarcador5_.processo_uuid = processo6_.uuid)
  • Rows Removed by Join Filter: 6
32. 0.008 0.039 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.00..4.41 rows=1 width=3,568) (actual time=0.036..0.039 rows=1 loops=1)

  • Join Filter: (conhecimen3_.embarcador_uuid = embarcador5_.uuid)
  • Rows Removed by Join Filter: 4
33. 0.006 0.029 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.00..3.28 rows=1 width=2,379) (actual time=0.027..0.029 rows=1 loops=1)

  • Join Filter: (consignata2_.conhecimento_embarque_uuid = conhecimen3_.uuid)
  • Rows Removed by Join Filter: 4
34. 0.011 0.022 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.00..2.14 rows=1 width=2,044) (actual time=0.020..0.022 rows=1 loops=1)

  • Join Filter: (conhecimen0_.consignatario_uuid = consignata2_.uuid)
  • Rows Removed by Join Filter: 3
35. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on conhecimento_embarque conhecimen0_ (cost=0.00..1.08 rows=1 width=335) (actual time=0.008..0.009 rows=1 loops=1)

  • Filter: (uuid = '14366de5-548e-4f8e-9e1a-40cfa847311a'::uuid)
  • Rows Removed by Filter: 4
36. 0.002 0.002 ↓ 1.3 4 1

Seq Scan on consignatario consignata2_ (cost=0.00..1.03 rows=3 width=1,709) (actual time=0.002..0.002 rows=4 loops=1)

37. 0.001 0.001 ↑ 1.2 5 1

Seq Scan on conhecimento_embarque conhecimen3_ (cost=0.00..1.06 rows=6 width=335) (actual time=0.001..0.001 rows=5 loops=1)

38. 0.002 0.002 ↑ 1.2 5 1

Seq Scan on embarcador embarcador5_ (cost=0.00..1.06 rows=6 width=1,189) (actual time=0.002..0.002 rows=5 loops=1)

39. 0.012 0.028 ↓ 1.2 6 1

Hash Right Join (cost=1.11..12.13 rows=5 width=2,297) (actual time=0.023..0.028 rows=6 loops=1)

  • Hash Cond: (anexos7_.processo_uuid = processo6_.uuid)
40. 0.001 0.001 ↑ 17.5 4 1

Seq Scan on anexo anexos7_ (cost=0.00..10.70 rows=70 width=1,120) (actual time=0.001..0.001 rows=4 loops=1)

41. 0.010 0.015 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=1,177) (actual time=0.015..0.015 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
42. 0.005 0.005 ↑ 1.0 5 1

Seq Scan on processo processo6_ (cost=0.00..1.05 rows=5 width=1,177) (actual time=0.004..0.005 rows=5 loops=1)

43. 0.001 0.001 ↓ 0.0 0 1

Index Scan using carga_bloqueada_pkey on carga_bloqueada cargabloqu1_ (cost=0.14..8.15 rows=1 width=2,112) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (conhecimen0_.carga_bloqueada_uuid = uuid)
44. 0.002 0.002 ↑ 1.5 2 1

Seq Scan on desconsolidacao desconsoli4_ (cost=0.00..1.03 rows=3 width=181) (actual time=0.002..0.002 rows=2 loops=1)

45. 0.001 0.001 ↑ 1.2 5 1

Seq Scan on conhecimento_embarque conhecimen8_ (cost=0.00..1.06 rows=6 width=335) (actual time=0.001..0.001 rows=5 loops=1)

46. 0.000 0.000 ↓ 0.0 0 1

Index Scan using fretes_despesas_pkey on fretes_despesas fretesdesp9_ (cost=0.14..4.16 rows=1 width=2,124) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (conhecimen8_.fretes_despesas_uuid = uuid)
47. 0.000 0.000 ↓ 0.0 0 1

Index Scan using conhecimento_embarque_pkey on conhecimento_embarque conhecimen10_ (cost=0.13..0.55 rows=1 width=335) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (fretesdesp9_.conhecimento_embarque_uuid = uuid)
48. 0.002 0.002 ↓ 1.2 6 1

Seq Scan on item_carga itenscarga12_ (cost=0.00..1.05 rows=5 width=310) (actual time=0.002..0.002 rows=6 loops=1)

49. 0.001 0.001 ↑ 3.0 2 1

Seq Scan on declaracao_transito_container declaracao13_ (cost=0.00..1.06 rows=6 width=637) (actual time=0.001..0.001 rows=2 loops=1)

50. 0.001 0.001 ↓ 1.2 6 1

Seq Scan on item_carga itemcarga14_ (cost=0.00..1.05 rows=5 width=310) (actual time=0.001..0.001 rows=6 loops=1)

51. 0.004 0.004 ↑ 1.0 15 1

Seq Scan on house houses11_ (cost=0.00..2.15 rows=15 width=163) (actual time=0.002..0.004 rows=15 loops=1)

52. 0.007 0.010 ↑ 1.3 6 1

Materialize (cost=0.00..1.12 rows=8 width=87) (actual time=0.007..0.010 rows=6 loops=1)

53. 0.003 0.003 ↑ 1.3 6 1

Seq Scan on lacre_container lacreconta15_ (cost=0.00..1.08 rows=8 width=87) (actual time=0.002..0.003 rows=6 loops=1)

54. 0.007 0.031 ↓ 1.2 6 1

Materialize (cost=1.11..3.52 rows=5 width=455) (actual time=0.021..0.031 rows=6 loops=1)

55. 0.009 0.024 ↓ 1.2 6 1

Hash Right Join (cost=1.11..3.49 rows=5 width=455) (actual time=0.016..0.024 rows=6 loops=1)

  • Hash Cond: (tipomercad17_.uuid = itemcarga16_.ncm_predominante_uuid)
56. 0.004 0.004 ↑ 1.0 24 1

Seq Scan on tipo_mercadoriancm tipomercad17_ (cost=0.00..2.24 rows=24 width=145) (actual time=0.002..0.004 rows=24 loops=1)

57. 0.008 0.011 ↓ 1.2 6 1

Hash (cost=1.05..1.05 rows=5 width=310) (actual time=0.011..0.011 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
58. 0.003 0.003 ↓ 1.2 6 1

Seq Scan on item_carga itemcarga16_ (cost=0.00..1.05 rows=5 width=310) (actual time=0.001..0.003 rows=6 loops=1)

59. 0.005 0.007 ↓ 1.2 6 1

Materialize (cost=0.00..1.08 rows=5 width=310) (actual time=0.005..0.007 rows=6 loops=1)

60. 0.002 0.002 ↓ 1.2 6 1

Seq Scan on item_carga itemcarga18_ (cost=0.00..1.05 rows=5 width=310) (actual time=0.001..0.002 rows=6 loops=1)

61. 0.007 0.009 ↑ 1.2 5 1

Materialize (cost=0.00..1.09 rows=6 width=85) (actual time=0.008..0.009 rows=5 loops=1)

62. 0.002 0.002 ↑ 1.2 5 1

Seq Scan on manifesto_conhecimento manifestoc19_ (cost=0.00..1.06 rows=6 width=85) (actual time=0.002..0.002 rows=5 loops=1)

63. 0.008 0.011 ↑ 1.0 6 1

Materialize (cost=0.00..1.09 rows=6 width=373) (actual time=0.007..0.011 rows=6 loops=1)

64. 0.003 0.003 ↑ 1.0 6 1

Seq Scan on manifesto_maritimo manifestos20_ (cost=0.00..1.06 rows=6 width=373) (actual time=0.002..0.003 rows=6 loops=1)

65. 0.015 0.024 ↑ 1.0 16 1

Materialize (cost=0.00..4.24 rows=16 width=1,054) (actual time=0.003..0.024 rows=16 loops=1)

66. 0.009 0.009 ↑ 1.0 16 1

Seq Scan on escala escalas21_ (cost=0.00..4.16 rows=16 width=1,054) (actual time=0.002..0.009 rows=16 loops=1)

67. 0.008 0.028 ↑ 1.0 5 1

Materialize (cost=1.11..11.60 rows=5 width=2,782) (actual time=0.022..0.028 rows=5 loops=1)

68. 0.008 0.020 ↑ 1.0 5 1

Hash Right Join (cost=1.11..11.58 rows=5 width=2,782) (actual time=0.016..0.020 rows=5 loops=1)

  • Hash Cond: (dadoscompl24_.uuid = processo23_.dados_complementares_uuid)
69. 0.003 0.003 ↑ 6.0 5 1

Seq Scan on dados_complementares dadoscompl24_ (cost=0.00..10.30 rows=30 width=1,605) (actual time=0.003..0.003 rows=5 loops=1)

70. 0.007 0.009 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=1,177) (actual time=0.009..0.009 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
71. 0.002 0.002 ↑ 1.0 5 1

Seq Scan on processo processo23_ (cost=0.00..1.05 rows=5 width=1,177) (actual time=0.001..0.002 rows=5 loops=1)

72. 0.007 0.010 ↑ 1.0 6 1

Materialize (cost=0.00..1.09 rows=6 width=62) (actual time=0.008..0.010 rows=6 loops=1)

73. 0.003 0.003 ↑ 1.0 6 1

Seq Scan on terminal_portuario_descarregamento listatermi22_ (cost=0.00..1.06 rows=6 width=62) (actual time=0.002..0.003 rows=6 loops=1)

74. 0.008 0.026 ↑ 1.0 5 1

Materialize (cost=1.11..2.26 rows=5 width=1,288) (actual time=0.019..0.026 rows=5 loops=1)

75. 0.007 0.018 ↑ 1.0 5 1

Hash Right Join (cost=1.11..2.24 rows=5 width=1,288) (actual time=0.014..0.018 rows=5 loops=1)

  • Hash Cond: (integratio26_.uuid = processo25_.integration_error_uuid)
76. 0.002 0.002 ↑ 1.5 4 1

Seq Scan on integration_error integratio26_ (cost=0.00..1.06 rows=6 width=111) (actual time=0.002..0.002 rows=4 loops=1)

77. 0.007 0.009 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=1,177) (actual time=0.009..0.009 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
78. 0.002 0.002 ↑ 1.0 5 1

Seq Scan on processo processo25_ (cost=0.00..1.05 rows=5 width=1,177) (actual time=0.001..0.002 rows=5 loops=1)

79. 0.007 0.025 ↓ 1.3 4 1

Materialize (cost=1.07..2.20 rows=3 width=656) (actual time=0.017..0.025 rows=4 loops=1)

80. 0.007 0.018 ↓ 1.3 4 1

Hash Right Join (cost=1.07..2.18 rows=3 width=656) (actual time=0.015..0.018 rows=4 loops=1)

  • Hash Cond: (conhecimen28_.uuid = mercadoria27_.conhecimento_embarque_uuid)
81. 0.001 0.001 ↑ 1.2 5 1

Seq Scan on conhecimento_embarque conhecimen28_ (cost=0.00..1.06 rows=6 width=335) (actual time=0.001..0.001 rows=5 loops=1)

82. 0.007 0.010 ↓ 1.3 4 1

Hash (cost=1.03..1.03 rows=3 width=321) (actual time=0.010..0.010 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
83. 0.003 0.003 ↓ 1.3 4 1

Seq Scan on mercadoria mercadoria27_ (cost=0.00..1.03 rows=3 width=321) (actual time=0.002..0.003 rows=4 loops=1)

84. 0.007 0.009 ↓ 1.3 4 1

Materialize (cost=0.00..1.04 rows=3 width=197) (actual time=0.008..0.009 rows=4 loops=1)

85. 0.002 0.002 ↓ 1.3 4 1

Seq Scan on parte_notificada partenotif29_ (cost=0.00..1.03 rows=3 width=197) (actual time=0.002..0.002 rows=4 loops=1)

86. 0.009 0.023 ↑ 1.2 5 1

Materialize (cost=1.14..2.31 rows=6 width=1,983) (actual time=0.019..0.023 rows=5 loops=1)

87. 0.005 0.014 ↑ 1.2 5 1

Hash Left Join (cost=1.14..2.28 rows=6 width=1,983) (actual time=0.013..0.014 rows=5 loops=1)

  • Hash Cond: (conhecimen30_.procedencia_destino_uuid = procedenci31_.uuid)
88. 0.001 0.001 ↑ 1.2 5 1

Seq Scan on conhecimento_embarque conhecimen30_ (cost=0.00..1.06 rows=6 width=335) (actual time=0.001..0.001 rows=5 loops=1)

89. 0.006 0.008 ↑ 1.2 5 1

Hash (cost=1.06..1.06 rows=6 width=1,648) (actual time=0.008..0.008 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
90. 0.002 0.002 ↑ 1.2 5 1

Seq Scan on procedencia_destino procedenci31_ (cost=0.00..1.06 rows=6 width=1,648) (actual time=0.002..0.002 rows=5 loops=1)

91. 0.006 0.022 ↑ 1.2 5 1

Materialize (cost=1.14..11.86 rows=6 width=1,931) (actual time=0.016..0.022 rows=5 loops=1)

92. 0.007 0.016 ↑ 1.2 5 1

Hash Right Join (cost=1.14..11.83 rows=6 width=1,931) (actual time=0.013..0.016 rows=5 loops=1)

  • Hash Cond: (transbordo33_.uuid = conhecimen32_.transbordos_uuid)
93. 0.001 0.001 ↑ 25.0 2 1

Seq Scan on transbordos transbordo33_ (cost=0.00..10.50 rows=50 width=1,596) (actual time=0.001..0.001 rows=2 loops=1)

94. 0.006 0.008 ↑ 1.2 5 1

Hash (cost=1.06..1.06 rows=6 width=335) (actual time=0.008..0.008 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
95. 0.002 0.002 ↑ 1.2 5 1

Seq Scan on conhecimento_embarque conhecimen32_ (cost=0.00..1.06 rows=6 width=335) (actual time=0.001..0.002 rows=5 loops=1)

96. 0.007 0.021 ↑ 1.2 5 1

Materialize (cost=1.14..2.31 rows=6 width=441) (actual time=0.017..0.021 rows=5 loops=1)

97. 0.005 0.014 ↑ 1.2 5 1

Hash Left Join (cost=1.14..2.28 rows=6 width=441) (actual time=0.012..0.014 rows=5 loops=1)

  • Hash Cond: (conhecimen34_.transportador_representante_uuid = transporta35_.uuid)
98. 0.001 0.001 ↑ 1.2 5 1

Seq Scan on conhecimento_embarque conhecimen34_ (cost=0.00..1.06 rows=6 width=335) (actual time=0.001..0.001 rows=5 loops=1)

99. 0.006 0.008 ↑ 1.2 5 1

Hash (cost=1.06..1.06 rows=6 width=106) (actual time=0.008..0.008 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
100. 0.002 0.002 ↑ 1.2 5 1

Seq Scan on transportador_representante transporta35_ (cost=0.00..1.06 rows=6 width=106) (actual time=0.002..0.002 rows=5 loops=1)

101. 0.001 0.003 ↑ 1.2 5 1

Materialize (cost=0.00..1.09 rows=6 width=335) (actual time=0.001..0.003 rows=5 loops=1)

102. 0.002 0.002 ↑ 1.2 5 1

Seq Scan on conhecimento_embarque conhecimen36_ (cost=0.00..1.06 rows=6 width=335) (actual time=0.001..0.002 rows=5 loops=1)

103. 0.007 0.009 ↑ 1.0 5 1

Materialize (cost=0.00..1.08 rows=5 width=1,177) (actual time=0.008..0.009 rows=5 loops=1)

104. 0.002 0.002 ↑ 1.0 5 1

Seq Scan on processo processo37_ (cost=0.00..1.05 rows=5 width=1,177) (actual time=0.001..0.002 rows=5 loops=1)

105. 0.005 0.007 ↑ 1.0 5 1

Materialize (cost=0.00..1.08 rows=5 width=1,177) (actual time=0.006..0.007 rows=5 loops=1)

106. 0.002 0.002 ↑ 1.0 5 1

Seq Scan on processo processo38_ (cost=0.00..1.05 rows=5 width=1,177) (actual time=0.001..0.002 rows=5 loops=1)

107. 0.007 0.009 ↑ 1.0 3 1

Materialize (cost=0.00..1.04 rows=3 width=313) (actual time=0.008..0.009 rows=3 loops=1)

108. 0.002 0.002 ↑ 1.0 3 1

Seq Scan on entrega_carga entregacar39_ (cost=0.00..1.03 rows=3 width=313) (actual time=0.002..0.002 rows=3 loops=1)

109. 0.006 0.008 ↓ 1.3 4 1

Materialize (cost=0.00..1.04 rows=3 width=321) (actual time=0.006..0.008 rows=4 loops=1)

110. 0.002 0.002 ↓ 1.3 4 1

Seq Scan on mercadoria mercadoria40_ (cost=0.00..1.03 rows=3 width=321) (actual time=0.001..0.002 rows=4 loops=1)

111. 0.003 0.005 ↑ 1.0 5 1

Materialize (cost=0.00..1.08 rows=5 width=1,177) (actual time=0.003..0.005 rows=5 loops=1)

112. 0.002 0.002 ↑ 1.0 5 1

Seq Scan on processo processo41_ (cost=0.00..1.05 rows=5 width=1,177) (actual time=0.001..0.002 rows=5 loops=1)

Planning time : 13.001 ms
Execution time : 3.749 ms