Postgres 12

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 1 from (values(1))v(i);

?column?

1

SELECT 1

select generate_series(1,10) from (values(1))v(i);

generate_series

1

2

3

4

5

6

7

8

9

10

SELECT 10

select generate_series(1,10);

generate_series

1

2

3

4

5

6

7

8

9

10

SELECT 10

select * from generate_series(1,10);

generate_series

1

2

3

4

5

6

7

8

9

10

SELECT 10