By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TABLE
DO
| QUERY PLAN |
|---|
| Append (actual rows=0 loops=1) |
| -> Seq Scan on my_table_0 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_1 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_2 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_3 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_4 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_5 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_6 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_7 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_8 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_9 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_10 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_11 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_12 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_13 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_14 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_15 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_16 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_17 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_18 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_19 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_20 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_21 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_22 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_23 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_24 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_25 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_26 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_27 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_28 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_29 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_30 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_31 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_32 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_33 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_34 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_35 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_36 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_37 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_38 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_39 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_40 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_41 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_42 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_43 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_44 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_45 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_46 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_47 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_48 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_49 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_50 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_51 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_52 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_53 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_54 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_55 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_56 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_57 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_58 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_59 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_60 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_61 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_62 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_63 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_64 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_65 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_66 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_67 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_68 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_69 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_70 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_71 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_72 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_73 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_74 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_75 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_76 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_77 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_78 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_79 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_80 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_81 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_82 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_83 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_84 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_85 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_86 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_87 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_88 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_89 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_90 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_91 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_92 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_93 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_94 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_95 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_96 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_97 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_98 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_99 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_100 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_101 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_102 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_103 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_104 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_105 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_106 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_107 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_108 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_109 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_110 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_111 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_112 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_113 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_114 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_115 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_116 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_117 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_118 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_119 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_120 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_121 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_122 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_123 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_124 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_125 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_126 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_127 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_128 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_129 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_130 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_131 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_132 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_133 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_134 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_135 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_136 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_137 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_138 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_139 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_140 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_141 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_142 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_143 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_144 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_145 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_146 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_147 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_148 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_149 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_150 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_151 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_152 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_153 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_154 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_155 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_156 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_157 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_158 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_159 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_160 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_161 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_162 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_163 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_164 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_165 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_166 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_167 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_168 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_169 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_170 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_171 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_172 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_173 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_174 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_175 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_176 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_177 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_178 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_179 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_180 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_181 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_182 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_183 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_184 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_185 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_186 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_187 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_188 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_189 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_190 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_191 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_192 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_193 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_194 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_195 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_196 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_197 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_198 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_199 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_200 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_201 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_202 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_203 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_204 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_205 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_206 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_207 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_208 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_209 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_210 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_211 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_212 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_213 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_214 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_215 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_216 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_217 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_218 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_219 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_220 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_221 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_222 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_223 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_224 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_225 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_226 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_227 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_228 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_229 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_230 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_231 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_232 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_233 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_234 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_235 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_236 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_237 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_238 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_239 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_240 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_241 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_242 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_243 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_244 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_245 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_246 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_247 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_248 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_249 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_250 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_251 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_252 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_253 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_254 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_255 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_256 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_257 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_258 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_259 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_260 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_261 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_262 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_263 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_264 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_265 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_266 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_267 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_268 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_269 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_270 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_271 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_272 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_273 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_274 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_275 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_276 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_277 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_278 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_279 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_280 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_281 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_282 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_283 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_284 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_285 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_286 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_287 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_288 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_289 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_290 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_291 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_292 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_293 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_294 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_295 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_296 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_297 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_298 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_299 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_300 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_301 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_302 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_303 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_304 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_305 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_306 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_307 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_308 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_309 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_310 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_311 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_312 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_313 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_314 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_315 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_316 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_317 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_318 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_319 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_320 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_321 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_322 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_323 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_324 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_325 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_326 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_327 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_328 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_329 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_330 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_331 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_332 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_333 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_334 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_335 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_336 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_337 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_338 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_339 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_340 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_341 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_342 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_343 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_344 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_345 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_346 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_347 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_348 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_349 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_350 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_351 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_352 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_353 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_354 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_355 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_356 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_357 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_358 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_359 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_360 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_361 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_362 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_363 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_364 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_365 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_366 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_367 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_368 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_369 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_370 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_371 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_372 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_373 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_374 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_375 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_376 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_377 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_378 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_379 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_380 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_381 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_382 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_383 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_384 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_385 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_386 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_387 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_388 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_389 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_390 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_391 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_392 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_393 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_394 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_395 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_396 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_397 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_398 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_399 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_400 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_401 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_402 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_403 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_404 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_405 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_406 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_407 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_408 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_409 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_410 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_411 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_412 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_413 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_414 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_415 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_416 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_417 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_418 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_419 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_420 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_421 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_422 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_423 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_424 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_425 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_426 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_427 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_428 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_429 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_430 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_431 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_432 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_433 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_434 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_435 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_436 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_437 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_438 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_439 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_440 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_441 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_442 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_443 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_444 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_445 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_446 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_447 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_448 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_449 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_450 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_451 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_452 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_453 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_454 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_455 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_456 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_457 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_458 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_459 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_460 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_461 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_462 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_463 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_464 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_465 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_466 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_467 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_468 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_469 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_470 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_471 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_472 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_473 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_474 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_475 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_476 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_477 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_478 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_479 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_480 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_481 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_482 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_483 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_484 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_485 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_486 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_487 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_488 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_489 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_490 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_491 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_492 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_493 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_494 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_495 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_496 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_497 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_498 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_499 (actual rows=0 loops=1) |
| -> Seq Scan on my_table_500 (actual rows=0 loops=1) |
| Planning Time: 16.209 ms |
| Execution Time: 7.006 ms |
EXPLAIN