explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1N88

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 18,000.557 ↑ 1.0 50 1

Limit (cost=1,198,217.00..1,237,636.71 rows=50 width=582) (actual time=18,000.457..18,000.557 rows=50 loops=1)

2. 0.027 18,000.552 ↑ 4.0 50 1

Unique (cost=1,198,217.00..1,355,895.85 rows=200 width=582) (actual time=18,000.456..18,000.552 rows=50 loops=1)

3. 0.032 18,000.525 ↑ 17,061.5 50 1

Nested Loop Left Join (cost=1,198,217.00..1,353,763.16 rows=853,077 width=582) (actual time=18,000.453..18,000.525 rows=50 loops=1)

4. 0.039 18,000.493 ↑ 17,061.5 50 1

Merge Left Join (cost=1,198,216.86..1,217,294.82 rows=853,077 width=463) (actual time=18,000.443..18,000.493 rows=50 loops=1)

  • Merge Cond: ("*SELECT* 1".codigo = crpg.contasareceber_faturamentos_cr_codigo)
5. 1,141.504 17,711.759 ↑ 17,061.5 50 1

Sort (cost=1,087,276.45..1,089,409.14 rows=853,077 width=455) (actual time=17,711.749..17,711.759 rows=50 loops=1)

  • Sort Key: "*SELECT* 1".codigo
  • Sort Method: external merge Disk: 117168kB
6. 445.517 16,570.255 ↑ 1.0 820,009 1

Hash Left Join (cost=152,631.13..653,343.48 rows=853,077 width=455) (actual time=1,760.522..16,570.255 rows=820,009 loops=1)

  • Hash Cond: ("*SELECT* 1".vendedores_codigo = v.codigo)
7. 78.699 16,124.710 ↑ 1.0 820,009 1

Append (cost=152,628.25..651,053.83 rows=853,077 width=446) (actual time=1,760.488..16,124.710 rows=820,009 loops=1)

8. 227.932 16,011.335 ↓ 1.0 819,997 1

Subquery Scan on *SELECT* 1 (cost=152,628.25..522,340.46 rows=819,941 width=446) (actual time=1,760.487..16,011.335 rows=819,997 loops=1)

9. 8,506.019 15,783.403 ↓ 1.0 819,997 1

Hash Left Join (cost=152,628.25..514,141.05 rows=819,941 width=538) (actual time=1,760.486..15,783.403 rows=819,997 loops=1)

  • Hash Cond: ("*SELECT* 1_1".tipodocumento_codigo = t_1.codigo)
10. 215.531 7,277.364 ↓ 1.0 819,997 1

Hash Left Join (cost=152,626.78..304,906.51 rows=819,941 width=364) (actual time=1,760.199..7,277.364 rows=819,997 loops=1)

  • Hash Cond: ("*SELECT* 1_1".gruposcontas_codigo = grct.codigo)
11. 305.854 7,061.827 ↓ 1.0 819,997 1

Hash Left Join (cost=152,606.88..302,713.53 rows=819,941 width=246) (actual time=1,760.188..7,061.827 rows=819,997 loops=1)

  • Hash Cond: (cr_sit.situacoesconta_codigo = sc.codigo)
12. 403.040 6,755.946 ↓ 1.0 819,997 1

Hash Join (cost=152,587.20..300,520.30 rows=819,941 width=125) (actual time=1,760.147..6,755.946 rows=819,997 loops=1)

  • Hash Cond: ("*SELECT* 1_1".clientes_codigo = c.codigo)
13. 934.214 6,315.731 ↑ 1.0 819,997 1

Hash Join (cost=151,258.67..297,038.64 rows=819,997 width=99) (actual time=1,722.904..6,315.731 rows=819,997 loops=1)

  • Hash Cond: ("*SELECT* 1_1".prevendas_codigo = pv.codigo)
14. 828.814 5,083.591 ↑ 1.0 819,997 1

Hash Left Join (cost=126,546.57..243,791.03 rows=819,997 width=91) (actual time=1,424.610..5,083.591 rows=819,997 loops=1)

  • Hash Cond: ("*SELECT* 1_1".codigo = cr_sit.contasareceber_codigo)
15. 749.533 4,055.898 ↑ 1.0 819,997 1

Hash Join (cost=101,262.71..190,728.67 rows=819,997 width=87) (actual time=1,225.337..4,055.898 rows=819,997 loops=1)

  • Hash Cond: ("*SELECT* 1_1".codigo = cr_fat.contasareceber_codigo)
16. 45.425 2,884.988 ↑ 1.0 819,997 1

Append (cost=74,385.65..136,073.10 rows=819,997 width=87) (actual time=803.592..2,884.988 rows=819,997 loops=1)

17. 117.042 2,839.563 ↑ 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=803.591..2,839.563 rows=819,997 loops=1)

18. 906.797 2,722.521 ↑ 1.0 819,997 1

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

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

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

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

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

  • Hash Cond: (pvpg_cr.prevendas_pagtos_codigo = pvpg.codigo)
21. 103.234 103.234 ↑ 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.012..103.234 rows=819,997 loops=1)

22. 83.008 179.466 ↑ 1.0 507,453 1

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

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

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

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

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

26. 212.784 423.441 ↓ 1.0 820,039 1

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

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

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

28. 125.663 421.377 ↓ 1.0 820,004 1

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

  • Buckets: 131072 Batches: 16 Memory Usage: 2832kB
29. 295.714 295.714 ↓ 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..295.714 rows=820,004 loops=1)

  • Filter: (contasareceber_codigo IS NOT NULL)
30. 121.655 198.879 ↓ 1.0 820,039 1

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

  • Buckets: 131072 Batches: 16 Memory Usage: 3033kB
31. 77.224 77.224 ↓ 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.031..77.224 rows=820,039 loops=1)

32. 92.310 297.926 ↑ 1.0 483,071 1

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

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

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

34. 3.130 37.175 ↓ 1.0 14,622 1

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

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

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

  • Filter: ((nome)::text ~~* '%'::text)
36. 0.014 0.027 ↑ 71.7 6 1

Hash (cost=14.30..14.30 rows=430 width=125) (actual time=0.027..0.027 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.012..0.013 rows=6 loops=1)

38. 0.001 0.006 ↓ 0.0 0 1

Hash (cost=14.40..14.40 rows=440 width=122) (actual time=0.005..0.006 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.010 0.020 ↓ 1.0 22 1

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

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

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

42. 0.001 1.127 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=1,332.85..71,982.69 rows=2,260 width=446) (actual time=1.127..1.127 rows=0 loops=1)

43. 0.000 1.126 ↓ 0.0 0 1

Nested Loop (cost=1,332.85..71,960.09 rows=2,260 width=538) (actual time=1.126..1.126 rows=0 loops=1)

44. 0.001 1.126 ↓ 0.0 0 1

Hash Left Join (cost=1,332.43..59,031.04 rows=2,260 width=434) (actual time=1.125..1.126 rows=0 loops=1)

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

Nested Loop Left Join (cost=1,330.95..59,023.51 rows=2,260 width=356) (actual time=1.125..1.125 rows=0 loops=1)

46. 0.000 1.125 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,330.81..58,606.79 rows=2,260 width=238) (actual time=1.125..1.125 rows=0 loops=1)

47. 0.000 1.125 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,330.66..58,233.85 rows=2,260 width=117) (actual time=1.125..1.125 rows=0 loops=1)

48. 0.001 1.125 ↓ 0.0 0 1

Hash Join (cost=1,330.23..43,797.80 rows=2,260 width=113) (actual time=1.125..1.125 rows=0 loops=1)

  • Hash Cond: ("*SELECT* 2_1".clientes_codigo = c_1.codigo)
49. 0.017 1.124 ↓ 0.0 0 1

Nested Loop (cost=1.70..42,463.33 rows=2,260 width=87) (actual time=1.124..1.124 rows=0 loops=1)

50. 0.004 0.932 ↑ 64.6 35 1

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

51. 0.008 0.928 ↑ 64.6 35 1

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

52. 0.036 0.920 ↑ 64.6 35 1

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

53. 0.010 0.604 ↑ 64.6 35 1

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

54. 0.021 0.314 ↑ 64.6 35 1

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

55. 0.048 0.048 ↑ 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.043..0.048 rows=35 loops=1)

56. 0.245 0.245 ↑ 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.007..0.007 rows=1 loops=35)

  • Index Cond: (codigo = snfpg_cr.contasareceber_codigo)
57. 0.280 0.280 ↑ 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.008..0.008 rows=1 loops=35)

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

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

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=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

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

61. 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)
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.004 33.549 ↑ 2,573.0 12 1

Subquery Scan on *SELECT* 3 (cost=43,764.41..52,465.30 rows=30,876 width=446) (actual time=33.408..33.549 rows=12 loops=1)

69. 0.428 33.545 ↑ 2,573.0 12 1

Merge Right Join (cost=43,764.41..52,156.54 rows=30,876 width=538) (actual time=33.407..33.545 rows=12 loops=1)

  • Merge Cond: (cat.contasareceber_avulsas_codigo = "*SELECT* 3_1".contasareceber_avulsas_codigo)
70. 0.014 0.032 ↑ 390.0 2 1

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

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

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

72. 0.015 33.085 ↑ 719.7 11 1

Materialize (cost=43,709.14..43,857.83 rows=7,917 width=438) (actual time=33.072..33.085 rows=11 loops=1)

73. 0.010 33.070 ↑ 879.7 9 1

Merge Left Join (cost=43,709.14..43,838.04 rows=7,917 width=438) (actual time=33.062..33.070 rows=9 loops=1)

  • Merge Cond: ("*SELECT* 3_1".contasareceber_avulsas_codigo = cav.contasareceber_avulsas_codigo)
74. 0.011 33.032 ↑ 290.0 7 1

Sort (cost=43,653.87..43,658.94 rows=2,030 width=434) (actual time=33.031..33.032 rows=7 loops=1)

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

Nested Loop Left Join (cost=1,351.33..43,542.35 rows=2,030 width=434) (actual time=32.854..33.021 rows=7 loops=1)

76. 0.006 32.944 ↑ 290.0 7 1

Hash Left Join (cost=1,350.76..29,892.54 rows=2,030 width=309) (actual time=32.833..32.944 rows=7 loops=1)

  • Hash Cond: ("*SELECT* 3_1".tipodocumento_codigo = t_3.codigo)
77. 0.008 32.924 ↑ 290.0 7 1

Hash Left Join (cost=1,349.29..29,885.63 rows=2,030 width=231) (actual time=32.816..32.924 rows=7 loops=1)

  • Hash Cond: ("*SELECT* 3_1".gruposcontas_codigo = grct_2.codigo)
78. 0.056 32.905 ↑ 290.0 7 1

Hash Join (cost=1,329.39..29,860.34 rows=2,030 width=113) (actual time=32.798..32.905 rows=7 loops=1)

  • Hash Cond: ("*SELECT* 3_1".clientes_codigo = c_2.codigo)
79. 0.010 0.140 ↑ 290.0 7 1

Nested Loop (cost=0.85..28,526.48 rows=2,030 width=87) (actual time=0.036..0.140 rows=7 loops=1)

80. 0.001 0.088 ↑ 290.0 7 1

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

81. 0.003 0.087 ↑ 290.0 7 1

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

82. 0.010 0.084 ↑ 290.0 7 1

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

83. 0.018 0.018 ↑ 290.0 7 1

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

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

  • Index Cond: (codigo = crav.contasareceber_codigo)
85. 0.042 0.042 ↑ 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.006..0.006 rows=1 loops=7)

  • Index Cond: ((contasareceber_codigo = "*SELECT* 3_1".codigo) AND (contasareceber_codigo IS NOT NULL))
  • Heap Fetches: 7
86. 2.476 32.709 ↓ 1.0 14,622 1

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

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

Seq Scan on clientes c_2 (cost=0.00..1,145.78 rows=14,621 width=30) (actual time=0.015..30.233 rows=14,622 loops=1)

  • Filter: ((nome)::text ~~* '%'::text)
88. 0.001 0.011 ↓ 0.0 0 1

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

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

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

90. 0.005 0.014 ↓ 1.0 22 1

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

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

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

92. 0.007 0.070 ↑ 1.0 1 7

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

93. 0.056 0.056 ↑ 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.007..0.008 rows=1 loops=7)

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

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=7)

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

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

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

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

97. 0.012 0.028 ↑ 1.0 39 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
98. 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.009..0.016 rows=39 loops=1)

99. 0.019 288.695 ↑ 16,460.6 49 1

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

100. 139.073 288.676 ↑ 16,460.6 49 1

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

  • Sort Key: crpg.contasareceber_faturamentos_cr_codigo
  • Sort Method: external merge Disk: 17432kB
101. 149.603 149.603 ↑ 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.037..149.603 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 : 20.116 ms
Execution time : 18,034.956 ms