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
4 rows affected
productnumber | productetcetera | priceamount | startdate | enddate |
---|---|---|---|---|
1750 | Price time series sample | 4000 | 2017-06-07 | null |
1750 | Price time series sample | 3000 | 2017-06-05 | 2017-06-07 |
1750 | Price time series sample | 2000 | 2017-06-03 | 2017-06-05 |
1750 | Price time series sample | 1000 | 2017-06-01 | 2017-06-03 |
productnumber | productetcetera | priceamount | startdate | enddate |
---|---|---|---|---|
1750 | Price time series sample | 1000 | 2017-06-01 | 2017-06-03 |