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?.
genre | hit_movies | total_collection |
---|---|---|
horror | 0 | 0 |
action | 0 | 0 |
rom-com | 4 | 120 |
sci-fi | 2 | 180 |