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?.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
share_of_value_of_owner | share_of_value_of_cars |
---|---|
22.2200 % | 18.1800 % |
55.5600 % | 45.4500 % |
22.2200 % | 18.1800 % |
100.0000 % | 18.1800 % |
1 rows affected
1 rows affected
1 rows affected
share_of_value_of_owner | share_of_value_of_cars |
---|---|
50.0000 % | 33.3300 % |
50.0000 % | 33.3300 % |
100.0000 % | 33.3300 % |