explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Re3y

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

Limit (cost=1,175,117.53..1,214,438.46 rows=50 width=582) (actual time=11,860.579..11,860.678 rows=50 loops=1)

2. 0.020 11,860.674 ↑ 4.0 50 1

Unique (cost=1,175,117.53..1,332,401.26 rows=200 width=582) (actual time=11,860.579..11,860.674 rows=50 loops=1)

3. 0.023 11,860.654 ↑ 17,018.2 50 1

Nested Loop Left Join (cost=1,175,117.53..1,330,273.98 rows=850,911 width=582) (actual time=11,860.577..11,860.654 rows=50 loops=1)

4. 0.052 11,860.631 ↑ 17,018.2 50 1

Merge Left Join (cost=1,175,117.39..1,194,152.03 rows=850,911 width=463) (actual time=11,860.569..11,860.631 rows=50 loops=1)

  • Merge Cond: ("*SELECT* 1".codigo = crpg.contasareceber_faturamentos_cr_codigo)
5. 1,083.761 11,666.319 ↑ 17,018.2 50 1

Sort (cost=1,064,176.98..1,066,304.26 rows=850,911 width=455) (actual time=11,666.310..11,666.319 rows=50 loops=1)

  • Sort Key: "*SELECT* 1".codigo
  • Sort Method: external merge Disk: 117288kB
6. 239.736 10,582.558 ↑ 1.0 820,010 1

Hash Left Join (cost=152,594.85..631,355.00 rows=850,911 width=455) (actual time=1,030.926..10,582.558 rows=820,010 loops=1)

  • Hash Cond: ("*SELECT* 1".vendedores_codigo = v.codigo)
7. 68.561 10,342.808 ↑ 1.0 820,010 1

Append (cost=152,591.98..629,071.14 rows=850,911 width=446) (actual time=1,030.909..10,342.808 rows=820,010 loops=1)

8. 152.035 10,269.355 ↑ 1.0 820,000 1

Subquery Scan on *SELECT* 1 (cost=152,591.98..570,757.06 rows=820,000 width=446) (actual time=1,030.908..10,269.355 rows=820,000 loops=1)

9. 5,396.252 10,117.320 ↑ 1.0 820,000 1

Hash Left Join (cost=152,591.98..562,557.06 rows=820,000 width=538) (actual time=1,030.907..10,117.320 rows=820,000 loops=1)

  • Hash Cond: ("*SELECT* 1_1".gruposcontas_codigo = grct.codigo)
10. 223.464 4,721.066 ↑ 1.0 820,000 1

Hash Left Join (cost=152,572.08..353,313.92 rows=820,000 width=324) (actual time=1,030.732..4,721.066 rows=820,000 loops=1)

  • Hash Cond: (cr_sit.situacoesconta_codigo = sc.codigo)
11. 291.790 4,497.595 ↑ 1.0 820,000 1

Hash Left Join (cost=152,552.40..351,120.53 rows=820,000 width=203) (actual time=1,030.720..4,497.595 rows=820,000 loops=1)

  • Hash Cond: ("*SELECT* 1_1".clientes_codigo = c.codigo)
12. 681.484 4,201.597 ↑ 1.0 820,000 1

Hash Join (cost=151,260.41..347,675.42 rows=820,000 width=177) (actual time=1,026.499..4,201.597 rows=820,000 loops=1)

  • Hash Cond: ("*SELECT* 1_1".prevendas_codigo = pv.codigo)
13. 576.534 3,345.335 ↑ 1.0 820,000 1

Hash Left Join (cost=126,548.29..278,411.77 rows=820,000 width=169) (actual time=851.682..3,345.335 rows=820,000 loops=1)

  • Hash Cond: ("*SELECT* 1_1".codigo = cr_sit.contasareceber_codigo)
14. 506.542 2,629.171 ↑ 1.0 820,000 1

Hash Join (cost=101,264.37..209,333.34 rows=820,000 width=165) (actual time=712.014..2,629.171 rows=820,000 loops=1)

  • Hash Cond: ("*SELECT* 1_1".codigo = cr_fat.contasareceber_codigo)
15. 39.261 1,931.258 ↑ 1.0 820,000 1

Append (cost=74,387.23..138,661.69 rows=820,000 width=165) (actual time=520.601..1,931.258 rows=820,000 loops=1)

16. 85.885 1,891.997 ↑ 1.0 820,000 1

Subquery Scan on *SELECT* 1_1 (cost=74,387.23..134,561.69 rows=820,000 width=165) (actual time=520.600..1,891.997 rows=820,000 loops=1)

17. 153.872 1,806.112 ↑ 1.0 820,000 1

Hash Left Join (cost=74,387.23..126,361.69 rows=820,000 width=246) (actual time=520.600..1,806.112 rows=820,000 loops=1)

  • Hash Cond: (cr.tipodocumento_codigo = t_1.codigo)
18. 430.570 1,652.230 ↑ 1.0 820,000 1

Hash Join (cost=74,385.76..123,773.31 rows=820,000 width=43) (actual time=520.582..1,652.230 rows=820,000 loops=1)

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

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

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

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

  • Hash Cond: (pvpg_cr.prevendas_pagtos_codigo = pvpg.codigo)
21. 72.650 72.650 ↑ 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..72.650 rows=820,000 loops=1)

22. 64.198 115.712 ↓ 1.0 507,455 1

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

  • Buckets: 131072 Batches: 8 Memory Usage: 3498kB
23. 51.514 51.514 ↓ 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.006..51.514 rows=507,455 loops=1)

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

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

  • Buckets: 131072 Batches: 8 Memory Usage: 3385kB
25. 64.964 64.964 ↑ 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.144..64.964 rows=483,072 loops=1)

26. 149.499 279.787 ↑ 1.0 820,042 1

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

  • Buckets: 65536 Batches: 32 Memory Usage: 2161kB
27. 130.288 130.288 ↑ 1.0 820,042 1

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

28. 0.003 0.010 ↓ 1.0 22 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
29. 0.007 0.007 ↓ 1.0 22 1

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

30. 99.774 191.371 ↓ 1.0 820,007 1

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

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

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

  • Filter: (contasareceber_codigo IS NOT NULL)
32. 84.797 139.630 ↓ 1.0 820,042 1

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

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

Seq Scan on contasareceber_situacao cr_sit (cost=0.00..11,829.41 rows=820,041 width=8) (actual time=0.005..54.833 rows=820,042 loops=1)

34. 67.516 174.778 ↑ 1.0 483,072 1

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

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

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

36. 1.785 4.208 ↑ 1.0 14,622 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 1036kB
37. 2.423 2.423 ↑ 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.423 rows=14,622 loops=1)

38. 0.002 0.007 ↑ 71.7 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
39. 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)

40. 0.001 0.002 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
41. 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)

42. 0.000 0.494 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=23.01..1,807.36 rows=35 width=446) (actual time=0.494..0.494 rows=0 loops=1)

43. 0.001 0.494 ↓ 0.0 0 1

Nested Loop (cost=23.01..1,807.01 rows=35 width=538) (actual time=0.494..0.494 rows=0 loops=1)

44. 0.001 0.493 ↓ 0.0 0 1

Hash Left Join (cost=22.59..1,502.77 rows=35 width=434) (actual time=0.493..0.493 rows=0 loops=1)

  • Hash Cond: ("*SELECT* 2_1".gruposcontas_codigo = grct_1.codigo)
45. 0.000 0.492 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.69..1,482.78 rows=35 width=316) (actual time=0.492..0.492 rows=0 loops=1)

46. 0.000 0.492 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.54..1,477.01 rows=35 width=195) (actual time=0.492..0.492 rows=0 loops=1)

47. 0.000 0.492 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.12..1,181.52 rows=35 width=191) (actual time=0.492..0.492 rows=0 loops=1)

48. 0.020 0.492 ↓ 0.0 0 1

Nested Loop (cost=1.83..914.93 rows=35 width=165) (actual time=0.491..0.492 rows=0 loops=1)

49. 0.003 0.367 ↑ 1.0 35 1

Append (cost=1.41..619.35 rows=35 width=165) (actual time=0.052..0.367 rows=35 loops=1)

50. 0.004 0.364 ↑ 1.0 35 1

Subquery Scan on *SELECT* 2_1 (cost=1.41..619.18 rows=35 width=165) (actual time=0.052..0.364 rows=35 loops=1)

51. 0.002 0.360 ↑ 1.0 35 1

Nested Loop Left Join (cost=1.41..618.83 rows=35 width=246) (actual time=0.051..0.360 rows=35 loops=1)

52. 0.003 0.323 ↑ 1.0 35 1

Nested Loop (cost=1.27..613.43 rows=35 width=43) (actual time=0.044..0.323 rows=35 loops=1)

53. 0.002 0.215 ↑ 1.0 35 1

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

54. 0.030 0.108 ↑ 1.0 35 1

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

55. 0.008 0.008 ↑ 1.0 35 1

Seq Scan on saidasnf_pagtos_contasareceber snfpg_cr (cost=0.00..1.35 rows=35 width=8) (actual time=0.005..0.008 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.035 0.035 ↑ 1.0 1 35

Index Scan using tipodocumento_pkey on tipodocumento t_2 (cost=0.14..0.16 rows=1 width=82) (actual time=0.001..0.001 rows=1 loops=35)

  • Index Cond: (codigo = cr_1.tipodocumento_codigo)
60. 0.105 0.105 ↓ 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.003..0.003 rows=0 loops=35)

  • Index Cond: ((contasareceber_codigo = "*SELECT* 2_1".codigo) AND (contasareceber_codigo IS NOT NULL))
  • Heap Fetches: 0
61. 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)
62. 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)
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

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

65. 0.000 0.000 ↓ 0.0 0

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

66. 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)
67. 0.003 4.398 ↑ 3,087.6 10 1

Subquery Scan on *SELECT* 3 (cost=43,387.59..52,252.16 rows=30,876 width=446) (actual time=4.323..4.398 rows=10 loops=1)

68. 0.220 4.395 ↑ 3,087.6 10 1

Hash Left Join (cost=43,387.59..51,943.40 rows=30,876 width=538) (actual time=4.322..4.395 rows=10 loops=1)

  • Hash Cond: ("*SELECT* 3_1".gruposcontas_codigo = grct_2.codigo)
69. 0.007 4.173 ↑ 3,087.6 10 1

Hash Left Join (cost=43,367.69..44,045.48 rows=30,876 width=324) (actual time=4.157..4.173 rows=10 loops=1)

  • Hash Cond: (cr_sit_2.situacoesconta_codigo = sc_2.codigo)
70. 0.005 4.162 ↑ 3,087.6 10 1

Merge Right Join (cost=43,348.01..43,943.96 rows=30,876 width=203) (actual time=4.150..4.162 rows=10 loops=1)

  • Merge Cond: (cat.contasareceber_avulsas_codigo = "*SELECT* 3_1".contasareceber_avulsas_codigo)
71. 0.005 0.008 ↑ 390.0 2 1

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

  • Sort Key: cat.contasareceber_avulsas_codigo
  • Sort Method: quicksort Memory: 25kB
72. 0.003 0.003 ↑ 390.0 2 1

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

73. 0.005 4.149 ↑ 879.7 9 1

Materialize (cost=43,292.74..43,441.44 rows=7,917 width=199) (actual time=4.140..4.149 rows=9 loops=1)

74. 0.007 4.144 ↑ 989.6 8 1

Merge Left Join (cost=43,292.74..43,421.65 rows=7,917 width=199) (actual time=4.139..4.144 rows=8 loops=1)

  • Merge Cond: ("*SELECT* 3_1".contasareceber_avulsas_codigo = cav.contasareceber_avulsas_codigo)
75. 0.005 4.130 ↑ 290.0 7 1

Sort (cost=43,237.47..43,242.55 rows=2,030 width=195) (actual time=4.130..4.130 rows=7 loops=1)

  • Sort Key: "*SELECT* 3_1".contasareceber_avulsas_codigo
  • Sort Method: quicksort Memory: 26kB
76. 0.007 4.125 ↑ 290.0 7 1

Nested Loop Left Join (cost=1,294.74..43,125.95 rows=2,030 width=195) (actual time=4.063..4.125 rows=7 loops=1)

77. 0.009 4.104 ↑ 290.0 7 1

Hash Left Join (cost=1,294.32..29,831.68 rows=2,030 width=191) (actual time=4.056..4.104 rows=7 loops=1)

  • Hash Cond: ("*SELECT* 3_1".clientes_codigo = c_2.codigo)
78. 0.008 0.073 ↑ 290.0 7 1

Nested Loop (cost=2.32..28,534.36 rows=2,030 width=165) (actual time=0.027..0.073 rows=7 loops=1)

79. 0.002 0.044 ↑ 290.0 7 1

Append (cost=1.90..14,799.01 rows=2,030 width=165) (actual time=0.022..0.044 rows=7 loops=1)

80. 0.001 0.042 ↑ 290.0 7 1

Subquery Scan on *SELECT* 3_1 (cost=1.90..14,788.86 rows=2,030 width=165) (actual time=0.021..0.042 rows=7 loops=1)

81. 0.008 0.041 ↑ 290.0 7 1

Hash Left Join (cost=1.90..14,768.56 rows=2,030 width=246) (actual time=0.021..0.041 rows=7 loops=1)

  • Hash Cond: (cr_2.tipodocumento_codigo = t_3.codigo)
82. 0.007 0.025 ↑ 290.0 7 1

Nested Loop (cost=0.42..14,760.68 rows=2,030 width=43) (actual time=0.007..0.025 rows=7 loops=1)

83. 0.004 0.004 ↑ 290.0 7 1

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

  • Filter: (codigo IS NOT NULL)
84. 0.014 0.014 ↑ 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.002..0.002 rows=1 loops=7)

  • Index Cond: (codigo = crav.contasareceber_codigo)
85. 0.004 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
86. 0.004 0.004 ↓ 1.0 22 1

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

87. 0.021 0.021 ↑ 1.0 1 7

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.003..0.003 rows=1 loops=7)

  • Index Cond: ((contasareceber_codigo = "*SELECT* 3_1".codigo) AND (contasareceber_codigo IS NOT NULL))
  • Heap Fetches: 7
88. 1.640 4.022 ↑ 1.0 14,622 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 1036kB
89. 2.382 2.382 ↑ 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.382 rows=14,622 loops=1)

90. 0.014 0.014 ↑ 1.0 1 7

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

  • Index Cond: ("*SELECT* 3_1".codigo = contasareceber_codigo)
91. 0.004 0.007 ↑ 97.5 8 1

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

  • Sort Key: cav.contasareceber_avulsas_codigo
  • Sort Method: quicksort Memory: 25kB
92. 0.003 0.003 ↑ 97.5 8 1

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

93. 0.001 0.004 ↑ 71.7 6 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
94. 0.003 0.003 ↑ 71.7 6 1

Seq Scan on situacoescontas sc_2 (cost=0.00..14.30 rows=430 width=125) (actual time=0.002..0.003 rows=6 loops=1)

95. 0.000 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
96. 0.002 0.002 ↓ 0.0 0 1

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

97. 0.006 0.014 ↑ 1.0 39 1

Hash (cost=2.39..2.39 rows=39 width=13) (actual time=0.014..0.014 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 194.260 ↑ 16,460.6 49 1

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

100. 100.392 194.253 ↑ 16,460.6 49 1

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

  • Sort Key: crpg.contasareceber_faturamentos_cr_codigo
  • Sort Method: external merge Disk: 17432kB
101. 93.861 93.861 ↑ 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.015..93.861 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 : 10.680 ms
Execution time : 12,196.719 ms