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 mytest (x int, y int, z int);
insert into mytest values (6, 3, 3), (5, 6, null), (4, 5, 6), (11, 7, 8);
select t.*, percentile_cont(0.5) within group (order by e.v::int)
from mytest t
cross join lateral jsonb_each_text(to_jsonb(t)) e(k,v)
group by t.x, t.y, t.z;
CREATE TABLE
INSERT 0 4
| x | y | z | percentile_cont |
|---|---|---|---|
| 4 | 5 | 6 | 5 |
| 5 | 6 | null | 5.5 |
| 6 | 3 | 3 | 3 |
| 11 | 7 | 8 | 8 |
SELECT 4