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?.
SELECT 3
| jsonb_pretty |
|---|
| { "id": 169, "status": 1, "to_time": "19:30:00", "language": [ "English", "Hindi", "Punjabi" ], "from_time": "10:30:00", "created_at": "2023-11-03 18:05:16", "updated_at": "2024-03-31 18:11:43" } |
| { "id": 817, "status": 1, "to_time": "17:30:00", "language": [ "English", "Hindi" ], "from_time": "10:00:00", "created_at": "2024-03-29 17:31:26", "updated_at": null } |
| { "id": 999, "status": 1, "to_time": "16:30:00", "language": [ "English", "French" ], "from_time": "11:00:00", "created_at": "2024-04-02 16:01:26", "updated_at": null } |
SELECT 3
| jsonb_pretty |
|---|
| { "id": 169, "status": 1, "to_time": "19:30:00", "language": [ "English", "Hindi", "Punjabi" ], "from_time": "10:30:00", "created_at": "2023-11-03 18:05:16", "updated_at": "2024-03-31 18:11:43" } |
| { "id": 817, "status": 1, "to_time": "17:30:00", "language": [ "English", "Hindi" ], "from_time": "10:00:00", "created_at": "2024-03-29 17:31:26", "updated_at": null } |
SELECT 2