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 type e as enum ('en', 'ru');
CREATE TABLE t1 (
c00 TIMESTAMP (0) WITH TIME ZONE DEFAULT clock_timestamp(),
c0 TIMESTAMP (0) WITH TIME ZONE DEFAULT clock_timestamp(),
c1 INTEGER DEFAULT 1,
c2 INTEGER DEFAULT 1,
c3 INTEGER DEFAULT 1,
c4 INTEGER DEFAULT 1,
c5 DATE DEFAULT '2018-12-31',
c6 DATE DEFAULT '2018-12-31',
c7 e DEFAULT 'en',
c8 e DEFAULT 'en',
c9 e DEFAULT 'en',
c10 VARCHAR(100) DEFAULT 'en',
c11 VARCHAR(100) DEFAULT 'en',
c12 VARCHAR(100) DEFAULT 'en',
c13 VARCHAR(50) DEFAULT 'en',
c14 VARCHAR(50) DEFAULT 'en',
c15 VARCHAR(50) DEFAULT 'en',
c16 VARCHAR(50) DEFAULT 'en',
c17 VARCHAR(50) DEFAULT 'en',
c18 VARCHAR(50) DEFAULT 'en',
c19 VARCHAR(20) DEFAULT 'en',
c20 VARCHAR(20) DEFAULT 'en'
);
INSERT INTO t1 VALUES (DEFAULT);
1 rows affected
CREATE TABLE t2 (
c1 INTEGER DEFAULT 1,
c2 INTEGER DEFAULT 1,
c13 VARCHAR(50) DEFAULT 'en',
c5 DATE DEFAULT '2018-12-31',
c3 INTEGER DEFAULT 1,
c12 VARCHAR(100) DEFAULT 'en',
c4 INTEGER DEFAULT 1,
c9 e DEFAULT 'en',
c6 DATE DEFAULT '2018-12-31',
c11 VARCHAR(100) DEFAULT 'en',
c14 VARCHAR(50) DEFAULT 'en',
c19 VARCHAR(20) DEFAULT 'en',
c15 VARCHAR(50) DEFAULT 'en',
c20 VARCHAR(20) DEFAULT 'en',
c16 VARCHAR(50) DEFAULT 'en',
c10 VARCHAR(100) DEFAULT 'en',
c7 e DEFAULT 'en',
c17 VARCHAR(50) DEFAULT 'en',
c8 e DEFAULT 'en',
c18 VARCHAR(50) DEFAULT 'en',
c00 TIMESTAMP (0) WITH TIME ZONE DEFAULT clock_timestamp(),
c0 TIMESTAMP (0) WITH TIME ZONE DEFAULT clock_timestamp()
);
INSERT INTO t2 values(DEFAULT);
1 rows affected
select * from t1;
| c00 | c0 | c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | c9 | c10 | c11 | c12 | c13 | c14 | c15 | c16 | c17 | c18 | c19 | c20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2019-01-03 15:51:49+00 | 2019-01-03 15:51:49+00 | 1 | 1 | 1 | 1 | 2018-12-31 | 2018-12-31 | en | en | en | en | en | en | en | en | en | en | en | en | en | en |
select * from t2;
| c1 | c2 | c13 | c5 | c3 | c12 | c4 | c9 | c6 | c11 | c14 | c19 | c15 | c20 | c16 | c10 | c7 | c17 | c8 | c18 | c00 | c0 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | en | 2018-12-31 | 1 | en | 1 | en | 2018-12-31 | en | en | en | en | en | en | en | en | en | en | en | 2019-01-03 15:51:50+00 | 2019-01-03 15:51:50+00 |
SELECT pg_column_size(t1) as t1 FROM t1;
| t1 |
|---|
| 109 |
SELECT pg_column_size(t2) as t2 FROM t2;
| t2 |
|---|
| 120 |