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?.
2 rows affected
document_id | data_block |
---|---|
878979 | {"COMMONS": {"DATE": {"value": "2017-03-11"}}, "PAYABLE_INVOICE_LINES": [{"AMOUNT": {"value": 52408.53}}, {"AMOUNT": {"value": 654.23}}]} |
document_id | data_block |
---|---|
878979 | {"COMMONS": {"DATE": {"value": "2017-03-11"}}, "PAYABLE_INVOICE_LINES": [{"AMOUNT": {"value": 52408.53}}, {"AMOUNT": {"value": 654.23}}]} |