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 8
| id | date | json_count |
|---|---|---|
| 101 | 2024-03-12 00:00:00 | {"Chrome": 1, "Firefox": 1} |
| 106 | 2024-03-14 00:00:00 | {"Edge": 1, "Chrome": 1, "Firefox": 1} |
| 103 | 2024-03-13 00:00:00 | {"Brave": 1, "Chrome": 1, "Firefox": 1} |
SELECT 3