explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h4oH

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,036,514.362 ↓ 298.6 60,315 1

Nested Loop Left Join (cost=699,655.31..724,280.90 rows=202 width=648) (actual time=1,036,185.369..1,036,514.362 rows=60,315 loops=1)

2. 1,036,387.897 1,036,387.897 ↓ 298.6 60,315 1

Merge Left Join (cost=699,655.02..723,829.75 rows=202 width=640) (actual time=1,036,185.309..1,036,387.897 rows=60,315 loops=1)

3. 1,029,997.030 1,029,997.030 ↓ 298.6 60,315 1

Sort (cost=124,924.91..124,925.41 rows=202 width=632) (actual time=1,029,985.202..1,029,997.030 rows=60,315 loops=1)

4. 1,029,890.293 1,029,890.293 ↓ 298.6 60,315 1

Subquery Scan on audit (cost=124,913.13..124,917.17 rows=202 width=632) (actual time=1,029,792.172..1,029,890.293 rows=60,315 loops=1)

5. 1,029,851.672 1,029,851.672 ↓ 298.6 60,315 1

HashAggregate (cost=124,913.13..124,915.15 rows=202 width=632) (actual time=1,029,792.050..1,029,851.672 rows=60,315 loops=1)

6. 1,029,717.695 1,029,717.695 ↓ 298.6 60,315 1

Append (cost=67,267.79..124,889.90 rows=202 width=632) (actual time=516,095.258..1,029,717.695 rows=60,315 loops=1)

7. 516,124.348 516,124.348 ↓ 220.6 44,127 1

Unique (cost=67,267.79..67,299.28 rows=200 width=632) (actual time=516,095.257..516,124.348 rows=44,127 loops=1)

8. 516,098.282 516,098.282 ↓ 164.7 44,127 1

Sort (cost=67,267.79..67,268.46 rows=268 width=632) (actual time=516,095.255..516,098.282 rows=44,127 loops=1)

9. 516,070.213 516,070.213 ↓ 164.7 44,127 1

Unique (cost=67,140.31..67,254.30 rows=268 width=632) (actual time=516,040.030..516,070.213 rows=44,127 loops=1)

10. 516,049.610 516,049.610 ↓ 16.5 44,127 1

Sort (cost=67,140.31..67,147.02 rows=2,682 width=632) (actual time=516,040.027..516,049.610 rows=44,127 loops=1)

11. 515,723.700 515,723.700 ↓ 16.5 44,127 1

Subquery Scan on ci_null (cost=66,933.95..66,987.59 rows=2,682 width=632) (actual time=515,694.310..515,723.700 rows=44,127 loops=1)

12. 515,711.047 515,711.047 ↓ 16.5 44,127 1

HashAggregate (cost=66,933.95..66,960.77 rows=2,682 width=232) (actual time=515,694.305..515,711.047 rows=44,127 loops=1)

13. 515,663.923 515,663.923 ↓ 1.7 44,127 1

Hash Anti Join (cost=64,652.17..65,877.87 rows=26,402 width=232) (actual time=515,633.367..515,663.923 rows=44,127 loops=1)

14. 202.734 202.734 ↓ 1.6 44,127 1

HashAggregate (cost=7,064.63..7,332.84 rows=26,821 width=232) (actual time=184.129..202.734 rows=44,127 loops=1)

15. 153.170 153.170 ↓ 1.6 44,127 1

Append (cost=35.62..5,991.79 rows=26,821 width=232) (actual time=119.783..153.170 rows=44,127 loops=1)

16. 0.746 0.746 ↓ 0.0 0 1

Unique (cost=35.62..36.44 rows=30 width=232) (actual time=0.746..0.746 rows=0 loops=1)

17. 0.745 0.745 ↓ 0.0 0 1

Sort (cost=35.62..35.69 rows=30 width=232) (actual time=0.744..0.745 rows=0 loops=1)

18. 0.729 0.729 ↓ 0.0 0 1

Index Scan using nokia_ca_k2 on nokia_ca (cost=0.29..34.88 rows=30 width=232) (actual time=0.729..0.729 rows=0 loops=1)

19. 147.804 147.804 ↓ 1.6 44,127 1

Subquery Scan on *SELECT* 2 (cost=4,883.26..5,820.94 rows=26,791 width=207) (actual time=119.036..147.804 rows=44,127 loops=1)

20. 139.710 139.710 ↓ 1.6 44,127 1

HashAggregate (cost=4,883.26..5,553.03 rows=26,791 width=207) (actual time=119.033..139.710 rows=44,127 loops=1)

21. 86.014 86.014 ↑ 1.0 44,127 1

Seq Scan on exgce (cost=0.00..3,118.18 rows=44,127 width=207) (actual time=45.097..86.014 rows=44,127 loops=1)

22. 515,449.201 515,449.201 ↓ 0.0 0 1

Hash (cost=57,587.49..57,587.49 rows=2 width=80) (actual time=515,449.201..515,449.201 rows=0 loops=1)

23. 515,448.036 515,448.036 ↓ 8,093.5 16,187 1

Subquery Scan on t (cost=57,587.42..57,587.49 rows=2 width=80) (actual time=515,440.596..515,448.036 rows=16,187 loops=1)

24. 515,445.259 515,445.259 ↓ 8,093.5 16,187 1

Unique (cost=57,587.42..57,587.47 rows=2 width=176) (actual time=515,440.592..515,445.259 rows=16,187 loops=1)

25. 515,441.506 515,441.506 ↓ 8,093.5 16,187 1

Sort (cost=57,587.42..57,587.43 rows=2 width=176) (actual time=515,440.590..515,441.506 rows=16,187 loops=1)

26. 515,432.384 515,432.384 ↓ 8,093.5 16,187 1

Append (cost=14,865.41..57,587.41 rows=2 width=176) (actual time=515,409.222..515,432.384 rows=16,187 loops=1)

27. 298.081 298.081 ↓ 0.0 0 1

Unique (cost=14,865.41..14,865.51 rows=1 width=176) (actual time=298.081..298.081 rows=0 loops=1)

28. 298.080 298.080 ↓ 0.0 0 1

Subquery Scan on audit_externals_tiers_2g_in_nokia_2g (cost=14,865.41..14,865.49 rows=1 width=176) (actual time=298.080..298.080 rows=0 loops=1)

29. 298.080 298.080 ↓ 0.0 0 1

Unique (cost=14,865.41..14,865.48 rows=1 width=586) (actual time=298.080..298.080 rows=0 loops=1)

30. 298.079 298.079 ↓ 0.0 0 1

Sort (cost=14,865.41..14,865.41 rows=1 width=586) (actual time=298.079..298.079 rows=0 loops=1)

31. 298.043 298.043 ↓ 0.0 0 1

Merge Join (cost=14,304.69..14,865.40 rows=1 width=586) (actual time=298.043..298.043 rows=0 loops=1)

32. 256.728 256.728 ↑ 26,821.0 1 1

Sort (cost=9,573.87..9,640.93 rows=26,821 width=232) (actual time=256.727..256.728 rows=1 loops=1)

33. 139.075 139.075 ↓ 1.6 44,127 1

HashAggregate (cost=7,064.63..7,332.84 rows=26,821 width=232) (actual time=121.343..139.075 rows=44,127 loops=1)

34. 90.657 90.657 ↓ 1.6 44,127 1

Append (cost=35.62..5,991.79 rows=26,821 width=232) (actual time=57.494..90.657 rows=44,127 loops=1)

35. 0.038 0.038 ↓ 0.0 0 1

Unique (cost=35.62..36.44 rows=30 width=232) (actual time=0.038..0.038 rows=0 loops=1)

36. 0.038 0.038 ↓ 0.0 0 1

Sort (cost=35.62..35.69 rows=30 width=232) (actual time=0.038..0.038 rows=0 loops=1)

37. 0.024 0.024 ↓ 0.0 0 1

Index Scan using nokia_ca_k2 on nokia_ca nokia_ca_1 (cost=0.29..34.88 rows=30 width=232) (actual time=0.024..0.024 rows=0 loops=1)

38. 86.366 86.366 ↓ 1.6 44,127 1

Subquery Scan on *SELECT* 2_1 (cost=4,883.26..5,820.94 rows=26,791 width=207) (actual time=57.455..86.366 rows=44,127 loops=1)

39. 78.447 78.447 ↓ 1.6 44,127 1

HashAggregate (cost=4,883.26..5,553.03 rows=26,791 width=207) (actual time=57.452..78.447 rows=44,127 loops=1)

40. 25.404 25.404 ↑ 1.0 44,127 1

Seq Scan on exgce exgce_1 (cost=0.00..3,118.18 rows=44,127 width=207) (actual time=0.999..25.404 rows=44,127 loops=1)

41. 41.311 41.311 ↓ 0.0 0 1

Sort (cost=4,730.82..4,757.21 rows=10,559 width=177) (actual time=41.311..41.311 rows=0 loops=1)

42. 41.298 41.298 ↓ 0.0 0 1

HashAggregate (cost=3,444.40..3,919.56 rows=10,559 width=177) (actual time=41.298..41.298 rows=0 loops=1)

43. 41.235 41.235 ↓ 0.0 0 1

Hash Join (cost=2.41..3,048.44 rows=10,559 width=177) (actual time=41.234..41.235 rows=0 loops=1)

44. 39.501 39.501 ↓ 2.3 24,265 1

Hash Join (cost=1.16..2,639.23 rows=10,559 width=26) (actual time=0.032..39.501 rows=24,265 loops=1)

45. 32.350 32.350 ↑ 1.0 58,072 1

Seq Scan on operateurs_tiers cell (cost=0.00..2,426.90 rows=58,072 width=28) (actual time=0.014..32.350 rows=58,072 loops=1)

46. 0.008 0.008 ↑ 1.0 2 1

Hash (cost=1.14..1.14 rows=2 width=4) (actual time=0.007..0.008 rows=2 loops=1)

47. 0.006 0.006 ↑ 1.0 2 1

Seq Scan on ocean_systeme sys (cost=0.00..1.14 rows=2 width=4) (actual time=0.005..0.006 rows=2 loops=1)

48. 0.026 0.026 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=13) (actual time=0.026..0.026 rows=11 loops=1)

49. 0.015 0.015 ↑ 1.0 11 1

Seq Scan on ocean_constructeur cons (cost=0.00..1.11 rows=11 width=13) (actual time=0.013..0.015 rows=11 loops=1)

50. 515,132.985 515,132.985 ↓ 16,187.0 16,187 1

Unique (cost=42,721.74..42,721.87 rows=1 width=176) (actual time=515,111.137..515,132.985 rows=16,187 loops=1)

51. 515,126.656 515,126.656 ↓ 16,188.0 16,188 1

Subquery Scan on audit_externals_sfr_2g_in_nokia_2g (cost=42,721.74..42,721.85 rows=1 width=176) (actual time=515,111.130..515,126.656 rows=16,188 loops=1)

52. 515,123.575 515,123.575 ↓ 16,188.0 16,188 1

Unique (cost=42,721.74..42,721.84 rows=1 width=609) (actual time=515,111.126..515,123.575 rows=16,188 loops=1)

53. 515,112.581 515,112.581 ↓ 16,188.0 16,188 1

Sort (cost=42,721.74..42,721.75 rows=1 width=609) (actual time=515,111.116..515,112.581 rows=16,188 loops=1)

54. 514,959.007 514,959.007 ↓ 16,188.0 16,188 1

Nested Loop (cost=38,301.09..42,721.73 rows=1 width=609) (actual time=1,023.371..514,959.007 rows=16,188 loops=1)

55. 999.241 999.241 ↓ 16,206.0 16,206 1

Merge Join (cost=23,318.57..23,741.70 rows=1 width=432) (actual time=817.440..999.241 rows=16,206 loops=1)

56. 279.423 279.423 ↓ 1.6 43,917 1

Sort (cost=9,573.87..9,640.93 rows=26,821 width=232) (actual time=255.860..279.423 rows=43,917 loops=1)

57. 124.147 124.147 ↓ 1.6 44,127 1

HashAggregate (cost=7,064.63..7,332.84 rows=26,821 width=232) (actual time=102.757..124.147 rows=44,127 loops=1)

58. 76.659 76.659 ↓ 1.6 44,127 1

Append (cost=35.62..5,991.79 rows=26,821 width=232) (actual time=49.099..76.659 rows=44,127 loops=1)

59. 0.028 0.028 ↓ 0.0 0 1

Unique (cost=35.62..36.44 rows=30 width=232) (actual time=0.028..0.028 rows=0 loops=1)

60. 0.027 0.027 ↓ 0.0 0 1

Sort (cost=35.62..35.69 rows=30 width=232) (actual time=0.027..0.027 rows=0 loops=1)

61. 0.023 0.023 ↓ 0.0 0 1

Index Scan using nokia_ca_k2 on nokia_ca nokia_ca_2 (cost=0.29..34.88 rows=30 width=232) (actual time=0.022..0.023 rows=0 loops=1)

62. 73.041 73.041 ↓ 1.6 44,127 1

Subquery Scan on *SELECT* 2_2 (cost=4,883.26..5,820.94 rows=26,791 width=207) (actual time=49.070..73.041 rows=44,127 loops=1)

63. 66.464 66.464 ↓ 1.6 44,127 1

HashAggregate (cost=4,883.26..5,553.03 rows=26,791 width=207) (actual time=49.068..66.464 rows=44,127 loops=1)

64. 22.140 22.140 ↑ 1.0 44,127 1

Seq Scan on exgce exgce_2 (cost=0.00..3,118.18 rows=44,127 width=207) (actual time=0.948..22.140 rows=44,127 loops=1)

65. 588.637 588.637 ↓ 42.4 58,773 1

Sort (cost=13,744.70..13,748.17 rows=1,387 width=200) (actual time=561.552..588.637 rows=58,773 loops=1)

66. 420.050 420.050 ↓ 41.0 56,798 1

HashAggregate (cost=13,644.57..13,658.44 rows=1,387 width=200) (actual time=395.872..420.050 rows=56,798 loops=1)

67. 351.758 351.758 ↓ 41.0 56,798 1

Append (cost=131.13..13,592.56 rows=1,387 width=200) (actual time=8.340..351.758 rows=56,798 loops=1)

68. 8.977 8.977 ↓ 8.3 1,719 1

Unique (cost=131.13..136.85 rows=208 width=177) (actual time=8.339..8.977 rows=1,719 loops=1)

69. 8.460 8.460 ↓ 8.3 1,719 1

Sort (cost=131.13..131.65 rows=208 width=177) (actual time=8.333..8.460 rows=1,719 loops=1)

70. 2.615 2.615 ↓ 8.3 1,719 1

Hash Join (cost=7.39..123.12 rows=208 width=177) (actual time=0.160..2.615 rows=1,719 loops=1)

71. 0.480 0.480 ↑ 1.0 1,725 1

Seq Scan on "Cell_CA" cell_1 (cost=0.00..65.25 rows=1,725 width=53) (actual time=0.020..0.480 rows=1,725 loops=1)

72. 0.107 0.107 ↑ 1.0 196 1

Hash (cost=3.96..3.96 rows=196 width=41) (actual time=0.107..0.107 rows=196 loops=1)

73. 0.049 0.049 ↑ 1.0 196 1

Seq Scan on "RnlAlcatelBSC_CA" bsc (cost=0.00..3.96 rows=196 width=41) (actual time=0.009..0.049 rows=196 loops=1)

74. 154.262 154.262 ↓ 164.2 26,274 1

Unique (cost=6,693.73..6,698.13 rows=160 width=158) (actual time=144.790..154.262 rows=26,274 loops=1)

75. 147.351 147.351 ↓ 164.2 26,274 1

Sort (cost=6,693.73..6,694.13 rows=160 width=158) (actual time=144.789..147.351 rows=26,274 loops=1)

76. 53.372 53.372 ↓ 164.2 26,274 1

Gather (cost=4,587.08..6,687.87 rows=160 width=158) (actual time=30.168..53.372 rows=26,274 loops=1)

77. 85.604 85.604 ↓ 139.8 13,137 2

Parallel Hash Join (cost=3,587.08..5,671.87 rows=94 width=158) (actual time=22.977..42.802 rows=13,137 loops=2)

78. 24.596 24.596 ↑ 1.2 13,137 2

Parallel Seq Scan on nokia_ca cell_2 (cost=0.00..1,923.28 rows=15,382 width=32) (actual time=0.017..12.298 rows=13,137 loops=2)

79. 44.878 44.878 ↑ 1.2 27,911 2

Parallel Hash (cost=2,930.36..2,930.36 rows=32,836 width=38) (actual time=22.439..22.439 rows=27,911 loops=2)

80. 24.978 24.978 ↑ 1.2 27,911 2

Parallel Seq Scan on topologies t_1 (cost=0.00..2,930.36 rows=32,836 width=38) (actual time=0.048..12.489 rows=27,911 loops=2)

81. 174.447 174.447 ↓ 27,827.0 27,827 1

Unique (cost=3,710.36..3,710.39 rows=1 width=163) (actual time=163.839..174.447 rows=27,827 loops=1)

82. 167.126 167.126 ↓ 27,827.0 27,827 1

Sort (cost=3,710.36..3,710.37 rows=1 width=163) (actual time=163.838..167.126 rows=27,827 loops=1)

83. 48.700 48.700 ↓ 27,827.0 27,827 1

Hash Join (cost=1,358.27..3,710.35 rows=1 width=163) (actual time=19.388..48.700 rows=27,827 loops=1)

84. 17.488 17.488 ↓ 1.0 27,827 1

Seq Scan on gcell_ca ca (cost=0.00..1,830.55 rows=27,814 width=20) (actual time=0.023..17.488 rows=27,827 loops=1)

85. 19.330 19.330 ↑ 1.0 27,828 1

Hash (cost=871.28..871.28 rows=27,828 width=45) (actual time=19.330..19.330 rows=27,828 loops=1)

86. 12.281 12.281 ↑ 1.0 27,828 1

Seq Scan on rad_gcell cell_3 (cost=0.00..871.28 rows=27,828 width=45) (actual time=0.011..12.281 rows=27,828 loops=1)

87. 9.223 9.223 ↑ 1.0 978 1

Unique (cost=3,000.93..3,026.38 rows=1,018 width=177) (actual time=8.926..9.223 rows=978 loops=1)

88. 8.980 8.980 ↑ 1.0 978 1

Sort (cost=3,000.93..3,003.48 rows=1,018 width=177) (actual time=8.924..8.980 rows=978 loops=1)

89. 7.222 7.222 ↑ 1.0 978 1

Nested Loop (cost=15.94..2,950.08 rows=1,018 width=177) (actual time=1.629..7.222 rows=978 loops=1)

90. 2.834 2.834 ↓ 1.0 978 1

Nested Loop (cost=15.52..893.41 rows=964 width=33) (actual time=1.568..2.834 rows=978 loops=1)

91. 0.022 0.022 ↑ 1.0 1 1

Seq Scan on ocean_constructeur cons_1 (cost=0.00..1.14 rows=1 width=13) (actual time=0.020..0.022 rows=1 loops=1)

92. 2.678 2.678 ↓ 1.0 978 1

Append (cost=15.52..882.64 rows=964 width=28) (actual time=1.543..2.678 rows=978 loops=1)

93. 2.578 2.578 ↓ 1.0 978 1

Bitmap Heap Scan on cellule2g cell_4 (cost=15.52..877.82 rows=964 width=28) (actual time=1.542..2.578 rows=978 loops=1)

94. 1.510 1.510 ↑ 1.0 978 1

Bitmap Index Scan on cellule2g_ctr_id_idx (cost=0.00..15.28 rows=1,010 width=0) (actual time=1.510..1.510 rows=978 loops=1)

95. 3.912 3.912 ↑ 1.0 1 978

Index Scan using frequence2g_index_unique_1 on ocean_frequence2g f2g (cost=0.42..2.11 rows=1 width=10) (actual time=0.004..0.004 rows=1 loops=978)

96. 389,608.446 389,608.446 ↑ 1.0 71,559 16,206

HashAggregate (cost=14,982.52..16,617.86 rows=72,682 width=177) (actual time=0.013..24.041 rows=71,559 loops=16,206)

97. 151.594 151.594 ↑ 1.0 71,562 1

Hash Join (cost=4,471.22..12,256.94 rows=72,682 width=177) (actual time=63.738..151.594 rows=71,562 loops=1)

98. 133.901 133.901 ↑ 1.0 71,562 1

Hash Join (cost=4,469.98..11,082.88 rows=72,682 width=26) (actual time=63.695..133.901 rows=71,562 loops=1)

99. 38.661 38.661 ↓ 1.0 73,443 1

Seq Scan on ocean_frequence2g f2g_1 (cost=0.00..5,613.52 rows=72,682 width=10) (actual time=0.016..38.661 rows=73,443 loops=1)

100. 63.145 63.145 ↑ 1.0 71,557 1

Hash (cost=3,575.33..3,575.33 rows=71,572 width=28) (actual time=63.145..63.145 rows=71,557 loops=1)

101. 46.332 46.332 ↑ 1.0 71,557 1

Append (cost=0.00..3,575.33 rows=71,572 width=28) (actual time=0.020..46.332 rows=71,557 loops=1)

102. 40.532 40.532 ↑ 1.0 71,557 1

Seq Scan on cellule2g cell_5 (cost=0.00..3,217.47 rows=71,572 width=28) (actual time=0.018..40.532 rows=71,557 loops=1)

103. 0.022 0.022 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=13) (actual time=0.022..0.022 rows=11 loops=1)

104. 0.017 0.017 ↑ 1.0 11 1

Seq Scan on ocean_constructeur cons_2 (cost=0.00..1.11 rows=11 width=13) (actual time=0.015..0.017 rows=11 loops=1)

105. 513,324.135 513,324.135 ↓ 16,188.0 16,188 1

Unique (cost=42,721.86..42,721.98 rows=1 width=609) (actual time=513,315.806..513,324.135 rows=16,188 loops=1)

106. 513,316.749 513,316.749 ↓ 16,188.0 16,188 1

Sort (cost=42,721.86..42,721.86 rows=1 width=609) (actual time=513,315.804..513,316.749 rows=16,188 loops=1)

107. 513,306.378 513,306.378 ↓ 16,188.0 16,188 1

Unique (cost=42,721.74..42,721.84 rows=1 width=609) (actual time=513,293.803..513,306.378 rows=16,188 loops=1)

108. 513,294.906 513,294.906 ↓ 16,188.0 16,188 1

Sort (cost=42,721.74..42,721.75 rows=1 width=609) (actual time=513,293.789..513,294.906 rows=16,188 loops=1)

109. 513,137.392 513,137.392 ↓ 16,188.0 16,188 1

Nested Loop (cost=38,301.09..42,721.73 rows=1 width=609) (actual time=1,464.089..513,137.392 rows=16,188 loops=1)

110. 1,224.155 1,224.155 ↓ 16,206.0 16,206 1

Merge Join (cost=23,318.57..23,741.70 rows=1 width=432) (actual time=1,057.923..1,224.155 rows=16,206 loops=1)

111. 261.294 261.294 ↓ 1.6 43,917 1

Sort (cost=9,573.87..9,640.93 rows=26,821 width=232) (actual time=239.984..261.294 rows=43,917 loops=1)

112. 129.339 129.339 ↓ 1.6 44,127 1

HashAggregate (cost=7,064.63..7,332.84 rows=26,821 width=232) (actual time=113.415..129.339 rows=44,127 loops=1)

113. 85.764 85.764 ↓ 1.6 44,127 1

Append (cost=35.62..5,991.79 rows=26,821 width=232) (actual time=52.846..85.764 rows=44,127 loops=1)

114. 0.034 0.034 ↓ 0.0 0 1

Unique (cost=35.62..36.44 rows=30 width=232) (actual time=0.034..0.034 rows=0 loops=1)

115. 0.033 0.033 ↓ 0.0 0 1

Sort (cost=35.62..35.69 rows=30 width=232) (actual time=0.033..0.033 rows=0 loops=1)

116. 0.027 0.027 ↓ 0.0 0 1

Index Scan using nokia_ca_k2 on nokia_ca nokia_ca_3 (cost=0.29..34.88 rows=30 width=232) (actual time=0.027..0.027 rows=0 loops=1)

117. 82.176 82.176 ↓ 1.6 44,127 1

Subquery Scan on *SELECT* 2_3 (cost=4,883.26..5,820.94 rows=26,791 width=207) (actual time=52.810..82.176 rows=44,127 loops=1)

118. 75.475 75.475 ↓ 1.6 44,127 1

HashAggregate (cost=4,883.26..5,553.03 rows=26,791 width=207) (actual time=52.807..75.475 rows=44,127 loops=1)

119. 24.762 24.762 ↑ 1.0 44,127 1

Seq Scan on exgce exgce_3 (cost=0.00..3,118.18 rows=44,127 width=207) (actual time=1.378..24.762 rows=44,127 loops=1)

120. 846.965 846.965 ↓ 42.4 58,773 1

Sort (cost=13,744.70..13,748.17 rows=1,387 width=200) (actual time=817.896..846.965 rows=58,773 loops=1)

121. 622.847 622.847 ↓ 41.0 56,798 1

HashAggregate (cost=13,644.57..13,658.44 rows=1,387 width=200) (actual time=585.653..622.847 rows=56,798 loops=1)

122. 539.457 539.457 ↓ 41.0 56,798 1

Append (cost=131.13..13,592.56 rows=1,387 width=200) (actual time=16.008..539.457 rows=56,798 loops=1)

123. 16.980 16.980 ↓ 8.3 1,719 1

Unique (cost=131.13..136.85 rows=208 width=177) (actual time=16.006..16.980 rows=1,719 loops=1)

124. 16.182 16.182 ↓ 8.3 1,719 1

Sort (cost=131.13..131.65 rows=208 width=177) (actual time=16.004..16.182 rows=1,719 loops=1)

125. 6.975 6.975 ↓ 8.3 1,719 1

Hash Join (cost=7.39..123.12 rows=208 width=177) (actual time=1.592..6.975 rows=1,719 loops=1)

126. 3.384 3.384 ↑ 1.0 1,725 1

Seq Scan on "Cell_CA" cell_6 (cost=0.00..65.25 rows=1,725 width=53) (actual time=1.331..3.384 rows=1,725 loops=1)

127. 0.208 0.208 ↑ 1.0 196 1

Hash (cost=3.96..3.96 rows=196 width=41) (actual time=0.208..0.208 rows=196 loops=1)

128. 0.109 0.109 ↑ 1.0 196 1

Seq Scan on "RnlAlcatelBSC_CA" bsc_1 (cost=0.00..3.96 rows=196 width=41) (actual time=0.017..0.109 rows=196 loops=1)

129. 231.867 231.867 ↓ 164.2 26,274 1

Unique (cost=6,693.73..6,698.13 rows=160 width=158) (actual time=220.148..231.867 rows=26,274 loops=1)

130. 223.879 223.879 ↓ 164.2 26,274 1

Sort (cost=6,693.73..6,694.13 rows=160 width=158) (actual time=220.144..223.879 rows=26,274 loops=1)

131. 119.764 119.764 ↓ 164.2 26,274 1

Gather (cost=4,587.08..6,687.87 rows=160 width=158) (actual time=38.142..119.764 rows=26,274 loops=1)

132. 221.490 221.490 ↓ 139.8 13,137 2

Parallel Hash Join (cost=3,587.08..5,671.87 rows=94 width=158) (actual time=31.327..110.745 rows=13,137 loops=2)

133. 137.432 137.432 ↑ 1.2 13,137 2

Parallel Seq Scan on nokia_ca cell_7 (cost=0.00..1,923.28 rows=15,382 width=32) (actual time=0.679..68.716 rows=13,137 loops=2)

134. 59.958 59.958 ↑ 1.2 27,911 2

Parallel Hash (cost=2,930.36..2,930.36 rows=32,836 width=38) (actual time=29.979..29.979 rows=27,911 loops=2)

135. 31.362 31.362 ↑ 1.2 27,911 2

Parallel Seq Scan on topologies t_2 (cost=0.00..2,930.36 rows=32,836 width=38) (actual time=0.031..15.681 rows=27,911 loops=2)

136. 267.141 267.141 ↓ 27,827.0 27,827 1

Unique (cost=3,710.36..3,710.39 rows=1 width=163) (actual time=252.041..267.141 rows=27,827 loops=1)

137. 257.462 257.462 ↓ 27,827.0 27,827 1

Sort (cost=3,710.36..3,710.37 rows=1 width=163) (actual time=252.039..257.462 rows=27,827 loops=1)

138. 128.959 128.959 ↓ 27,827.0 27,827 1

Hash Join (cost=1,358.27..3,710.35 rows=1 width=163) (actual time=68.925..128.959 rows=27,827 loops=1)

139. 43.905 43.905 ↓ 1.0 27,827 1

Seq Scan on gcell_ca ca_1 (cost=0.00..1,830.55 rows=27,814 width=20) (actual time=1.315..43.905 rows=27,827 loops=1)

140. 67.542 67.542 ↑ 1.0 27,828 1

Hash (cost=871.28..871.28 rows=27,828 width=45) (actual time=67.542..67.542 rows=27,828 loops=1)

141. 58.100 58.100 ↑ 1.0 27,828 1

Seq Scan on rad_gcell cell_8 (cost=0.00..871.28 rows=27,828 width=45) (actual time=1.300..58.100 rows=27,828 loops=1)

142. 18.546 18.546 ↑ 1.0 978 1

Unique (cost=3,000.93..3,026.38 rows=1,018 width=177) (actual time=18.246..18.546 rows=978 loops=1)

143. 18.301 18.301 ↑ 1.0 978 1

Sort (cost=3,000.93..3,003.48 rows=1,018 width=177) (actual time=18.244..18.301 rows=978 loops=1)

144. 16.456 16.456 ↑ 1.0 978 1

Nested Loop (cost=15.94..2,950.08 rows=1,018 width=177) (actual time=3.061..16.456 rows=978 loops=1)

145. 4.141 4.141 ↓ 1.0 978 1

Nested Loop (cost=15.52..893.41 rows=964 width=33) (actual time=3.028..4.141 rows=978 loops=1)

146. 0.025 0.025 ↑ 1.0 1 1

Seq Scan on ocean_constructeur cons_3 (cost=0.00..1.14 rows=1 width=13) (actual time=0.021..0.025 rows=1 loops=1)

147. 3.973 3.973 ↓ 1.0 978 1

Append (cost=15.52..882.64 rows=964 width=28) (actual time=2.992..3.973 rows=978 loops=1)

148. 3.877 3.877 ↓ 1.0 978 1

Bitmap Heap Scan on cellule2g cell_9 (cost=15.52..877.82 rows=964 width=28) (actual time=2.992..3.877 rows=978 loops=1)

149. 2.961 2.961 ↑ 1.0 978 1

Bitmap Index Scan on cellule2g_ctr_id_idx (cost=0.00..15.28 rows=1,010 width=0) (actual time=2.961..2.961 rows=978 loops=1)

150. 11.736 11.736 ↑ 1.0 1 978

Index Scan using frequence2g_index_unique_1 on ocean_frequence2g f2g_2 (cost=0.42..2.11 rows=1 width=10) (actual time=0.012..0.012 rows=1 loops=978)

151. 387,582.696 387,582.696 ↑ 1.0 71,559 16,206

HashAggregate (cost=14,982.52..16,617.86 rows=72,682 width=177) (actual time=0.025..23.916 rows=71,559 loops=16,206)

152. 341.892 341.892 ↑ 1.0 71,562 1

Hash Join (cost=4,471.22..12,256.94 rows=72,682 width=177) (actual time=72.588..341.892 rows=71,562 loops=1)

153. 322.347 322.347 ↑ 1.0 71,562 1

Hash Join (cost=4,469.98..11,082.88 rows=72,682 width=26) (actual time=72.530..322.347 rows=71,562 loops=1)

154. 206.656 206.656 ↓ 1.0 73,443 1

Seq Scan on ocean_frequence2g f2g_3 (cost=0.00..5,613.52 rows=72,682 width=10) (actual time=1.524..206.656 rows=73,443 loops=1)

155. 70.269 70.269 ↑ 1.0 71,557 1

Hash (cost=3,575.33..3,575.33 rows=71,572 width=28) (actual time=70.269..70.269 rows=71,557 loops=1)

156. 48.796 48.796 ↑ 1.0 71,557 1

Append (cost=0.00..3,575.33 rows=71,572 width=28) (actual time=0.019..48.796 rows=71,557 loops=1)

157. 41.958 41.958 ↑ 1.0 71,557 1

Seq Scan on cellule2g cell_10 (cost=0.00..3,217.47 rows=71,572 width=28) (actual time=0.018..41.958 rows=71,557 loops=1)

158. 0.031 0.031 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=13) (actual time=0.031..0.031 rows=11 loops=1)

159. 0.023 0.023 ↑ 1.0 11 1

Seq Scan on ocean_constructeur cons_4 (cost=0.00..1.11 rows=11 width=13) (actual time=0.020..0.023 rows=11 loops=1)

160. 264.037 264.037 ↓ 0.0 0 1

Unique (cost=14,865.50..14,865.62 rows=1 width=586) (actual time=264.037..264.037 rows=0 loops=1)

161. 264.036 264.036 ↓ 0.0 0 1

Sort (cost=14,865.50..14,865.50 rows=1 width=586) (actual time=264.036..264.036 rows=0 loops=1)

162. 264.004 264.004 ↓ 0.0 0 1

Unique (cost=14,865.41..14,865.48 rows=1 width=586) (actual time=264.004..264.004 rows=0 loops=1)

163. 264.003 264.003 ↓ 0.0 0 1

Sort (cost=14,865.41..14,865.41 rows=1 width=586) (actual time=264.003..264.003 rows=0 loops=1)

164. 263.994 263.994 ↓ 0.0 0 1

Merge Join (cost=14,304.69..14,865.40 rows=1 width=586) (actual time=263.994..263.994 rows=0 loops=1)

165. 227.295 227.295 ↑ 26,821.0 1 1

Sort (cost=9,573.87..9,640.93 rows=26,821 width=232) (actual time=227.295..227.295 rows=1 loops=1)

166. 119.026 119.026 ↓ 1.6 44,127 1

HashAggregate (cost=7,064.63..7,332.84 rows=26,821 width=232) (actual time=103.930..119.026 rows=44,127 loops=1)

167. 77.792 77.792 ↓ 1.6 44,127 1

Append (cost=35.62..5,991.79 rows=26,821 width=232) (actual time=49.870..77.792 rows=44,127 loops=1)

168. 0.079 0.079 ↓ 0.0 0 1

Unique (cost=35.62..36.44 rows=30 width=232) (actual time=0.079..0.079 rows=0 loops=1)

169. 0.079 0.079 ↓ 0.0 0 1

Sort (cost=35.62..35.69 rows=30 width=232) (actual time=0.079..0.079 rows=0 loops=1)

170. 0.074 0.074 ↓ 0.0 0 1

Index Scan using nokia_ca_k2 on nokia_ca nokia_ca_4 (cost=0.29..34.88 rows=30 width=232) (actual time=0.074..0.074 rows=0 loops=1)

171. 74.182 74.182 ↓ 1.6 44,127 1

Subquery Scan on *SELECT* 2_4 (cost=4,883.26..5,820.94 rows=26,791 width=207) (actual time=49.789..74.182 rows=44,127 loops=1)

172. 67.554 67.554 ↓ 1.6 44,127 1

HashAggregate (cost=4,883.26..5,553.03 rows=26,791 width=207) (actual time=49.787..67.554 rows=44,127 loops=1)

173. 23.117 23.117 ↑ 1.0 44,127 1

Seq Scan on exgce exgce_4 (cost=0.00..3,118.18 rows=44,127 width=207) (actual time=1.098..23.117 rows=44,127 loops=1)

174. 36.679 36.679 ↓ 0.0 0 1

Sort (cost=4,730.82..4,757.21 rows=10,559 width=177) (actual time=36.679..36.679 rows=0 loops=1)

175. 36.663 36.663 ↓ 0.0 0 1

HashAggregate (cost=3,444.40..3,919.56 rows=10,559 width=177) (actual time=36.663..36.663 rows=0 loops=1)

176. 36.602 36.602 ↓ 0.0 0 1

Hash Join (cost=2.41..3,048.44 rows=10,559 width=177) (actual time=36.602..36.602 rows=0 loops=1)

177. 34.795 34.795 ↓ 2.3 24,265 1

Hash Join (cost=1.16..2,639.23 rows=10,559 width=26) (actual time=0.041..34.795 rows=24,265 loops=1)

178. 27.576 27.576 ↑ 1.0 58,072 1

Seq Scan on operateurs_tiers cell_11 (cost=0.00..2,426.90 rows=58,072 width=28) (actual time=0.011..27.576 rows=58,072 loops=1)

179. 0.009 0.009 ↑ 1.0 2 1

Hash (cost=1.14..1.14 rows=2 width=4) (actual time=0.009..0.009 rows=2 loops=1)

180. 0.007 0.007 ↑ 1.0 2 1

Seq Scan on ocean_systeme sys_1 (cost=0.00..1.14 rows=2 width=4) (actual time=0.006..0.007 rows=2 loops=1)

181. 0.034 0.034 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=13) (actual time=0.033..0.034 rows=11 loops=1)

182. 0.023 0.023 ↑ 1.0 11 1

Seq Scan on ocean_constructeur cons_5 (cost=0.00..1.11 rows=11 width=13) (actual time=0.021..0.023 rows=11 loops=1)

183. 6,263.520 6,263.520 ↑ 3.3 365,614 1

Sort (cost=574,730.11..577,751.44 rows=1,208,534 width=27) (actual time=6,199.973..6,263.520 rows=365,614 loops=1)

184. 5,763.251 5,763.251 ↑ 3.2 382,201 1

Subquery Scan on ho (cost=428,468.33..452,639.01 rows=1,208,534 width=27) (actual time=5,490.374..5,763.251 rows=382,201 loops=1)

185. 5,626.248 5,626.248 ↑ 3.2 382,201 1

HashAggregate (cost=428,468.33..440,553.67 rows=1,208,534 width=27) (actual time=5,490.365..5,626.248 rows=382,201 loops=1)

186. 1,707.979 1,707.979 ↑ 1.0 12,085,339 1

Index Only Scan using oasis_full_k1 on oasis_full (cost=0.56..247,188.24 rows=12,085,339 width=19) (actual time=0.037..1,707.979 rows=12,085,339 loops=1)

187. 120.630 120.630 ↓ 0.0 0 60,315

Index Scan using topologies_k1 on topologies topo (cost=0.29..2.22 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=60,315)