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?.
4 rows affected
id | hour | hostname | visits | referrers | paths | widths |
---|---|---|---|---|---|---|
1 | 2019-01-16 09:00:00 | example.com | 6 | [{"url": "example2.com", "value": 4}] | {"/": 5, "/about": 1} | {"1280": 5, "1283": 1} |
2 | 2019-01-16 14:00:00 | example.com | 7 | [{"url": "google", "value": 6}] | {"/": 1, "/about": 3, "/article/title1": 1, "/article/title2": 2} | {"360": 3, "1398": 1, "1680": 1, "2560": 1} |
3 | 2019-01-16 15:00:00 | example.com | 6 | [{"url": "google", "value": 6}] | {"/": 1, "/about": 1, "/article/title1": 1, "/article/title2": 3} | {"360": 3, "1280": 2, "1920": 1} |
4 | 2019-01-16 16:00:00 | example.com | 6 | [{"url": "facebook", "value": 1}, {"url": "example2.com", "value": 1}] | {"/": 4, "/about": 1, "/article/title1": 1} | {"360": 1, "1440": 2, "1680": 2, "1920": 1} |
hostname | visits |
---|---|
example.com | 25 |
hostname | ref_url | ref_value |
---|---|---|
example.com | "google" | 12 |
example.com | "facebook" | 1 |
example.com | "example2.com" | 5 |
jsonb_agg |
---|
[{"url": "google", "val": 12}, {"url": "facebook", "val": 1}, {"url": "example2.com", "val": 5}] |