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?.
| attrelid | attname | atttypid | attstattarget | attlen | attnum | attndims | attcacheoff | atttypmod | attbyval | attstorage | attalign | attnotnull | atthasdef | attidentity | attisdropped | attislocal | attinhcount | attcollation | attacl | attoptions | attfdwoptions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1255 | proname | 19 | -1 | 64 | 1 | 0 | -1 | -1 | f | p | c | t | f | f | t | 0 | 0 | null | null | null | |
| 1255 | pronamespace | 26 | -1 | 4 | 2 | 0 | -1 | -1 | t | p | i | t | f | f | t | 0 | 0 | null | null | null | |
| 1255 | proowner | 26 | -1 | 4 | 3 | 0 | -1 | -1 | t | p | i | t | f | f | t | 0 | 0 | null | null | null |
| f_num_nulls |
|---|
| 3 |
| 3 |
| 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 |
| 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 |