Postgres 9.6

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 to_char('2018-11-01 15:21:24'::timestamp, 'YYYY-MM-DDTHH24:MI:SSZ')

to_char

2018-11-01STH24:21:24Z

SELECT 1

SELECT to_char('2018-11-04 15:21:24'::timestamp, 'YYYY-MM-DDTHH24:MI:SSZ')

to_char

2018-11-04THH24:21:24Z

SELECT 1

SELECT to_char('2018-11-01 15:21:24'::timestamp, 'YYYY-MM-DDTH')

to_char

2018-11-01ST

SELECT 1

SELECT to_char('2018-11-04 15:21:24'::timestamp, 'YYYY-MM-DDTH')

to_char

2018-11-04TH

SELECT 1

SELECT to_char('2018-11-01 15:21:24'::timestamp, 'YYYY-MM-DD"T"HH24:MI:SSZ')

to_char

2018-11-01T15:21:24Z

SELECT 1