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
id | cnt | rel_id |
---|---|---|
PS291 | 6.606 | PS479 |
PS377 | 1.335 | PS479 |
PS386 | 0.867 | PS377 |
PS479 | 14.756 | PS606 |
PS650 | 0.297 | PS667 |
PS667 | 3.409 | PS479 |
PS779 | 0.224 | PS479 |
id | cnt |
---|---|
PS291 | 21.362 |
PS291 | 6.606 |
PS377 | 1.335 |
PS377 | 16.091 |
PS386 | 16.958 |
PS386 | 0.867 |
PS386 | 2.202 |
PS479 | 14.756 |
PS650 | 3.706 |
PS650 | 0.297 |
PS650 | 18.462 |
PS667 | 3.409 |
PS667 | 18.165 |
PS779 | 0.224 |
PS779 | 14.98 |