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?.
5 rows affected
jsonb_value | ?column? | ?column? |
---|---|---|
{"en": "value", "ru": "значение"} | t | t |
{"ru": "значение", "en": "value"} | f | t |
{"en": 6, "ru": "значение"} | f | f |
{"en": "", "ru": "значение"} | f | f |
{"en": "value", "ru": "значение", "fr": "de valuje"} | f | f |