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 3
UPDATE 3
| js |
|---|
| {"Id": "7324326", "Details": {"Email": "henry@test.com", "Phone": "03722", "Images": [{"Link": "https://face.png", "Size": null, "UploadedBy": null}]}, "UserName": "Henry"} |
| {"Id": "325325", "Details": {"Email": "mark@test.com", "Phone": "83272", "Images": [{"Link": "https://hair.png", "Size": null, "UploadedBy": null}, {"Link": "https://nose.png", "Size": null, "UploadedBy": null}]}, "UserName": "Mark"} |
| {"Id": "832743", "Details": {"Email": "david@test.com", "Phone": "65128", "Images": []}, "UserName": "David"} |
SELECT 3