explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 61eO

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 2,618.837 ↑ 1.0 50 1

Limit (cost=299,086.88..299,122.89 rows=50 width=575) (actual time=2,609.656..2,618.837 rows=50 loops=1)

2. 0.059 2,618.832 ↑ 39,673,326.2 50 1

Nested Loop Left Join (cost=299,086.88..1,429,010,478.95 rows=1,983,666,310 width=575) (actual time=2,609.655..2,618.832 rows=50 loops=1)

3. 0.008 2,618.573 ↑ 39,673,326.2 50 1

Append (cost=299,086.45..531,352,785.67 rows=1,983,666,310 width=566) (actual time=2,609.643..2,618.573 rows=50 loops=1)

4. 0.017 2,618.565 ↑ 39,608,971.9 50 1

Subquery Scan on *SELECT* 1 (cost=299,086.45..520,397,301.51 rows=1,980,448,594 width=566) (actual time=2,609.642..2,618.565 rows=50 loops=1)

5. 1.443 2,618.548 ↑ 39,608,971.9 50 1

Hash Join (cost=299,086.45..500,592,815.57 rows=1,980,448,594 width=658) (actual time=2,609.641..2,618.548 rows=50 loops=1)

  • Hash Cond: ("*SELECT* 1_1".prevendas_codigo = pv.codigo)
6. 0.075 1,224.519 ↑ 4,292.9 191 1

Hash Left Join (cost=127,916.15..253,858.33 rows=819,941 width=434) (actual time=1,216.714..1,224.519 rows=191 loops=1)

  • Hash Cond: ("*SELECT* 1_1".tipodocumento_codigo = t.codigo)
7. 0.055 1,224.426 ↑ 4,292.9 191 1

Hash Left Join (cost=127,914.68..251,658.90 rows=819,941 width=356) (actual time=1,216.691..1,224.426 rows=191 loops=1)

  • Hash Cond: ("*SELECT* 1_1".gruposcontas_codigo = grct.codigo)
8. 0.087 1,224.366 ↑ 4,292.9 191 1

Hash Left Join (cost=127,894.78..249,465.92 rows=819,941 width=238) (actual time=1,216.679..1,224.366 rows=191 loops=1)

  • Hash Cond: (cr_sit.situacoesconta_codigo = sc.codigo)
9. 0.144 1,224.255 ↑ 4,292.9 191 1

Hash Join (cost=127,875.11..247,272.68 rows=819,941 width=117) (actual time=1,216.643..1,224.255 rows=191 loops=1)

  • Hash Cond: ("*SELECT* 1_1".clientes_codigo = c.codigo)
10. 0.439 1,189.456 ↑ 4,293.2 191 1

Hash Left Join (cost=126,546.57..243,791.03 rows=819,997 width=91) (actual time=1,181.943..1,189.456 rows=191 loops=1)

  • Hash Cond: ("*SELECT* 1_1".codigo = cr_sit.contasareceber_codigo)
11. 0.458 1,031.764 ↑ 4,293.2 191 1

Hash Join (cost=101,262.71..190,728.67 rows=819,997 width=87) (actual time=1,024.345..1,031.764 rows=191 loops=1)

  • Hash Cond: ("*SELECT* 1_1".codigo = cr_fat.contasareceber_codigo)
12. 0.016 754.903 ↑ 4,293.2 191 1

Append (cost=74,385.65..136,073.10 rows=819,997 width=87) (actual time=747.572..754.903 rows=191 loops=1)

13. 0.038 754.887 ↑ 4,293.2 191 1

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

14. 1.141 754.849 ↑ 4,293.2 191 1

Hash Join (cost=74,385.65..123,773.15 rows=819,997 width=168) (actual time=747.570..754.849 rows=191 loops=1)

  • Hash Cond: (pvpg_cr.contasareceber_codigo = cr.codigo)
15. 2.154 341.019 ↑ 4,141.4 198 1

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

  • Hash Cond: (pvpg.codprevenda = pv_1.codigo)
16. 4.315 160.258 ↑ 522.6 1,569 1

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

  • Hash Cond: (pvpg_cr.prevendas_pagtos_codigo = pvpg.codigo)
17. 1.591 1.591 ↑ 64.3 12,755 1

Seq Scan on prevendas_pagtos_contasareceber pvpg_cr (cost=0.00..11,828.97 rows=819,997 width=8) (actual time=0.014..1.591 rows=12,755 loops=1)

18. 79.855 154.352 ↑ 1.0 507,453 1

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

  • Buckets: 131072 Batches: 8 Memory Usage: 3498kB
19. 74.497 74.497 ↑ 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..74.497 rows=507,453 loops=1)

  • Filter: (codprevenda IS NOT NULL)
20. 77.450 178.607 ↑ 1.0 483,071 1

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

  • Buckets: 131072 Batches: 8 Memory Usage: 3385kB
21. 101.157 101.157 ↑ 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.033..101.157 rows=483,071 loops=1)

22. 205.762 412.689 ↑ 1.0 820,038 1

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

  • Buckets: 65536 Batches: 32 Memory Usage: 2160kB
23. 206.927 206.927 ↑ 1.0 820,038 1

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

24. 138.935 276.403 ↑ 1.0 820,003 1

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

  • Buckets: 131072 Batches: 16 Memory Usage: 2832kB
25. 137.468 137.468 ↑ 1.0 820,003 1

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

  • Filter: (contasareceber_codigo IS NOT NULL)
26. 101.527 157.253 ↑ 1.0 820,038 1

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

  • Buckets: 131072 Batches: 16 Memory Usage: 3033kB
27. 55.726 55.726 ↑ 1.0 820,038 1

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

28. 2.721 34.655 ↓ 1.0 14,622 1

Hash (cost=1,145.78..1,145.78 rows=14,621 width=30) (actual time=34.655..34.655 rows=14,622 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1036kB
29. 31.934 31.934 ↓ 1.0 14,622 1

Seq Scan on clientes c (cost=0.00..1,145.78 rows=14,621 width=30) (actual time=0.030..31.934 rows=14,622 loops=1)

  • Filter: ((nome)::text ~~* '%'::text)
30. 0.010 0.024 ↑ 71.7 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
31. 0.014 0.014 ↑ 71.7 6 1

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

32. 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
33. 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)

34. 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
35. 0.009 0.009 ↓ 1.0 22 1

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

36. 179.135 1,392.586 ↑ 1.0 483,071 1

Hash (cost=155,696.91..155,696.91 rows=483,071 width=132) (actual time=1,392.585..1,392.586 rows=483,071 loops=1)

  • Buckets: 32768 Batches: 32 Memory Usage: 2523kB
37. 58.910 1,213.451 ↑ 1.0 483,071 1

Subquery Scan on pv (cost=133,958.72..155,696.91 rows=483,071 width=132) (actual time=493.953..1,213.451 rows=483,071 loops=1)

38. 578.331 1,154.541 ↑ 1.0 483,071 1

GroupAggregate (cost=133,958.72..150,866.20 rows=483,071 width=132) (actual time=493.952..1,154.541 rows=483,071 loops=1)

  • Group Key: prevendas.codigo
39. 254.285 576.210 ↑ 1.0 483,071 1

Sort (cost=133,958.72..135,166.39 rows=483,071 width=139) (actual time=493.935..576.210 rows=483,071 loops=1)

  • Sort Key: prevendas.codigo
  • Sort Method: external merge Disk: 12784kB
40. 68.982 321.925 ↑ 1.0 483,071 1

Hash Left Join (cost=14.68..19,003.28 rows=483,071 width=139) (actual time=0.095..321.925 rows=483,071 loops=1)

  • Hash Cond: (prevendas.codtecnico = tec.codigo)
41. 176.015 252.938 ↑ 1.0 483,071 1

Hash Left Join (cost=2.88..17,723.42 rows=483,071 width=21) (actual time=0.085..252.938 rows=483,071 loops=1)

  • Hash Cond: (prevendas.codvendedor = vend.codigo)
42. 76.897 76.897 ↑ 1.0 483,071 1

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

43. 0.012 0.026 ↑ 1.0 39 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
44. 0.014 0.014 ↑ 1.0 39 1

Seq Scan on vendedores vend (cost=0.00..2.39 rows=39 width=13) (actual time=0.007..0.014 rows=39 loops=1)

45. 0.000 0.005 ↓ 0.0 0 1

Hash (cost=10.80..10.80 rows=80 width=122) (actual time=0.005..0.005 rows=0 loops=1)

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

Seq Scan on tecnicos tec (cost=0.00..10.80 rows=80 width=122) (actual time=0.005..0.005 rows=0 loops=1)

47. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2 (cost=85,346.10..992,985.34 rows=3,215,686 width=566) (never executed)

48. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=85,346.10..960,828.48 rows=3,215,686 width=658) (never executed)

  • Hash Cond: ("*SELECT* 2_1".saidasnf_codigo = snf.codigo)
49. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1,332.43..59,031.04 rows=2,260 width=434) (never executed)

  • Hash Cond: ("*SELECT* 2_1".tipodocumento_codigo = t_1.codigo)
50. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1,330.95..59,023.51 rows=2,260 width=356) (never executed)

51. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1,330.81..58,606.79 rows=2,260 width=238) (never executed)

52. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1,330.66..58,233.85 rows=2,260 width=117) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,330.23..43,797.80 rows=2,260 width=113) (never executed)

  • Hash Cond: ("*SELECT* 2_1".clientes_codigo = c_1.codigo)
54. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.70..42,463.33 rows=2,260 width=87) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Append (cost=1.27..27,493.63 rows=2,260 width=87) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 2_1 (cost=1.27..27,482.33 rows=2,260 width=87) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.27..27,459.73 rows=2,260 width=168) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..26,091.05 rows=2,260 width=39) (never executed)

59. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..16,180.65 rows=2,260 width=39) (never executed)

60. 0.000 0.000 ↓ 0.0 0

Seq Scan on saidasnf_pagtos_contasareceber snfpg_cr (cost=0.00..32.60 rows=2,260 width=8) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Index Scan using contasareceber_pkey1 on contasareceber cr_1 (cost=0.42..7.15 rows=1 width=35) (never executed)

  • Index Cond: (codigo = snfpg_cr.contasareceber_codigo)
62. 0.000 0.000 ↓ 0.0 0

Index Scan using saidasnf_pagto_pkey on saidasnf_pagto snfpg (cost=0.42..4.39 rows=1 width=8) (never executed)

  • Index Cond: (codigo = snfpg_cr.saidasnf_pagtos_codigo)
  • Filter: (codsaidasnf IS NOT NULL)
63. 0.000 0.000 ↓ 0.0 0

Index Scan using saidasnf_codigo_index on saidasnf snf_1 (cost=0.42..0.61 rows=1 width=8) (never executed)

  • Index Cond: (codigo = snfpg.codsaidasnf)
64. 0.000 0.000 ↓ 0.0 0

Index Only Scan using contasareceber_faturamentos_pkey on contasareceber_faturamentos cr_fat_1 (cost=0.42..6.62 rows=1 width=4) (never executed)

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

Hash (cost=1,145.78..1,145.78 rows=14,621 width=30) (never executed)

66. 0.000 0.000 ↓ 0.0 0

Seq Scan on clientes c_1 (cost=0.00..1,145.78 rows=14,621 width=30) (never executed)

  • Filter: ((nome)::text ~~* '%'::text)
67. 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)
68. 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)
69. 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)
70. 0.000 0.000 ↓ 0.0 0

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

71. 0.000 0.000 ↓ 0.0 0

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

72. 0.000 0.000 ↓ 0.0 0

Hash (cost=74,897.50..74,897.50 rows=284,574 width=132) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Subquery Scan on snf (cost=62,091.67..74,897.50 rows=284,574 width=132) (never executed)

74. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=62,091.67..72,051.76 rows=284,574 width=132) (never executed)

  • Group Key: saidasnf.codigo
75. 0.000 0.000 ↓ 0.0 0

Sort (cost=62,091.67..62,803.11 rows=284,574 width=139) (never executed)

  • Sort Key: saidasnf.codigo
76. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=14.68..15,885.48 rows=284,574 width=139) (never executed)

  • Hash Cond: (saidasnf.codtecnico = tec_1.codigo)
77. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2.88..15,126.68 rows=284,574 width=21) (never executed)

  • Hash Cond: (saidasnf.codvendedor = vend_1.codigo)
78. 0.000 0.000 ↓ 0.0 0

Seq Scan on saidasnf (cost=0.00..14,308.74 rows=284,574 width=12) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.39..2.39 rows=39 width=13) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Seq Scan on vendedores vend_1 (cost=0.00..2.39 rows=39 width=13) (never executed)

81. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.80..10.80 rows=80 width=122) (never executed)

82. 0.000 0.000 ↓ 0.0 0

Seq Scan on tecnicos tec_1 (cost=0.00..10.80 rows=80 width=122) (never executed)

83. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3 (cost=1,432.49..44,167.26 rows=2,030 width=566) (never executed)

84. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1,432.49..44,146.96 rows=2,030 width=658) (never executed)

  • Hash Cond: ("*SELECT* 3_1".contasareceber_avulsas_codigo = cat.contasareceber_avulsas_codigo)
85. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1,387.45..43,583.91 rows=2,030 width=498) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1,386.88..29,934.10 rows=2,030 width=373) (never executed)

  • Hash Cond: ("*SELECT* 3_1".contasareceber_avulsas_codigo = cav.contasareceber_avulsas_codigo)
87. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1,350.76..29,892.54 rows=2,030 width=309) (never executed)

  • Hash Cond: ("*SELECT* 3_1".tipodocumento_codigo = t_2.codigo)
88. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1,349.29..29,885.63 rows=2,030 width=231) (never executed)

  • Hash Cond: ("*SELECT* 3_1".gruposcontas_codigo = grct_2.codigo)
89. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1,329.39..29,860.34 rows=2,030 width=113) (never executed)

  • Hash Cond: ("*SELECT* 3_1".clientes_codigo = c_2.codigo)
90. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..28,526.48 rows=2,030 width=87) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Append (cost=0.42..14,791.13 rows=2,030 width=87) (never executed)

92. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 3_1 (cost=0.42..14,780.98 rows=2,030 width=87) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..14,760.68 rows=2,030 width=168) (never executed)

94. 0.000 0.000 ↓ 0.0 0

Seq Scan on contasareceber_avulsas crav (cost=0.00..30.40 rows=2,030 width=12) (never executed)

  • Filter: (codigo IS NOT NULL)
95. 0.000 0.000 ↓ 0.0 0

Index Scan using contasareceber_pkey1 on contasareceber cr_2 (cost=0.42..7.26 rows=1 width=35) (never executed)

  • Index Cond: (codigo = crav.contasareceber_codigo)
96. 0.000 0.000 ↓ 0.0 0

Index Only Scan using contasareceber_faturamentos_pkey on contasareceber_faturamentos cr_fat_2 (cost=0.42..6.77 rows=1 width=4) (never executed)

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

Hash (cost=1,145.78..1,145.78 rows=14,621 width=30) (never executed)

98. 0.000 0.000 ↓ 0.0 0

Seq Scan on clientes c_2 (cost=0.00..1,145.78 rows=14,621 width=30) (never executed)

  • Filter: ((nome)::text ~~* '%'::text)
99. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.40..14.40 rows=440 width=122) (never executed)

100. 0.000 0.000 ↓ 0.0 0

Seq Scan on gruposcontas grct_2 (cost=0.00..14.40 rows=440 width=122) (never executed)

101. 0.000 0.000 ↓ 0.0 0

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

102. 0.000 0.000 ↓ 0.0 0

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

103. 0.000 0.000 ↓ 0.0 0

Hash (cost=33.62..33.62 rows=200 width=68) (never executed)

104. 0.000 0.000 ↓ 0.0 0

Subquery Scan on cav (cost=28.62..33.62 rows=200 width=68) (never executed)

105. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=28.62..31.62 rows=200 width=68) (never executed)

  • Group Key: contasareceber_avulsas_vendedores.contasareceber_avulsas_codigo
106. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2.88..22.77 rows=780 width=17) (never executed)

  • Hash Cond: (contasareceber_avulsas_vendedores.vendedores_codigo = vend_2.codigo)
107. 0.000 0.000 ↓ 0.0 0

Seq Scan on contasareceber_avulsas_vendedores (cost=0.00..17.80 rows=780 width=8) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.39..2.39 rows=39 width=13) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Seq Scan on vendedores vend_2 (cost=0.00..2.39 rows=39 width=13) (never executed)

110. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.57..6.71 rows=1 width=129) (never executed)

111. 0.000 0.000 ↓ 0.0 0

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

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

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

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

Hash (cost=42.54..42.54 rows=200 width=68) (never executed)

114. 0.000 0.000 ↓ 0.0 0

Subquery Scan on cat (cost=37.54..42.54 rows=200 width=68) (never executed)

115. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=37.54..40.54 rows=200 width=68) (never executed)

  • Group Key: contasareceber_avulsas_tecnicos.contasareceber_avulsas_codigo
116. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=11.80..31.69 rows=780 width=126) (never executed)

  • Hash Cond: (contasareceber_avulsas_tecnicos.tecnicos_codigo = tec_2.codigo)
117. 0.000 0.000 ↓ 0.0 0

Seq Scan on contasareceber_avulsas_tecnicos (cost=0.00..17.80 rows=780 width=8) (never executed)

118. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.80..10.80 rows=80 width=122) (never executed)

119. 0.000 0.000 ↓ 0.0 0

Seq Scan on tecnicos tec_2 (cost=0.00..10.80 rows=80 width=122) (never executed)

120. 0.200 0.200 ↑ 1.0 1 50

Index Scan using contasareceber_pagtos_contasareceber_faturamentos_cr_codigo_idx on contasareceber_pagtos crpg (cost=0.42..0.44 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=50)

  • Index Cond: (contasareceber_faturamentos_cr_codigo = "*SELECT* 1".codigo)
Planning time : 30.653 ms
Execution time : 2,742.922 ms