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?.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
organization_id | pairing_id | gson |
---|---|---|
1 | 1 | {"id":2,"organization_id":1,"pairing_id":1,"device":{"tracking_id":1},"events":[{"id":1,"created":"2022-05-23T10:26:44Z","condition_id":1}]} |
1 | 1 | {"id":1,"organization_id":1,"pairing_id":1,"device":{"tracking_id":1}} |