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
INSERT 0 3
id | num_nulls |
---|---|
1 | 2 |
2 | 0 |
3 | 1 |
SELECT 3
id | num_nulls |
---|---|
1 | 2 |
2 | 0 |
3 | 1 |
SELECT 3
CREATE FUNCTION
attrelid | attname | atttypid | attstattarget | attlen | attnum | attndims | attcacheoff | atttypmod | attbyval | attalign | attstorage | attcompression | attnotnull | atthasdef | atthasmissing | attidentity | attgenerated | attisdropped | attislocal | attinhcount | attcollation | attacl | attoptions | attfdwoptions | attmissingval |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1255 | oid | 26 | -1 | 4 | 1 | 0 | -1 | -1 | t | i | p | t | f | f | f | t | 0 | 0 | null | null | null | null | |||
1255 | proname | 19 | -1 | 64 | 2 | 0 | -1 | -1 | f | c | p | t | f | f | f | t | 0 | 950 | null | null | null | null | |||
1255 | pronamespace | 26 | -1 | 4 | 3 | 0 | -1 | -1 | t | i | p | t | f | f | f | t | 0 | 0 | null | null | null | null |
SELECT 3
f_num_nulls |
---|
4 |
4 |
4 |
SELECT 3
column1 | column2 | column3 | column4 | column5 | num_nulls |
---|---|---|---|---|---|
null | hi | 2 | null | null | 2 |
null | hi | 2 | null | null | 2 |
hi | 2 | 3 | test | 0 | |
null | hi | 2 | 3 | null | 1 |
SELECT 4
column1 | column2 | column3 | column4 | column5 | j | num_nulls1 | num_nulls2 | num_nulls3 |
---|---|---|---|---|---|---|---|---|
null | hi | 2 | null | null | {"column1":null,"column2":"hi","column3":2,"column4":null,"column5":"null"} | 2 | 2 | 2 |
null | hi | 2 | null | null | {"column1":null,"column2":"hi","column3":2,"column4":null,"column5":"null"} | 2 | 2 | 2 |
hi | 2 | 3 | test | {"column1":"","column2":"hi","column3":2,"column4":3,"column5":"test"} | 0 | 0 | 0 | |
null | hi | 2 | 3 | null | {"column1":null,"column2":"hi","column3":2,"column4":3,"column5":"null"} | 1 | 1 | 1 |
SELECT 4