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 2
| txn_id | description |
|---|---|
| 3332654 | CAD@10.00@0.9397@$10.64@THB@150.00@23.8235@$6.30@KRW@36,000.00@860.3722@$41.84@FJD@20.00@1.5711@$12.73@EUR@5.00@0.6013@$8.32@SGP@15.00@10.6013@$18.32 |
| 3332655 | CAD@11.00@0.8197@$11.64@THB@110.00@21.8135@$61.30@KRW@36,001.00@861.3722@$411.84@FJD@21.00@11.5711@$11.73 |
SELECT 2
| txn_id | cncy_cd | txn_cncy_amt | txn_exch_rate | txn_nzd_amt |
|---|---|---|---|---|
| 3332654 | SGP | 15.00 | 10.6013 | $18.32 |
| 3332654 | EUR | 5.00 | 0.6013 | $8.32 |
| 3332654 | KRW | 36,000.00 | 860.3722 | $41.84 |
| 3332655 | KRW | 36,001.00 | 861.3722 | $411.84 |
| 3332654 | THB | 150.00 | 23.8235 | $6.30 |
| 3332654 | FJD | 20.00 | 1.5711 | $12.73 |
| 3332654 | CAD | 10.00 | 0.9397 | $10.64 |
| 3332655 | FJD | 21.00 | 11.5711 | $11.73 |
| 3332655 | CAD | 11.00 | 0.8197 | $11.64 |
| 3332655 | THB | 110.00 | 21.8135 | $61.30 |
SELECT 10