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 1
id | iddocumento | numparcialida |
---|---|---|
aaa1ada1-9151-4c90-aa62-43590dcc7c81 | AAA1D7E6-23AD-44FC-A544-9CB47D9CFCCD | 1 |
aaa1ada1-9151-4c90-aa62-43590dcc7c81 | AAA124C5-48FC-4409-BB76-8A23BF6318F3 | 1 |
aaa1ada1-9151-4c90-aa62-43590dcc7c81 | AAA17CA8-222A-4146-A943-58AAFD62C7F3 | 1 |
aaa1ada1-9151-4c90-aa62-43590dcc7c81 | AAA111BC-4CE8-4572-8C75-2D673F1ED9F4 | 1 |
aaa1ada1-9151-4c90-aa62-43590dcc7c81 | AAA1686A-7605-423D-809F-A6EE240E9587 | 1 |
aaa1ada1-9151-4c90-aa62-43590dcc7c81 | AAA1783C-A24A-4DC6-8A87-54591E555CCE | 1 |
aaa1ada1-9151-4c90-aa62-43590dcc7c81 | AAA17618-B009-4A80-8C12-CF7F697A512E | 1 |
aaa1ada1-9151-4c90-aa62-43590dcc7c81 | AAA1DBB5-B99E-4BFB-AD27-FC249EDEEBCE | 1 |
aaa1ada1-9151-4c90-aa62-43590dcc7c81 | AAA19C00-65FB-4E83-9AD7-2EF660694ECF | 1 |
aaa1ada1-9151-4c90-aa62-43590dcc7c81 | AAA1CD78-9581-4F43-8741-8C9506E26B2C | 1 |
SELECT 10