explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iNjQ : Optimization for: Optimization for: listaofertas; plan #6T6; plan #HMju

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 117,354.152 139,998.001 ↓ 674.0 674 1

Nested Loop (cost=189.99..59,800.09 rows=1 width=972) (actual time=7.088..139,998.001 rows=674 loops=1)

  • Join Filter: (oh.sogecodi = oca.sogecodi)
2.          

Initplan (forNested Loop)

3. 0.042 0.464 ↑ 1.0 1 1

Aggregate (cost=76.60..76.61 rows=1 width=8) (actual time=0.464..0.464 rows=1 loops=1)

4. 0.422 0.422 ↑ 1.0 694 1

Seq Scan on tipotarifas (cost=0.00..74.86 rows=694 width=0) (actual time=0.020..0.422 rows=694 loops=1)

  • Filter: (titaresi = 0)
  • Rows Removed by Filter: 975
5. 0.003 0.012 ↑ 1.0 1 1

Aggregate (cost=1.34..1.35 rows=1 width=8) (actual time=0.011..0.012 rows=1 loops=1)

6. 0.009 0.009 ↑ 1.0 18 1

Seq Scan on mercado (cost=0.00..1.30 rows=18 width=0) (actual time=0.005..0.009 rows=18 loops=1)

  • Filter: (mercficticio = '0'::numeric)
  • Rows Removed by Filter: 6
7. 3.720 85.218 ↓ 674.0 674 1

Nested Loop Left Join (cost=111.89..3,157.15 rows=1 width=316) (actual time=2.803..85.218 rows=674 loops=1)

8. 3.790 74.758 ↓ 674.0 674 1

Nested Loop (cost=111.60..3,155.87 rows=1 width=284) (actual time=2.768..74.758 rows=674 loops=1)

9. 4.299 59.103 ↓ 2.5 791 1

Hash Left Join (cost=111.31..3,048.81 rows=320 width=228) (actual time=2.718..59.103 rows=791 loops=1)

  • Hash Cond: ((oh.centcodi)::text = (c.centcodi)::text)
  • Filter: ((c.centbaja <> 1) OR ((oh.centcodi)::text = '-1'::text))
  • Rows Removed by Filter: 184
10. 39.853 54.602 ↓ 1.7 975 1

Hash Join (cost=95.90..3,031.72 rows=559 width=222) (actual time=2.433..54.602 rows=975 loops=1)

  • Hash Cond: ((oh.sogecodi = oc.sogecodi) AND (oh.ofcodi = oc.ofcacodi))
11. 12.434 12.434 ↑ 1.0 72,316 1

Seq Scan on ofertamasterhotel oh (cost=0.00..2,556.16 rows=72,316 width=101) (actual time=0.014..12.434 rows=72,316 loops=1)

12. 1.404 2.315 ↑ 1.0 1,636 1

Hash (cost=71.36..71.36 rows=1,636 width=121) (actual time=2.315..2.315 rows=1,636 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 257kB
13. 0.911 0.911 ↑ 1.0 1,636 1

Seq Scan on ofertacambio oc (cost=0.00..71.36 rows=1,636 width=121) (actual time=0.013..0.911 rows=1,636 loops=1)

14. 0.080 0.202 ↑ 1.0 196 1

Hash (cost=12.96..12.96 rows=196 width=10) (actual time=0.202..0.202 rows=196 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
15. 0.122 0.122 ↑ 1.0 196 1

Seq Scan on centros c (cost=0.00..12.96 rows=196 width=10) (actual time=0.027..0.122 rows=196 loops=1)

16. 11.865 11.865 ↑ 1.0 1 791

Index Scan using ofertamaster_pkey on ofertamaster om (cost=0.29..0.33 rows=1 width=60) (actual time=0.015..0.015 rows=1 loops=791)

  • Index Cond: ((sogecodi = oh.sogecodi) AND (ofmacodi = oh.ofmacodi))
  • Filter: ((ofmatipo)::text = 'C'::text)
  • Rows Removed by Filter: 0
17. 6.740 6.740 ↑ 1.0 1 674

Index Scan using ofertacambiodescripcion_pkey on ofertacambiodescripcion ofcd (cost=0.29..1.28 rows=1 width=40) (actual time=0.010..0.010 rows=1 loops=674)

  • Index Cond: ((sogecodi = oc.sogecodi) AND (ofcacodi = oc.ofcacodi) AND (idiocodi = 1))
18. 3.370 3.370 ↑ 1.0 1 674

Index Scan using ofertacategoria_pkey on ofertacategoria oca (cost=0.14..0.23 rows=1 width=22) (actual time=0.005..0.005 rows=1 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofcacodi = om.ofcacodi))
19.          

SubPlan (forNested Loop)

20. 4.342 1,243.816 ↑ 1.0 1 167

Aggregate (cost=2,277.40..2,277.41 rows=1 width=8) (actual time=7.448..7.448 rows=1 loops=167)

21. 1,027.050 1,239.474 ↓ 4.0 4 167

Bitmap Heap Scan on ofertamasterhotel (cost=237.78..2,277.40 rows=1 width=4) (actual time=4.986..7.422 rows=4 loops=167)

  • Recheck Cond: (sogecodi = om.sogecodi)
  • Filter: ((centcodi > 0) AND (ofmacodi = om.ofmacodi) AND ((ofmatipo)::text = (om.ofmatipo)::text))
  • Rows Removed by Filter: 22905
  • Heap Blocks: exact=230549
22. 212.424 212.424 ↓ 2.2 22,909 167

Bitmap Index Scan on ofertamasterhotel_pkey (cost=0.00..237.78 rows=10,331 width=0) (actual time=1.272..1.272 rows=22,909 loops=167)

  • Index Cond: (sogecodi = om.sogecodi)
23. 2.672 1,254.170 ↑ 1.0 1 167

Aggregate (cost=2,294.23..2,294.24 rows=1 width=8) (actual time=7.510..7.510 rows=1 loops=167)

24. 0.698 1,251.498 ↓ 2.0 2 167

Nested Loop (cost=238.48..2,294.22 rows=1 width=4) (actual time=6.541..7.494 rows=2 loops=167)

25. 3.336 1,249.828 ↓ 2.0 2 167

Nested Loop (cost=238.20..2,285.86 rows=1 width=12) (actual time=6.535..7.484 rows=2 loops=167)

26. 1,012.187 1,226.782 ↓ 4.0 4 167

Bitmap Heap Scan on ofertamasterhotel omh (cost=237.78..2,277.40 rows=1 width=16) (actual time=4.901..7.346 rows=4 loops=167)

  • Recheck Cond: (sogecodi = om.sogecodi)
  • Filter: ((centcodi > 0) AND (ofmacodi = om.ofmacodi) AND ((ofmatipo)::text = (om.ofmatipo)::text))
  • Rows Removed by Filter: 22905
  • Heap Blocks: exact=230549
27. 214.595 214.595 ↓ 2.2 22,909 167

Bitmap Index Scan on ofertamasterhotel_pkey (cost=0.00..237.78 rows=10,331 width=0) (actual time=1.285..1.285 rows=22,909 loops=167)

  • Index Cond: (sogecodi = om.sogecodi)
28. 19.710 19.710 ↓ 0.0 0 657

Index Scan using ofertaperiodos_sogecodi_idx on ofertaperiodos op (cost=0.42..8.45 rows=1 width=8) (actual time=0.030..0.030 rows=0 loops=657)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofmahocodi = omh.ofmahocodi) AND (ofpetipo = 2) AND (now() >= ofpefechadesde))
  • Filter: (now() <= ofpefechahasta)
  • Rows Removed by Filter: 1
29. 0.972 0.972 ↑ 1.0 1 324

Index Only Scan using ofertacambio_pkey on ofertacambio oc_1 (cost=0.28..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=324)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofcacodi = omh.ofcodi))
  • Heap Fetches: 324
30. 1.348 50.550 ↑ 1.0 1 674

Result (cost=8.45..8.46 rows=1 width=8) (actual time=0.075..0.075 rows=1 loops=674)

31.          

Initplan (forResult)

32. 2.696 49.202 ↑ 1.0 1 674

Limit (cost=0.42..8.45 rows=1 width=8) (actual time=0.072..0.073 rows=1 loops=674)

33. 46.506 46.506 ↑ 1.0 1 674

Index Only Scan using ofertaperiodos_sogecodi_idx on ofertaperiodos (cost=0.42..8.45 rows=1 width=8) (actual time=0.069..0.069 rows=1 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofmahocodi = oh.ofmahocodi) AND (ofpetipo = 2) AND (ofpefechadesde IS NOT NULL))
  • Heap Fetches: 620
34. 2.022 5.392 ↑ 1.0 1 674

Aggregate (cost=8.44..8.45 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=674)

35. 3.370 3.370 ↑ 1.0 1 674

Index Scan using ofertaperiodos_sogecodi_idx on ofertaperiodos ofertaperiodos_1 (cost=0.42..8.44 rows=1 width=8) (actual time=0.003..0.005 rows=1 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofmahocodi = oh.ofmahocodi) AND (ofpetipo = 2))
36. 0.674 4.044 ↑ 1.0 1 674

Result (cost=8.45..8.46 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=674)

37.          

Initplan (forResult)

38. 1.348 3.370 ↑ 1.0 1 674

Limit (cost=0.42..8.45 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=674)

39. 2.022 2.022 ↑ 1.0 1 674

Index Only Scan using ofertaperiodos_sogecodi_idx on ofertaperiodos ofertaperiodos_2 (cost=0.42..8.45 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofmahocodi = oh.ofmahocodi) AND (ofpetipo = 1) AND (ofpefechadesde IS NOT NULL))
  • Heap Fetches: 620
40. 2.022 3.370 ↑ 1.0 1 674

Aggregate (cost=8.44..8.45 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=674)

41. 1.348 1.348 ↑ 1.0 1 674

Index Scan using ofertaperiodos_sogecodi_idx on ofertaperiodos ofertaperiodos_3 (cost=0.42..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofmahocodi = oh.ofmahocodi) AND (ofpetipo = 1))
42. 2.696 4.044 ↑ 1.0 1 674

Aggregate (cost=8.46..8.54 rows=1 width=32) (actual time=0.006..0.006 rows=1 loops=674)

43. 1.348 1.348 ↑ 1.0 1 674

Index Scan using ofertaperiodos_sogecodi_idx on ofertaperiodos ofertaperiodos_4 (cost=0.42..8.44 rows=1 width=2) (actual time=0.002..0.002 rows=1 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofmahocodi = oh.ofmahocodi) AND (ofpetipo = 2))
44. 1.348 4.044 ↑ 1.0 1 674

Result (cost=8.45..8.46 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=674)

45.          

Initplan (forResult)

46. 0.674 2.696 ↑ 1.0 1 674

Limit (cost=0.42..8.45 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=674)

47. 2.022 2.022 ↑ 1.0 1 674

Index Only Scan using ofertaperiodos_sogecodi_idx on ofertaperiodos ofertaperiodos_5 (cost=0.42..8.45 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofmahocodi = oh.ofmahocodi) AND (ofpetipo = 2) AND (ofpefechadesde IS NOT NULL))
  • Heap Fetches: 620
48. 1.348 2.696 ↑ 1.0 1 674

Aggregate (cost=8.44..8.45 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=674)

49. 1.348 1.348 ↑ 1.0 1 674

Index Scan using ofertaperiodos_sogecodi_idx on ofertaperiodos ofertaperiodos_6 (cost=0.42..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofmahocodi = oh.ofmahocodi) AND (ofpetipo = 2))
50. 2.022 3.370 ↑ 1.0 1 674

Aggregate (cost=8.46..8.54 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=674)

51. 1.348 1.348 ↑ 1.0 1 674

Index Scan using ofertaperiodos_sogecodi_idx on ofertaperiodos ofertaperiodos_7 (cost=0.42..8.44 rows=1 width=2) (actual time=0.002..0.002 rows=1 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofmahocodi = oh.ofmahocodi) AND (ofpetipo = 1))
52. 2.022 3.370 ↑ 1.0 1 674

Aggregate (cost=8.44..8.45 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=674)

53. 1.348 1.348 ↑ 1.0 1 674

Index Scan using ofertaperiodos_sogecodi_idx on ofertaperiodos ofertaperiodos_8 (cost=0.42..8.44 rows=1 width=5) (actual time=0.002..0.002 rows=1 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofmahocodi = oh.ofmahocodi) AND (ofpetipo = 2))
54. 2.022 3.370 ↑ 1.0 1 674

Aggregate (cost=8.44..8.45 rows=1 width=32) (actual time=0.004..0.005 rows=1 loops=674)

55. 1.348 1.348 ↑ 1.0 1 674

Index Scan using ofertaperiodos_sogecodi_idx on ofertaperiodos ofertaperiodos_9 (cost=0.42..8.44 rows=1 width=5) (actual time=0.002..0.002 rows=1 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofmahocodi = oh.ofmahocodi) AND (ofpetipo = 2))
56. 1.348 2.696 ↑ 1.0 1 674

Aggregate (cost=8.44..8.45 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=674)

57. 1.348 1.348 ↑ 1.0 1 674

Index Scan using ofertaperiodos_sogecodi_idx on ofertaperiodos ofertaperiodos_10 (cost=0.42..8.44 rows=1 width=5) (actual time=0.002..0.002 rows=1 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofmahocodi = oh.ofmahocodi) AND (ofpetipo = 2))
58. 2.022 3.370 ↑ 1.0 1 674

Aggregate (cost=8.44..8.45 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=674)

59. 1.348 1.348 ↑ 1.0 1 674

Index Scan using ofertaperiodos_sogecodi_idx on ofertaperiodos ofertaperiodos_11 (cost=0.42..8.44 rows=1 width=5) (actual time=0.002..0.002 rows=1 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofmahocodi = oh.ofmahocodi) AND (ofpetipo = 2))
60. 10.110 5,195.192 ↑ 1.0 1 674

Aggregate (cost=2,251.57..2,251.58 rows=1 width=8) (actual time=7.707..7.708 rows=1 loops=674)

61. 4,253.614 5,185.082 ↓ 25.0 25 674

Bitmap Heap Scan on ofertamasterhotel ofertamasterhotel_1 (cost=237.78..2,251.57 rows=1 width=0) (actual time=3.292..7.693 rows=25 loops=674)

  • Recheck Cond: (sogecodi = om.sogecodi)
  • Filter: ((centcodi > 0) AND (ofmacodi = om.ofmacodi))
  • Rows Removed by Filter: 24457
  • Heap Blocks: exact=1099052
62. 931.468 931.468 ↓ 2.4 24,482 674

Bitmap Index Scan on ofertamasterhotel_pkey (cost=0.00..237.78 rows=10,331 width=0) (actual time=1.382..1.382 rows=24,482 loops=674)

  • Index Cond: (sogecodi = om.sogecodi)
63. 8.088 8,303.680 ↑ 1.0 1 674

Aggregate (cost=1,433.79..1,433.80 rows=1 width=8) (actual time=12.320..12.320 rows=1 loops=674)

64. 8,295.592 8,295.592 ↓ 4.0 4 674

Index Only Scan using ofertasregimenes_pkey on ofertasregimenes (cost=0.42..1,433.78 rows=1 width=0) (actual time=0.922..12.308 rows=4 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofcodi = (oh.ofcodi)::numeric) AND (oftipo = (om.ofmatipo)::text))
  • Heap Fetches: 2992
65. 8.304 5,781.141 ↑ 1.0 1 519

Aggregate (cost=1,433.79..1,433.80 rows=1 width=32) (actual time=11.138..11.139 rows=1 loops=519)

66. 5,772.837 5,772.837 ↓ 3.0 3 519

Index Only Scan using ofertasregimenes_pkey on ofertasregimenes ofertasregimenes_1 (cost=0.42..1,433.78 rows=1 width=4) (actual time=1.164..11.123 rows=3 loops=519)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofcodi = (oh.ofcodi)::numeric) AND (oftipo = (om.ofmatipo)::text))
  • Heap Fetches: 1752
67. 1.905 477.520 ↑ 1.0 1 635

Aggregate (cost=900.36..900.37 rows=1 width=8) (actual time=0.752..0.752 rows=1 loops=635)

68. 69.049 475.615 ↓ 0.0 0 635

Nested Loop (cost=10.51..900.36 rows=1 width=0) (actual time=0.734..0.749 rows=0 loops=635)

69. 179.705 211.455 ↓ 1.0 102 635

Bitmap Heap Scan on tipotarifas tt (cost=10.09..67.66 rows=99 width=8) (actual time=0.074..0.333 rows=102 loops=635)

  • Recheck Cond: (sogecodi = om.sogecodi)
  • Filter: (titaresi = 0)
  • Rows Removed by Filter: 734
  • Heap Blocks: exact=23785
70. 31.750 31.750 ↓ 3.5 836 635

Bitmap Index Scan on tipotarifas_pkey (cost=0.00..10.06 rows=238 width=0) (actual time=0.050..0.050 rows=836 loops=635)

  • Index Cond: (sogecodi = om.sogecodi)
71. 195.111 195.111 ↓ 0.0 0 65,037

Index Only Scan using ofertastipotarifa_pkey on ofertastipotarifa oft (cost=0.43..8.33 rows=1 width=9) (actual time=0.003..0.003 rows=0 loops=65,037)

  • Index Cond: ((sogecodi = om.sogecodi) AND (titacodi = (tt.titacodi)::numeric) AND (ofcodi = (oh.ofcodi)::numeric) AND (oftipo = (om.ofmatipo)::text))
  • Heap Fetches: 217
72. 0.117 30.888 ↑ 1.0 1 39

Aggregate (cost=900.36..900.37 rows=1 width=8) (actual time=0.792..0.792 rows=1 loops=39)

73. 4.680 30.771 ↑ 1.0 1 39

Nested Loop (cost=10.51..900.36 rows=1 width=0) (actual time=0.502..0.789 rows=1 loops=39)

74. 4.095 4.875 ↓ 1.8 181 39

Bitmap Heap Scan on tipotarifas tt_1 (cost=10.09..67.66 rows=99 width=8) (actual time=0.029..0.125 rows=181 loops=39)

  • Recheck Cond: (sogecodi = om.sogecodi)
  • Filter: (titaresi = 0)
  • Rows Removed by Filter: 50
  • Heap Blocks: exact=714
75. 0.780 0.780 ↑ 1.0 231 39

Bitmap Index Scan on tipotarifas_pkey (cost=0.00..10.06 rows=238 width=0) (actual time=0.020..0.020 rows=231 loops=39)

  • Index Cond: (sogecodi = om.sogecodi)
76. 21.216 21.216 ↓ 0.0 0 7,072

Index Only Scan using ofertastipotarifa_pkey on ofertastipotarifa oft_1 (cost=0.43..8.33 rows=1 width=9) (actual time=0.003..0.003 rows=0 loops=7,072)

  • Index Cond: ((sogecodi = om.sogecodi) AND (titacodi = (tt_1.titacodi)::numeric) AND (ofcodi = (oh.ofcodi)::numeric) AND (oftipo = (om.ofmatipo)::text))
  • Heap Fetches: 46
77. 8.088 46.506 ↑ 1.0 1 674

Aggregate (cost=9.83..9.84 rows=1 width=8) (actual time=0.069..0.069 rows=1 loops=674)

78. 12.735 38.418 ↓ 15.0 15 674

Hash Join (cost=8.46..9.82 rows=1 width=0) (actual time=0.047..0.057 rows=15 loops=674)

  • Hash Cond: ((me.merccodi)::numeric = ome.merccodi)
79. 5.463 5.463 ↑ 1.0 18 607

Seq Scan on mercado me (cost=0.00..1.30 rows=18 width=4) (actual time=0.005..0.009 rows=18 loops=607)

  • Filter: (mercficticio = '0'::numeric)
  • Rows Removed by Filter: 6
80. 5.392 20.220 ↓ 15.0 15 674

Hash (cost=8.45..8.45 rows=1 width=5) (actual time=0.030..0.030 rows=15 loops=674)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
81. 14.828 14.828 ↓ 15.0 15 674

Index Only Scan using ofertasmercado_pkey on ofertasmercado ome (cost=0.43..8.45 rows=1 width=5) (actual time=0.016..0.022 rows=15 loops=674)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofcodi = (oh.ofcodi)::numeric) AND (oftipo = (om.ofmatipo)::text))
  • Heap Fetches: 9951
82. 1.408 5.456 ↑ 1.0 1 176

Aggregate (cost=9.83..9.84 rows=1 width=32) (actual time=0.031..0.031 rows=1 loops=176)

83. 1.458 4.048 ↓ 5.0 5 176

Hash Join (cost=8.46..9.82 rows=1 width=4) (actual time=0.018..0.023 rows=5 loops=176)

  • Hash Cond: ((me_1.merccodi)::numeric = ome_1.merccodi)
84. 0.654 0.654 ↑ 1.0 18 109

Seq Scan on mercado me_1 (cost=0.00..1.30 rows=18 width=8) (actual time=0.002..0.006 rows=18 loops=109)

  • Filter: (mercficticio = '0'::numeric)
  • Rows Removed by Filter: 6
85. 0.704 1.936 ↓ 5.0 5 176

Hash (cost=8.45..8.45 rows=1 width=5) (actual time=0.011..0.011 rows=5 loops=176)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
86. 1.232 1.232 ↓ 5.0 5 176

Index Only Scan using ofertasmercado_pkey on ofertasmercado ome_1 (cost=0.43..8.45 rows=1 width=5) (actual time=0.005..0.007 rows=5 loops=176)

  • Index Cond: ((sogecodi = om.sogecodi) AND (ofcodi = (oh.ofcodi)::numeric) AND (oftipo = (om.ofmatipo)::text))
  • Heap Fetches: 944
87. 14.744 120.668 ↑ 1.0 1 388

Aggregate (cost=40.89..40.90 rows=1 width=8) (actual time=0.311..0.311 rows=1 loops=388)

88. 88.852 105.924 ↓ 4.0 455 388

Bitmap Heap Scan on partners (cost=9.74..40.60 rows=115 width=0) (actual time=0.054..0.273 rows=455 loops=388)

  • Recheck Cond: (sogecodi = om.sogecodi)
  • Filter: (partactivo = 1)
  • Rows Removed by Filter: 417
  • Heap Blocks: exact=9544
89. 17.072 17.072 ↓ 4.6 872 388

Bitmap Index Scan on partners_pkey (cost=0.00..9.71 rows=191 width=0) (actual time=0.044..0.044 rows=872 loops=388)

  • Index Cond: (sogecodi = om.sogecodi)
90. 1.164 5.432 ↑ 1.0 1 388

Aggregate (cost=21.02..21.03 rows=1 width=8) (actual time=0.014..0.014 rows=1 loops=388)

91. 4.268 4.268 ↑ 5.0 1 388

Index Only Scan using ofertacanal_pkey on ofertacanal (cost=0.43..21.01 rows=5 width=0) (actual time=0.011..0.011 rows=1 loops=388)