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 t(id INT);
INSERT INTO t(id) VALUES (1);
CREATE TABLE
INSERT 0 1
SELECT s.col, s.col+1 AS col2
FROM t
,LATERAL (SELECT RANDOM()) AS s(col)
| col | col2 |
|---|---|
| 0.5880620856270831 | 1.588062085627083 |
SELECT 1