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