Postgres 10

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 10.23 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-15), 64-bit

SELECT 1

create table test(f1 int, f2 int);
insert into test values(1,2);

CREATE TABLE

INSERT 0 1

select concat(f1,'/',f2) from test;

concat

1/2

SELECT 1

select concat(2,'/',32) as "Fraction"

Fraction

2/32

SELECT 1