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?.
100000 rows affected
i | b | f1 | f2 | f3 | f4 |
---|---|---|---|---|---|
1 | 1 | 1 | 1 | 1 | 1 |
3 | 11 | 3 | 3 | 3 | 3 |
0 | null | 0 | 0 | 0 | |
13 | 1101 | 13 | 13 | 13 | 13 |
29 | 11101 | 29 | 29 | 29 | 29 |
23 | 10111 | 23 | 23 | 23 | 23 |
113 | 1110001 | 113 | 113 | 113 | 113 |
178 | 10110010 | 178 | 178 | 178 | 178 |
456 | 111001000 | 456 | 456 | 456 | 456 |
746 | 1011101010 | 746 | 746 | 746 | 746 |
QUERY PLAN |
---|
Seq Scan on t (actual rows=100000 loops=1) |
Planning Time: 0.061 ms |
Execution Time: 31.859 ms |
QUERY PLAN |
---|
Seq Scan on t (actual rows=100000 loops=1) |
Planning Time: 0.578 ms |
Execution Time: 48.529 ms |
QUERY PLAN |
---|
Seq Scan on t (actual rows=100000 loops=1) |
Planning Time: 0.088 ms |
Execution Time: 104.304 ms |
QUERY PLAN |
---|
Seq Scan on t (actual rows=100000 loops=1) |
Planning Time: 0.095 ms |
Execution Time: 97.314 ms |