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?.
version |
---|
PostgreSQL 14.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-4), 64-bit |
7 rows affected
a | b | c |
---|---|---|
|3|3| some stuff here | 3 | 3 |
|SE + 18.5D some other stuff | null | null |
|54|45| yet more stuff | 54 | 45 |
|32|23| yet more |78|78| stuff | 32 | 23 |
|This is more text |11|111|22222||| and stuff ||||||| | null | null |
|1 1|1 1 1|22222| | null | null |
|7125341246362562654562465|ahgsdfhgasfghasf | null | null |