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 yourtable (yourtimestamp timestamp);
CREATE TABLE
insert into yourtable values ('2022-11-25T17:54:29.819Z');
insert into yourtable values ('2022-11-18T22:54:29.819Z');
insert into yourtable values ('2022-11-22T06:54:29.819');
INSERT 0 1
INSERT 0 1
INSERT 0 1
SELECT EXTRACT(HOUR FROM yourtimestamp) FROM yourtable;
| extract |
|---|
| 17 |
| 22 |
| 6 |
SELECT 3