explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9BxW

Settings
# exclusive inclusive rows x rows loops node
1. 1.593 74,890.450 ↓ 2.0 4,556 1

Append (cost=8,280.96..1,109,083.01 rows=2,313 width=7,758) (actual time=137.743..74,890.450 rows=4,556 loops=1)

2. 19,961.977 24,347.141 ↓ 2.0 4,516 1

Nested Loop Left Join (cost=8,280.96..894,962.18 rows=2,275 width=2,386) (actual time=137.742..24,347.141 rows=4,516 loops=1)

  • Join Filter: (saldoinv.pro_id = pro.pro_id)
  • Rows Removed by Join Filter: 2343289
3. 5.592 180.768 ↓ 2.0 4,516 1

Hash Left Join (cost=7,888.52..18,120.41 rows=2,275 width=525) (actual time=130.051..180.768 rows=4,516 loops=1)

  • Hash Cond: (cla1.cla1_id = jl.cla1_id)
4. 4.876 174.827 ↓ 2.0 4,516 1

Hash Left Join (cost=7,856.76..18,055.45 rows=2,275 width=524) (actual time=129.696..174.827 rows=4,516 loops=1)

  • Hash Cond: (cla1.cla1_id = jl_1.cla1_id)
5. 13.606 169.561 ↓ 2.0 4,516 1

Hash Right Join (cost=7,824.99..17,990.50 rows=2,275 width=519) (actual time=129.296..169.561 rows=4,516 loops=1)

  • Hash Cond: (saldoinv_1.pro_id = pro.pro_id)
6. 26.798 27.960 ↓ 73.4 3,888 1

Bitmap Heap Scan on saldoinv saldoinv_1 (cost=3,849.93..14,014.97 rows=53 width=79) (actual time=1.288..27.960 rows=3,888 loops=1)

  • Recheck Cond: (bod_id = 1)
  • Filter: ((sal_periodo)::double precision = date_part('year'::text, (('now'::cstring)::date)::timestamp without time zone))
  • Rows Removed by Filter: 7121
  • Heap Blocks: exact=781
7. 1.162 1.162 ↓ 1.1 11,260 1

Bitmap Index Scan on idx_saldoinv_bod (cost=0.00..3,849.91 rows=10,640 width=0) (actual time=1.162..1.162 rows=11,260 loops=1)

  • Index Cond: (bod_id = 1)
8. 6.784 127.995 ↓ 2.0 4,516 1

Hash (cost=3,946.63..3,946.63 rows=2,275 width=444) (actual time=127.995..127.995 rows=4,516 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 2027kB
9. 5.837 121.211 ↓ 2.0 4,516 1

Hash Right Join (cost=3,468.08..3,946.63 rows=2,275 width=444) (actual time=113.527..121.211 rows=4,516 loops=1)

  • Hash Cond: (dlp.pro_id = pro.pro_id)
10. 1.885 1.885 ↓ 1.0 4,556 1

Index Scan using dlistapre_llave_cabecera on dlistapre dlp (cost=0.29..439.20 rows=4,518 width=10) (actual time=0.028..1.885 rows=4,556 loops=1)

  • Index Cond: (lpr_id = 1)
11. 6.952 113.489 ↓ 2.0 4,516 1

Hash (cost=3,439.35..3,439.35 rows=2,275 width=438) (actual time=113.488..113.489 rows=4,516 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 2000kB
12. 2.317 106.537 ↓ 2.0 4,516 1

Hash Left Join (cost=2,792.09..3,439.35 rows=2,275 width=438) (actual time=92.838..106.537 rows=4,516 loops=1)

  • Hash Cond: (pro1.cli_id = cli.cli_id)
13. 2.270 100.782 ↓ 2.0 4,516 1

Hash Left Join (cost=2,552.39..3,173.03 rows=2,275 width=430) (actual time=89.387..100.782 rows=4,516 loops=1)

  • Hash Cond: (pro1.prod1_id = abc2.prod1_id)
14. 2.401 97.129 ↓ 2.0 4,516 1

Hash Left Join (cost=2,441.48..3,034.95 rows=2,275 width=426) (actual time=87.993..97.129 rows=4,516 loops=1)

  • Hash Cond: (pro1.prod1_id = abc1.prod1_id)
15. 5.639 93.310 ↓ 2.0 4,516 1

Hash Right Join (cost=2,330.56..2,896.88 rows=2,275 width=422) (actual time=86.564..93.310 rows=4,516 loops=1)

  • Hash Cond: (buf.pro_id = pro.pro_id)
16. 1.127 1.127 ↑ 1.0 4,012 1

Seq Scan on buffer buf (cost=0.00..531.12 rows=4,012 width=39) (actual time=0.009..1.127 rows=4,012 loops=1)

17. 5.143 86.544 ↓ 2.0 4,516 1

Hash (cost=2,302.13..2,302.13 rows=2,275 width=387) (actual time=86.544..86.544 rows=4,516 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 1811kB
18. 4.117 81.401 ↓ 2.0 4,516 1

Hash Right Join (cost=2,131.29..2,302.13 rows=2,275 width=387) (actual time=76.003..81.401 rows=4,516 loops=1)

  • Hash Cond: (pro_img.pro_id = pro.pro_id)
19. 1.302 1.302 ↓ 1.0 4,556 1

Seq Scan on producto_imagen pro_img (cost=0.00..131.12 rows=4,552 width=28) (actual time=0.014..1.302 rows=4,556 loops=1)

  • Filter: (pim_activo AND (pim_orden = 1))
  • Rows Removed by Filter: 1495
20. 5.382 75.982 ↓ 2.0 4,516 1

Hash (cost=2,102.99..2,102.99 rows=2,264 width=363) (actual time=75.982..75.982 rows=4,516 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 1714kB
21. 1.585 70.600 ↓ 2.0 4,516 1

Hash Left Join (cost=1,788.40..2,102.99 rows=2,264 width=363) (actual time=58.078..70.600 rows=4,516 loops=1)

  • Hash Cond: (pro1.uinv_id = ubi2.ubinv_id)
22. 1.777 68.343 ↓ 2.0 4,516 1

Hash Left Join (cost=1,727.18..2,033.27 rows=2,264 width=354) (actual time=57.397..68.343 rows=4,516 loops=1)

  • Hash Cond: (pro1.spa_id = spa.spa_id)
23. 1.692 66.459 ↓ 2.0 4,516 1

Hash Left Join (cost=1,720.62..1,995.67 rows=2,264 width=344) (actual time=57.283..66.459 rows=4,516 loops=1)

  • Hash Cond: (pro1.cla2_id = cla2.cla2_id)
24. 1.938 64.753 ↓ 2.0 4,516 1

Hash Left Join (cost=1,719.26..1,963.18 rows=2,264 width=337) (actual time=57.262..64.753 rows=4,516 loops=1)

  • Hash Cond: (pro1.cla1_id = cla1.cla1_id)
25. 4.176 62.599 ↓ 2.0 4,516 1

Hash Right Join (cost=1,704.48..1,917.27 rows=2,264 width=314) (actual time=57.032..62.599 rows=4,516 loops=1)

  • Hash Cond: (idi4.prod1_id = pro1.prod1_id)
26. 1.418 1.418 ↓ 1.0 4,551 1

Index Scan using idx_producto1i_idi_id on producto1_idioma idi4 (cost=0.29..174.59 rows=4,382 width=29) (actual time=0.016..1.418 rows=4,551 loops=1)

  • Index Cond: (idi_id = 4)
27. 4.375 57.005 ↓ 2.0 4,516 1

Hash (cost=1,675.89..1,675.89 rows=2,264 width=289) (actual time=57.005..57.005 rows=4,516 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 1372kB
28. 3.929 52.630 ↓ 2.0 4,516 1

Hash Right Join (cost=1,463.29..1,675.89 rows=2,264 width=289) (actual time=47.264..52.630 rows=4,516 loops=1)

  • Hash Cond: (idi1.prod1_id = pro1.prod1_id)
29. 1.468 1.468 ↓ 1.0 4,544 1

Index Scan using idx_producto1i_idi_id on producto1_idioma idi1 (cost=0.29..174.47 rows=4,375 width=29) (actual time=0.022..1.468 rows=4,544 loops=1)

  • Index Cond: (idi_id = 1)
30. 4.179 47.233 ↓ 2.0 4,516 1

Hash (cost=1,434.70..1,434.70 rows=2,264 width=264) (actual time=47.233..47.233 rows=4,516 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 1217kB
31. 4.027 43.054 ↓ 2.0 4,516 1

Hash Right Join (cost=1,222.31..1,434.70 rows=2,264 width=264) (actual time=37.733..43.054 rows=4,516 loops=1)

  • Hash Cond: (idi3.prod1_id = pro1.prod1_id)
32. 1.316 1.316 ↓ 1.0 4,535 1

Index Scan using idx_producto1i_idi_id on producto1_idioma idi3 (cost=0.29..174.33 rows=4,367 width=29) (actual time=0.012..1.316 rows=4,535 loops=1)

  • Index Cond: (idi_id = 3)
33. 4.121 37.711 ↓ 2.0 4,516 1

Hash (cost=1,193.73..1,193.73 rows=2,264 width=239) (actual time=37.711..37.711 rows=4,516 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 1171kB
34. 3.889 33.590 ↓ 2.0 4,516 1

Hash Right Join (cost=983.67..1,193.73 rows=2,264 width=239) (actual time=28.439..33.590 rows=4,516 loops=1)

  • Hash Cond: (idi2.prod1_id = pro1.prod1_id)
35. 1.308 1.308 ↓ 1.0 4,475 1

Index Scan using idx_producto1i_idi_id on producto1_idioma idi2 (cost=0.29..172.53 rows=4,306 width=29) (actual time=0.035..1.308 rows=4,475 loops=1)

  • Index Cond: (idi_id = 2)
36. 4.023 28.393 ↓ 2.0 4,516 1

Hash (cost=955.09..955.09 rows=2,264 width=214) (actual time=28.393..28.393 rows=4,516 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 1091kB
37. 1.909 24.370 ↓ 2.0 4,516 1

Hash Left Join (cost=684.75..955.09 rows=2,264 width=214) (actual time=12.063..24.370 rows=4,516 loops=1)

  • Hash Cond: (pro1.mdl_id = mdl.mdl_id)
38. 1.744 21.903 ↓ 2.0 4,516 1

Hash Left Join (cost=628.76..867.97 rows=2,264 width=210) (actual time=11.497..21.903 rows=4,516 loops=1)

  • Hash Cond: (pro.uinv_id = ubi1.ubinv_id)
39. 1.501 19.491 ↓ 2.0 4,516 1

Hash Left Join (cost=567.53..780.61 rows=2,264 width=201) (actual time=10.823..19.491 rows=4,516 loops=1)

  • Hash Cond: (pro.ubi_id = ubi.ubi_id)
40. 1.613 17.890 ↓ 2.0 4,516 1

Hash Left Join (cost=558.59..740.55 rows=2,264 width=195) (actual time=10.718..17.890 rows=4,516 loops=1)

  • Hash Cond: (pro.uni_id = uni.uni_id)
41. 1.549 16.270 ↓ 2.0 4,516 1

Hash Left Join (cost=557.48..708.31 rows=2,264 width=195) (actual time=10.705..16.270 rows=4,516 loops=1)

  • Hash Cond: (pro.mar_id = mar.mar_id)
42. 3.467 14.692 ↓ 2.0 4,516 1

Hash Right Join (cost=555.09..674.79 rows=2,264 width=193) (actual time=10.665..14.692 rows=4,516 loops=1)

  • Hash Cond: (sthi.pro_id = pro.pro_id)
43. 0.589 0.589 ↑ 1.0 4,144 1

Seq Scan on mv_stock_historico sthi (cost=0.00..83.44 rows=4,144 width=49) (actual time=0.019..0.589 rows=4,144 loops=1)

44. 2.417 10.636 ↓ 2.0 4,516 1

Hash (cost=526.79..526.79 rows=2,264 width=148) (actual time=10.636..10.636 rows=4,516 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 841kB
45. 4.161 8.219 ↓ 2.0 4,516 1

Hash Left Join (cost=186.26..526.79 rows=2,264 width=148) (actual time=3.206..8.219 rows=4,516 loops=1)

  • Hash Cond: (pro.pro_id = pro1.pro_id)
  • Filter: (NOT (hashed SubPlan 374))
  • Rows Removed by Filter: 40
46. 0.887 0.887 ↓ 1.0 4,556 1

Seq Scan on producto pro (cost=0.00..267.29 rows=4,529 width=96) (actual time=0.012..0.887 rows=4,556 loops=1)

47. 1.533 3.163 ↓ 1.0 4,556 1

Hash (cost=129.00..129.00 rows=4,500 width=56) (actual time=3.163..3.163 rows=4,556 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 451kB
48. 1.630 1.630 ↓ 1.0 4,556 1

Seq Scan on producto1 pro1 (cost=0.00..129.00 rows=4,500 width=56) (actual time=0.010..1.630 rows=4,556 loops=1)

49.          

SubPlan (forHash Left Join)

50. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on datos_motostop (cost=0.00..1.01 rows=1 width=4) (actual time=0.007..0.008 rows=1 loops=1)

51. 0.017 0.029 ↑ 1.0 62 1

Hash (cost=1.62..1.62 rows=62 width=10) (actual time=0.029..0.029 rows=62 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
52. 0.012 0.012 ↑ 1.0 62 1

Seq Scan on marca mar (cost=0.00..1.62 rows=62 width=10) (actual time=0.006..0.012 rows=62 loops=1)

53. 0.001 0.007 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=8) (actual time=0.007..0.007 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
54. 0.006 0.006 ↑ 1.0 5 1

Seq Scan on unidad uni (cost=0.00..1.05 rows=5 width=8) (actual time=0.004..0.006 rows=5 loops=1)

55. 0.056 0.100 ↓ 1.0 268 1

Hash (cost=5.64..5.64 rows=264 width=14) (actual time=0.100..0.100 rows=268 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
56. 0.044 0.044 ↓ 1.0 268 1

Seq Scan on ubicacion ubi (cost=0.00..5.64 rows=264 width=14) (actual time=0.006..0.044 rows=268 loops=1)

57. 0.342 0.668 ↓ 1.0 1,961 1

Hash (cost=37.21..37.21 rows=1,921 width=17) (actual time=0.668..0.668 rows=1,961 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 116kB
58. 0.326 0.326 ↓ 1.0 1,961 1

Seq Scan on ubicacioninv ubi1 (cost=0.00..37.21 rows=1,921 width=17) (actual time=0.006..0.326 rows=1,961 loops=1)

59. 0.284 0.558 ↑ 1.1 1,564 1

Hash (cost=35.44..35.44 rows=1,644 width=12) (actual time=0.558..0.558 rows=1,564 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 87kB
60. 0.274 0.274 ↑ 1.1 1,564 1

Seq Scan on modelo mdl (cost=0.00..35.44 rows=1,644 width=12) (actual time=0.007..0.274 rows=1,564 loops=1)

61. 0.105 0.216 ↓ 1.0 436 1

Hash (cost=9.35..9.35 rows=435 width=23) (actual time=0.216..0.216 rows=436 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
62. 0.111 0.111 ↓ 1.0 436 1

Seq Scan on clasificacion1 cla1 (cost=0.00..9.35 rows=435 width=23) (actual time=0.015..0.111 rows=436 loops=1)

63. 0.005 0.014 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=15) (actual time=0.014..0.014 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
64. 0.009 0.009 ↑ 1.0 16 1

Seq Scan on clasificacion2 cla2 (cost=0.00..1.16 rows=16 width=15) (actual time=0.005..0.009 rows=16 loops=1)

65. 0.036 0.107 ↓ 1.0 159 1

Hash (cost=4.58..4.58 rows=158 width=18) (actual time=0.107..0.107 rows=159 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
66. 0.071 0.071 ↓ 1.0 159 1

Seq Scan on subpartidaarancelaria spa (cost=0.00..4.58 rows=158 width=18) (actual time=0.007..0.071 rows=159 loops=1)

67. 0.331 0.672 ↓ 1.0 1,961 1

Hash (cost=37.21..37.21 rows=1,921 width=17) (actual time=0.672..0.672 rows=1,961 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 116kB
68. 0.341 0.341 ↓ 1.0 1,961 1

Seq Scan on ubicacioninv ubi2 (cost=0.00..37.21 rows=1,921 width=17) (actual time=0.012..0.341 rows=1,961 loops=1)

69. 0.727 1.418 ↑ 1.0 3,685 1

Hash (cost=64.85..64.85 rows=3,685 width=8) (actual time=1.417..1.418 rows=3,685 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 176kB
70. 0.691 0.691 ↑ 1.0 3,685 1

Seq Scan on producto_clasabcfms1 abc1 (cost=0.00..64.85 rows=3,685 width=8) (actual time=0.007..0.691 rows=3,685 loops=1)

71. 0.752 1.383 ↑ 1.0 3,685 1

Hash (cost=64.85..64.85 rows=3,685 width=8) (actual time=1.383..1.383 rows=3,685 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 176kB
72. 0.631 0.631 ↑ 1.0 3,685 1

Seq Scan on producto_clasabcfms2 abc2 (cost=0.00..64.85 rows=3,685 width=8) (actual time=0.009..0.631 rows=3,685 loops=1)

73. 1.102 3.438 ↓ 1.0 6,221 1

Hash (cost=162.37..162.37 rows=6,186 width=16) (actual time=3.437..3.438 rows=6,221 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 366kB
74. 2.336 2.336 ↓ 1.0 6,221 1

Index Only Scan using idx_clu_cliente on cliente cli (cost=0.28..162.37 rows=6,186 width=16) (actual time=0.015..2.336 rows=6,221 loops=1)

  • Heap Fetches: 3104
75. 0.074 0.390 ↓ 1.0 421 1

Hash (cost=26.55..26.55 rows=417 width=9) (actual time=0.390..0.390 rows=421 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
76. 0.109 0.316 ↓ 1.0 421 1

Hash Left Join (cost=2.40..26.55 rows=417 width=9) (actual time=0.063..0.316 rows=421 loops=1)

  • Hash Cond: (jl_1.emp_id = emp_1.emp_id)
77. 0.165 0.165 ↓ 1.0 421 1

Seq Scan on jefe_linea jl_1 (cost=0.00..18.43 rows=417 width=8) (actual time=0.016..0.165 rows=421 loops=1)

  • Filter: (jel_tipo = 2)
  • Rows Removed by Filter: 421
78. 0.028 0.042 ↓ 1.1 67 1

Hash (cost=1.62..1.62 rows=62 width=9) (actual time=0.042..0.042 rows=67 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
79. 0.014 0.014 ↓ 1.1 67 1

Seq Scan on empleado emp_1 (cost=0.00..1.62 rows=62 width=9) (actual time=0.006..0.014 rows=67 loops=1)

80. 0.067 0.349 ↓ 1.0 421 1

Hash (cost=26.55..26.55 rows=417 width=9) (actual time=0.349..0.349 rows=421 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
81. 0.121 0.282 ↓ 1.0 421 1

Hash Left Join (cost=2.40..26.55 rows=417 width=9) (actual time=0.037..0.282 rows=421 loops=1)

  • Hash Cond: (jl.emp_id = emp.emp_id)
82. 0.136 0.136 ↓ 1.0 421 1

Seq Scan on jefe_linea jl (cost=0.00..18.43 rows=417 width=8) (actual time=0.007..0.136 rows=421 loops=1)

  • Filter: (jel_tipo = 1)
  • Rows Removed by Filter: 421
83. 0.015 0.025 ↓ 1.1 67 1

Hash (cost=1.62..1.62 rows=62 width=9) (actual time=0.025..0.025 rows=67 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
84. 0.010 0.010 ↓ 1.1 67 1

Seq Scan on empleado emp (cost=0.00..1.62 rows=62 width=9) (actual time=0.003..0.010 rows=67 loops=1)

85. 128.976 130.964 ↓ 103.8 519 4,516

Materialize (cost=392.44..1,580.65 rows=5 width=79) (actual time=0.000..0.029 rows=519 loops=4,516)

86. 1.843 1.988 ↓ 103.8 519 1

Bitmap Heap Scan on saldoinv (cost=392.44..1,580.62 rows=5 width=79) (actual time=0.492..1.988 rows=519 loops=1)

  • Recheck Cond: (bod_id = 6)
  • Filter: ((sal_periodo)::double precision = date_part('year'::text, (('now'::cstring)::date)::timestamp without time zone))
  • Rows Removed by Filter: 661
  • Heap Blocks: exact=293
87. 0.145 0.145 ↓ 1.1 1,180 1

Bitmap Index Scan on idx_saldoinv_bod (cost=0.00..392.44 rows=1,083 width=0) (actual time=0.144..0.145 rows=1,180 loops=1)

  • Index Cond: (bod_id = 6)
88.          

SubPlan (forNested Loop Left Join)

89. 27.096 27.096 ↑ 1.0 1 4,516

Index Scan using clasificacion1_pk on clasificacion1 clasificacion1_1 (cost=0.27..2.49 rows=1 width=15) (actual time=0.005..0.006 rows=1 loops=4,516)

  • Index Cond: (cla1_id = cla1.cla1_reporta)
90. 13.548 13.548 ↓ 0.0 0 4,516

Index Scan using producto1_codigo_oem_prod1_id on producto1_codigo_oem producto1_codigo_oem_1 (cost=0.28..2.50 rows=1 width=12) (actual time=0.003..0.003 rows=0 loops=4,516)

  • Index Cond: (prod1_id = pro1.prod1_id)
91. 0.000 614.176 ↓ 0.0 0 4,516

Limit (cost=5.56..11.81 rows=1 width=12) (actual time=0.136..0.136 rows=0 loops=4,516)

92.          

Initplan (forLimit)

93. 18.064 18.064 ↑ 1.0 1 4,516

Index Scan using idx_producto1_producto on producto1 p1_1_2 (cost=0.28..2.50 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=4,516)

  • Index Cond: (pro_id = pro.pro_id)
94. 9.030 9.030 ↑ 1.0 1 4,515

Index Scan using idx_producto1_producto on producto1 p1_1_3 (cost=0.28..2.50 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=4,515)

  • Index Cond: (pro_id = pro.pro_id)
95. 5.228 609.660 ↓ 0.0 0 4,516

Nested Loop (cost=0.56..31.81 rows=5 width=12) (actual time=0.135..0.135 rows=0 loops=4,516)

96. 14.260 600.628 ↓ 0.0 0 4,516

Nested Loop (cost=0.28..29.95 rows=5 width=4) (actual time=0.133..0.133 rows=0 loops=4,516)

97. 582.564 582.564 ↓ 0.0 0 4,516

Seq Scan on productos_hermanos ph_1 (cost=0.00..17.40 rows=5 width=4) (actual time=0.129..0.129 rows=0 loops=4,516)

  • Filter: ((prod1_id_base = $358) OR (prod1_id_hermano = $359))
  • Rows Removed by Filter: 678
98. 3.804 3.804 ↑ 1.0 1 951

Index Scan using producto1_pk1 on producto1 p1_2 (cost=0.28..2.50 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=951)

  • Index Cond: (prod1_id = ph_1.prod1_id_base)
99. 3.804 3.804 ↑ 1.0 1 951

Index Scan using producto_pkey on producto p_1 (cost=0.28..0.36 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=951)

  • Index Cond: (pro_id = p1_2.pro_id)
100. 18.064 230.316 ↑ 1.0 1 4,516

Aggregate (cost=9.18..9.19 rows=1 width=32) (actual time=0.051..0.051 rows=1 loops=4,516)

101. 33.093 212.252 ↓ 0.0 0 4,516

Hash Join (cost=4.66..9.17 rows=1 width=5) (actual time=0.044..0.047 rows=0 loops=4,516)

  • Hash Cond: (cor_10.cor_id = dor_11.cor_id)
102. 143.031 143.031 ↓ 1.3 14 2,919

Seq Scan on cordcom cor_10 (cost=0.00..4.43 rows=11 width=4) (actual time=0.027..0.049 rows=14 loops=2,919)

  • Filter: (cor_estado = ANY ('{3,4,5}'::integer[]))
  • Rows Removed by Filter: 91
103. 9.032 36.128 ↑ 1.5 2 4,516

Hash (cost=4.63..4.63 rows=3 width=9) (actual time=0.008..0.008 rows=2 loops=4,516)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
104. 27.096 27.096 ↑ 1.5 2 4,516

Index Scan using idx_dordcom_pro_id on dordcom dor_11 (cost=0.28..4.63 rows=3 width=9) (actual time=0.005..0.006 rows=2 loops=4,516)

  • Index Cond: (pro_id = pro.pro_id)
105. 18.064 185.156 ↑ 1.0 1 4,516

Aggregate (cost=9.03..9.04 rows=1 width=32) (actual time=0.040..0.041 rows=1 loops=4,516)

106. 16.076 167.092 ↓ 0.0 0 4,516

Hash Join (cost=4.66..9.02 rows=1 width=5) (actual time=0.037..0.037 rows=0 loops=4,516)

  • Hash Cond: (cor_11.cor_id = dor_12.cor_id)
107. 128.436 128.436 ↑ 2.0 4 2,919

Seq Scan on cordcom cor_11 (cost=0.00..4.30 rows=8 width=4) (actual time=0.037..0.044 rows=4 loops=2,919)

  • Filter: (cor_estado = 1)
  • Rows Removed by Filter: 101
108. 4.516 22.580 ↑ 1.5 2 4,516

Hash (cost=4.63..4.63 rows=3 width=9) (actual time=0.005..0.005 rows=2 loops=4,516)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
109. 18.064 18.064 ↑ 1.5 2 4,516

Index Scan using idx_dordcom_pro_id on dordcom dor_12 (cost=0.28..4.63 rows=3 width=9) (actual time=0.003..0.004 rows=2 loops=4,516)

  • Index Cond: (pro_id = pro.pro_id)
110. 13.548 185.156 ↑ 1.0 1 4,516

Aggregate (cost=9.02..9.03 rows=1 width=32) (actual time=0.041..0.041 rows=1 loops=4,516)

111. 17.673 171.608 ↓ 0.0 0 4,516

Hash Join (cost=4.66..9.02 rows=1 width=5) (actual time=0.032..0.038 rows=0 loops=4,516)

  • Hash Cond: (cor_12.cor_id = dor_13.cor_id)
112. 131.355 131.355 ↓ 1.1 8 2,919

Seq Scan on cordcom cor_12 (cost=0.00..4.30 rows=7 width=4) (actual time=0.025..0.045 rows=8 loops=2,919)

  • Filter: (cor_estado = 2)
  • Rows Removed by Filter: 97
113. 4.516 22.580 ↑ 1.5 2 4,516

Hash (cost=4.63..4.63 rows=3 width=9) (actual time=0.005..0.005 rows=2 loops=4,516)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
114. 18.064 18.064 ↑ 1.5 2 4,516

Index Scan using idx_dordcom_pro_id on dordcom dor_13 (cost=0.28..4.63 rows=3 width=9) (actual time=0.003..0.004 rows=2 loops=4,516)

  • Index Cond: (pro_id = pro.pro_id)
115. 13.548 194.188 ↑ 1.0 1 4,516

Aggregate (cost=9.18..9.19 rows=1 width=32) (actual time=0.043..0.043 rows=1 loops=4,516)

116. 20.867 180.640 ↓ 0.0 0 4,516

Hash Join (cost=4.66..9.17 rows=1 width=5) (actual time=0.037..0.040 rows=0 loops=4,516)

  • Hash Cond: (cor_13.cor_id = dor_14.cor_id)
117. 137.193 137.193 ↓ 1.3 14 2,919

Seq Scan on cordcom cor_13 (cost=0.00..4.43 rows=11 width=4) (actual time=0.025..0.047 rows=14 loops=2,919)

  • Filter: (cor_estado = ANY ('{3,4,5}'::integer[]))
  • Rows Removed by Filter: 91
118. 4.516 22.580 ↑ 1.5 2 4,516

Hash (cost=4.63..4.63 rows=3 width=9) (actual time=0.005..0.005 rows=2 loops=4,516)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
119. 18.064 18.064 ↑ 1.5 2 4,516

Index Scan using idx_dordcom_pro_id on dordcom dor_14 (cost=0.28..4.63 rows=3 width=9) (actual time=0.003..0.004 rows=2 loops=4,516)

  • Index Cond: (pro_id = pro.pro_id)
120. 13.548 180.640 ↑ 1.0 1 4,516

Aggregate (cost=9.03..9.04 rows=1 width=32) (actual time=0.040..0.040 rows=1 loops=4,516)

121. 16.076 167.092 ↓ 0.0 0 4,516

Hash Join (cost=4.66..9.02 rows=1 width=5) (actual time=0.037..0.037 rows=0 loops=4,516)

  • Hash Cond: (cor_14.cor_id = dor_15.cor_id)
122. 128.436 128.436 ↑ 2.0 4 2,919

Seq Scan on cordcom cor_14 (cost=0.00..4.30 rows=8 width=4) (actual time=0.037..0.044 rows=4 loops=2,919)

  • Filter: (cor_estado = 1)
  • Rows Removed by Filter: 101
123. 4.516 22.580 ↑ 1.5 2 4,516

Hash (cost=4.63..4.63 rows=3 width=9) (actual time=0.005..0.005 rows=2 loops=4,516)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
124. 18.064 18.064 ↑ 1.5 2 4,516

Index Scan using idx_dordcom_pro_id on dordcom dor_15 (cost=0.28..4.63 rows=3 width=9) (actual time=0.003..0.004 rows=2 loops=4,516)

  • Index Cond: (pro_id = pro.pro_id)
125. 18.064 185.156 ↑ 1.0 1 4,516

Aggregate (cost=9.02..9.03 rows=1 width=32) (actual time=0.041..0.041 rows=1 loops=4,516)

126. 16.076 167.092 ↓ 0.0 0 4,516

Hash Join (cost=4.66..9.02 rows=1 width=5) (actual time=0.032..0.037 rows=0 loops=4,516)

  • Hash Cond: (cor_15.cor_id = dor_16.cor_id)
127. 128.436 128.436 ↓ 1.1 8 2,919

Seq Scan on cordcom cor_15 (cost=0.00..4.30 rows=7 width=4) (actual time=0.024..0.044 rows=8 loops=2,919)

  • Filter: (cor_estado = 2)
  • Rows Removed by Filter: 97
128. 4.516 22.580 ↑ 1.5 2 4,516

Hash (cost=4.63..4.63 rows=3 width=9) (actual time=0.005..0.005 rows=2 loops=4,516)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
129. 18.064 18.064 ↑ 1.5 2 4,516

Index Scan using idx_dordcom_pro_id on dordcom dor_16 (cost=0.28..4.63 rows=3 width=9) (actual time=0.003..0.004 rows=2 loops=4,516)

  • Index Cond: (pro_id = pro.pro_id)
130. 13.548 212.252 ↑ 1.0 1 4,516

Aggregate (cost=6.81..6.82 rows=1 width=8) (actual time=0.047..0.047 rows=1 loops=4,516)

131. 0.000 198.704 ↓ 0.0 0 4,516

Nested Loop (cost=0.28..6.81 rows=1 width=4) (actual time=0.044..0.044 rows=0 loops=4,516)

132. 198.704 198.704 ↓ 0.0 0 4,516

Seq Scan on cordcom co_1 (cost=0.00..4.30 rows=1 width=4) (actual time=0.044..0.044 rows=0 loops=4,516)

  • Filter: (cor_estado = 8)
  • Rows Removed by Filter: 105
133. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_dordcom_corpro on dordcom dor_17 (cost=0.28..2.50 rows=1 width=4) (never executed)

  • Index Cond: ((cor_id = co_1.cor_id) AND (pro_id = pro.pro_id))
  • Heap Fetches: 0
134. 9.032 72.256 ↓ 0.0 0 4,516

Limit (cost=9.58..9.59 rows=1 width=8) (actual time=0.015..0.016 rows=0 loops=4,516)

135. 18.064 63.224 ↓ 0.0 0 4,516

Sort (cost=9.58..9.59 rows=1 width=8) (actual time=0.014..0.014 rows=0 loops=4,516)

  • Sort Key: cor_16.cor_fecha_disponibilidad
  • Sort Method: quicksort Memory: 25kB
136. 4.374 45.160 ↓ 0.0 0 4,516

Nested Loop (cost=0.42..9.57 rows=1 width=8) (actual time=0.009..0.010 rows=0 loops=4,516)

137. 18.064 18.064 ↑ 1.5 2 4,516

Index Scan using idx_dordcom_pro_id on dordcom dor_18 (cost=0.28..4.63 rows=3 width=4) (actual time=0.003..0.004 rows=2 loops=4,516)

  • Index Cond: (pro_id = pro.pro_id)
138. 22.722 22.722 ↓ 0.0 0 7,574

Index Scan using cordcom_pkey on cordcom cor_16 (cost=0.14..1.64 rows=1 width=12) (actual time=0.003..0.003 rows=0 loops=7,574)

  • Index Cond: (cor_id = dor_18.cor_id)
  • Filter: ((cor_estado <> 7) AND (cor_estado <> 6) AND ((cor_estado = 3) OR (cor_estado = 4) OR (cor_estado = 5)))
  • Rows Removed by Filter: 1
139. 9.032 1,038.680 ↑ 1.0 1 4,516

Limit (cost=248.08..248.08 rows=1 width=8) (actual time=0.229..0.230 rows=1 loops=4,516)

140. 54.192 1,029.648 ↑ 72.0 1 4,516

Sort (cost=248.08..248.26 rows=72 width=8) (actual time=0.228..0.228 rows=1 loops=4,516)

  • Sort Key: cfa_1.cfa_fecha DESC
  • Sort Method: quicksort Memory: 25kB
141. 86.816 975.456 ↑ 1.6 46 4,516

Nested Loop (cost=0.71..247.72 rows=72 width=8) (actual time=0.011..0.216 rows=46 loops=4,516)

142. 261.928 261.928 ↑ 1.6 46 4,516

Index Scan using idx_dfactura_proid on dfactura dfa_1 (cost=0.42..80.94 rows=72 width=4) (actual time=0.007..0.058 rows=46 loops=4,516)

  • Index Cond: (pro_id = pro.pro_id)
143. 626.712 626.712 ↑ 1.0 1 208,904

Index Scan using cfactura_pkey on cfactura cfa_1 (cost=0.29..2.31 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=208,904)

  • Index Cond: (cfa_id = dfa_1.cfa_id)
144. 4.516 261.928 ↓ 0.0 0 4,516

Limit (cost=20.24..20.24 rows=1 width=8) (actual time=0.058..0.058 rows=0 loops=4,516)

145. 27.096 257.412 ↓ 0.0 0 4,516

Sort (cost=20.24..20.25 rows=6 width=8) (actual time=0.057..0.057 rows=0 loops=4,516)

  • Sort Key: ce_1.corest_fecha DESC
  • Sort Method: quicksort Memory: 25kB
146. 18.056 230.316 ↓ 0.0 0 4,516

Hash Join (cost=6.82..20.21 rows=6 width=8) (actual time=0.051..0.051 rows=0 loops=4,516)

  • Hash Cond: (ce_1.cor_id = cor_17.cor_id)
147. 0.008 0.008 ↑ 606.0 1 1

Seq Scan on cordcom_estado ce_1 (cost=0.00..11.06 rows=606 width=12) (actual time=0.008..0.008 rows=1 loops=1)

148. 4.516 212.252 ↓ 0.0 0 4,516

Hash (cost=6.81..6.81 rows=1 width=8) (actual time=0.047..0.047 rows=0 loops=4,516)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
149. 4.516 207.736 ↓ 0.0 0 4,516

Nested Loop (cost=0.28..6.81 rows=1 width=8) (actual time=0.046..0.046 rows=0 loops=4,516)

150. 203.220 203.220 ↓ 0.0 0 4,516

Seq Scan on cordcom cor_17 (cost=0.00..4.30 rows=1 width=4) (actual time=0.045..0.045 rows=0 loops=4,516)

  • Filter: (cor_estado = 6)
  • Rows Removed by Filter: 105
151. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_dordcom_corpro on dordcom dor_19 (cost=0.28..2.50 rows=1 width=4) (never executed)

  • Index Cond: ((cor_id = cor_17.cor_id) AND (pro_id = pro.pro_id))
  • Heap Fetches: 0
152. 9.032 225.800 ↑ 1.0 1 4,516

Limit (cost=0.42..5.73 rows=1 width=13) (actual time=0.049..0.050 rows=1 loops=4,516)

153. 121.932 216.768 ↑ 3.0 1 4,516

Nested Loop (cost=0.42..16.35 rows=3 width=13) (actual time=0.048..0.048 rows=1 loops=4,516)

  • Join Filter: (dor_20.cor_id = cor_18.cor_id)
  • Rows Removed by Join Filter: 49
154. 94.836 94.836 ↑ 1.7 63 4,516

Index Scan using idx_corfecha on cordcom cor_18 (cost=0.14..7.04 rows=104 width=12) (actual time=0.004..0.021 rows=63 loops=4,516)

155. 0.000 0.000 ↑ 3.0 1 282,314

Materialize (cost=0.28..4.64 rows=3 width=9) (actual time=0.000..0.000 rows=1 loops=282,314)

156. 18.064 18.064 ↑ 1.5 2 4,516

Index Scan using idx_dordcom_pro_id on dordcom dor_20 (cost=0.28..4.63 rows=3 width=9) (actual time=0.003..0.004 rows=2 loops=4,516)

  • Index Cond: (pro_id = pro.pro_id)
157. 4.516 365.796 ↓ 0.0 0 4,516

Limit (cost=0.42..7.87 rows=1 width=12) (actual time=0.081..0.081 rows=0 loops=4,516)

158. 108.384 361.280 ↓ 0.0 0 4,516

Nested Loop (cost=0.42..15.31 rows=2 width=12) (actual time=0.080..0.080 rows=0 loops=4,516)

  • Join Filter: (dor_21.cor_id = cor_19.cor_id)
  • Rows Removed by Join Filter: 42
159. 252.896 252.896 ↑ 1.5 50 4,516

Index Scan using idx_corfecha on cordcom cor_19 (cost=0.14..7.30 rows=75 width=16) (actual time=0.017..0.056 rows=50 loops=4,516)

  • Filter: (cor_estado = 7)
  • Rows Removed by Filter: 28
160. 0.000 0.000 ↑ 3.0 1 227,756

Materialize (cost=0.28..4.64 rows=3 width=4) (actual time=0.000..0.000 rows=1 loops=227,756)

161. 22.580 22.580 ↑ 1.5 2 4,516

Index Scan using idx_dordcom_pro_id on dordcom dor_21 (cost=0.28..4.63 rows=3 width=4) (actual time=0.004..0.005 rows=2 loops=4,516)

  • Index Cond: (pro_id = pro.pro_id)
162. 13.548 81.288 ↑ 1.0 1 4,516

Aggregate (cost=7.51..7.52 rows=1 width=32) (actual time=0.018..0.018 rows=1 loops=4,516)

163. 8.793 67.740 ↑ 1.0 1 4,516

Nested Loop (cost=0.84..7.51 rows=1 width=8) (actual time=0.011..0.015 rows=1 loops=4,516)

164. 4.516 40.644 ↑ 1.0 1 4,516

Nested Loop (cost=0.56..7.20 rows=1 width=4) (actual time=0.008..0.009 rows=1 loops=4,516)

165. 18.064 18.064 ↑ 1.0 1 4,516

Index Scan using idx_producto1_producto on producto1 p1_3 (cost=0.28..2.50 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=4,516)

  • Index Cond: (pro_id = pro.pro_id)
166. 18.064 18.064 ↑ 3.0 1 4,516

Index Scan using idx_productos_modelos_hermanos_prod1_id on productos_modelos_hermanos pmh (cost=0.28..4.67 rows=3 width=8) (actual time=0.003..0.004 rows=1 loops=4,516)

  • Index Cond: (prod1 = p1_3.prod1_id)
167. 18.303 18.303 ↑ 1.0 1 6,101

Index Scan using modelo_pk on modelo mdl_1_1 (cost=0.28..0.30 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=6,101)

  • Index Cond: (mdl_id = pmh.mdl_id)
168. 0.105 50,541.716 ↓ 1.1 40 1

Subquery Scan on *SELECT* 2 (cost=1,799.78..214,098.08 rows=38 width=7,599) (actual time=205.597..50,541.716 rows=40 loops=1)

169. 0.084 50,541.611 ↓ 1.1 40 1

Subquery Scan on control_inventarios (cost=1,799.78..214,097.61 rows=38 width=7,571) (actual time=205.593..50,541.611 rows=40 loops=1)

170. 186.897 50,541.527 ↓ 1.1 40 1

Nested Loop Left Join (cost=1,799.78..214,097.23 rows=38 width=7,535) (actual time=205.591..50,541.527 rows=40 loops=1)

  • Join Filter: (saldoinv_3.pro_id = pro_1.pro_id)
  • Rows Removed by Join Filter: 64146
171. 0.067 49,089.710 ↓ 1.1 40 1

Nested Loop Left Join (cost=1,699.78..2,318.41 rows=38 width=7,371) (actual time=156.299..49,089.710 rows=40 loops=1)

  • Join Filter: (saldoinv_2.pro_id = pro_1.pro_id)
172. 20.853 49,087.443 ↓ 1.1 40 1

Nested Loop Left Join (cost=1,599.78..2,199.71 rows=38 width=6,921) (actual time=154.098..49,087.443 rows=40 loops=1)

  • Join Filter: (dlp_1.pro_id = pro_1.pro_id)
  • Rows Removed by Join Filter: 180160
173. 0.113 49,035.870 ↓ 1.1 40 1

Hash Left Join (cost=1,499.78..2,062.13 rows=38 width=6,903) (actual time=147.680..49,035.870 rows=40 loops=1)

  • Hash Cond: (cla1_1.cla1_id = jl_2.cla1_id)
174. 0.095 49,035.723 ↓ 1.1 40 1

Hash Left Join (cost=1,495.39..2,057.22 rows=38 width=6,902) (actual time=147.639..49,035.723 rows=40 loops=1)

  • Hash Cond: (cla1_1.cla1_id = jl_3.cla1_id)
175. 0.067 49,035.566 ↓ 1.1 40 1

Hash Left Join (cost=1,491.01..2,052.32 rows=38 width=6,897) (actual time=147.569..49,035.566 rows=40 loops=1)

  • Hash Cond: (pro1_1.prod1_id = abc2_1.prod1_id)
176. 0.080 49,034.954 ↓ 1.1 40 1

Hash Left Join (cost=1,373.53..1,934.37 rows=38 width=6,461) (actual time=147.015..49,034.954 rows=40 loops=1)

  • Hash Cond: (pro1_1.prod1_id = abc1_1.prod1_id)
177. 0.137 49,034.256 ↓ 1.1 40 1

Hash Left Join (cost=1,256.05..1,816.41 rows=38 width=6,025) (actual time=146.386..49,034.256 rows=40 loops=1)

  • Hash Cond: (pro1_1.cli_id = cli_1.cli_id)
178. 0.219 49,013.059 ↓ 5.7 40 1

Nested Loop Left Join (cost=1,100.28..1,659.30 rows=7 width=5,981) (actual time=125.312..49,013.059 rows=40 loops=1)

179. 8.198 49,011.920 ↓ 5.7 40 1

Nested Loop Left Join (cost=1,100.00..1,643.56 rows=7 width=5,946) (actual time=125.283..49,011.920 rows=40 loops=1)

  • Join Filter: (ubi2_1.ubinv_id = pro1_1.uinv_id)
  • Rows Removed by Join Filter: 77560
180. 14.915 48,992.562 ↓ 5.7 40 1

Nested Loop Left Join (cost=1,000.00..1,512.94 rows=7 width=5,434) (actual time=118.394..48,992.562 rows=40 loops=1)

  • Join Filter: (pro_img_1.pro_id = pro_1.pro_id)
  • Rows Removed by Join Filter: 120106
181. 5.743 48,961.247 ↓ 5.7 40 1

Nested Loop Left Join (cost=900.00..1,400.52 rows=7 width=5,016) (actual time=115.552..48,961.247 rows=40 loops=1)

  • Join Filter: (spa_1.spa_id = pro1_1.spa_id)
  • Rows Removed by Join Filter: 6320
182. 23.524 48,933.584 ↓ 40.0 40 1

Nested Loop Left Join (cost=800.00..1,232.51 rows=1 width=4,988) (actual time=114.582..48,933.584 rows=40 loops=1)

  • Join Filter: (idi4_1.prod1_id = pro1_1.prod1_id)
  • Rows Removed by Join Filter: 144506
183. 23.763 48,447.460 ↓ 40.0 40 1

Nested Loop Left Join (cost=700.00..1,105.22 rows=1 width=4,956) (actual time=109.314..48,447.460 rows=40 loops=1)

  • Join Filter: (idi3_1.prod1_id = pro1_1.prod1_id)
  • Rows Removed by Join Filter: 144506
184. 22.852 47,977.897 ↓ 40.0 40 1

Nested Loop Left Join (cost=600.00..977.93 rows=1 width=4,924) (actual time=104.504..47,977.897 rows=40 loops=1)

  • Join Filter: (idi2_1.prod1_id = pro1_1.prod1_id)
  • Rows Removed by Join Filter: 144546
185. 23.465 47,497.925 ↓ 40.0 40 1

Nested Loop Left Join (cost=500.00..850.64 rows=1 width=4,892) (actual time=100.292..47,497.925 rows=40 loops=1)

  • Join Filter: (idi1_1.prod1_id = pro1_1.prod1_id)
  • Rows Removed by Join Filter: 144546
186. 0.198 47,001.020 ↓ 40.0 40 1

Nested Loop Left Join (cost=400.00..723.35 rows=1 width=4,860) (actual time=95.526..47,001.020 rows=40 loops=1)

  • Join Filter: (cla2_1.cla2_id = pro1_1.cla2_id)
  • Rows Removed by Join Filter: 600
187. 0.145 47,000.342 ↓ 40.0 40 1

Nested Loop Left Join (cost=300.00..605.58 rows=1 width=4,446) (actual time=95.102..47,000.342 rows=40 loops=1)

  • Join Filter: (cla1_1.cla1_id = pro1_1.cla1_id)
188. 2.133 46,999.677 ↓ 40.0 40 1

Nested Loop Left Join (cost=200.00..493.27 rows=1 width=4,020) (actual time=94.593..46,999.677 rows=40 loops=1)

  • Join Filter: (pro_2.pro_id = pro_1.pro_id)
  • Rows Removed by Join Filter: 1560
189. 4.864 4.864 ↓ 40.0 40 1

Foreign Scan (cost=100.00..299.27 rows=1 width=3,636) (actual time=4.845..4.864 rows=40 loops=1)

  • Relations: ((((((fdw_motostop.producto pro) LEFT JOIN (fdw_motostop.marca mar)) LEFT JOIN (fdw_motostop.unidad uni)) LEFT JOIN (fdw_motostop.ubicacion ubi)) LEFT JOIN (fdw_motostop.ubicacioninv ubi1)) INNER JOIN (fdw_motostop.producto1 pro1)) LEFT JOIN (fdw_motostop.modelo mdl)
190. 46,992.680 46,992.680 ↓ 2.7 40 40

Foreign Scan on producto pro_2 (cost=100.00..193.66 rows=15 width=388) (actual time=29.810..1,174.817 rows=40 loops=40)

191. 0.520 0.520 ↑ 1.0 1 40

Foreign Scan on clasificacion1 cla1_1 (cost=100.00..112.30 rows=1 width=426) (actual time=0.013..0.013 rows=1 loops=40)

192. 0.480 0.480 ↑ 11.4 16 40

Foreign Scan on clasificacion2 cla2_1 (cost=100.00..115.49 rows=183 width=422) (actual time=0.011..0.012 rows=16 loops=40)

193. 473.440 473.440 ↓ 516.3 3,614 40

Foreign Scan on producto1_idioma idi1_1 (cost=100.00..127.20 rows=7 width=36) (actual time=0.770..11.836 rows=3,614 loops=40)

194. 457.120 457.120 ↓ 516.3 3,614 40

Foreign Scan on producto1_idioma idi2_1 (cost=100.00..127.20 rows=7 width=36) (actual time=0.286..11.428 rows=3,614 loops=40)

195. 445.800 445.800 ↓ 516.1 3,613 40

Foreign Scan on producto1_idioma idi3_1 (cost=100.00..127.20 rows=7 width=36) (actual time=1.142..11.145 rows=3,613 loops=40)

196. 462.600 462.600 ↓ 516.1 3,613 40

Foreign Scan on producto1_idioma idi4_1 (cost=100.00..127.20 rows=7 width=36) (actual time=1.546..11.565 rows=3,613 loops=40)

197. 21.920 21.920 ↑ 8.6 159 40

Foreign Scan on subpartidaarancelaria spa_1 (cost=100.00..150.95 rows=1,365 width=36) (actual time=0.305..0.548 rows=159 loops=40)

198. 7.211 16.400 ↓ 3,003.0 3,003 40

Materialize (cost=100.00..112.31 rows=1 width=422) (actual time=0.017..0.410 rows=3,003 loops=40)

199. 9.189 9.189 ↓ 3,003.0 3,003 1

Foreign Scan on producto_imagen pro_img_1 (cost=100.00..112.31 rows=1 width=422) (actual time=0.664..9.189 rows=3,003 loops=1)

200. 4.823 11.160 ↓ 12.9 1,939 40

Materialize (cost=100.00..115.25 rows=150 width=520) (actual time=0.013..0.279 rows=1,939 loops=40)

201. 6.337 6.337 ↓ 12.9 1,939 1

Foreign Scan on ubicacioninv ubi2_1 (cost=100.00..114.50 rows=150 width=520) (actual time=0.515..6.337 rows=1,939 loops=1)

202. 0.920 0.920 ↑ 1.0 1 40

Index Scan using idx_buffer_pro_id on buffer buf_1 (cost=0.28..2.24 rows=1 width=39) (actual time=0.021..0.023 rows=1 loops=40)

  • Index Cond: (pro_id = pro_1.pro_id)
203. 1.259 21.060 ↓ 5.7 6,155 1

Hash (cost=142.31..142.31 rows=1,077 width=52) (actual time=21.060..21.060 rows=6,155 loops=1)

  • Buckets: 8192 (originally 2048) Batches: 1 (originally 1) Memory Usage: 362kB
204. 19.801 19.801 ↓ 5.7 6,155 1

Foreign Scan on cliente cli_1 (cost=100.00..142.31 rows=1,077 width=52) (actual time=0.706..19.801 rows=6,155 loops=1)

205. 0.001 0.618 ↓ 0.0 0 1

Hash (cost=115.28..115.28 rows=176 width=440) (actual time=0.618..0.618 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
206. 0.617 0.617 ↓ 0.0 0 1

Foreign Scan on producto_clasabcfms1 abc1_1 (cost=100.00..115.28 rows=176 width=440) (actual time=0.617..0.617 rows=0 loops=1)

207. 0.002 0.545 ↓ 0.0 0 1

Hash (cost=115.28..115.28 rows=176 width=440) (actual time=0.545..0.545 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
208. 0.543 0.543 ↓ 0.0 0 1

Foreign Scan on producto_clasabcfms2 abc2_1 (cost=100.00..115.28 rows=176 width=440) (actual time=0.543..0.543 rows=0 loops=1)

209. 0.004 0.062 ↑ 1.0 1 1

Hash (cost=4.37..4.37 rows=1 width=9) (actual time=0.062..0.062 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
210. 0.019 0.058 ↑ 1.0 1 1

Hash Right Join (cost=2.51..4.37 rows=1 width=9) (actual time=0.052..0.058 rows=1 loops=1)

  • Hash Cond: (emp_3.emp_id = jl_3.emp_id)
211. 0.019 0.019 ↓ 1.1 67 1

Seq Scan on empleado emp_3 (cost=0.00..1.62 rows=62 width=9) (actual time=0.013..0.019 rows=67 loops=1)

212. 0.002 0.020 ↑ 1.0 1 1

Hash (cost=2.49..2.49 rows=1 width=8) (actual time=0.020..0.020 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
213. 0.018 0.018 ↑ 1.0 1 1

Index Scan using idx_jefe_linea_cla1_id_jel_tipo on jefe_linea jl_3 (cost=0.28..2.49 rows=1 width=8) (actual time=0.017..0.018 rows=1 loops=1)

  • Index Cond: ((cla1_id = 509) AND (jel_tipo = 2))
214. 0.001 0.034 ↑ 1.0 1 1

Hash (cost=4.37..4.37 rows=1 width=9) (actual time=0.034..0.034 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
215. 0.016 0.033 ↑ 1.0 1 1

Hash Right Join (cost=2.51..4.37 rows=1 width=9) (actual time=0.027..0.033 rows=1 loops=1)

  • Hash Cond: (emp_2.emp_id = jl_2.emp_id)
216. 0.008 0.008 ↓ 1.1 67 1

Seq Scan on empleado emp_2 (cost=0.00..1.62 rows=62 width=9) (actual time=0.004..0.008 rows=67 loops=1)

217. 0.001 0.009 ↑ 1.0 1 1

Hash (cost=2.49..2.49 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
218. 0.008 0.008 ↑ 1.0 1 1

Index Scan using idx_jefe_linea_cla1_id_jel_tipo on jefe_linea jl_2 (cost=0.28..2.49 rows=1 width=8) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: ((cla1_id = 509) AND (jel_tipo = 1))
219. 10.914 30.720 ↓ 500.6 4,505 40

Materialize (cost=100.00..132.48 rows=9 width=22) (actual time=0.032..0.768 rows=4,505 loops=40)

220. 19.806 19.806 ↓ 500.6 4,505 1

Foreign Scan on dlistapre dlp_1 (cost=100.00..132.43 rows=9 width=22) (actual time=1.282..19.806 rows=4,505 loops=1)

221. 0.003 2.200 ↓ 0.0 0 40

Materialize (cost=100.00..118.13 rows=1 width=454) (actual time=0.055..0.055 rows=0 loops=40)

222. 2.197 2.197 ↓ 0.0 0 1

Foreign Scan on saldoinv saldoinv_2 (cost=100.00..118.12 rows=1 width=454) (actual time=2.197..2.197 rows=0 loops=1)

  • Filter: ((sal_periodo)::double precision = date_part('year'::text, (('now'::cstring)::date)::timestamp without time zone))
223. 4.817 51.920 ↓ 1,604.0 1,604 40

Materialize (cost=100.00..118.13 rows=1 width=454) (actual time=0.056..1.298 rows=1,604 loops=40)

224. 47.103 47.103 ↓ 1,604.0 1,604 1

Foreign Scan on saldoinv saldoinv_3 (cost=100.00..118.12 rows=1 width=454) (actual time=2.229..47.103 rows=1,604 loops=1)

  • Filter: ((sal_periodo)::double precision = date_part('year'::text, (('now'::cstring)::date)::timestamp without time zone))
  • Rows Removed by Filter: 1664
225.          

SubPlan (forNested Loop Left Join)

226. 19.240 19.240 ↑ 1.0 1 40

Foreign Scan on clasificacion1 (cost=100.00..112.33 rows=1 width=418) (actual time=0.481..0.481 rows=1 loops=40)

227. 14.680 14.680 ↓ 0.0 0 40

Foreign Scan on producto1_codigo_oem (cost=100.00..128.41 rows=7 width=32) (actual time=0.367..0.367 rows=0 loops=40)

228. 0.000 130.720 ↓ 0.0 0 40

Limit (cost=393.73..394.58 rows=1 width=48) (actual time=3.268..3.268 rows=0 loops=40)

229.          

Initplan (forLimit)

230. 41.040 41.040 ↑ 15.0 1 40

Foreign Scan on producto1 p1_1 (cost=100.00..146.86 rows=15 width=4) (actual time=1.026..1.026 rows=1 loops=40)

231. 37.240 37.240 ↑ 15.0 1 40

Foreign Scan on producto1 p1_1_1 (cost=100.00..146.86 rows=15 width=4) (actual time=0.931..0.931 rows=1 loops=40)

232. 125.640 125.640 ↓ 0.0 0 40

Foreign Scan (cost=100.00..1,805.92 rows=1,998 width=48) (actual time=3.141..3.141 rows=0 loops=40)

  • Relations: ((fdw_motostop.productos_hermanos ph) INNER JOIN (fdw_motostop.producto1 p1)) INNER JOIN (fdw_motostop.producto p)
233. 5.160 30.920 ↑ 1.0 1 40

Aggregate (cost=185.98..185.99 rows=1 width=32) (actual time=0.773..0.773 rows=1 loops=40)

234. 25.760 25.760 ↓ 0.0 0 40

Foreign Scan (cost=100.00..185.97 rows=2 width=18) (actual time=0.643..0.644 rows=0 loops=40)

  • Relations: (fdw_motostop.dordcom dor) INNER JOIN (fdw_motostop.cordcom cor)
235. 5.040 28.720 ↑ 1.0 1 40

Aggregate (cost=179.85..179.86 rows=1 width=32) (actual time=0.718..0.718 rows=1 loops=40)

236. 23.680 23.680 ↓ 0.0 0 40

Foreign Scan (cost=100.00..179.84 rows=1 width=18) (actual time=0.592..0.592 rows=0 loops=40)

  • Relations: (fdw_motostop.dordcom dor) INNER JOIN (fdw_motostop.cordcom cor)
237. 5.080 28.800 ↑ 1.0 1 40

Aggregate (cost=179.85..179.86 rows=1 width=32) (actual time=0.720..0.720 rows=1 loops=40)

238. 23.720 23.720 ↑ 1.0 1 40

Foreign Scan (cost=100.00..179.84 rows=1 width=18) (actual time=0.593..0.593 rows=1 loops=40)

  • Relations: (fdw_motostop.dordcom dor) INNER JOIN (fdw_motostop.cordcom cor)
239. 5.200 29.400 ↑ 1.0 1 40

Aggregate (cost=185.98..185.99 rows=1 width=32) (actual time=0.735..0.735 rows=1 loops=40)

240. 24.200 24.200 ↓ 0.0 0 40

Foreign Scan (cost=100.00..185.97 rows=2 width=18) (actual time=0.605..0.605 rows=0 loops=40)

  • Relations: (fdw_motostop.dordcom dor) INNER JOIN (fdw_motostop.cordcom cor)
241. 4.920 28.480 ↑ 1.0 1 40

Aggregate (cost=179.85..179.86 rows=1 width=32) (actual time=0.712..0.712 rows=1 loops=40)

242. 23.560 23.560 ↓ 0.0 0 40

Foreign Scan (cost=100.00..179.84 rows=1 width=18) (actual time=0.589..0.589 rows=0 loops=40)

  • Relations: (fdw_motostop.dordcom dor) INNER JOIN (fdw_motostop.cordcom cor)
243. 5.000 28.440 ↑ 1.0 1 40

Aggregate (cost=179.85..179.86 rows=1 width=32) (actual time=0.710..0.711 rows=1 loops=40)

244. 23.440 23.440 ↑ 1.0 1 40

Foreign Scan (cost=100.00..179.84 rows=1 width=18) (actual time=0.586..0.586 rows=1 loops=40)

  • Relations: (fdw_motostop.dordcom dor) INNER JOIN (fdw_motostop.cordcom cor)
245. 5.120 28.640 ↑ 1.0 1 40

Aggregate (cost=194.83..194.84 rows=1 width=8) (actual time=0.716..0.716 rows=1 loops=40)

246. 23.520 23.520 ↓ 0.0 0 40

Foreign Scan (cost=100.00..194.83 rows=1 width=4) (actual time=0.588..0.588 rows=0 loops=40)

  • Relations: (fdw_motostop.dordcom dor) INNER JOIN (fdw_motostop.cordcom co)
247. 4.960 30.920 ↓ 0.0 0 40

Limit (cost=100.00..146.69 rows=1 width=8) (actual time=0.773..0.773 rows=0 loops=40)

248. 25.960 25.960 ↓ 0.0 0 40

Foreign Scan (cost=100.00..240.07 rows=3 width=8) (actual time=0.649..0.649 rows=0 loops=40)

  • Relations: (fdw_motostop.cordcom cor) INNER JOIN (fdw_motostop.dordcom dor)
249. 5.200 138.080 ↓ 0.0 0 40

Limit (cost=100.00..101.77 rows=1 width=8) (actual time=3.451..3.452 rows=0 loops=40)

250. 132.880 132.880 ↓ 0.0 0 40

Foreign Scan (cost=100.00..403.34 rows=171 width=8) (actual time=3.322..3.322 rows=0 loops=40)

  • Relations: (fdw_motostop.cfactura cfa) INNER JOIN (fdw_motostop.dfactura dfa)
251. 5.480 37.920 ↓ 0.0 0 40

Limit (cost=100.00..114.56 rows=1 width=8) (actual time=0.948..0.948 rows=0 loops=40)

252. 32.440 32.440 ↓ 0.0 0 40

Foreign Scan (cost=100.00..260.12 rows=11 width=8) (actual time=0.811..0.811 rows=0 loops=40)

  • Relations: ((fdw_motostop.cordcom cor) INNER JOIN (fdw_motostop.dordcom dor)) INNER JOIN (fdw_motostop.cordcom_estado ce)
253. 5.040 30.800 ↑ 1.0 1 40

Limit (cost=100.00..101.99 rows=1 width=26) (actual time=0.769..0.770 rows=1 loops=40)

254. 25.760 25.760 ↑ 102.0 1 40

Foreign Scan (cost=100.00..302.89 rows=102 width=26) (actual time=0.644..0.644 rows=1 loops=40)

  • Relations: (fdw_motostop.dordcom dor) INNER JOIN (fdw_motostop.cordcom cor)
255. 30.194 30.200 ↓ 0.0 0 40

Foreign Scan on saldoventas_dolares svd (cost=100.24..115.35 rows=2 width=32) (actual time=0.755..0.755 rows=0 loops=40)

256.          

Initplan (forForeign Scan)

257. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

258. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

259. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

260. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

261. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

262. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

263. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

264. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

265. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

266. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

267. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

268. 0.006 0.006 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=1)

269. 26.275 26.280 ↓ 0.0 0 40

Foreign Scan on saldoventas_dolares svd_1 (cost=100.24..115.35 rows=2 width=32) (actual time=0.657..0.657 rows=0 loops=40)

270.          

Initplan (forForeign Scan)

271. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

272. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

273. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

274. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

275. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

276. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

277. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

278. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

279. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

280. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

281. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

282. 0.005 0.005 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1)

283. 27.314 27.320 ↓ 0.0 0 40

Foreign Scan on saldoventas_dolares svd_2 (cost=100.24..115.35 rows=2 width=32) (actual time=0.683..0.683 rows=0 loops=40)

284.          

Initplan (forForeign Scan)

285. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

286. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

287. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

288. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

289. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

290. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

291. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

292. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

293. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

294. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

295. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

296. 0.006 0.006 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=1)

297. 26.915 26.920 ↓ 0.0 0 40

Foreign Scan on saldoventas_dolares svd_3 (cost=100.24..115.35 rows=2 width=32) (actual time=0.673..0.673 rows=0 loops=40)

298.          

Initplan (forForeign Scan)

299. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

300. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

301. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

302. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

303. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

304. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

305. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

306. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

307. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

308. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

309. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

310. 0.005 0.005 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1)

311. 26.273 26.280 ↓ 0.0 0 40

Foreign Scan on saldoventas_dolares svd_4 (cost=100.24..115.35 rows=2 width=32) (actual time=0.656..0.657 rows=0 loops=40)

312.          

Initplan (forForeign Scan)

313. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

314. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

315. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

316. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

317. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

318. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

319. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

320. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

321. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

322. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

323. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

324. 0.007 0.007 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=1)

325. 25.955 25.960 ↓ 0.0 0 40

Foreign Scan on saldoventas_dolares svd_5 (cost=100.24..115.35 rows=2 width=32) (actual time=0.649..0.649 rows=0 loops=40)

326.          

Initplan (forForeign Scan)

327. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

328. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

329. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

330. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

331. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

332. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

333. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

334. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

335. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

336. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

337. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

338. 0.005 0.005 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=1)

339. 25.675 25.680 ↓ 0.0 0 40

Foreign Scan on saldoventas_dolares svd_6 (cost=100.24..115.35 rows=2 width=32) (actual time=0.642..0.642 rows=0 loops=40)

340.          

Initplan (forForeign Scan)

341. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

342. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

343. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

344. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

345. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

346. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

347. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

348. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

349. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

350. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

351. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

352. 0.005 0.005 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=1)

353. 26.156 26.160 ↓ 0.0 0 40

Foreign Scan on saldoventas_dolares svd_7 (cost=100.24..115.35 rows=2 width=32) (actual time=0.654..0.654 rows=0 loops=40)

354.          

Initplan (forForeign Scan)

355. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

356. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

357. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

358. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

359. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

360. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

361. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

362. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

363. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

364. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

365. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

366. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

367. 25.676 25.680 ↓ 0.0 0 40

Foreign Scan on saldoventas_dolares svd_8 (cost=100.24..115.35 rows=2 width=32) (actual time=0.642..0.642 rows=0 loops=40)

368.          

Initplan (forForeign Scan)

369. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

370. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

371. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

372. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

373. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

374. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

375. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

376. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

377. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

378. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

379. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

380. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

381. 26.555 26.560 ↓ 0.0 0 40

Foreign Scan on saldoventas_dolares svd_9 (cost=100.24..115.35 rows=2 width=32) (actual time=0.664..0.664 rows=0 loops=40)

382.          

Initplan (forForeign Scan)

383. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

384. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

385. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

386. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

387. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

388. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

389. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

390. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

391. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

392. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

393. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

394. 0.005 0.005 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=1)

395. 26.596 26.600 ↓ 0.0 0 40

Foreign Scan on saldoventas_dolares svd_10 (cost=100.24..115.35 rows=2 width=32) (actual time=0.664..0.665 rows=0 loops=40)

396.          

Initplan (forForeign Scan)

397. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

398. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

399. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

400. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

401. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

402. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

403. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

404. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

405. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

406. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

407. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

408. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=1)

409. 26.396 26.400 ↓ 0.0 0 40

Foreign Scan on saldoventas_dolares svd_11 (cost=100.24..115.35 rows=2 width=32) (actual time=0.660..0.660 rows=0 loops=40)

410.          

Initplan (forForeign Scan)

411. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

412. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

413. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

414. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

415. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

416. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

417. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

418. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

419. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

420. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

421. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

422. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

423. 18.596 18.600 ↓ 0.0 0 40

Foreign Scan on saldoventas sv (cost=100.24..115.35 rows=2 width=32) (actual time=0.465..0.465 rows=0 loops=40)

424.          

Initplan (forForeign Scan)

425. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

426. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

427. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

428. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

429. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

430. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

431. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

432. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

433. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

434. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

435. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

436. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

437. 17.555 17.560 ↓ 0.0 0 40

Foreign Scan on saldoventas sv_1 (cost=100.24..115.35 rows=2 width=32) (actual time=0.439..0.439 rows=0 loops=40)

438.          

Initplan (forForeign Scan)

439. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

440. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

441. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

442. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

443. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

444. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

445. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

446. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

447. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

448. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

449. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

450. 0.005 0.005 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=1)

451. 18.076 18.080 ↓ 0.0 0 40

Foreign Scan on saldoventas sv_2 (cost=100.24..115.35 rows=2 width=32) (actual time=0.452..0.452 rows=0 loops=40)

452.          

Initplan (forForeign Scan)

453. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

454. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

455. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

456. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

457. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

458. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

459. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

460. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

461. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

462. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

463. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

464. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

465. 17.596 17.600 ↓ 0.0 0 40

Foreign Scan on saldoventas sv_3 (cost=100.24..115.35 rows=2 width=32) (actual time=0.440..0.440 rows=0 loops=40)

466.          

Initplan (forForeign Scan)

467. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

468. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

469. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

470. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

471. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

472. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

473. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

474. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

475. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

476. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

477. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

478. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

479. 17.756 17.760 ↓ 0.0 0 40

Foreign Scan on saldoventas sv_4 (cost=100.24..115.35 rows=2 width=32) (actual time=0.444..0.444 rows=0 loops=40)

480.          

Initplan (forForeign Scan)

481. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

482. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

483. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

484. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

485. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

486. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

487. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

488. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

489. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

490. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

491. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

492. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

493. 17.476 17.480 ↓ 0.0 0 40

Foreign Scan on saldoventas sv_5 (cost=100.24..115.35 rows=2 width=32) (actual time=0.437..0.437 rows=0 loops=40)

494.          

Initplan (forForeign Scan)

495. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

496. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

497. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

498. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

499. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

500. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

501. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

502. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

503. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

504. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

505. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

506. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

507. 17.236 17.240 ↓ 0.0 0 40

Foreign Scan on saldoventas sv_6 (cost=100.24..115.35 rows=2 width=32) (actual time=0.431..0.431 rows=0 loops=40)

508.          

Initplan (forForeign Scan)

509. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

510. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

511. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

512. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

513. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

514. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

515. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

516. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

517. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

518. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

519. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

520. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

521. 17.475 17.480 ↓ 0.0 0 40

Foreign Scan on saldoventas sv_7 (cost=100.24..115.35 rows=2 width=32) (actual time=0.437..0.437 rows=0 loops=40)

522.          

Initplan (forForeign Scan)

523. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

524. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

525. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

526. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

527. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

528. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

529. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

530. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

531. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

532. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

533. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

534. 0.005 0.005 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=1)

535. 17.516 17.520 ↓ 0.0 0 40

Foreign Scan on saldoventas sv_8 (cost=100.24..115.35 rows=2 width=32) (actual time=0.438..0.438 rows=0 loops=40)

536.          

Initplan (forForeign Scan)

537. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

538. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

539. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

540. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

541. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

542. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

543. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

544. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

545. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

546. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

547. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

548. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

549. 17.355 17.360 ↓ 0.0 0 40

Foreign Scan on saldoventas sv_9 (cost=100.24..115.35 rows=2 width=32) (actual time=0.434..0.434 rows=0 loops=40)

550.          

Initplan (forForeign Scan)

551. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

552. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

553. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

554. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

555. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

556. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

557. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

558. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

559. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

560. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

561. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

562. 0.005 0.005 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=1)

563. 17.476 17.480 ↓ 0.0 0 40

Foreign Scan on saldoventas sv_10 (cost=100.24..115.35 rows=2 width=32) (actual time=0.437..0.437 rows=0 loops=40)

564.          

Initplan (forForeign Scan)

565. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

566. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

567. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

568. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

569. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

570. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

571. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

572. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

573. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

574. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

575. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

576. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

577. 17.196 17.200 ↓ 0.0 0 40

Foreign Scan on saldoventas sv_11 (cost=100.24..115.35 rows=2 width=32) (actual time=0.430..0.430 rows=0 loops=40)

578.          

Initplan (forForeign Scan)

579. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

580. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

581. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

582. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

583. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

584. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

585. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

586. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

587. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

588. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

589. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

590. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

591. 17.356 17.360 ↓ 0.0 0 40

Foreign Scan on saldoventas sv_12 (cost=100.24..115.35 rows=2 width=32) (actual time=0.434..0.434 rows=0 loops=40)

592.          

Initplan (forForeign Scan)

593. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

594. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

595. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

596. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

597. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

598. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

599. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

600. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

601. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

602. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

603. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

604. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=1)

605. 26.955 26.960 ↓ 0.0 0 40

Foreign Scan on saldoventas_dolares svd_12 (cost=100.24..115.35 rows=2 width=32) (actual time=0.674..0.674 rows=0 loops=40)

606.          

Initplan (forForeign Scan)

607. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

608. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

609. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

610. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

611. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

612. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

613. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

614. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

615. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

616. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

617. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.02 rows=1 width=8) (never executed)

618. 0.005 0.005 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=1)

619. 0.080 31.520 ↓ 0.0 0 40

Limit (cost=183.32..183.32 rows=1 width=12) (actual time=0.788..0.788 rows=0 loops=40)

620. 5.400 31.440 ↓ 0.0 0 40

Sort (cost=183.32..183.32 rows=1 width=12) (actual time=0.786..0.786 rows=0 loops=40)

  • Sort Key: cor_9.cor_fecha DESC
  • Sort Method: quicksort Memory: 25kB
621. 26.040 26.040 ↓ 0.0 0 40

Foreign Scan (cost=100.00..183.31 rows=1 width=12) (actual time=0.651..0.651 rows=0 loops=40)

  • Relations: (fdw_motostop.dordcom dor) INNER JOIN (fdw_motostop.cordcom cor)