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 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
time | useid | value |
---|---|---|
t1 | 116C123 | 2 |
t2 | 116C123 | 3 |
t3 | 116C123 | 4 |
t4 | 116C123 | 5 |
t2 | 116C111 | 6 |
t3 | 116C111 | 7 |
t4 | 116C111 | 8 |
SELECT 7
CREATE AGGREGATE
time | useid | value | plt |
---|---|---|---|
t2 | 116C111 | 6 | 6 |
t3 | 116C111 | 7 | 42 |
t4 | 116C111 | 8 | 336 |
t1 | 116C123 | 2 | 2 |
t2 | 116C123 | 3 | 6 |
t3 | 116C123 | 4 | 24 |
t4 | 116C123 | 5 | 120 |
SELECT 7