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?.
CREATE TABLE
INSERT 0 3
| fund_type | fund_name | fund_value | sign_val |
|---|---|---|---|
| INR | Y | fund6 | - |
| INR | Y | fund5 | - |
| INR | N | fund4 | - |
| INR | Y | fund3 | - |
| INR | N | fund2 | - |
| INR | N | fund1 | - |
| SGP | Y | fund1 | - |
| SGP | N | fund2 | - |
| SGP | N | fund3 | - |
| SGP | N | fund4 | - |
| SGP | Y | fund5 | - |
| SGP | N | fund6 | - |
| USD | N | fund6 | + |
| USD | Y | fund5 | + |
| USD | Y | fund4 | + |
| USD | Y | fund3 | + |
| USD | N | fund2 | + |
| USD | Y | fund1 | + |
SELECT 18