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?.
7 rows affected
| name | f1 | f2 | f3 | f4 | f5 |
|---|---|---|---|---|---|
| lol | 0 | 1 | 1 | 0 | 0 |
| lol | 0 | 1 | 1 | 0 | 0 |
| lol | 0 | 1 | 1 | 0 | 0 |
| kek | 1 | 1 | 1 | 1 | 0 |
| kek | 2 | 1 | 1 | 0 | 0 |
| kek | 4 | 1 | 1 | 0 | 0 |
| kek | 3 | 1 | 1 | 0 | 0 |
| QUERY PLAN |
|---|
| GroupAggregate (cost=36.79..60.99 rows=200 width=278) (actual time=0.241..0.303 rows=2 loops=1) |
| Group Key: name |
| -> Sort (cost=36.79..38.02 rows=490 width=138) (actual time=0.062..0.064 rows=7 loops=1) |
| Sort Key: name |
| Sort Method: quicksort Memory: 25kB |
| -> Seq Scan on my_table (cost=0.00..14.90 rows=490 width=138) (actual time=0.009..0.010 rows=7 loops=1) |
| Planning time: 0.429 ms |
| Execution time: 0.499 ms |