explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yD5D : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #XQWu; plan #8YqG; plan #8hDi; plan #WFOh; plan #gfk1; plan #L8Wp; plan #2iGh

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.321 ↓ 3.0 3 1

Unique (cost=75,897.89..75,897.90 rows=1 width=749) (actual time=0.320..0.321 rows=3 loops=1)

2. 0.006 0.320 ↓ 3.0 3 1

Sort (cost=75,897.89..75,897.89 rows=1 width=749) (actual time=0.320..0.320 rows=3 loops=1)

  • Sort Key: all_svc.svcprovider_id, all_svc.arrival
  • Sort Method: quicksort Memory: 25kB
3. 0.002 0.314 ↓ 3.0 3 1

Subquery Scan on all_svc (cost=75,888.92..75,897.88 rows=1 width=749) (actual time=0.311..0.314 rows=3 loops=1)

  • Filter: (NOT (SubPlan 1))
4. 0.001 0.306 ↓ 1.5 3 1

Unique (cost=75,888.92..75,889.07 rows=2 width=160) (actual time=0.305..0.306 rows=3 loops=1)

5. 0.020 0.305 ↓ 1.5 3 1

Sort (cost=75,888.92..75,888.93 rows=2 width=160) (actual time=0.305..0.305 rows=3 loops=1)

  • Sort Key: (1), (CASE WHEN ((ap.svctype = 'Fuel'::text) AND ("substring"(ap.svcprovider_id, 1, 3) <> '666'::text)) THEN (SubPlan 228) ELSE (ap.svcprovider_id)::bigint END), (replace(ap.svctype, ' (other)'::text, ''::text)), ('Requi (...)
  • Sort Method: quicksort Memory: 25kB
6. 0.001 0.285 ↓ 1.5 3 1

Append (cost=41.52..75,888.91 rows=2 width=160) (actual time=0.080..0.285 rows=3 loops=1)

7. 0.120 0.172 ↓ 2.0 2 1

Seq Scan on aircraftprefs ap (cost=41.52..37,944.45 rows=1 width=160) (actual time=0.079..0.172 rows=2 loops=1)

  • Filter: ((deletedflag IS NOT TRUE) AND (svcprovider_id IS NOT NULL) AND (svcprovider_id <> '-1'::text) AND (ac_id = 96) AND (acconfig_id = 77) AND ((legtype = (-1)) OR (legtype = 1)) AND ((commercial = 0) OR (commercia (...)
  • Rows Removed by Filter: 8
8.          

Initplan (forSeq Scan)

9. 0.004 0.004 ↑ 1.0 1 1

Index Scan using aptidentifier_idx on airport airport_5 (cost=0.29..8.30 rows=1 width=5) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (identifier = 'AU25150'::text)
10. 0.004 0.004 ↑ 1.0 1 1

Index Scan using aptidentifier_idx on airport airport_6 (cost=0.29..8.30 rows=1 width=5) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (identifier = 'AU25150'::text)
11. 0.003 0.003 ↑ 1.0 1 1

Index Scan using aptidentifier_idx on airport airport_7 (cost=0.29..8.30 rows=1 width=5) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (identifier = 'AU25150'::text)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using aptidentifier_idx on airport airport_8 (cost=0.29..8.30 rows=1 width=5) (never executed)

  • Index Cond: (identifier = 'RS30325'::text)
13. 0.009 0.009 ↑ 1.0 1 1

Index Scan using aptidentifier_idx on airport airport_9 (cost=0.29..8.30 rows=1 width=5) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (identifier = 'AU25150'::text)
14.          

SubPlan (forSeq Scan)

15. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aptservices_2 (cost=37,526.32..37,526.33 rows=1 width=8) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Sort (cost=37,526.32..37,526.32 rows=1 width=681) (never executed)

  • Sort Key: (CASE WHEN aptservices_3.isprimary THEN 1 WHEN (aptservices_3.isprimary IS NULL) THEN 2 ELSE 2 END)
17. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aptservices_3 (cost=2,458.71..37,526.31 rows=1 width=681) (never executed)

  • Filter: ((aptservices_3.svctype = 'Fuel'::text) AND (aptservices_3.name = split_part(ap.svcprovider_id, '^'::text, 2)) AND ((aptservices_3.icao)::text = split_part(ap.svcprovider_id, '^'::text, 1)))
18. 0.000 0.000 ↓ 0.0 0

Append (cost=2,458.71..33,538.81 rows=159,500 width=218) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,458.71..4,186.34 rows=13,156 width=206) (never executed)

  • Hash Cond: (f_1.aptidentifier = a_6.identifier)
20.          

Initplan (forHash Left Join)

21. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Seq Scan on aptfbo f_1 (cost=0.00..691.60 rows=13,156 width=201) (never executed)

  • Filter: (NOT deletedflag)
25. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,086.08..2,086.08 rows=29,808 width=14) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Seq Scan on airport a_6 (cost=0.00..2,086.08 rows=29,808 width=14) (never executed)

27.          

SubPlan (forHash Left Join)

28. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.03 rows=1 width=0) (never executed)

29. 0.000 0.000 ↓ 0.0 0

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

30. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,458.76..9,717.87 rows=57,759 width=247) (never executed)

  • Hash Cond: (h_1.aptidentifier = a_7.identifier)
31.          

Initplan (forHash Left Join)

32. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

33. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

36. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

40. 0.000 0.000 ↓ 0.0 0

Seq Scan on apthotel h_1 (cost=0.00..2,710.59 rows=57,759 width=242) (never executed)

  • Filter: (NOT deletedflag)
41. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,086.08..2,086.08 rows=29,808 width=14) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Seq Scan on airport a_7 (cost=0.00..2,086.08 rows=29,808 width=14) (never executed)

43.          

SubPlan (forHash Left Join)

44. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.03 rows=1 width=0) (never executed)

45. 0.000 0.000 ↓ 0.0 0

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

46. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,458.80..4,739.80 rows=20,991 width=188) (never executed)

  • Hash Cond: (t_1.aptidentifier = a_8.identifier)
47.          

Initplan (forHash Left Join)

48. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

49. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

50. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

51. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

52. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

59. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

60. 0.000 0.000 ↓ 0.0 0

Seq Scan on apttransport t_1 (cost=0.00..732.91 rows=20,991 width=183) (never executed)

  • Filter: (NOT deletedflag)
61. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,086.08..2,086.08 rows=29,808 width=14) (never executed)

62. 0.000 0.000 ↓ 0.0 0

Seq Scan on airport a_8 (cost=0.00..2,086.08 rows=29,808 width=14) (never executed)

63.          

SubPlan (forHash Left Join)

64. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.03 rows=1 width=0) (never executed)

65. 0.000 0.000 ↓ 0.0 0

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

66. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,458.80..2,733.47 rows=2,599 width=179) (never executed)

  • Hash Cond: (c_1.aptidentifier = a_9.identifier)
67.          

Initplan (forHash Left Join)

68. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

71. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

72. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

76. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

78. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Seq Scan on aptcatering c_1 (cost=0.00..82.99 rows=2,599 width=174) (never executed)

  • Filter: (NOT deletedflag)
81. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,086.08..2,086.08 rows=29,808 width=14) (never executed)

82. 0.000 0.000 ↓ 0.0 0

Seq Scan on airport a_9 (cost=0.00..2,086.08 rows=29,808 width=14) (never executed)

83.          

SubPlan (forHash Left Join)

84. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.03 rows=1 width=0) (never executed)

85. 0.000 0.000 ↓ 0.0 0

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

86. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 5_1 (cost=27.81..5,334.14 rows=36,527 width=189) (never executed)

87. 0.000 0.000 ↓ 0.0 0

WindowAgg (cost=27.81..4,968.87 rows=36,527 width=189) (never executed)

88.          

Initplan (forWindowAgg)

89. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

90. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

92. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

94. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

97. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

98. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

99. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

100. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

101. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=27.68..2,777.11 rows=36,527 width=189) (never executed)

  • Hash Cond: ((a_10.icao)::text = fu_1.icao)
103. 0.000 0.000 ↓ 0.0 0

Seq Scan on airport a_10 (cost=0.00..2,086.08 rows=29,808 width=14) (never executed)

104. 0.000 0.000 ↓ 0.0 0

Hash (cost=22.86..22.86 rows=386 width=180) (never executed)

105. 0.000 0.000 ↓ 0.0 0

Seq Scan on aptfuel fu_1 (cost=0.00..22.86 rows=386 width=180) (never executed)

  • Filter: (NOT deletedflag)
106.          

SubPlan (forWindowAgg)

107. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.03 rows=1 width=0) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,458.76..5,597.47 rows=28,468 width=226) (never executed)

  • Hash Cond: (s_1.aptidentifier = a_11.identifier)
109.          

Initplan (forHash Left Join)

110. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

111. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

112. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

114. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

115. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

117. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

118. 0.000 0.000 ↓ 0.0 0

Seq Scan on aptotherservice s_1 (cost=0.00..825.68 rows=28,468 width=221) (never executed)

  • Filter: (NOT deletedflag)
119. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,086.08..2,086.08 rows=29,808 width=14) (never executed)

120. 0.000 0.000 ↓ 0.0 0

Seq Scan on airport a_11 (cost=0.00..2,086.08 rows=29,808 width=14) (never executed)

121.          

SubPlan (forHash Left Join)

122. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.03 rows=1 width=0) (never executed)

123. 0.000 0.000 ↓ 0.0 0

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

124. 0.004 0.005 ↑ 1.0 1 1

Index Scan using aptfbo_pkey on aptfbo aptfbo_14 (cost=0.30..8.32 rows=1 width=19) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (aptfbo_id = ($256)::integer)
125.          

Initplan (forIndex Scan)

126. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

127. 0.000 0.000 ↓ 0.0 0

Index Scan using aptcatering_pkey on aptcatering aptcatering_5 (cost=0.30..8.32 rows=1 width=15) (never executed)

  • Index Cond: (aptcatering_id = ($258)::integer)
128.          

Initplan (forIndex Scan)

129. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

130. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=7) (never executed)

131. 0.000 0.000 ↓ 0.0 0

Index Scan using fuel_icao_idx on aptfuel aptfuel_4 (cost=0.28..8.30 rows=1 width=7) (never executed)

  • Index Cond: (icao = split_part(ap.svcprovider_id, '^'::text, 1))
  • Filter: (contractor = split_part(ap.svcprovider_id, '^'::text, 2))
132. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_8 (cost=0.31..8.33 rows=1 width=26) (never executed)

  • Index Cond: (apthotel_id = ($261)::integer)
133.          

Initplan (forIndex Scan)

134. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Index Scan using apttransport_pkey on apttransport apttransport_5 (cost=0.31..8.33 rows=1 width=24) (never executed)

  • Index Cond: (apttransport_id = ($263)::integer)
136.          

Initplan (forIndex Scan)

137. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

138. 0.003 0.004 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_9 (cost=0.31..8.33 rows=1 width=21) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (aptother_id = ($265)::integer)
139.          

Initplan (forIndex Scan)

140. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

141. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptfbo_pkey on aptfbo aptfbo_15 (cost=0.30..8.32 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptfbo_id = ($267)::integer)
142.          

Initplan (forIndex Scan)

143. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

144. 0.000 0.000 ↓ 0.0 0

Index Scan using aptcatering_pkey on aptcatering aptcatering_6 (cost=0.30..8.32 rows=1 width=7) (never executed)

  • Index Cond: (aptcatering_id = ($269)::integer)
145.          

Initplan (forIndex Scan)

146. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

147. 0.000 0.000 ↓ 0.0 0

Index Scan using apttransport_pkey on apttransport apttransport_6 (cost=0.31..8.33 rows=1 width=12) (never executed)

  • Index Cond: (apttransport_id = ($271)::integer)
148.          

Initplan (forIndex Scan)

149. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

150. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptfbo_pkey on aptfbo aptfbo_16 (cost=0.30..8.32 rows=1 width=13) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptfbo_id = ($273)::integer)
151.          

Initplan (forIndex Scan)

152. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

153. 0.000 0.000 ↓ 0.0 0

Index Scan using aptcatering_pkey on aptcatering aptcatering_7 (cost=0.30..8.32 rows=1 width=13) (never executed)

  • Index Cond: (aptcatering_id = ($275)::integer)
154.          

Initplan (forIndex Scan)

155. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

156. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=17) (never executed)

157. 0.000 0.000 ↓ 0.0 0

Index Scan using fuel_icao_idx on aptfuel aptfuel_5 (cost=0.28..8.30 rows=1 width=17) (never executed)

  • Index Cond: (icao = split_part(ap.svcprovider_id, '^'::text, 1))
  • Filter: (contractor = split_part(ap.svcprovider_id, '^'::text, 2))
158. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_9 (cost=0.31..8.33 rows=1 width=13) (never executed)

  • Index Cond: (apthotel_id = ($278)::integer)
159.          

Initplan (forIndex Scan)

160. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

161. 0.000 0.000 ↓ 0.0 0

Index Scan using apttransport_pkey on apttransport apttransport_7 (cost=0.31..8.33 rows=1 width=11) (never executed)

  • Index Cond: (apttransport_id = ($280)::integer)
162.          

Initplan (forIndex Scan)

163. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

164. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_10 (cost=0.31..8.33 rows=1 width=14) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($282)::integer)
165.          

Initplan (forIndex Scan)

166. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

167. 0.001 0.001 ↑ 1.0 1 1

Index Scan using aptfbo_pkey on aptfbo aptfbo_17 (cost=0.30..8.32 rows=1 width=11) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptfbo_id = ($284)::integer)
168.          

Initplan (forIndex Scan)

169. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=1)

170. 0.000 0.000 ↓ 0.0 0

Index Scan using aptcatering_pkey on aptcatering aptcatering_8 (cost=0.30..8.32 rows=1 width=10) (never executed)

  • Index Cond: (aptcatering_id = ($286)::integer)
171.          

Initplan (forIndex Scan)

172. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

173. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_10 (cost=0.31..8.33 rows=1 width=12) (never executed)

  • Index Cond: (apthotel_id = ($288)::integer)
174.          

Initplan (forIndex Scan)

175. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

176. 0.000 0.000 ↓ 0.0 0

Index Scan using apttransport_pkey on apttransport apttransport_8 (cost=0.31..8.33 rows=1 width=6) (never executed)

  • Index Cond: (apttransport_id = ($290)::integer)
177.          

Initplan (forIndex Scan)

178. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

179. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_11 (cost=0.31..8.33 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($292)::integer)
180.          

Initplan (forIndex Scan)

181. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

182. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptfbo_pkey on aptfbo aptfbo_18 (cost=0.30..8.32 rows=1 width=9) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptfbo_id = ($294)::integer)
183.          

Initplan (forIndex Scan)

184. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

185. 0.000 0.000 ↓ 0.0 0

Index Scan using aptcatering_pkey on aptcatering aptcatering_9 (cost=0.30..8.32 rows=1 width=19) (never executed)

  • Index Cond: (aptcatering_id = ($296)::integer)
186.          

Initplan (forIndex Scan)

187. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

188. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_11 (cost=0.31..8.33 rows=1 width=16) (never executed)

  • Index Cond: (apthotel_id = ($298)::integer)
189.          

Initplan (forIndex Scan)

190. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

191. 0.000 0.000 ↓ 0.0 0

Index Scan using apttransport_pkey on apttransport apttransport_9 (cost=0.31..8.33 rows=1 width=20) (never executed)

  • Index Cond: (apttransport_id = ($300)::integer)
192.          

Initplan (forIndex Scan)

193. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

194. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_12 (cost=0.31..8.33 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($302)::integer)
195.          

Initplan (forIndex Scan)

196. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

197. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptfbo_pkey on aptfbo aptfbo_19 (cost=0.30..8.32 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptfbo_id = ($304)::integer)
198.          

Initplan (forIndex Scan)

199. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

200. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_13 (cost=0.31..8.33 rows=1 width=29) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($306)::integer)
201.          

Initplan (forIndex Scan)

202. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

203. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptfbo_pkey on aptfbo aptfbo_20 (cost=0.30..8.32 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptfbo_id = ($308)::integer)
204.          

Initplan (forIndex Scan)

205. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

206. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptfbo_pkey on aptfbo aptfbo_21 (cost=0.30..8.32 rows=1 width=2) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptfbo_id = ($310)::integer)
207.          

Initplan (forIndex Scan)

208. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

209. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptfbo_pkey on aptfbo aptfbo_22 (cost=0.30..8.32 rows=1 width=2) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptfbo_id = ($312)::integer)
210.          

Initplan (forIndex Scan)

211. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

212. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptfbo_pkey on aptfbo aptfbo_23 (cost=0.30..8.32 rows=1 width=3) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptfbo_id = ($314)::integer)
213.          

Initplan (forIndex Scan)

214. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

215. 0.001 0.002 ↑ 1.0 1 1

Index Scan using aptfbo_pkey on aptfbo aptfbo_24 (cost=0.30..8.33 rows=1 width=10) (actual time=0.001..0.002 rows=1 loops=1)

  • Index Cond: (aptfbo_id = ($316)::integer)
216.          

Initplan (forIndex Scan)

217. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

218. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_12 (cost=0.31..8.33 rows=1 width=23) (never executed)

  • Index Cond: (apthotel_id = ($318)::integer)
219.          

Initplan (forIndex Scan)

220. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

221. 0.001 0.002 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_14 (cost=0.31..8.33 rows=1 width=2) (actual time=0.002..0.002 rows=1 loops=1)

  • Index Cond: (aptother_id = ($320)::integer)
222.          

Initplan (forIndex Scan)

223. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

224. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptfbo_pkey on aptfbo aptfbo_25 (cost=0.30..8.32 rows=1 width=3) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptfbo_id = ($322)::integer)
225.          

Initplan (forIndex Scan)

226. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.001 rows=1 loops=1)

227. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_13 (cost=0.31..8.33 rows=1 width=5) (never executed)

  • Index Cond: (apthotel_id = ($324)::integer)
228.          

Initplan (forIndex Scan)

229. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

230. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_15 (cost=0.31..8.33 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($326)::integer)
231.          

Initplan (forIndex Scan)

232. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.001 rows=1 loops=1)

233. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptfbo_pkey on aptfbo aptfbo_26 (cost=0.30..8.32 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptfbo_id = ($328)::integer)
234.          

Initplan (forIndex Scan)

235. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

236. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_14 (cost=0.31..8.33 rows=1 width=10) (never executed)

  • Index Cond: (apthotel_id = ($330)::integer)
237.          

Initplan (forIndex Scan)

238. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

239. 0.001 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_16 (cost=0.31..8.33 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($332)::integer)
240.          

Initplan (forIndex Scan)

241. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=1)

242. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptfbo_pkey on aptfbo aptfbo_27 (cost=0.30..8.32 rows=1 width=5) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptfbo_id = ($334)::integer)
243.          

Initplan (forIndex Scan)

244. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

245. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_15 (cost=0.31..8.33 rows=1 width=13) (never executed)

  • Index Cond: (apthotel_id = ($336)::integer)
246.          

Initplan (forIndex Scan)

247. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

248. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_17 (cost=0.31..8.33 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($338)::integer)
249.          

Initplan (forIndex Scan)

250. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

251. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=34) (never executed)

252. 0.000 0.000 ↓ 0.0 0

Index Scan using fuel_icao_idx on aptfuel aptfuel_6 (cost=0.28..8.30 rows=1 width=34) (never executed)

  • Index Cond: (icao = split_part(ap.svcprovider_id, '^'::text, 1))
  • Filter: (contractor = split_part(ap.svcprovider_id, '^'::text, 2))
253. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.31 rows=1 width=81) (never executed)

254. 0.000 0.000 ↓ 0.0 0

Index Scan using fuel_icao_idx on aptfuel aptfuel_7 (cost=0.28..8.31 rows=1 width=81) (never executed)

  • Index Cond: (icao = split_part(ap.svcprovider_id, '^'::text, 1))
  • Filter: (contractor = split_part(ap.svcprovider_id, '^'::text, 2))
255. 0.086 0.112 ↑ 1.0 1 1

Seq Scan on aircraftprefs ap_1 (cost=41.52..37,944.45 rows=1 width=160) (actual time=0.109..0.112 rows=1 loops=1)

  • Filter: ((deletedflag IS NOT TRUE) AND (svcprovider_id IS NOT NULL) AND (svcprovider_id <> '-1'::text) AND (ac_id = 96) AND (acconfig_id = 77) AND ((legtype = (-1)) OR (legtype = 1)) AND ((commercial = 0) OR (commercia (...)
  • Rows Removed by Filter: 9
256.          

Initplan (forSeq Scan)

257. 0.004 0.004 ↑ 1.0 1 1

Index Scan using aptidentifier_idx on airport (cost=0.29..8.30 rows=1 width=5) (actual time=0.003..0.004 rows=1 loops=1)

  • Index Cond: (identifier = 'RS30325'::text)
258. 0.004 0.004 ↑ 1.0 1 1

Index Scan using aptidentifier_idx on airport airport_1 (cost=0.29..8.30 rows=1 width=5) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (identifier = 'RS30325'::text)
259. 0.003 0.003 ↑ 1.0 1 1

Index Scan using aptidentifier_idx on airport airport_2 (cost=0.29..8.30 rows=1 width=5) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: (identifier = 'RS30325'::text)
260. 0.000 0.000 ↓ 0.0 0

Index Scan using aptidentifier_idx on airport airport_3 (cost=0.29..8.30 rows=1 width=5) (never executed)

  • Index Cond: (identifier = 'AU25150'::text)
261. 0.005 0.005 ↑ 1.0 1 1

Index Scan using aptidentifier_idx on airport airport_4 (cost=0.29..8.30 rows=1 width=5) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (identifier = 'RS30325'::text)
262.          

SubPlan (forSeq Scan)

263. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aptservices (cost=37,526.32..37,526.33 rows=1 width=8) (never executed)

264. 0.000 0.000 ↓ 0.0 0

Sort (cost=37,526.32..37,526.32 rows=1 width=681) (never executed)

  • Sort Key: (CASE WHEN aptservices_1.isprimary THEN 1 WHEN (aptservices_1.isprimary IS NULL) THEN 2 ELSE 2 END)
265. 0.000 0.000 ↓ 0.0 0

Subquery Scan on aptservices_1 (cost=2,458.71..37,526.31 rows=1 width=681) (never executed)

  • Filter: ((aptservices_1.svctype = 'Fuel'::text) AND (aptservices_1.name = split_part(ap_1.svcprovider_id, '^'::text, 2)) AND ((aptservices_1.icao)::text = split_part(ap_1.svcprovider_id, '^'::text, (...)
266. 0.000 0.000 ↓ 0.0 0

Append (cost=2,458.71..33,538.81 rows=159,500 width=218) (never executed)

267. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,458.71..4,186.34 rows=13,156 width=206) (never executed)

  • Hash Cond: (f.aptidentifier = a.identifier)
268.          

Initplan (forHash Left Join)

269. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

270. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

271. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

272. 0.000 0.000 ↓ 0.0 0

Seq Scan on aptfbo f (cost=0.00..691.60 rows=13,156 width=201) (never executed)

  • Filter: (NOT deletedflag)
273. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,086.08..2,086.08 rows=29,808 width=14) (never executed)

274. 0.000 0.000 ↓ 0.0 0

Seq Scan on airport a (cost=0.00..2,086.08 rows=29,808 width=14) (never executed)

275.          

SubPlan (forHash Left Join)

276. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.03 rows=1 width=0) (never executed)

277. 0.000 0.000 ↓ 0.0 0

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

278. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,458.76..9,717.87 rows=57,759 width=247) (never executed)

  • Hash Cond: (h.aptidentifier = a_1.identifier)
279.          

Initplan (forHash Left Join)

280. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

281. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

282. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

283. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

284. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

285. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

286. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

287. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

288. 0.000 0.000 ↓ 0.0 0

Seq Scan on apthotel h (cost=0.00..2,710.59 rows=57,759 width=242) (never executed)

  • Filter: (NOT deletedflag)
289. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,086.08..2,086.08 rows=29,808 width=14) (never executed)

290. 0.000 0.000 ↓ 0.0 0

Seq Scan on airport a_1 (cost=0.00..2,086.08 rows=29,808 width=14) (never executed)

291.          

SubPlan (forHash Left Join)

292. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.03 rows=1 width=0) (never executed)

293. 0.000 0.000 ↓ 0.0 0

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

294. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,458.80..4,739.80 rows=20,991 width=188) (never executed)

  • Hash Cond: (t.aptidentifier = a_2.identifier)
295.          

Initplan (forHash Left Join)

296. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

297. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

298. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

299. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

300. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

301. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

302. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

303. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

304. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

305. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

306. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

307. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

308. 0.000 0.000 ↓ 0.0 0

Seq Scan on apttransport t (cost=0.00..732.91 rows=20,991 width=183) (never executed)

  • Filter: (NOT deletedflag)
309. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,086.08..2,086.08 rows=29,808 width=14) (never executed)

310. 0.000 0.000 ↓ 0.0 0

Seq Scan on airport a_2 (cost=0.00..2,086.08 rows=29,808 width=14) (never executed)

311.          

SubPlan (forHash Left Join)

312. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.03 rows=1 width=0) (never executed)

313. 0.000 0.000 ↓ 0.0 0

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

314. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,458.80..2,733.47 rows=2,599 width=179) (never executed)

  • Hash Cond: (c.aptidentifier = a_3.identifier)
315.          

Initplan (forHash Left Join)

316. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

317. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

318. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

319. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

320. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

321. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

322. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

323. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

324. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

325. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

326. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

327. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

328. 0.000 0.000 ↓ 0.0 0

Seq Scan on aptcatering c (cost=0.00..82.99 rows=2,599 width=174) (never executed)

  • Filter: (NOT deletedflag)
329. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,086.08..2,086.08 rows=29,808 width=14) (never executed)

330. 0.000 0.000 ↓ 0.0 0

Seq Scan on airport a_3 (cost=0.00..2,086.08 rows=29,808 width=14) (never executed)

331.          

SubPlan (forHash Left Join)

332. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.03 rows=1 width=0) (never executed)

333. 0.000 0.000 ↓ 0.0 0

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

334. 0.000 0.000 ↓ 0.0 0

Subquery Scan on *SELECT* 5 (cost=27.81..5,334.14 rows=36,527 width=189) (never executed)

335. 0.000 0.000 ↓ 0.0 0

WindowAgg (cost=27.81..4,968.87 rows=36,527 width=189) (never executed)

336.          

Initplan (forWindowAgg)

337. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

338. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

339. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

340. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

341. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

342. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

343. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

344. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

345. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

346. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

347. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

348. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

349. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

350. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=27.68..2,777.11 rows=36,527 width=189) (never executed)

  • Hash Cond: ((a_4.icao)::text = fu.icao)
351. 0.000 0.000 ↓ 0.0 0

Seq Scan on airport a_4 (cost=0.00..2,086.08 rows=29,808 width=14) (never executed)

352. 0.000 0.000 ↓ 0.0 0

Hash (cost=22.86..22.86 rows=386 width=180) (never executed)

353. 0.000 0.000 ↓ 0.0 0

Seq Scan on aptfuel fu (cost=0.00..22.86 rows=386 width=180) (never executed)

  • Filter: (NOT deletedflag)
354.          

SubPlan (forWindowAgg)

355. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.03 rows=1 width=0) (never executed)

356. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=2,458.76..5,597.47 rows=28,468 width=226) (never executed)

  • Hash Cond: (s.aptidentifier = a_5.identifier)
357.          

Initplan (forHash Left Join)

358. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

359. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

360. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

361. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

362. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

363. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

364. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

365. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

366. 0.000 0.000 ↓ 0.0 0

Seq Scan on aptotherservice s (cost=0.00..825.68 rows=28,468 width=221) (never executed)

  • Filter: (NOT deletedflag)
367. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,086.08..2,086.08 rows=29,808 width=14) (never executed)

368. 0.000 0.000 ↓ 0.0 0

Seq Scan on airport a_5 (cost=0.00..2,086.08 rows=29,808 width=14) (never executed)

369.          

SubPlan (forHash Left Join)

370. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.03 rows=1 width=0) (never executed)

371. 0.000 0.000 ↓ 0.0 0

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

372. 0.000 0.000 ↓ 0.0 0

Index Scan using aptfbo_pkey on aptfbo (cost=0.30..8.32 rows=1 width=19) (never executed)

  • Index Cond: (aptfbo_id = ($85)::integer)
373.          

Initplan (forIndex Scan)

374. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

375. 0.000 0.000 ↓ 0.0 0

Index Scan using aptcatering_pkey on aptcatering (cost=0.30..8.32 rows=1 width=15) (never executed)

  • Index Cond: (aptcatering_id = ($87)::integer)
376.          

Initplan (forIndex Scan)

377. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

378. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=7) (never executed)

379. 0.000 0.000 ↓ 0.0 0

Index Scan using fuel_icao_idx on aptfuel (cost=0.28..8.30 rows=1 width=7) (never executed)

  • Index Cond: (icao = split_part(ap_1.svcprovider_id, '^'::text, 1))
  • Filter: (contractor = split_part(ap_1.svcprovider_id, '^'::text, 2))
380. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel (cost=0.31..8.33 rows=1 width=26) (never executed)

  • Index Cond: (apthotel_id = ($90)::integer)
381.          

Initplan (forIndex Scan)

382. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

383. 0.000 0.000 ↓ 0.0 0

Index Scan using apttransport_pkey on apttransport (cost=0.31..8.33 rows=1 width=24) (never executed)

  • Index Cond: (apttransport_id = ($92)::integer)
384.          

Initplan (forIndex Scan)

385. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

386. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice (cost=0.31..8.33 rows=1 width=21) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($94)::integer)
387.          

Initplan (forIndex Scan)

388. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

389. 0.000 0.000 ↓ 0.0 0

Index Scan using aptfbo_pkey on aptfbo aptfbo_1 (cost=0.30..8.32 rows=1 width=1) (never executed)

  • Index Cond: (aptfbo_id = ($96)::integer)
390.          

Initplan (forIndex Scan)

391. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

392. 0.000 0.000 ↓ 0.0 0

Index Scan using aptcatering_pkey on aptcatering aptcatering_1 (cost=0.30..8.32 rows=1 width=7) (never executed)

  • Index Cond: (aptcatering_id = ($98)::integer)
393.          

Initplan (forIndex Scan)

394. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

395. 0.000 0.000 ↓ 0.0 0

Index Scan using apttransport_pkey on apttransport apttransport_1 (cost=0.31..8.33 rows=1 width=12) (never executed)

  • Index Cond: (apttransport_id = ($100)::integer)
396.          

Initplan (forIndex Scan)

397. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

398. 0.000 0.000 ↓ 0.0 0

Index Scan using aptfbo_pkey on aptfbo aptfbo_2 (cost=0.30..8.32 rows=1 width=13) (never executed)

  • Index Cond: (aptfbo_id = ($102)::integer)
399.          

Initplan (forIndex Scan)

400. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

401. 0.000 0.000 ↓ 0.0 0

Index Scan using aptcatering_pkey on aptcatering aptcatering_2 (cost=0.30..8.32 rows=1 width=13) (never executed)

  • Index Cond: (aptcatering_id = ($104)::integer)
402.          

Initplan (forIndex Scan)

403. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

404. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=17) (never executed)

405. 0.000 0.000 ↓ 0.0 0

Index Scan using fuel_icao_idx on aptfuel aptfuel_1 (cost=0.28..8.30 rows=1 width=17) (never executed)

  • Index Cond: (icao = split_part(ap_1.svcprovider_id, '^'::text, 1))
  • Filter: (contractor = split_part(ap_1.svcprovider_id, '^'::text, 2))
406. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_1 (cost=0.31..8.33 rows=1 width=13) (never executed)

  • Index Cond: (apthotel_id = ($107)::integer)
407.          

Initplan (forIndex Scan)

408. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

409. 0.000 0.000 ↓ 0.0 0

Index Scan using apttransport_pkey on apttransport apttransport_2 (cost=0.31..8.33 rows=1 width=11) (never executed)

  • Index Cond: (apttransport_id = ($109)::integer)
410.          

Initplan (forIndex Scan)

411. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

412. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_1 (cost=0.31..8.33 rows=1 width=14) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($111)::integer)
413.          

Initplan (forIndex Scan)

414. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

415. 0.000 0.000 ↓ 0.0 0

Index Scan using aptfbo_pkey on aptfbo aptfbo_3 (cost=0.30..8.32 rows=1 width=11) (never executed)

  • Index Cond: (aptfbo_id = ($113)::integer)
416.          

Initplan (forIndex Scan)

417. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

418. 0.000 0.000 ↓ 0.0 0

Index Scan using aptcatering_pkey on aptcatering aptcatering_3 (cost=0.30..8.32 rows=1 width=10) (never executed)

  • Index Cond: (aptcatering_id = ($115)::integer)
419.          

Initplan (forIndex Scan)

420. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

421. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_2 (cost=0.31..8.33 rows=1 width=12) (never executed)

  • Index Cond: (apthotel_id = ($117)::integer)
422.          

Initplan (forIndex Scan)

423. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

424. 0.000 0.000 ↓ 0.0 0

Index Scan using apttransport_pkey on apttransport apttransport_3 (cost=0.31..8.33 rows=1 width=6) (never executed)

  • Index Cond: (apttransport_id = ($119)::integer)
425.          

Initplan (forIndex Scan)

426. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

427. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_2 (cost=0.31..8.33 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($121)::integer)
428.          

Initplan (forIndex Scan)

429. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

430. 0.000 0.000 ↓ 0.0 0

Index Scan using aptfbo_pkey on aptfbo aptfbo_4 (cost=0.30..8.32 rows=1 width=9) (never executed)

  • Index Cond: (aptfbo_id = ($123)::integer)
431.          

Initplan (forIndex Scan)

432. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

433. 0.000 0.000 ↓ 0.0 0

Index Scan using aptcatering_pkey on aptcatering aptcatering_4 (cost=0.30..8.32 rows=1 width=19) (never executed)

  • Index Cond: (aptcatering_id = ($125)::integer)
434.          

Initplan (forIndex Scan)

435. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

436. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_3 (cost=0.31..8.33 rows=1 width=16) (never executed)

  • Index Cond: (apthotel_id = ($127)::integer)
437.          

Initplan (forIndex Scan)

438. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

439. 0.000 0.000 ↓ 0.0 0

Index Scan using apttransport_pkey on apttransport apttransport_4 (cost=0.31..8.33 rows=1 width=20) (never executed)

  • Index Cond: (apttransport_id = ($129)::integer)
440.          

Initplan (forIndex Scan)

441. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

442. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_3 (cost=0.31..8.33 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($131)::integer)
443.          

Initplan (forIndex Scan)

444. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

445. 0.000 0.000 ↓ 0.0 0

Index Scan using aptfbo_pkey on aptfbo aptfbo_5 (cost=0.30..8.32 rows=1 width=8) (never executed)

  • Index Cond: (aptfbo_id = ($133)::integer)
446.          

Initplan (forIndex Scan)

447. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

448. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_4 (cost=0.31..8.33 rows=1 width=29) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($135)::integer)
449.          

Initplan (forIndex Scan)

450. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

451. 0.000 0.000 ↓ 0.0 0

Index Scan using aptfbo_pkey on aptfbo aptfbo_6 (cost=0.30..8.32 rows=1 width=1) (never executed)

  • Index Cond: (aptfbo_id = ($137)::integer)
452.          

Initplan (forIndex Scan)

453. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

454. 0.000 0.000 ↓ 0.0 0

Index Scan using aptfbo_pkey on aptfbo aptfbo_7 (cost=0.30..8.32 rows=1 width=2) (never executed)

  • Index Cond: (aptfbo_id = ($139)::integer)
455.          

Initplan (forIndex Scan)

456. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

457. 0.000 0.000 ↓ 0.0 0

Index Scan using aptfbo_pkey on aptfbo aptfbo_8 (cost=0.30..8.32 rows=1 width=2) (never executed)

  • Index Cond: (aptfbo_id = ($141)::integer)
458.          

Initplan (forIndex Scan)

459. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

460. 0.000 0.000 ↓ 0.0 0

Index Scan using aptfbo_pkey on aptfbo aptfbo_9 (cost=0.30..8.32 rows=1 width=3) (never executed)

  • Index Cond: (aptfbo_id = ($143)::integer)
461.          

Initplan (forIndex Scan)

462. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

463. 0.000 0.000 ↓ 0.0 0

Index Scan using aptfbo_pkey on aptfbo aptfbo_10 (cost=0.30..8.33 rows=1 width=10) (never executed)

  • Index Cond: (aptfbo_id = ($145)::integer)
464.          

Initplan (forIndex Scan)

465. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

466. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_4 (cost=0.31..8.33 rows=1 width=23) (never executed)

  • Index Cond: (apthotel_id = ($147)::integer)
467.          

Initplan (forIndex Scan)

468. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

469. 0.001 0.002 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_5 (cost=0.31..8.33 rows=1 width=2) (actual time=0.002..0.002 rows=1 loops=1)

  • Index Cond: (aptother_id = ($149)::integer)
470.          

Initplan (forIndex Scan)

471. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

472. 0.000 0.000 ↓ 0.0 0

Index Scan using aptfbo_pkey on aptfbo aptfbo_11 (cost=0.30..8.32 rows=1 width=3) (never executed)

  • Index Cond: (aptfbo_id = ($151)::integer)
473.          

Initplan (forIndex Scan)

474. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

475. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_5 (cost=0.31..8.33 rows=1 width=5) (never executed)

  • Index Cond: (apthotel_id = ($153)::integer)
476.          

Initplan (forIndex Scan)

477. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

478. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_6 (cost=0.31..8.33 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($155)::integer)
479.          

Initplan (forIndex Scan)

480. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

481. 0.000 0.000 ↓ 0.0 0

Index Scan using aptfbo_pkey on aptfbo aptfbo_12 (cost=0.30..8.32 rows=1 width=4) (never executed)

  • Index Cond: (aptfbo_id = ($157)::integer)
482.          

Initplan (forIndex Scan)

483. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

484. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_6 (cost=0.31..8.33 rows=1 width=10) (never executed)

  • Index Cond: (apthotel_id = ($159)::integer)
485.          

Initplan (forIndex Scan)

486. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

487. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_7 (cost=0.31..8.33 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($161)::integer)
488.          

Initplan (forIndex Scan)

489. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

490. 0.000 0.000 ↓ 0.0 0

Index Scan using aptfbo_pkey on aptfbo aptfbo_13 (cost=0.30..8.32 rows=1 width=5) (never executed)

  • Index Cond: (aptfbo_id = ($163)::integer)
491.          

Initplan (forIndex Scan)

492. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

493. 0.000 0.000 ↓ 0.0 0

Index Scan using apthotel_apthotel_id_idx on apthotel apthotel_7 (cost=0.31..8.33 rows=1 width=13) (never executed)

  • Index Cond: (apthotel_id = ($165)::integer)
494.          

Initplan (forIndex Scan)

495. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.01 rows=1 width=0) (never executed)

496. 0.000 0.001 ↑ 1.0 1 1

Index Scan using aptotherservice_pkey on aptotherservice aptotherservice_8 (cost=0.31..8.33 rows=1 width=1) (actual time=0.001..0.001 rows=1 loops=1)

  • Index Cond: (aptother_id = ($167)::integer)
497.          

Initplan (forIndex Scan)

498. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

499. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.30 rows=1 width=34) (never executed)

500. 0.000 0.000 ↓ 0.0 0

Index Scan using fuel_icao_idx on aptfuel aptfuel_2 (cost=0.28..8.30 rows=1 width=34) (never executed)

  • Index Cond: (icao = split_part(ap_1.svcprovider_id, '^'::text, 1))
  • Filter: (contractor = split_part(ap_1.svcprovider_id, '^'::text, 2))
501. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.28..8.31 rows=1 width=81) (never executed)

502. 0.000 0.000 ↓ 0.0 0

Index Scan using fuel_icao_idx on aptfuel aptfuel_3 (cost=0.28..8.31 rows=1 width=81) (never executed)

  • Index Cond: (icao = split_part(ap_1.svcprovider_id, '^'::text, 1))
  • Filter: (contractor = split_part(ap_1.svcprovider_id, '^'::text, 2))
503.          

SubPlan (forSubquery Scan)

504. 0.006 0.006 ↓ 0.0 0 3

Index Scan using svc_leg_id_idx on legsvc ls (cost=0.28..8.50 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=3)

  • Index Cond: (leg_id = 1)
  • Filter: ((arrival = all_svc.arrival) AND (icao = (all_svc.icao)::text))