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?.
| version |
|---|
| PostgreSQL 11.5 (Debian 11.5-3.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit |
12 rows affected
| first_level_key | first_level_key_name | key_value_en |
|---|---|---|
| topheader | screen | Screen Reader Access |
| header | title | title |
| header | subtitle | subtitletest |
| main-nav | help | Help |
| main-nav | tooling | Tooling |
| main-nav | news | News |
| main-nav | support | Support |
| nav-link | forum | Forum |
| nav-link | meetups | Meetups |
| nav-link | devtools | Devtools |
| nav-link | CLI | CLI |
| nav-link | loader | Loader |
| first_level_key | first_level_key_name | key_value_fr |
|---|---|---|
| topheader | screen | val_fr_1 |
| header | title | val_fr_2 |
| header | subtitle | val_fr_3 |
| main-nav | help | val_fr_4 |
| main-nav | tooling | val_fr_5 |
| main-nav | news | val_fr_6 |
| main-nav | support | val_fr_7 |
| nav-link | forum | val_fr_8 |
| nav-link | meetups | val_fr_9 |
| nav-link | devtools | val_fr_10 |
| nav-link | CLI | val_fr_11 |
| nav-link | loader | val_fr_12 |
| id | first_level_key | first_level_key_name | key_value_en | key_value_fr | key_value_ko |
|---|---|---|---|---|---|
| 1 | topheader | screen | Screen Reader Access | val_fr_1 | null |
| 2 | header | title | title | val_fr_2 | null |
| 3 | header | subtitle | subtitletest | val_fr_3 | null |
| 4 | main-nav | help | Help | val_fr_4 | null |
| 5 | main-nav | tooling | Tooling | val_fr_5 | null |
| 6 | main-nav | news | News | val_fr_6 | null |
| 7 | main-nav | support | Support | val_fr_7 | null |
| 8 | nav-link | forum | Forum | val_fr_8 | null |
| 9 | nav-link | meetups | Meetups | val_fr_9 | null |
| 10 | nav-link | devtools | Devtools | val_fr_10 | null |
| 11 | nav-link | CLI | CLI | val_fr_11 | null |
| 12 | nav-link | loader | Loader | val_fr_12 | null |
ERROR: syntax error at or near "{"
LINE 18: {
^