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 13.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.4.1 20200928 (Red Hat 8.4.1-1), 64-bit |
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 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 |
| |text|123|456| | null | null |
| 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 |
| |text|123|456| | null | null |
| QUERY PLAN |
|---|
| Seq Scan on public.t (cost=0.00..1.06 rows=6 width=37) (actual time=0.005..0.006 rows=6 loops=1) |
| Output: a, b, c |
| Buffers: shared hit=1 |
| Planning Time: 0.024 ms |
| Execution Time: 0.015 ms |