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 test (
test_id int
, created_at timestamp
);
INSERT INTO test (test_id, created_at) VALUES
(1, '2010-1-1 12:00');
ALTER TABLE test ALTER created_at TYPE timestamptz;
CREATE TABLE
INSERT 0 1
ALTER TABLE
TABLE test;
| test_id | created_at |
|---|---|
| 1 | 2010-01-01 12:00:00+00 |
SELECT 1