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?.
DROP TABLE
CREATE TABLE
INSERT 0 1
DROP TABLE
CREATE TABLE
INSERT 0 1
DROP TABLE
CREATE TABLE
INSERT 0 2
id | comments | users |
---|---|---|
10 | [{"id" : "rows1", "user" : "a test comment"}] | [{"type" : "updatedBy", "user" : 5}, {"type" : "closedBy", "user" : 5}] |
SELECT 1