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 6
| device_serial | device_gen | status_code | methods | event_time | first_step_ts |
|---|---|---|---|---|---|
| ABC345 | i13 | 200 | post:/login_request | 3/3/24 23:10:05 | null |
| ABC345 | i13 | 200 | post:/login | 3/3/24 23:10:10 | 3/3/24 23:10:05 |
| EFG456 | i13 | 200 | post:/login_request | 3/3/24 18:37:25 | null |
| EFG456 | i13 | 200 | post:/login | 3/3/24 18:37:28 | 3/3/24 18:37:25 |
| EFG456 | i13 | 200 | post:/login_request | 3/3/24 21:58:44 | null |
| EFG456 | i13 | 200 | post:/login | 3/3/24 21:58:48 | 3/3/24 21:58:44 |
SELECT 6