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?.
with users as (
select 1 as id, 'adfasdf' as name, 123 as private_key union all
select 2 as id, 'adfasdf' as name, 123 as private_key union all
select 3 as id, 'adfasdf' as name, 123 as private_key union all
select 4 as id, 'adfasdf' as name, 123 as private_key union all
select 5 as id, 'adfasdf' as name, 123 as private_key union all
select 6 as id, 'adfasdf' as name, 123 as private_key union all
select 7 as id, 'adfasdf' as name, 123 as private_key
)
SELECT
id,
name,
private_key
FROM
users
ORDER BY name
OFFSET 3 ROWS
FETCH FIRST 2 ROW ONLY
| id | name | private_key |
|---|---|---|
| 4 | adfasdf | 123 |
| 5 | adfasdf | 123 |
SELECT 2