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

    CREATE TABLE sample
    (
      x INTEGER,    -- always have to specify a non-null value for x and y!
      y VARCHAR(10),
      z INTEGER NOT NULL DEFAULT 3,
      w TIMESTAMP,
      v TIMESTAMP NOT NULL DEFAULT NOW()
    );
INSERT INTO sample VALUES (34);
1 rows affected

SELECT * FROM sample;


x
y
z
w
v


34
null
3
null
2018-05-21 12:58:59.972643