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?.
11 rows affected
| num | arr | expected | t_simple | t_safe1 | t_safe2 | t_smart1 | t_smart2 | t_93a | t_93b | t_93c | t_94 | t_95a | t_95b | t_95c |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | {1,2,NULL} | t | t | t | t | t | t | t | t | t | t | t | t | t |
| 2 | {-1,NULL,2} | t | f | t | t | t | t | t | t | t | t | t | t | t |
| 3 | {NULL} | t | t | t | t | t | t | t | t | null | t | t | t | t |
| 4 | {1,2,3} | f | f | f | f | f | f | f | f | f | f | f | f | f |
| 5 | {-1,2,3} | f | f | f | f | f | f | f | f | f | f | f | f | f |
| 6 | null | null | t | null | f | null | t | null | null | null | null | f | f | null |
| num | arr | expected | t_simple | t_safe1 | t_safe2 | t_smart | t_93a |
|---|---|---|---|---|---|---|---|
| 1 | {1,2,NULL} | t | t | t | t | t | t |
| 2 | {-1,NULL,2} | t | f | t | t | t | t |
| 3 | {NULL} | t | t | t | t | t | t |
| 4 | {1,2,3} | f | f | f | f | f | f |
| 5 | {-1,2,3} | f | f | f | f | f | f |
| 6 | null | null | t | null | f | t | null |
| 11 | {{1,2,3},{1,2,NULL}} | t | t | t | t | t | t |
| 12 | {{1,2,3},{-1,2,NULL}} | t | f | t | t | t | t |
| 13 | {{NULL},{NULL}} | t | t | t | t | t | t |
| 14 | {{1,2,3},{1,2,3}} | f | f | f | f | f | f |
| 15 | {{-1,2,3},{1,2,3}} | f | f | f | f | f | f |