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 |
| jsonb_build_object |
|---|
| {"topheader": {"screen": {"Screen Reader Access": ["screen"]}}} |
| {"main-nav": {"help": {"Help": ["help"]}, "news": {"News": ["news"]}, "support": {"Support": ["support"]}, "tooling": {"Tooling": ["tooling"]}}} |
| {"header": {"title": {"title": ["title"]}, "subtitle": {"subtitletest": ["subtitle"]}}} |
| {"nav-link": {"CLI": {"CLI": ["CLI"]}, "forum": {"Forum": ["forum"]}, "loader": {"Loader": ["loader"]}, "meetups": {"Meetups": ["meetups"]}, "devtools": {"Devtools": ["devtools"]}}} |
| jsonb_object_agg |
|---|
| {"header": {"title": "title", "subtitle": "subtitletest"}, "main-nav": {"help": "Help", "news": "News", "support": "Support", "tooling": "Tooling"}, "nav-link": {"CLI": "CLI", "forum": "Forum", "loader": "Loader", "meetups": "Meetups", "devtools": "Devtools"}, "topheader": {"screen": "Screen Reader Access"}} |