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?.
SELECT *
FROM ( VALUES('en', 'English', 'USA', TRUE, TRUE),
('de', 'German', 'Deutschland', FALSE, FALSE)
) sub (LANGUAGE_CODE, NAME, I18N_NAME, LOCALIZE_UI, CAN_CHOOSE)
| language_code | name | i18n_name | localize_ui | can_choose |
|---|---|---|---|---|
| en | English | USA | t | t |
| de | German | Deutschland | f | f |
SELECT 2