explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0dnn

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 11,063.013 ↑ 1.0 50 1

Limit (cost=1,126,863.94..1,166,184.87 rows=50 width=582) (actual time=11,062.940..11,063.013 rows=50 loops=1)

2. 0.020 11,063.009 ↑ 4.0 50 1

Unique (cost=1,126,863.94..1,284,147.67 rows=200 width=582) (actual time=11,062.939..11,063.009 rows=50 loops=1)

3. 0.024 11,062.989 ↑ 17,018.2 50 1

Nested Loop Left Join (cost=1,126,863.94..1,282,020.39 rows=850,911 width=582) (actual time=11,062.937..11,062.989 rows=50 loops=1)

4. 0.026 11,062.965 ↑ 17,018.2 50 1

Merge Left Join (cost=1,126,863.80..1,145,898.44 rows=850,911 width=463) (actual time=11,062.928..11,062.965 rows=50 loops=1)

  • Merge Cond: ("*SELECT* 1".codigo = crpg.contasareceber_faturamentos_cr_codigo)
5. 676.366 10,863.783 ↑ 17,018.2 50 1

Sort (cost=1,015,923.39..1,018,050.66 rows=850,911 width=455) (actual time=10,863.774..10,863.783 rows=50 loops=1)

  • Sort Key: "*SELECT* 1".codigo
  • Sort Method: external merge Disk: 117288kB
6. 252.030 10,187.417 ↑ 1.0 820,011 1

Hash Left Join (cost=152,594.85..583,101.40 rows=850,911 width=455) (actual time=979.595..10,187.417 rows=820,011 loops=1)

  • Hash Cond: ("*SELECT* 1".vendedores_codigo = v.codigo)
7. 64.946 9,935.374 ↑ 1.0 820,011 1

Append (cost=152,591.98..580,817.55 rows=850,911 width=446) (actual time=979.579..9,935.374 rows=820,011 loops=1)

8. 169.244 9,865.302 ↑ 1.0 820,000 1

Subquery Scan on *SELECT* 1 (cost=152,591.98..522,320.27 rows=820,000 width=446) (actual time=979.578..9,865.302 rows=820,000 loops=1)

9. 5,274.226 9,696.058 ↑ 1.0 820,000 1

Hash Left Join (cost=152,591.98..514,120.27 rows=820,000 width=538) (actual time=979.577..9,696.058 rows=820,000 loops=1)

  • Hash Cond: ("*SELECT* 1_1".tipodocumento_codigo = t_1.codigo)
10. 155.887 4,421.824 ↑ 1.0 820,000 1

Hash Left Join (cost=152,590.50..304,870.68 rows=820,000 width=364) (actual time=979.410..4,421.824 rows=820,000 loops=1)

  • Hash Cond: ("*SELECT* 1_1".gruposcontas_codigo = grct.codigo)
11. 211.935 4,265.935 ↑ 1.0 820,000 1

Hash Left Join (cost=152,570.60..302,677.54 rows=820,000 width=246) (actual time=979.406..4,265.935 rows=820,000 loops=1)

  • Hash Cond: (cr_sit.situacoesconta_codigo = sc.codigo)
12. 313.405 4,053.994 ↑ 1.0 820,000 1

Hash Left Join (cost=152,550.93..300,484.15 rows=820,000 width=125) (actual time=979.395..4,053.994 rows=820,000 loops=1)

  • Hash Cond: ("*SELECT* 1_1".clientes_codigo = c.codigo)
13. 652.330 3,736.721 ↑ 1.0 820,000 1

Hash Join (cost=151,258.93..297,039.04 rows=820,000 width=99) (actual time=975.516..3,736.721 rows=820,000 loops=1)

  • Hash Cond: ("*SELECT* 1_1".prevendas_codigo = pv.codigo)
14. 493.907 2,920.116 ↑ 1.0 820,000 1

Hash Left Join (cost=126,546.82..243,791.39 rows=820,000 width=91) (actual time=811.200..2,920.116 rows=820,000 loops=1)

  • Hash Cond: ("*SELECT* 1_1".codigo = cr_sit.contasareceber_codigo)
15. 443.713 2,297.489 ↑ 1.0 820,000 1

Hash Join (cost=101,262.89..190,728.96 rows=820,000 width=87) (actual time=682.438..2,297.489 rows=820,000 loops=1)

  • Hash Cond: ("*SELECT* 1_1".codigo = cr_fat.contasareceber_codigo)
16. 37.734 1,674.806 ↑ 1.0 820,000 1

Append (cost=74,385.76..136,073.31 rows=820,000 width=87) (actual time=503.387..1,674.806 rows=820,000 loops=1)

17. 80.098 1,637.072 ↑ 1.0 820,000 1

Subquery Scan on *SELECT* 1_1 (cost=74,385.76..131,973.31 rows=820,000 width=87) (actual time=503.386..1,637.072 rows=820,000 loops=1)

18. 406.287 1,556.974 ↑ 1.0 820,000 1

Hash Join (cost=74,385.76..123,773.31 rows=820,000 width=168) (actual time=503.385..1,556.974 rows=820,000 loops=1)

  • Hash Cond: (pvpg_cr.contasareceber_codigo = cr.codigo)
19. 281.072 877.867 ↑ 1.0 820,000 1

Hash Join (cost=40,879.81..73,699.86 rows=820,000 width=12) (actual time=230.537..877.867 rows=820,000 loops=1)

  • Hash Cond: (pvpg.codprevenda = pv_1.codigo)
20. 296.185 476.561 ↑ 1.0 820,000 1

Hash Join (cost=16,639.69..39,012.21 rows=820,000 width=8) (actual time=110.139..476.561 rows=820,000 loops=1)

  • Hash Cond: (pvpg_cr.prevendas_pagtos_codigo = pvpg.codigo)
21. 70.283 70.283 ↑ 1.0 820,000 1

Seq Scan on prevendas_pagtos_contasareceber pvpg_cr (cost=0.00..11,829.00 rows=820,000 width=8) (actual time=0.008..70.283 rows=820,000 loops=1)

22. 61.142 110.093 ↓ 1.0 507,455 1

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

  • Buckets: 131072 Batches: 8 Memory Usage: 3498kB
23. 48.951 48.951 ↓ 1.0 507,455 1

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

  • Filter: (codprevenda IS NOT NULL)
24. 58.460 120.234 ↑ 1.0 483,072 1

Hash (cost=16,314.72..16,314.72 rows=483,072 width=8) (actual time=120.234..120.234 rows=483,072 loops=1)

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

Seq Scan on prevendas pv_1 (cost=0.00..16,314.72 rows=483,072 width=8) (actual time=0.010..61.774 rows=483,072 loops=1)

26. 147.248 272.820 ↓ 1.0 820,043 1

Hash (cost=16,848.42..16,848.42 rows=820,042 width=35) (actual time=272.820..272.820 rows=820,043 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 2161kB
27. 125.572 125.572 ↓ 1.0 820,043 1

Seq Scan on contasareceber cr (cost=0.00..16,848.42 rows=820,042 width=35) (actual time=0.010..125.572 rows=820,043 loops=1)

28. 94.961 178.970 ↓ 1.0 820,008 1

Hash (cost=13,423.06..13,423.06 rows=820,006 width=4) (actual time=178.970..178.970 rows=820,008 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 2832kB
29. 84.009 84.009 ↓ 1.0 820,008 1

Seq Scan on contasareceber_faturamentos cr_fat (cost=0.00..13,423.06 rows=820,006 width=4) (actual time=0.012..84.009 rows=820,008 loops=1)

  • Filter: (contasareceber_codigo IS NOT NULL)
30. 80.432 128.720 ↓ 1.0 820,043 1

Hash (cost=11,829.41..11,829.41 rows=820,041 width=8) (actual time=128.720..128.720 rows=820,043 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 3033kB
31. 48.288 48.288 ↓ 1.0 820,043 1

Seq Scan on contasareceber_situacao cr_sit (cost=0.00..11,829.41 rows=820,041 width=8) (actual time=0.006..48.288 rows=820,043 loops=1)

32. 64.531 164.275 ↑ 1.0 483,072 1

Hash (cost=16,314.72..16,314.72 rows=483,072 width=12) (actual time=164.275..164.275 rows=483,072 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 3385kB
33. 99.744 99.744 ↑ 1.0 483,072 1

Seq Scan on prevendas pv (cost=0.00..16,314.72 rows=483,072 width=12) (actual time=0.022..99.744 rows=483,072 loops=1)

34. 1.568 3.868 ↑ 1.0 14,622 1

Hash (cost=1,109.22..1,109.22 rows=14,622 width=30) (actual time=3.868..3.868 rows=14,622 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1036kB
35. 2.300 2.300 ↑ 1.0 14,622 1

Seq Scan on clientes c (cost=0.00..1,109.22 rows=14,622 width=30) (actual time=0.004..2.300 rows=14,622 loops=1)

36. 0.001 0.006 ↑ 71.7 6 1

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

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

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

38. 0.001 0.002 ↓ 0.0 0 1

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

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

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

40. 0.003 0.008 ↓ 1.0 22 1

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

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

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

42. 0.000 0.428 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=22.88..1,813.97 rows=35 width=446) (actual time=0.428..0.428 rows=0 loops=1)

43. 0.001 0.428 ↓ 0.0 0 1

Nested Loop (cost=22.88..1,813.62 rows=35 width=538) (actual time=0.428..0.428 rows=0 loops=1)

44. 0.000 0.427 ↓ 0.0 0 1

Nested Loop Left Join (cost=22.45..1,509.38 rows=35 width=434) (actual time=0.427..0.427 rows=0 loops=1)

  • Join Filter: (t_2.codigo = "*SELECT* 2_1".tipodocumento_codigo)
45. 0.000 0.427 ↓ 0.0 0 1

Hash Left Join (cost=22.45..1,497.38 rows=35 width=356) (actual time=0.427..0.427 rows=0 loops=1)

  • Hash Cond: ("*SELECT* 2_1".gruposcontas_codigo = grct_1.codigo)
46. 0.001 0.427 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.55..1,477.39 rows=35 width=238) (actual time=0.427..0.427 rows=0 loops=1)

47. 0.000 0.426 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.40..1,471.61 rows=35 width=117) (actual time=0.426..0.426 rows=0 loops=1)

48. 0.000 0.426 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.98..1,176.12 rows=35 width=113) (actual time=0.426..0.426 rows=0 loops=1)

49. 0.006 0.426 ↓ 0.0 0 1

Nested Loop (cost=1.70..909.53 rows=35 width=87) (actual time=0.426..0.426 rows=0 loops=1)

50. 0.002 0.350 ↑ 1.0 35 1

Append (cost=1.27..613.96 rows=35 width=87) (actual time=0.079..0.350 rows=35 loops=1)

51. 0.005 0.348 ↑ 1.0 35 1

Subquery Scan on *SELECT* 2_1 (cost=1.27..613.78 rows=35 width=87) (actual time=0.079..0.348 rows=35 loops=1)

52. 0.017 0.343 ↑ 1.0 35 1

Nested Loop (cost=1.27..613.43 rows=35 width=168) (actual time=0.078..0.343 rows=35 loops=1)

53. 0.000 0.221 ↑ 1.0 35 1

Nested Loop (cost=0.85..592.24 rows=35 width=39) (actual time=0.055..0.221 rows=35 loops=1)

54. 0.022 0.116 ↑ 1.0 35 1

Nested Loop (cost=0.42..296.84 rows=35 width=39) (actual time=0.048..0.116 rows=35 loops=1)

55. 0.024 0.024 ↑ 1.0 35 1

Seq Scan on saidasnf_pagtos_contasareceber snfpg_cr (cost=0.00..1.35 rows=35 width=8) (actual time=0.021..0.024 rows=35 loops=1)

56. 0.070 0.070 ↑ 1.0 1 35

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

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

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

  • Index Cond: (codigo = snfpg_cr.saidasnf_pagtos_codigo)
  • Filter: (codsaidasnf IS NOT NULL)
58. 0.105 0.105 ↑ 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.003..0.003 rows=1 loops=35)

  • Index Cond: (codigo = snfpg.codsaidasnf)
59. 0.070 0.070 ↓ 0.0 0 35

Index Only Scan using contasareceber_faturamentos_pkey on contasareceber_faturamentos cr_fat_1 (cost=0.42..8.45 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=35)

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

Index Scan using unq_clientes on clientes c_1 (cost=0.29..7.62 rows=1 width=30) (never executed)

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

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

  • Index Cond: ("*SELECT* 2_1".codigo = contasareceber_codigo)
62. 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)
63. 0.000 0.000 ↓ 0.0 0

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

64. 0.000 0.000 ↓ 0.0 0

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

65. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.31 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..8.44 rows=1 width=12) (never executed)

  • Index Cond: (codigo = "*SELECT* 2_1".saidasnf_codigo)
68. 0.003 4.698 ↑ 2,806.9 11 1

Subquery Scan on *SELECT* 3 (cost=43,727.86..52,428.76 rows=30,876 width=446) (actual time=4.517..4.698 rows=11 loops=1)

69. 0.308 4.695 ↑ 2,806.9 11 1

Merge Right Join (cost=43,727.86..52,120.00 rows=30,876 width=538) (actual time=4.516..4.695 rows=11 loops=1)

  • Merge Cond: (cat.contasareceber_avulsas_codigo = "*SELECT* 3_1".contasareceber_avulsas_codigo)
70. 0.010 0.013 ↑ 260.0 3 1

Sort (cost=55.27..57.22 rows=780 width=8) (actual time=0.012..0.013 rows=3 loops=1)

  • Sort Key: cat.contasareceber_avulsas_codigo
  • Sort Method: quicksort Memory: 25kB
71. 0.003 0.003 ↑ 260.0 3 1

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

72. 0.006 4.374 ↑ 719.7 11 1

Materialize (cost=43,672.59..43,821.29 rows=7,917 width=438) (actual time=4.364..4.374 rows=11 loops=1)

73. 0.007 4.368 ↑ 879.7 9 1

Merge Left Join (cost=43,672.59..43,801.50 rows=7,917 width=438) (actual time=4.362..4.368 rows=9 loops=1)

  • Merge Cond: ("*SELECT* 3_1".contasareceber_avulsas_codigo = cav.contasareceber_avulsas_codigo)
74. 0.008 4.354 ↑ 253.8 8 1

Sort (cost=43,617.33..43,622.40 rows=2,030 width=434) (actual time=4.353..4.354 rows=8 loops=1)

  • Sort Key: "*SELECT* 3_1".contasareceber_avulsas_codigo
  • Sort Method: quicksort Memory: 27kB
75. 0.007 4.346 ↑ 253.8 8 1

Nested Loop Left Join (cost=1,314.79..43,505.80 rows=2,030 width=434) (actual time=4.272..4.346 rows=8 loops=1)

76. 0.005 4.307 ↑ 253.8 8 1

Hash Left Join (cost=1,314.22..29,856.00 rows=2,030 width=309) (actual time=4.261..4.307 rows=8 loops=1)

  • Hash Cond: ("*SELECT* 3_1".tipodocumento_codigo = t_3.codigo)
77. 0.005 4.294 ↑ 253.8 8 1

Hash Left Join (cost=1,312.75..29,849.08 rows=2,030 width=231) (actual time=4.249..4.294 rows=8 loops=1)

  • Hash Cond: ("*SELECT* 3_1".gruposcontas_codigo = grct_2.codigo)
78. 0.012 4.286 ↑ 253.8 8 1

Hash Left Join (cost=1,292.85..29,823.80 rows=2,030 width=113) (actual time=4.242..4.286 rows=8 loops=1)

  • Hash Cond: ("*SELECT* 3_1".clientes_codigo = c_2.codigo)
79. 0.006 0.055 ↑ 253.8 8 1

Nested Loop (cost=0.85..28,526.48 rows=2,030 width=87) (actual time=0.015..0.055 rows=8 loops=1)

80. 0.003 0.033 ↑ 253.8 8 1

Append (cost=0.42..14,791.13 rows=2,030 width=87) (actual time=0.009..0.033 rows=8 loops=1)

81. 0.002 0.030 ↑ 253.8 8 1

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

82. 0.008 0.028 ↑ 253.8 8 1

Nested Loop (cost=0.42..14,760.68 rows=2,030 width=168) (actual time=0.008..0.028 rows=8 loops=1)

83. 0.004 0.004 ↑ 253.8 8 1

Seq Scan on contasareceber_avulsas crav (cost=0.00..30.40 rows=2,030 width=12) (actual time=0.002..0.004 rows=8 loops=1)

  • Filter: (codigo IS NOT NULL)
84. 0.016 0.016 ↑ 1.0 1 8

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

  • Index Cond: (codigo = crav.contasareceber_codigo)
85. 0.016 0.016 ↑ 1.0 1 8

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.002..0.002 rows=1 loops=8)

  • Index Cond: ((contasareceber_codigo = "*SELECT* 3_1".codigo) AND (contasareceber_codigo IS NOT NULL))
  • Heap Fetches: 8
86. 1.780 4.219 ↑ 1.0 14,622 1

Hash (cost=1,109.22..1,109.22 rows=14,622 width=30) (actual time=4.219..4.219 rows=14,622 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1036kB
87. 2.439 2.439 ↑ 1.0 14,622 1

Seq Scan on clientes c_2 (cost=0.00..1,109.22 rows=14,622 width=30) (actual time=0.003..2.439 rows=14,622 loops=1)

88. 0.000 0.003 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
89. 0.003 0.003 ↓ 0.0 0 1

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

90. 0.003 0.008 ↓ 1.0 22 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
91. 0.005 0.005 ↓ 1.0 22 1

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

92. 0.000 0.032 ↑ 1.0 1 8

Nested Loop Left Join (cost=0.57..6.71 rows=1 width=129) (actual time=0.004..0.004 rows=1 loops=8)

93. 0.024 0.024 ↑ 1.0 1 8

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

  • Index Cond: ("*SELECT* 3_1".codigo = contasareceber_codigo)
94. 0.008 0.008 ↑ 1.0 1 8

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

  • Index Cond: (cr_sit_2.situacoesconta_codigo = codigo)
95. 0.003 0.007 ↑ 86.7 9 1

Sort (cost=55.27..57.22 rows=780 width=8) (actual time=0.006..0.007 rows=9 loops=1)

  • Sort Key: cav.contasareceber_avulsas_codigo
  • Sort Method: quicksort Memory: 25kB
96. 0.004 0.004 ↑ 86.7 9 1

Seq Scan on contasareceber_avulsas_vendedores cav (cost=0.00..17.80 rows=780 width=8) (actual time=0.003..0.004 rows=9 loops=1)

97. 0.005 0.013 ↑ 1.0 39 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
98. 0.008 0.008 ↑ 1.0 39 1

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

99. 0.007 199.156 ↑ 16,460.6 49 1

Materialize (cost=110,940.41..114,973.25 rows=806,569 width=12) (actual time=199.148..199.156 rows=49 loops=1)

100. 105.103 199.149 ↑ 16,460.6 49 1

Sort (cost=110,940.41..112,956.83 rows=806,569 width=12) (actual time=199.145..199.149 rows=49 loops=1)

  • Sort Key: crpg.contasareceber_faturamentos_cr_codigo
  • Sort Method: external merge Disk: 17432kB
101. 94.046 94.046 ↑ 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.011..94.046 rows=806,569 loops=1)

102. 0.000 0.000 ↓ 0.0 0 50

Index Scan using tecnicos_pkey on tecnicos t (cost=0.14..0.16 rows=1 width=122) (actual time=0.000..0.000 rows=0 loops=50)

  • Index Cond: (codigo = "*SELECT* 1".tecnicos_codigo)
Planning time : 11.332 ms
Execution time : 11,082.537 ms