explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZciC

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 8,858.694 ↑ 1.0 50 1

Limit (cost=586,295.48..586,584.88 rows=50 width=582) (actual time=8,858.663..8,858.694 rows=50 loops=1)

2. 0.020 8,858.690 ↑ 4.0 50 1

Unique (cost=586,295.48..587,453.07 rows=200 width=582) (actual time=8,858.662..8,858.690 rows=50 loops=1)

3. 236.001 8,858.670 ↑ 4,630.4 50 1

Sort (cost=586,295.48..586,874.27 rows=231,518 width=582) (actual time=8,858.660..8,858.670 rows=50 loops=1)

  • Sort Key: "*SELECT* 1".codigo
  • Sort Method: external merge Disk: 37304kB
4. 62.475 8,622.669 ↓ 1.0 236,609 1

Hash Left Join (cost=184,554.57..445,385.34 rows=231,518 width=582) (actual time=1,797.858..8,622.669 rows=236,609 loops=1)

  • Hash Cond: ("*SELECT* 1".tecnicos_codigo = t.codigo)
5. 72.097 8,560.185 ↓ 1.0 236,609 1

Hash Left Join (cost=184,542.77..444,752.92 rows=231,518 width=463) (actual time=1,797.816..8,560.185 rows=236,609 loops=1)

  • Hash Cond: ("*SELECT* 1".vendedores_codigo = v.codigo)
6. 480.695 8,488.061 ↓ 1.0 236,609 1

Hash Left Join (cost=184,539.89..444,129.43 rows=231,518 width=454) (actual time=1,797.778..8,488.061 rows=236,609 loops=1)

  • Hash Cond: ("*SELECT* 1".codigo = crpg.contasareceber_faturamentos_cr_codigo)
7. 24.279 7,721.685 ↓ 1.0 236,609 1

Append (cost=152,495.09..378,282.25 rows=231,518 width=446) (actual time=1,511.777..7,721.685 rows=236,609 loops=1)

8. 60.932 7,618.757 ↓ 1.1 236,603 1

Subquery Scan on *SELECT* 1 (cost=152,495.09..310,515.73 rows=222,524 width=446) (actual time=1,511.776..7,618.757 rows=236,603 loops=1)

9. 2,358.769 7,557.825 ↓ 1.1 236,603 1

Hash Left Join (cost=152,495.09..308,290.49 rows=222,524 width=538) (actual time=1,511.775..7,557.825 rows=236,603 loops=1)

  • Hash Cond: ("*SELECT* 1_1".tipodocumento_codigo = t_1.codigo)
10. 58.412 5,199.038 ↓ 1.1 236,603 1

Hash Left Join (cost=152,493.62..251,505.20 rows=222,524 width=364) (actual time=1,511.508..5,199.038 rows=236,603 loops=1)

  • Hash Cond: ("*SELECT* 1_1".gruposcontas_codigo = grct.codigo)
11. 90.721 5,140.621 ↓ 1.1 236,603 1

Hash Left Join (cost=152,473.72..250,895.54 rows=222,524 width=246) (actual time=1,511.498..5,140.621 rows=236,603 loops=1)

  • Hash Cond: (cr_sit.situacoesconta_codigo = sc.codigo)
12. 393.360 5,049.876 ↓ 1.1 236,603 1

Hash Join (cost=152,454.04..250,285.99 rows=222,524 width=125) (actual time=1,511.463..5,049.876 rows=236,603 loops=1)

  • Hash Cond: ("*SELECT* 1_1".prevendas_codigo = pv.codigo)
13. 342.737 4,393.935 ↓ 1.1 236,603 1

Hash Left Join (cost=127,741.94..214,806.77 rows=222,524 width=117) (actual time=1,248.446..4,393.935 rows=236,603 loops=1)

  • Hash Cond: ("*SELECT* 1_1".codigo = cr_sit.contasareceber_codigo)
14. 300.731 3,889.034 ↓ 1.1 236,603 1

Hash Join (cost=102,458.09..177,910.79 rows=222,524 width=113) (actual time=1,085.907..3,889.034 rows=236,603 loops=1)

  • Hash Cond: ("*SELECT* 1_1".codigo = cr_fat.contasareceber_codigo)
15. 139.022 3,306.962 ↓ 1.1 236,603 1

Hash Join (cost=75,581.02..139,421.59 rows=222,524 width=113) (actual time=804.251..3,306.962 rows=236,603 loops=1)

  • Hash Cond: ("*SELECT* 1_1".clientes_codigo = c.codigo)
16. 45.500 3,130.988 ↑ 1.0 819,997 1

Append (cost=74,385.65..136,073.10 rows=819,997 width=87) (actual time=766.515..3,130.988 rows=819,997 loops=1)

17. 154.520 3,085.488 ↑ 1.0 819,997 1

Subquery Scan on *SELECT* 1_1 (cost=74,385.65..131,973.12 rows=819,997 width=87) (actual time=766.514..3,085.488 rows=819,997 loops=1)

18. 1,208.586 2,930.968 ↑ 1.0 819,997 1

Hash Join (cost=74,385.65..123,773.15 rows=819,997 width=168) (actual time=766.513..2,930.968 rows=819,997 loops=1)

  • Hash Cond: (pvpg_cr.contasareceber_codigo = cr.codigo)
19. 436.448 1,309.559 ↑ 1.0 819,997 1

Hash Join (cost=40,879.79..73,699.79 rows=819,997 width=12) (actual time=353.489..1,309.559 rows=819,997 loops=1)

  • Hash Cond: (pvpg.codprevenda = pv_1.codigo)
20. 429.977 679.111 ↑ 1.0 819,997 1

Hash Join (cost=16,639.69..39,012.18 rows=819,997 width=8) (actual time=156.192..679.111 rows=819,997 loops=1)

  • Hash Cond: (pvpg_cr.prevendas_pagtos_codigo = pvpg.codigo)
21. 93.297 93.297 ↑ 1.0 819,997 1

Seq Scan on prevendas_pagtos_contasareceber pvpg_cr (cost=0.00..11,828.97 rows=819,997 width=8) (actual time=0.013..93.297 rows=819,997 loops=1)

22. 80.765 155.837 ↑ 1.0 507,453 1

Hash (cost=8,313.53..8,313.53 rows=507,453 width=8) (actual time=155.837..155.837 rows=507,453 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 3498kB
23. 75.072 75.072 ↑ 1.0 507,453 1

Seq Scan on prevenda_pagto pvpg (cost=0.00..8,313.53 rows=507,453 width=8) (actual time=0.011..75.072 rows=507,453 loops=1)

  • Filter: (codprevenda IS NOT NULL)
24. 79.228 194.000 ↑ 1.0 483,071 1

Hash (cost=16,314.71..16,314.71 rows=483,071 width=8) (actual time=194.000..194.000 rows=483,071 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 3385kB
25. 114.772 114.772 ↑ 1.0 483,071 1

Seq Scan on prevendas pv_1 (cost=0.00..16,314.71 rows=483,071 width=8) (actual time=0.031..114.772 rows=483,071 loops=1)

26. 207.149 412.823 ↓ 1.0 820,039 1

Hash (cost=16,848.38..16,848.38 rows=820,038 width=35) (actual time=412.823..412.823 rows=820,039 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 2160kB
27. 205.674 205.674 ↓ 1.0 820,039 1

Seq Scan on contasareceber cr (cost=0.00..16,848.38 rows=820,038 width=35) (actual time=0.042..205.674 rows=820,039 loops=1)

28. 0.710 36.952 ↑ 1.1 3,477 1

Hash (cost=1,145.78..1,145.78 rows=3,968 width=30) (actual time=36.952..36.952 rows=3,477 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 254kB
29. 36.242 36.242 ↑ 1.1 3,477 1

Seq Scan on clientes c (cost=0.00..1,145.78 rows=3,968 width=30) (actual time=0.030..36.242 rows=3,477 loops=1)

  • Filter: ((nome)::text ~~* '%maria%'::text)
  • Rows Removed by Filter: 11145
30. 124.953 281.341 ↓ 1.0 820,004 1

Hash (cost=13,423.03..13,423.03 rows=820,003 width=4) (actual time=281.341..281.341 rows=820,004 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 2832kB
31. 156.388 156.388 ↓ 1.0 820,004 1

Seq Scan on contasareceber_faturamentos cr_fat (cost=0.00..13,423.03 rows=820,003 width=4) (actual time=0.016..156.388 rows=820,004 loops=1)

  • Filter: (contasareceber_codigo IS NOT NULL)
32. 105.065 162.164 ↓ 1.0 820,039 1

Hash (cost=11,829.38..11,829.38 rows=820,038 width=8) (actual time=162.164..162.164 rows=820,039 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3033kB
33. 57.099 57.099 ↓ 1.0 820,039 1

Seq Scan on contasareceber_situacao cr_sit (cost=0.00..11,829.38 rows=820,038 width=8) (actual time=0.020..57.099 rows=820,039 loops=1)

34. 84.648 262.581 ↑ 1.0 483,071 1

Hash (cost=16,314.71..16,314.71 rows=483,071 width=12) (actual time=262.581..262.581 rows=483,071 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 3385kB
35. 177.933 177.933 ↑ 1.0 483,071 1

Seq Scan on prevendas pv (cost=0.00..16,314.71 rows=483,071 width=12) (actual time=0.069..177.933 rows=483,071 loops=1)

36. 0.011 0.024 ↑ 71.7 6 1

Hash (cost=14.30..14.30 rows=430 width=125) (actual time=0.023..0.024 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
37. 0.013 0.013 ↑ 71.7 6 1

Seq Scan on situacoescontas sc (cost=0.00..14.30 rows=430 width=125) (actual time=0.011..0.013 rows=6 loops=1)

38. 0.000 0.005 ↓ 0.0 0 1

Hash (cost=14.40..14.40 rows=440 width=122) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
39. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on gruposcontas grct (cost=0.00..14.40 rows=440 width=122) (actual time=0.005..0.005 rows=0 loops=1)

40. 0.009 0.018 ↓ 1.0 22 1

Hash (cost=1.21..1.21 rows=21 width=82) (actual time=0.018..0.018 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
41. 0.009 0.009 ↓ 1.0 22 1

Seq Scan on tipodocumento t_1 (cost=0.00..1.21 rows=21 width=82) (actual time=0.006..0.009 rows=22 loops=1)

42. 0.001 38.455 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=1,199.68..40,401.23 rows=613 width=446) (actual time=38.455..38.455 rows=0 loops=1)

43. 0.001 38.454 ↓ 0.0 0 1

Nested Loop (cost=1,199.68..40,395.10 rows=613 width=538) (actual time=38.454..38.454 rows=0 loops=1)

44. 0.000 38.453 ↓ 0.0 0 1

Hash Left Join (cost=1,199.26..36,888.24 rows=613 width=434) (actual time=38.453..38.453 rows=0 loops=1)

  • Hash Cond: ("*SELECT* 2_1".tipodocumento_codigo = t_2.codigo)
45. 0.001 38.453 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,197.79..36,885.13 rows=613 width=356) (actual time=38.453..38.453 rows=0 loops=1)

46. 0.000 38.452 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,197.64..36,772.08 rows=613 width=238) (actual time=38.452..38.452 rows=0 loops=1)

47. 0.001 38.452 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,197.49..36,670.92 rows=613 width=117) (actual time=38.452..38.452 rows=0 loops=1)

48. 0.002 38.451 ↓ 0.0 0 1

Nested Loop (cost=1,197.07..32,755.30 rows=613 width=113) (actual time=38.451..38.451 rows=0 loops=1)

49. 0.021 38.439 ↑ 306.5 2 1

Hash Join (cost=1,196.64..28,694.94 rows=613 width=113) (actual time=38.351..38.439 rows=2 loops=1)

  • Hash Cond: ("*SELECT* 2_1".clientes_codigo = c_1.codigo)
50. 0.003 0.355 ↑ 64.6 35 1

Append (cost=1.27..27,493.63 rows=2,260 width=87) (actual time=0.044..0.355 rows=35 loops=1)

51. 0.008 0.352 ↑ 64.6 35 1

Subquery Scan on *SELECT* 2_1 (cost=1.27..27,482.33 rows=2,260 width=87) (actual time=0.043..0.352 rows=35 loops=1)

52. 0.036 0.344 ↑ 64.6 35 1

Nested Loop (cost=1.27..27,459.73 rows=2,260 width=168) (actual time=0.043..0.344 rows=35 loops=1)

53. 0.030 0.238 ↑ 64.6 35 1

Nested Loop (cost=0.85..26,091.05 rows=2,260 width=39) (actual time=0.034..0.238 rows=35 loops=1)

54. 0.017 0.138 ↑ 64.6 35 1

Nested Loop (cost=0.42..16,180.65 rows=2,260 width=39) (actual time=0.027..0.138 rows=35 loops=1)

55. 0.016 0.016 ↑ 64.6 35 1

Seq Scan on saidasnf_pagtos_contasareceber snfpg_cr (cost=0.00..32.60 rows=2,260 width=8) (actual time=0.013..0.016 rows=35 loops=1)

56. 0.105 0.105 ↑ 1.0 1 35

Index Scan using contasareceber_pkey1 on contasareceber cr_1 (cost=0.42..7.15 rows=1 width=35) (actual time=0.003..0.003 rows=1 loops=35)

  • Index Cond: (codigo = snfpg_cr.contasareceber_codigo)
57. 0.070 0.070 ↑ 1.0 1 35

Index Scan using saidasnf_pagto_pkey on saidasnf_pagto snfpg (cost=0.42..4.39 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=35)

  • Index Cond: (codigo = snfpg_cr.saidasnf_pagtos_codigo)
  • Filter: (codsaidasnf IS NOT NULL)
58. 0.070 0.070 ↑ 1.0 1 35

Index Scan using saidasnf_codigo_index on saidasnf snf_1 (cost=0.42..0.61 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=35)

  • Index Cond: (codigo = snfpg.codsaidasnf)
59. 0.673 38.063 ↑ 1.1 3,477 1

Hash (cost=1,145.78..1,145.78 rows=3,968 width=30) (actual time=38.063..38.063 rows=3,477 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 254kB
60. 37.390 37.390 ↑ 1.1 3,477 1

Seq Scan on clientes c_1 (cost=0.00..1,145.78 rows=3,968 width=30) (actual time=0.026..37.390 rows=3,477 loops=1)

  • Filter: ((nome)::text ~~* '%maria%'::text)
  • Rows Removed by Filter: 11145
61. 0.010 0.010 ↓ 0.0 0 2

Index Only Scan using contasareceber_faturamentos_pkey on contasareceber_faturamentos cr_fat_1 (cost=0.42..6.62 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=2)

  • Index Cond: ((contasareceber_codigo = "*SELECT* 2_1".codigo) AND (contasareceber_codigo IS NOT NULL))
  • Heap Fetches: 0
62. 0.000 0.000 ↓ 0.0 0

Index Scan using contasareceber_situacao_pkey on contasareceber_situacao cr_sit_1 (cost=0.42..6.39 rows=1 width=8) (never executed)

  • Index Cond: ("*SELECT* 2_1".codigo = contasareceber_codigo)
63. 0.000 0.000 ↓ 0.0 0

Index Scan using situacoescontas_pkey on situacoescontas sc_1 (cost=0.15..0.17 rows=1 width=125) (never executed)

  • Index Cond: (cr_sit_1.situacoesconta_codigo = codigo)
64. 0.000 0.000 ↓ 0.0 0

Index Scan using gruposcontas_pkey on gruposcontas grct_1 (cost=0.15..0.18 rows=1 width=122) (never executed)

  • Index Cond: (codigo = "*SELECT* 2_1".gruposcontas_codigo)
65. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.21..1.21 rows=21 width=82) (never executed)

66. 0.000 0.000 ↓ 0.0 0

Seq Scan on tipodocumento t_2 (cost=0.00..1.21 rows=21 width=82) (never executed)

67. 0.000 0.000 ↓ 0.0 0

Index Scan using saidasnf_codigo_index on saidasnf snf (cost=0.42..5.47 rows=1 width=12) (never executed)

  • Index Cond: (codigo = "*SELECT* 2_1".saidasnf_codigo)
68. 0.003 40.194 ↑ 1,396.8 6 1

Subquery Scan on *SELECT* 3 (cost=1,226.12..26,207.70 rows=8,381 width=446) (actual time=40.034..40.194 rows=6 loops=1)

69. 0.320 40.191 ↑ 1,396.8 6 1

Hash Left Join (cost=1,226.12..26,123.89 rows=8,381 width=538) (actual time=40.033..40.191 rows=6 loops=1)

  • Hash Cond: ("*SELECT* 3_1".contasareceber_avulsas_codigo = cat.contasareceber_avulsas_codigo)
70. 0.005 39.855 ↑ 358.2 6 1

Nested Loop Left Join (cost=1,198.57..23,681.43 rows=2,149 width=438) (actual time=39.756..39.855 rows=6 loops=1)

71. 0.019 39.826 ↑ 91.8 6 1

Hash Left Join (cost=1,198.42..23,525.14 rows=551 width=434) (actual time=39.738..39.826 rows=6 loops=1)

  • Hash Cond: ("*SELECT* 3_1".tipodocumento_codigo = t_3.codigo)
72. 0.008 39.770 ↑ 91.8 6 1

Nested Loop Left Join (cost=1,196.94..23,522.19 rows=551 width=356) (actual time=39.684..39.770 rows=6 loops=1)

73. 0.006 39.762 ↑ 91.8 6 1

Nested Loop Left Join (cost=1,196.80..23,419.37 rows=551 width=238) (actual time=39.680..39.762 rows=6 loops=1)

74. 0.004 39.744 ↑ 91.8 6 1

Nested Loop Left Join (cost=1,196.65..23,328.44 rows=551 width=117) (actual time=39.670..39.744 rows=6 loops=1)

75. 0.008 39.716 ↑ 91.8 6 1

Nested Loop (cost=1,196.22..19,720.00 rows=551 width=113) (actual time=39.657..39.716 rows=6 loops=1)

76. 0.025 39.660 ↑ 91.8 6 1

Hash Join (cost=1,195.80..15,991.83 rows=551 width=113) (actual time=39.618..39.660 rows=6 loops=1)

  • Hash Cond: ("*SELECT* 3_1".clientes_codigo = c_2.codigo)
77. 0.002 0.066 ↑ 290.0 7 1

Append (cost=0.42..14,791.13 rows=2,030 width=87) (actual time=0.028..0.066 rows=7 loops=1)

78. 0.002 0.064 ↑ 290.0 7 1

Subquery Scan on *SELECT* 3_1 (cost=0.42..14,780.98 rows=2,030 width=87) (actual time=0.027..0.064 rows=7 loops=1)

79. 0.012 0.062 ↑ 290.0 7 1

Nested Loop (cost=0.42..14,760.68 rows=2,030 width=168) (actual time=0.027..0.062 rows=7 loops=1)

80. 0.022 0.022 ↑ 290.0 7 1

Seq Scan on contasareceber_avulsas crav (cost=0.00..30.40 rows=2,030 width=12) (actual time=0.019..0.022 rows=7 loops=1)

  • Filter: (codigo IS NOT NULL)
81. 0.028 0.028 ↑ 1.0 1 7

Index Scan using contasareceber_pkey1 on contasareceber cr_2 (cost=0.42..7.26 rows=1 width=35) (actual time=0.004..0.004 rows=1 loops=7)

  • Index Cond: (codigo = crav.contasareceber_codigo)
82. 0.794 39.569 ↑ 1.1 3,477 1

Hash (cost=1,145.78..1,145.78 rows=3,968 width=30) (actual time=39.569..39.569 rows=3,477 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 254kB
83. 38.775 38.775 ↑ 1.1 3,477 1

Seq Scan on clientes c_2 (cost=0.00..1,145.78 rows=3,968 width=30) (actual time=0.021..38.775 rows=3,477 loops=1)

  • Filter: ((nome)::text ~~* '%maria%'::text)
  • Rows Removed by Filter: 11145
84. 0.048 0.048 ↑ 1.0 1 6

Index Only Scan using contasareceber_faturamentos_pkey on contasareceber_faturamentos cr_fat_2 (cost=0.42..6.77 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=6)

  • Index Cond: ((contasareceber_codigo = "*SELECT* 3_1".codigo) AND (contasareceber_codigo IS NOT NULL))
  • Heap Fetches: 6
85. 0.024 0.024 ↑ 1.0 1 6

Index Scan using contasareceber_situacao_pkey on contasareceber_situacao cr_sit_2 (cost=0.42..6.55 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=6)

  • Index Cond: ("*SELECT* 3_1".codigo = contasareceber_codigo)
86. 0.012 0.012 ↑ 1.0 1 6

Index Scan using situacoescontas_pkey on situacoescontas sc_2 (cost=0.15..0.17 rows=1 width=125) (actual time=0.002..0.002 rows=1 loops=6)

  • Index Cond: (cr_sit_2.situacoesconta_codigo = codigo)
87. 0.000 0.000 ↓ 0.0 0 6

Index Scan using gruposcontas_pkey on gruposcontas grct_2 (cost=0.15..0.19 rows=1 width=122) (actual time=0.000..0.000 rows=0 loops=6)

  • Index Cond: (codigo = "*SELECT* 3_1".gruposcontas_codigo)
88. 0.009 0.037 ↓ 1.0 22 1

Hash (cost=1.21..1.21 rows=21 width=82) (actual time=0.037..0.037 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
89. 0.028 0.028 ↓ 1.0 22 1

Seq Scan on tipodocumento t_3 (cost=0.00..1.21 rows=21 width=82) (actual time=0.024..0.028 rows=22 loops=1)

90. 0.024 0.024 ↑ 4.0 1 6

Index Only Scan using contasareceber_avulsas_vended_contasareceber_avulsas_codigo_key on contasareceber_avulsas_vendedores cav (cost=0.15..0.24 rows=4 width=8) (actual time=0.003..0.004 rows=1 loops=6)

  • Index Cond: (contasareceber_avulsas_codigo = "*SELECT* 3_1".contasareceber_avulsas_codigo)
  • Heap Fetches: 6
91. 0.004 0.016 ↑ 390.0 2 1

Hash (cost=17.80..17.80 rows=780 width=8) (actual time=0.016..0.016 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
92. 0.012 0.012 ↑ 390.0 2 1

Seq Scan on contasareceber_avulsas_tecnicos cat (cost=0.00..17.80 rows=780 width=8) (actual time=0.011..0.012 rows=2 loops=1)

93. 133.691 285.681 ↑ 1.0 806,569 1

Hash (cost=18,023.69..18,023.69 rows=806,569 width=12) (actual time=285.681..285.681 rows=806,569 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3200kB
94. 151.990 151.990 ↑ 1.0 806,569 1

Seq Scan on contasareceber_pagtos crpg (cost=0.00..18,023.69 rows=806,569 width=12) (actual time=0.028..151.990 rows=806,569 loops=1)

95. 0.011 0.027 ↑ 1.0 39 1

Hash (cost=2.39..2.39 rows=39 width=13) (actual time=0.027..0.027 rows=39 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
96. 0.016 0.016 ↑ 1.0 39 1

Seq Scan on vendedores v (cost=0.00..2.39 rows=39 width=13) (actual time=0.010..0.016 rows=39 loops=1)

97. 0.002 0.009 ↑ 40.0 2 1

Hash (cost=10.80..10.80 rows=80 width=122) (actual time=0.009..0.009 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
98. 0.007 0.007 ↑ 40.0 2 1

Seq Scan on tecnicos t (cost=0.00..10.80 rows=80 width=122) (actual time=0.006..0.007 rows=2 loops=1)

Planning time : 18.118 ms
Execution time : 8,891.413 ms