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
INSERT 0 10000
CREATE INDEX
CREATE TABLE
INSERT 0 9891
CREATE INDEX
ANALYZE
ANALYZE
| data_id | data | elem_id | elem |
|---|---|---|---|
| 56 | {5859,1769,7956,9489,5694,9396,7232,4333,9797,6779,20,2219,296,5710,7750,7532,8580,9003,3524,1473,8849,2213,3796,8645,546,7213,1234,7905,653,7715,2987,9456,8747,9364,4344,8317,2584} | 1234 | word1234word |
| 549 | {1234,9874,6825,7222,3851,410,4274,3182} | 1234 | word1234word |
| 772 | {8850,9691,992,2504,3000,6225,1486,3895,4543,2928,9003,2087,2203,6109,952,8232,9736,510,917,9356,1234,4271,160,7629,711,2084,3237,8027,3072,1340,4383,7422,9990,9821,123,1465,8492,2848,9866,4358,7917,4879,8933,1842} | 1234 | word1234word |
| 1085 | {3159,9363,7289,196,5969,5960,3275,8148,7361,4434,6972,6119,7431,843,1234,6741,5940,5708,8682,2444,5546} | 1234 | word1234word |
| 1087 | {2616,9990,3522,8155,8023,5236,1707,4471,1773,7627,1234,3819,3081,8276,6392,122,5742,8690,7905,5113,841,5515,8407,4465,2256,7521,9271,2796,7617,6721,8570,4801,5852} | 1234 | word1234word |
| 1486 | {9191,855,8990,4689,5415,1618,613,5484,2960,3386,6600,8415,2599,2224,1234,6030,4610,8329,7906,7937,9926,6087,878,4799,3898,8035,4092,442,3065,928,1177,3112,1489,2036,8444,4684,555,1417,1499,129,7643} | 1234 | word1234word |
| 2035 | {6769,9226,4552,9787,5759,8062,8876,6212,1234,2136,9397,4011,1080,4542,9070,4335,7044,7346,1900,1820,5107,4218,4525,8027,7090,8078,7540,3146,3737,6016} | 1234 | word1234word |
| 3068 | {7193,7123,4363,5322,1593,4874,323,1234,8641,8204,7707,8574,4985,875,4277,8128,5001,1810,749,4862,3977,4896,206,7707,208,4151,8721,3890,9524,2426,8148,9501,8581,540,8950,6094,2039,4041,6101,1377,481,565,563,733,6546} | 1234 | word1234word |
| 4981 | {4798,6573,3114,2008,5603,3446,1239,4358,5481,9405,187,4405,8721,7328,6185,4669,9445,9638,1150,51,4364,1277,8387,8903,8182,3030,2534,7632,3459,2088,5789,5041,7548,8428,3123,8992,6929,597,1234,6036,3313,7652,6358,1101} | 1234 | word1234word |
| 6942 | {1767,5719,2249,7182,7129,2440,8939,6923,2564,6690,5720,8884,1234,2614,3459,3735,9243,9271,6917,4492,5514,4851,4280,2534,5941} | 1234 | word1234word |
| 7568 | {7651,7090,6958,6241,4110,6352,4528,3788,9929,415,9332,9489,5493,1234,560,4621,937,500,198,1677,3335,675,2617,5925,7739,5735,4370,228,2223,4484,267,3016,5042} | 1234 | word1234word |
| 7720 | {4078,1151,3046,8581,3577,2056,8066,1183,6256,3624,8286,4448,2929,2224,134,1203,9198,9393,7822,4430,289,860,213,8260,4722,2461,194,1234,9489,8657,755,1742,4196} | 1234 | word1234word |
| 7869 | {7744,5171,8140,1704,3980,7792,5250,412,3779,3839,4284,4451,2373,8235,6473,7555,5941,7501,7802,1238,5651,4344,6743,6168,5348,439,8773,1146,322,5093,5864,1234,1351,9087,5896,2624,4485,9743,3769,7972,1455} | 1234 | word1234word |
| 7942 | {5789,2413,2146,1479,8548,6735,9857,9189,1567,9954,4541,2368,4081,4494,398,2875,9075,6713,3319,1234,1051,8797,8614,4474,597,855,4966,9611,5915} | 1234 | word1234word |
| 8096 | {6056,7701,6674,714,7192,5526,8884,7354,2042,9305,5324,1234,7551,6364,2510,194,4958,2365,2489,4561,9259,6343,2631,9646,5523,2894,8058,6362,2999,7917,7875,5637,6563,5500,3426,2931,4490,4033,5533,7262,2127,9691} | 1234 | word1234word |
| 8494 | {3173,4555,1234,5064,9372,8364,6104,5272,342,4898,917,3064,7577,5436,2408,6028,4848,2962,7947,7871,5682,562} | 1234 | word1234word |
| 8637 | {6490,3121,8528,4692,5960,4013,1308,8694,9536,1336,8636,4409,1234,8794,3698,3170,6679,4146,604,2965,2234,3324,2358,576,5581,1240,3666,3146,6242,3172,9162} | 1234 | word1234word |
| 8813 | {8381,9386,9116,3444,8926,4547,5212,9720,6087,2563,2918,2918,7506,8744,7322,1582,3123,8498,9046,5852,9238,5784,2409,6778,7373,9652,1141,9260,3509,7357,6717,82,6275,5783,8553,1234} | 1234 | word1234word |
SELECT 18