explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FPuB

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,799.825 2,301.521 ↓ 2.8 31,672 1

Gather (cost=2,222.13..172,853.90 rows=11,234 width=1,451) (actual time=25.655..2,301.521 rows=31,672 loops=1)

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

Initplan (forGather)

3. 0.018 0.018 ↑ 1.0 1 1

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

4. 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)

5. 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)

6. 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)

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

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

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

12. 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)

13. 0.006 0.006 ↑ 1.0 1 1

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

14. 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)

15. 0.010 0.010 ↑ 1.0 1 1

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

16. 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)

17. 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)

18. 0.011 0.011 ↑ 1.0 1 1

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

19. 0.006 0.006 ↑ 1.0 1 1

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

20. 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)

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.014 0.014 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.013..0.014 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.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)

26. 21.239 501.490 ↓ 2.4 15,836 2

Hash Left Join (cost=1,221.79..12,771.06 rows=6,608 width=445) (actual time=19.377..501.490 rows=15,836 loops=2)

  • Hash Cond: ((ubi.ubi_id = rua.ubi_id) AND (emp.emp_id = rua.emp_id))
27. 16.769 480.125 ↓ 2.4 15,836 2

Hash Left Join (cost=1,212.19..12,661.24 rows=6,608 width=449) (actual time=19.225..480.125 rows=15,836 loops=2)

  • Hash Cond: (ent.ent_telefono_principal = tel.tel_id)
28. 17.064 459.701 ↓ 2.4 15,836 2

Hash Left Join (cost=1,033.37..12,405.70 rows=6,608 width=444) (actual time=15.508..459.701 rows=15,836 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. 16.431 442.302 ↓ 2.4 15,836 2

Hash Left Join (cost=1,021.73..12,367.92 rows=6,608 width=376) (actual time=15.141..442.302 rows=15,836 loops=2)

  • Hash Cond: (ent.ent_direccion_principal = dir.dir_id)
30. 12.008 421.850 ↓ 2.4 15,836 2

Hash Left Join (cost=810.45..12,065.84 rows=6,608 width=342) (actual time=11.062..421.850 rows=15,836 loops=2)

  • Hash Cond: (cli.can_id = can.can_id)
31. 11.796 409.821 ↓ 2.4 15,836 2

Hash Left Join (cost=809.34..12,019.42 rows=6,608 width=339) (actual time=11.024..409.821 rows=15,836 loops=2)

  • Hash Cond: (cli.cat_id = cat.cat_id)
32. 15.466 398.000 ↓ 2.4 15,836 2

Hash Left Join (cost=808.20..11,927.42 rows=6,608 width=318) (actual time=10.980..398.000 rows=15,836 loops=2)

  • Hash Cond: (dcom.cco_id = cue.cco_id)
33. 137.080 382.257 ↓ 2.4 15,836 2

Nested Loop Left Join (cost=793.20..11,821.56 rows=6,608 width=284) (actual time=10.680..382.257 rows=15,836 loops=2)

34. 12.576 245.170 ↓ 2.4 15,836 2

Hash Left Join (cost=792.78..7,394.12 rows=6,608 width=284) (actual time=10.644..245.170 rows=15,836 loops=2)

  • Hash Cond: (cli.emp_id = emp.emp_id)
35. 11.004 232.300 ↓ 2.4 15,836 2

Hash Left Join (cost=676.56..7,232.60 rows=6,608 width=256) (actual time=10.330..232.300 rows=15,836 loops=2)

  • Hash Cond: (ccm.cti_id = cti.cti_id)
36. 13.733 221.239 ↓ 2.4 15,836 2

Hash Left Join (cost=672.03..7,137.21 rows=6,608 width=252) (actual time=10.257..221.239 rows=15,836 loops=2)

  • Hash Cond: (ccm.pve_id = pve.pve_id)
37. 147.566 207.444 ↓ 2.4 15,836 2

Nested Loop Left Join (cost=669.87..7,057.40 rows=6,608 width=244) (actual time=10.170..207.444 rows=15,836 loops=2)

38. 37.607 59.870 ↓ 2.4 15,836 2

Hash Join (cost=669.45..3,558.99 rows=6,608 width=192) (actual time=10.126..59.870 rows=15,836 loops=2)

  • Hash Cond: (ddo.cli_id = cli.cli_id)
39. 12.294 12.294 ↑ 1.2 18,159 2

Parallel Seq Scan on ddocumento ddo (cost=0.00..2,743.69 rows=21,269 width=82) (actual time=0.017..12.294 rows=18,159 loops=2)

40. 1.377 9.969 ↑ 1.0 1,922 2

Hash (cost=645.43..645.43 rows=1,922 width=114) (actual time=9.969..9.969 rows=1,922 loops=2)

  • Buckets: 2048 Batches: 1 Memory Usage: 286kB
41. 0.781 8.592 ↑ 1.0 1,922 2

Hash Left Join (cost=337.29..645.43 rows=1,922 width=114) (actual time=4.239..8.592 rows=1,922 loops=2)

  • Hash Cond: (cli.ubi_id = ubi.ubi_id)
42. 2.354 7.638 ↑ 1.0 1,922 2

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

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

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

44. 0.960 3.999 ↑ 1.0 1,922 2

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

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

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

  • Filter: (cli_tipocli = 1)
  • Rows Removed by Filter: 4274
46. 0.084 0.173 ↓ 1.0 268 2

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

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
47. 0.089 0.089 ↓ 1.0 268 2

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

48. 0.008 0.008 ↑ 1.0 1 31,672

Index Scan using pk_ccomproba on ccomproba ccm (cost=0.42..0.52 rows=1 width=56) (actual time=0.007..0.008 rows=1 loops=31,672)

  • Index Cond: (ddo.ccm_id = ccm_id)
49. 0.004 0.062 ↓ 1.2 5 2

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
50. 0.034 0.058 ↓ 1.2 5 2

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

  • Join Filter: (pve.alm_id = alm.alm_id)
51. 0.018 0.018 ↓ 1.2 5 2

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

52. 0.000 0.006 ↑ 1.0 1 10

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

53. 0.021 0.021 ↑ 1.0 1 2

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

54. 0.021 0.057 ↓ 1.0 69 2

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

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

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

56. 0.034 0.294 ↓ 1.1 67 2

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

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

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

58. 0.024 0.024 ↓ 1.1 67 2

Seq Scan on empleado emp (cost=0.00..1.62 rows=62 width=8) (actual time=0.013..0.024 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.003..0.003 rows=1 loops=134)

  • Index Cond: (emp.ent_id = ent_id)
60. 0.007 0.007 ↑ 1.0 1 31,672

Index Scan using dcomproba_pkey on dcomproba dcom (cost=0.42..0.66 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=31,672)

  • Index Cond: (ddo.dco_id = dco_id)
61. 0.144 0.277 ↓ 1.0 402 2

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

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

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

63. 0.010 0.025 ↑ 1.0 6 2

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

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

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

65. 0.007 0.021 ↑ 1.0 5 2

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

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

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

67. 2.235 4.021 ↑ 1.0 6,375 2

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

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

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

69. 0.011 0.335 ↑ 1.0 11 2

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Filter: (zon_reporta IS NULL)
79. 0.002 0.015 ↓ 0.0 0 2

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

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

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

81. 0.002 0.009 ↓ 0.0 0 2

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

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

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

83. 0.003 0.008 ↓ 0.0 0 2

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

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

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

85. 0.002 0.011 ↓ 0.0 0 2

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

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

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

87. 0.001 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
88. 0.006 0.006 ↑ 1.0 11 2

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

89. 0.003 0.008 ↓ 0.0 0 2

Hash (cost=1.11..1.11 rows=11 width=16) (actual time=0.007..0.008 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.004..0.005 rows=11 loops=2)

91. 0.001 0.008 ↓ 0.0 0 2

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

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

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

93. 0.001 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
94. 0.006 0.006 ↑ 1.0 11 2

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

95. 2.022 3.655 ↑ 1.0 6,373 2

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

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

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

97. 0.053 0.126 ↑ 1.9 156 2

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

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

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

99.          

SubPlan (forGather)

100. 0.002 0.023 ↑ 1.0 1 31,672

Limit (cost=2.93..8.13 rows=1 width=418) (actual time=0.023..0.023 rows=1 loops=31,672)

101.          

Initplan (forLimit)

102. 0.001 0.007 ↑ 1.0 1 31,672

Limit (cost=0.29..2.51 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=31,672)

103. 0.006 0.006 ↑ 1.0 1 31,672

Index Scan using cfactura_llave_idx on cfactura cfac (cost=0.29..2.51 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=31,672)

  • 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.002 0.014 ↑ 14.0 1 31,672

Index Scan using dfactura_llave_cabecera on dfactura dfac (cost=0.42..73.16 rows=14 width=418) (actual time=0.014..0.014 rows=1 loops=31,672)

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

SubPlan (forIndex Scan)

106. 0.001 0.012 ↑ 1.0 1 23,341

Limit (cost=0.56..5.00 rows=1 width=15) (actual time=0.012..0.012 rows=1 loops=23,341)

107. 0.002 0.011 ↑ 1.0 1 23,341

Nested Loop (cost=0.56..5.00 rows=1 width=15) (actual time=0.011..0.011 rows=1 loops=23,341)

108. 0.003 0.003 ↑ 1.0 1 23,341

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=23,341)

  • Index Cond: (pro_id = dfac.pro_id)
109. 0.006 0.006 ↑ 1.0 1 23,341

Index Scan using idx_cla1_codigo on clasificacion1 cla1 (cost=0.28..2.49 rows=1 width=21) (actual time=0.006..0.006 rows=1 loops=23,341)

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

Limit (cost=0.29..3.91 rows=1 width=17) (actual time=0.008..0.008 rows=0 loops=23,440)

111. 0.005 0.005 ↓ 0.0 0 23,440

Index Scan using drecibo_tpa_id_ddo_id on drecibo dr (cost=0.29..3.91 rows=1 width=17) (actual time=0.005..0.005 rows=0 loops=23,440)

  • Index Cond: ((tpa_id = ANY ('{164,165}'::integer[])) AND (ddo_id = ddo.ddo_id))
112. 0.004 0.013 ↑ 1.0 1 31,672

Aggregate (cost=1.64..1.65 rows=1 width=32) (actual time=0.013..0.013 rows=1 loops=31,672)

113. 0.009 0.009 ↓ 0.0 0 31,672

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

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