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?.
col |
---|
1 |
null |
count(*) | count(col) | count(tbl) | count(tbl.*) | count((tbl.*)) | count(ROW(col)) |
---|---|---|---|---|---|
2 | 1 | 2 | 2 | 2 | 2 |
col | tbl IS NULL | tbl.* IS NULL | (tbl.*) IS NULL | ROW(col) IS NULL | col IS NULL |
---|---|---|---|---|---|
1 | f | f | f | f | f |
null | t | t | t | t | t |
id | col |
---|---|
1 | 1 |
2 | null |
count(*) | count(col) | count(sub) | count(sub.*) | count((sub.*)) | count(ROW(col)) |
---|---|---|---|---|---|
2 | 1 | 2 | 2 | 2 | 2 |
composite |
---|
(1,2) |
(,) |
count |
---|
2 |
composite | composite IS NULL |
---|---|
(1,2) | f |
(,) | t |