Postgres 13

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?.

CREATE TABLE table_01 (
  column_a VARCHAR,
  column_b VARCHAR
);

INSERT INTO table_01 
    (column_a, column_b) 
VALUES 
    ('row_1 from table_01', 'row_1 from table_01'),
    ('row_2 from table_01', 'row_2 data from table_01');

CREATE TABLE table_02 (
  column_c VARCHAR,
  column_d VARCHAR
);

INSERT INTO table_02 
    (column_c, column_d) 
VALUES 
    ('row_1 from table_02', 'row_1 from table_02');
2 rows affected

1 rows affected

SELECT * FROM table_01


column_a
column_b


row_1 from table_01
row_1 from table_01

row_2 from table_01
row_2 data from table_01


SELECT * FROM table_02


column_c
column_d


row_1 from table_02
row_1 from table_02

column_a	column_b
row_1 from table_01	row_1 from table_01
row_2 from table_01	row_2 data from table_01