Postgres 15

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 version();

version

PostgreSQL 15.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit

SELECT 1

show time zone;

TimeZone

GB

SHOW

SELECT now(),
       now() AT TIME ZONE 'EST' AS est,
       now() AT TIME ZONE 'EDT' AS edt,
       now() AT TIME ZONE 'CST' AS cst,
       now() AT TIME ZONE 'CDT' AS cdt,
       now()::timestamp AT TIME ZONE 'EDT' AS timestamp_without_tz,
       now()::timestamptz AT TIME ZONE 'EDT' AS timestamptz;

now
est
edt
cst
cdt
timestamp_without_tz
timestamptz

2024-03-10 21:56:41.364758+00
2024-03-10 16:56:41.364758
2024-03-10 17:56:41.364758
2024-03-10 15:56:41.364758
2024-03-10 16:56:41.364758
2024-03-11 01:56:41.364758+00
2024-03-10 17:56:41.364758

SELECT 1