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
CREATE TABLE
CREATE TABLE
INSERT 0 4
INSERT 0 5
INSERT 0 10
container_with_things |
---|
{"id":"1","name":"one","location":"here","thingIds":["1", "2", "3"]} |
{"id":"3","name":"three","location":"somewhere","thingIds":["1", "2", "3", "4", "5"]} |
{"id":"4","name":"4 is empty","location":"void","thingIds":[null]} |
SELECT 3
container_with_things |
---|
{"id":"1","name":"one","location":"here","thingIds":["1", "2", "3"]} |
{"id":"3","name":"three","location":"somewhere","thingIds":["1", "2", "3", "4", "5"]} |
{"id":"4","name":"4 is empty","location":"void","thingIds":null} |
SELECT 3
container_with_things |
---|
{"id":"1","name":"one","location":"here","thingIds":["1","2","3"]} |
{"id":"3","name":"three","location":"somewhere","thingIds":["1","2","3","4","5"]} |
{"id":"4","name":"4 is empty","location":"void","thingIds":[]} |
SELECT 3
container_with_things |
---|
{"id": "1", "name": "one", "location": "here", "thingIds": ["1", "2", "3"]} |
{"id": "3", "name": "three", "location": "somewhere", "thingIds": ["1", "2", "3", "4", "5"]} |
{"id": "4", "name": "4 is empty", "location": "void", "thingIds": []} |
SELECT 3
container_with_things |
---|
{"id": "1", "name": "one", "location": "here", "thingIds": ["1", "2", "3"]} |
{"id": "3", "name": "three", "location": "somewhere", "thingIds": ["1", "2", "3", "4", "5"]} |
{"id": "4", "name": "4 is empty", "location": "void", "thingIds": null} |
SELECT 3