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
('data from table_01', 'data from table_01'),
('data from table_01', 'data from table_01');
CREATE TABLE table_02 (
column_c VARCHAR,
column_d VARCHAR
);
INSERT INTO table_02
(column_c, column_d)
VALUES
('data from table_02', 'data from table_02');
CREATE TABLE
INSERT 0 2
CREATE TABLE
INSERT 0 1
WITH t1 AS (
SELECT ROW_NUMBER() OVER (),*
FROM table_01
)
SELECT column_a,column_b,column_c,column_d FROM t1
LEFT JOIN (SELECT ROW_NUMBER() OVER (),*
FROM table_02) t2 ON t2.row_number = t1.row_number;
| column_a | column_b | column_c | column_d |
|---|---|---|---|
| data from table_01 | data from table_01 | data from table_02 | data from table_02 |
| data from table_01 | data from table_01 | null | null |
SELECT 2