explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l6Wd : Optimization for: plan #FPuB

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 212.075 305.486 ↓ 3.0 5,107 1

Gather (cost=2,195.71..32,132.59 rows=1,723 width=1,451) (actual time=16.852..305.486 rows=5,107 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2.          

Initplan (forGather)

3. 0.015 0.015 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.015..0.015 rows=1 loops=1)

4. 0.006 0.006 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=1)

5. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)

6. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=1)

7. 0.009 0.009 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=1)

8. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=1)

9. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)

10. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=1)

11. 0.008 0.008 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=1)

12. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)

13. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=1)

14. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=1)

15. 0.007 0.007 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=1)

16. 0.007 0.007 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=1)

17. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)

18. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)

19. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)

20. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)

21. 0.005 0.005 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=1)

22. 0.004 0.004 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=1)

23. 0.010 0.010 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.010..0.010 rows=1 loops=1)

24. 0.005 0.005 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=1)

25. 0.012 0.012 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.012..0.012 rows=1 loops=1)

26. 2.776 93.246 ↓ 2.5 2,554 2

Hash Left Join (cost=1,195.36..6,733.18 rows=1,014 width=445) (actual time=14.228..93.246 rows=2,554 loops=2)

  • Hash Cond: ((ubi.ubi_id = rua.ubi_id) AND (emp.emp_id = rua.emp_id))
27. 2.312 90.383 ↓ 2.5 2,554 2

Hash Left Join (cost=1,185.76..6,708.20 rows=1,014 width=449) (actual time=14.117..90.383 rows=2,554 loops=2)

  • Hash Cond: (ent.ent_telefono_principal = tel.tel_id)
28. 2.292 85.668 ↓ 2.5 2,554 2

Hash Left Join (cost=1,006.94..6,517.61 rows=1,014 width=444) (actual time=11.666..85.668 rows=2,554 loops=2)

  • Hash Cond: (cli.zon_id = CASE WHEN (zon2.zon_id IS NULL) THEN zon.zon_id WHEN (zon3.zon_id IS NULL) THEN zon2.zon_id WHEN (zon4.zon_id IS NULL) THEN zon3.zon_id WHEN (zon5.zon_id IS NULL) THEN zon4.zon_id WHEN (zon6.zon_id IS NULL) THEN zon5.zon_id WHEN (zon7.zon_id IS NULL) THEN zon6.zon_id WHEN (zon8.zon_id IS NULL) THEN zon7.zon_id WHEN (zon9.zon_id IS NULL) THEN zon8.zon_id ELSE zon9.zon_id END)
29. 2.213 83.187 ↓ 2.5 2,554 2

Hash Left Join (cost=995.30..6,501.96 rows=1,014 width=376) (actual time=11.450..83.187 rows=2,554 loops=2)

  • Hash Cond: (ent.ent_direccion_principal = dir.dir_id)
30. 1.595 77.960 ↓ 2.5 2,554 2

Hash Left Join (cost=784.02..6,276.74 rows=1,014 width=342) (actual time=8.387..77.960 rows=2,554 loops=2)

  • Hash Cond: (cli.can_id = can.can_id)
31. 1.699 76.348 ↓ 2.5 2,554 2

Hash Left Join (cost=782.91..6,268.68 rows=1,014 width=339) (actual time=8.355..76.348 rows=2,554 loops=2)

  • Hash Cond: (cli.cat_id = cat.cat_id)
32. 2.247 74.629 ↓ 2.5 2,554 2

Hash Left Join (cost=781.77..6,253.60 rows=1,014 width=318) (actual time=8.319..74.629 rows=2,554 loops=2)

  • Hash Cond: (dcom.cco_id = cue.cco_id)
33. 23.165 72.168 ↓ 2.5 2,554 2

Nested Loop Left Join (cost=766.77..6,224.66 rows=1,014 width=284) (actual time=8.082..72.168 rows=2,554 loops=2)

34. 1.756 48.995 ↓ 2.5 2,554 2

Hash Left Join (cost=766.35..4,588.18 rows=1,014 width=284) (actual time=8.050..48.995 rows=2,554 loops=2)

  • Hash Cond: (cli.emp_id = emp.emp_id)
35. 1.493 46.963 ↓ 2.5 2,554 2

Hash Left Join (cost=650.14..4,465.02 rows=1,014 width=256) (actual time=7.756..46.963 rows=2,554 loops=2)

  • Hash Cond: (ccm.cti_id = cti.cti_id)
36. 1.678 45.419 ↓ 2.5 2,554 2

Hash Left Join (cost=645.61..4,446.54 rows=1,014 width=252) (actual time=7.690..45.419 rows=2,554 loops=2)

  • Hash Cond: (cli.ubi_id = ubi.ubi_id)
37. 1.917 43.604 ↓ 2.5 2,554 2

Hash Left Join (cost=636.67..4,423.66 rows=1,014 width=242) (actual time=7.537..43.604 rows=2,554 loops=2)

  • Hash Cond: (ccm.pve_id = pve.pve_id)
38. 21.217 41.639 ↓ 2.5 2,554 2

Nested Loop Left Join (cost=634.50..4,409.59 rows=1,014 width=234) (actual time=7.470..41.639 rows=2,554 loops=2)

39. 3.680 20.415 ↓ 2.5 2,554 2

Hash Join (cost=634.09..3,400.15 rows=1,014 width=182) (actual time=7.438..20.415 rows=2,554 loops=2)

  • Hash Cond: (ddo.cli_id = cli.cli_id)
40. 9.445 9.445 ↑ 1.2 2,800 2

Parallel Seq Scan on ddocumento ddo (cost=0.00..2,743.69 rows=3,262 width=82) (actual time=0.017..9.445 rows=2,800 loops=2)

  • Filter: (NOT ddo_cancelado)
  • Rows Removed by Filter: 15363
41. 0.986 7.290 ↑ 1.0 1,922 2

Hash (cost=610.06..610.06 rows=1,922 width=104) (actual time=7.290..7.290 rows=1,922 loops=2)

  • Buckets: 2048 Batches: 1 Memory Usage: 267kB
42. 1.955 6.304 ↑ 1.0 1,922 2

Hash Right Join (cost=328.35..610.06 rows=1,922 width=104) (actual time=3.372..6.304 rows=1,922 loops=2)

  • Hash Cond: (ent.ent_id = cli.ent_id)
43. 1.015 1.015 ↓ 1.0 5,946 2

Seq Scan on entidad ent (cost=0.00..225.38 rows=5,938 width=40) (actual time=0.016..1.015 rows=5,946 loops=2)

44. 0.778 3.334 ↑ 1.0 1,922 2

Hash (cost=304.32..304.32 rows=1,922 width=72) (actual time=3.334..3.334 rows=1,922 loops=2)

  • Buckets: 2048 Batches: 1 Memory Usage: 204kB
45. 2.556 2.556 ↑ 1.0 1,922 2

Seq Scan on cliente cli (cost=0.00..304.32 rows=1,922 width=72) (actual time=0.024..2.556 rows=1,922 loops=2)

  • Filter: (cli_tipocli = 1)
  • Rows Removed by Filter: 4274
46. 0.007 0.007 ↑ 1.0 1 5,107

Index Scan using pk_ccomproba on ccomproba ccm (cost=0.42..0.99 rows=1 width=56) (actual time=0.007..0.007 rows=1 loops=5,107)

  • Index Cond: (ddo.ccm_id = ccm_id)
47. 0.007 0.048 ↓ 1.2 5 2

Hash (cost=2.11..2.11 rows=4 width=12) (actual time=0.048..0.048 rows=5 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
48. 0.022 0.041 ↓ 1.2 5 2

Nested Loop Left Join (cost=0.00..2.11 rows=4 width=12) (actual time=0.036..0.041 rows=5 loops=2)

  • Join Filter: (pve.alm_id = alm.alm_id)
49. 0.015 0.015 ↓ 1.2 5 2

Seq Scan on puntoventa pve (cost=0.00..1.04 rows=4 width=12) (actual time=0.014..0.015 rows=5 loops=2)

50. 0.000 0.004 ↑ 1.0 1 10

Materialize (cost=0.00..1.01 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=10)

51. 0.012 0.012 ↑ 1.0 1 2

Seq Scan on almacen alm (cost=0.00..1.01 rows=1 width=8) (actual time=0.011..0.012 rows=1 loops=2)

52. 0.065 0.137 ↓ 1.0 268 2

Hash (cost=5.64..5.64 rows=264 width=14) (actual time=0.137..0.137 rows=268 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
53. 0.072 0.072 ↓ 1.0 268 2

Seq Scan on ubicacion ubi (cost=0.00..5.64 rows=264 width=14) (actual time=0.013..0.072 rows=268 loops=2)

54. 0.019 0.051 ↓ 1.0 69 2

Hash (cost=3.68..3.68 rows=68 width=8) (actual time=0.051..0.051 rows=69 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
55. 0.032 0.032 ↓ 1.0 69 2

Seq Scan on ctipocom cti (cost=0.00..3.68 rows=68 width=8) (actual time=0.013..0.032 rows=69 loops=2)

56. 0.040 0.276 ↓ 1.1 67 2

Hash (cost=115.44..115.44 rows=62 width=32) (actual time=0.276..0.276 rows=67 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
57. 0.208 0.236 ↓ 1.1 67 2

Nested Loop Left Join (cost=0.28..115.44 rows=62 width=32) (actual time=0.030..0.236 rows=67 loops=2)

58. 0.025 0.025 ↓ 1.1 67 2

Seq Scan on empleado emp (cost=0.00..1.62 rows=62 width=8) (actual time=0.013..0.025 rows=67 loops=2)

59. 0.003 0.003 ↑ 1.0 1 134

Index Scan using pk_entidad on entidad ent1 (cost=0.28..1.83 rows=1 width=32) (actual time=0.002..0.003 rows=1 loops=134)

  • Index Cond: (emp.ent_id = ent_id)
60. 0.008 0.008 ↑ 1.0 1 5,107

Index Scan using dcomproba_pkey on dcomproba dcom (cost=0.42..1.60 rows=1 width=8) (actual time=0.007..0.008 rows=1 loops=5,107)

  • Index Cond: (ddo.dco_id = dco_id)
61. 0.112 0.214 ↓ 1.0 402 2

Hash (cost=10.00..10.00 rows=400 width=38) (actual time=0.214..0.214 rows=402 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
62. 0.102 0.102 ↓ 1.0 402 2

Seq Scan on cuenta_contable cue (cost=0.00..10.00 rows=400 width=38) (actual time=0.017..0.102 rows=402 loops=2)

63. 0.009 0.020 ↑ 1.0 6 2

Hash (cost=1.06..1.06 rows=6 width=29) (actual time=0.020..0.020 rows=6 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
64. 0.011 0.011 ↑ 1.0 6 2

Seq Scan on catcliente cat (cost=0.00..1.06 rows=6 width=29) (actual time=0.011..0.011 rows=6 loops=2)

65. 0.006 0.017 ↑ 1.0 5 2

Hash (cost=1.05..1.05 rows=5 width=11) (actual time=0.017..0.017 rows=5 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
66. 0.011 0.011 ↑ 1.0 5 2

Seq Scan on canal can (cost=0.00..1.05 rows=5 width=11) (actual time=0.010..0.011 rows=5 loops=2)

67. 1.695 3.014 ↑ 1.0 6,375 2

Hash (cost=130.57..130.57 rows=6,457 width=42) (actual time=3.014..3.014 rows=6,375 loops=2)

  • Buckets: 8192 Batches: 1 Memory Usage: 507kB
68. 1.319 1.319 ↑ 1.0 6,375 2

Seq Scan on direccion dir (cost=0.00..130.57 rows=6,457 width=42) (actual time=0.013..1.319 rows=6,375 loops=2)

69. 0.007 0.189 ↑ 1.0 11 2

Hash (cost=11.50..11.50 rows=11 width=108) (actual time=0.188..0.189 rows=11 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
70. 0.015 0.182 ↑ 1.0 11 2

Hash Left Join (cost=9.98..11.50 rows=11 width=108) (actual time=0.162..0.182 rows=11 loops=2)

  • Hash Cond: (zon8.zon_id = zon9.zon_reporta)
71. 0.018 0.162 ↑ 1.0 11 2

Hash Left Join (cost=8.73..10.20 rows=11 width=96) (actual time=0.146..0.162 rows=11 loops=2)

  • Hash Cond: (zon7.zon_id = zon8.zon_reporta)
72. 0.014 0.139 ↑ 1.0 11 2

Hash Left Join (cost=7.49..8.90 rows=11 width=84) (actual time=0.127..0.139 rows=11 loops=2)

  • Hash Cond: (zon6.zon_id = zon7.zon_reporta)
73. 0.017 0.120 ↑ 1.0 11 2

Hash Left Join (cost=6.24..7.60 rows=11 width=72) (actual time=0.107..0.120 rows=11 loops=2)

  • Hash Cond: (zon5.zon_id = zon6.zon_reporta)
74. 0.013 0.097 ↑ 1.0 11 2

Hash Left Join (cost=4.99..6.31 rows=11 width=60) (actual time=0.086..0.097 rows=11 loops=2)

  • Hash Cond: (zon4.zon_id = zon5.zon_reporta)
75. 0.014 0.077 ↑ 1.0 11 2

Hash Left Join (cost=3.74..5.01 rows=11 width=48) (actual time=0.068..0.077 rows=11 loops=2)

  • Hash Cond: (zon3.zon_id = zon4.zon_reporta)
76. 0.015 0.058 ↑ 1.0 11 2

Hash Left Join (cost=2.50..3.71 rows=11 width=36) (actual time=0.051..0.058 rows=11 loops=2)

  • Hash Cond: (zon2.zon_id = zon3.zon_reporta)
77. 0.014 0.038 ↑ 1.0 11 2

Hash Left Join (cost=1.25..2.41 rows=11 width=24) (actual time=0.033..0.038 rows=11 loops=2)

  • Hash Cond: (zon.zon_id = zon2.zon_reporta)
78. 0.018 0.018 ↑ 1.0 11 2

Seq Scan on zona zon (cost=0.00..1.11 rows=11 width=12) (actual time=0.015..0.018 rows=11 loops=2)

  • Filter: (zon_reporta IS NULL)
79. 0.001 0.006 ↓ 0.0 0 2

Hash (cost=1.11..1.11 rows=11 width=16) (actual time=0.006..0.006 rows=0 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
80. 0.005 0.005 ↑ 1.0 11 2

Seq Scan on zona zon2 (cost=0.00..1.11 rows=11 width=16) (actual time=0.002..0.005 rows=11 loops=2)

81. 0.001 0.005 ↓ 0.0 0 2

Hash (cost=1.11..1.11 rows=11 width=16) (actual time=0.005..0.005 rows=0 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
82. 0.004 0.004 ↑ 1.0 11 2

Seq Scan on zona zon3 (cost=0.00..1.11 rows=11 width=16) (actual time=0.002..0.004 rows=11 loops=2)

83. 0.001 0.005 ↓ 0.0 0 2

Hash (cost=1.11..1.11 rows=11 width=16) (actual time=0.005..0.005 rows=0 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
84. 0.004 0.004 ↑ 1.0 11 2

Seq Scan on zona zon4 (cost=0.00..1.11 rows=11 width=16) (actual time=0.003..0.004 rows=11 loops=2)

85. 0.002 0.007 ↓ 0.0 0 2

Hash (cost=1.11..1.11 rows=11 width=16) (actual time=0.007..0.007 rows=0 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
86. 0.005 0.005 ↑ 1.0 11 2

Seq Scan on zona zon5 (cost=0.00..1.11 rows=11 width=16) (actual time=0.004..0.005 rows=11 loops=2)

87. 0.002 0.006 ↓ 0.0 0 2

Hash (cost=1.11..1.11 rows=11 width=16) (actual time=0.005..0.006 rows=0 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
88. 0.004 0.004 ↑ 1.0 11 2

Seq Scan on zona zon6 (cost=0.00..1.11 rows=11 width=16) (actual time=0.002..0.004 rows=11 loops=2)

89. 0.000 0.005 ↓ 0.0 0 2

Hash (cost=1.11..1.11 rows=11 width=16) (actual time=0.005..0.005 rows=0 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
90. 0.005 0.005 ↑ 1.0 11 2

Seq Scan on zona zon7 (cost=0.00..1.11 rows=11 width=16) (actual time=0.003..0.005 rows=11 loops=2)

91. 0.001 0.005 ↓ 0.0 0 2

Hash (cost=1.11..1.11 rows=11 width=16) (actual time=0.005..0.005 rows=0 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
92. 0.004 0.004 ↑ 1.0 11 2

Seq Scan on zona zon8 (cost=0.00..1.11 rows=11 width=16) (actual time=0.002..0.004 rows=11 loops=2)

93. 0.000 0.005 ↓ 0.0 0 2

Hash (cost=1.11..1.11 rows=11 width=16) (actual time=0.005..0.005 rows=0 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
94. 0.005 0.005 ↑ 1.0 11 2

Seq Scan on zona zon9 (cost=0.00..1.11 rows=11 width=16) (actual time=0.002..0.005 rows=11 loops=2)

95. 1.363 2.403 ↑ 1.0 6,373 2

Hash (cost=98.92..98.92 rows=6,392 width=13) (actual time=2.403..2.403 rows=6,373 loops=2)

  • Buckets: 8192 Batches: 1 Memory Usage: 352kB
96. 1.040 1.040 ↑ 1.0 6,373 2

Seq Scan on telefono tel (cost=0.00..98.92 rows=6,392 width=13) (actual time=0.015..1.040 rows=6,373 loops=2)

97. 0.028 0.087 ↑ 1.9 156 2

Hash (cost=5.04..5.04 rows=304 width=12) (actual time=0.087..0.087 rows=156 loops=2)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
98. 0.059 0.059 ↑ 1.9 156 2

Seq Scan on ruta_agente rua (cost=0.00..5.04 rows=304 width=12) (actual time=0.022..0.059 rows=156 loops=2)

99.          

SubPlan (forGather)

100. 0.002 0.017 ↑ 1.0 1 5,107

Limit (cost=2.93..8.13 rows=1 width=418) (actual time=0.016..0.017 rows=1 loops=5,107)

101.          

Initplan (forLimit)

102. 0.001 0.006 ↑ 1.0 1 5,107

Limit (cost=0.29..2.51 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=5,107)

103. 0.005 0.005 ↑ 1.0 1 5,107

Index Scan using cfactura_llave_idx on cfactura cfac (cost=0.29..2.51 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=5,107)

  • Index Cond: ((cfa_numero = ccm.ccm_numero) AND (cti_id = ccm.cti_id))
  • Filter: (pve_id = ccm.pve_id)
  • Rows Removed by Filter: 0
104. 0.000 0.009 ↑ 14.0 1 5,107

Index Scan using dfactura_llave_cabecera on dfactura dfac (cost=0.42..73.16 rows=14 width=418) (actual time=0.009..0.009 rows=1 loops=5,107)

  • Index Cond: (cfa_id = $28)
105.          

SubPlan (forIndex Scan)

106. 0.001 0.011 ↑ 1.0 1 2,996

Limit (cost=0.56..5.00 rows=1 width=15) (actual time=0.010..0.011 rows=1 loops=2,996)

107. 0.002 0.010 ↑ 1.0 1 2,996

Nested Loop (cost=0.56..5.00 rows=1 width=15) (actual time=0.010..0.010 rows=1 loops=2,996)

108. 0.003 0.003 ↑ 1.0 1 2,996

Index Scan using producto_pkey on producto pro (cost=0.28..2.50 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=2,996)

  • Index Cond: (pro_id = dfac.pro_id)
109. 0.005 0.005 ↑ 1.0 1 2,996

Index Scan using idx_cla1_codigo on clasificacion1 cla1 (cost=0.28..2.49 rows=1 width=21) (actual time=0.005..0.005 rows=1 loops=2,996)

  • Index Cond: ((cla1_codigo)::text = "left"((pro.pro_codigo)::text, 2))
110. 0.003 0.007 ↓ 0.0 0 2,488

Limit (cost=0.29..3.91 rows=1 width=17) (actual time=0.007..0.007 rows=0 loops=2,488)

111. 0.004 0.004 ↓ 0.0 0 2,488

Index Scan using drecibo_tpa_id_ddo_id on drecibo dr (cost=0.29..3.91 rows=1 width=17) (actual time=0.004..0.004 rows=0 loops=2,488)

  • Index Cond: ((tpa_id = ANY ('{164,165}'::integer[])) AND (ddo_id = ddo.ddo_id))
112. 0.003 0.012 ↑ 1.0 1 5,107

Aggregate (cost=1.64..1.65 rows=1 width=32) (actual time=0.012..0.012 rows=1 loops=5,107)

113. 0.009 0.009 ↓ 0.0 0 5,107

Seq Scan on cliente_gestion clg (cost=0.00..1.64 rows=1 width=33) (actual time=0.009..0.009 rows=0 loops=5,107)

  • Filter: (clg_id = cli.cli_id)
  • Rows Removed by Filter: 66