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?.
3 rows affected
cust_id | generate_series | subs_price_p_month |
---|---|---|
1 | 2019-01-01 00:00:00+00 | 50.00 |
1 | 2019-02-01 00:00:00+00 | 50.00 |
1 | 2019-03-01 00:00:00+00 | 50.00 |
1 | 2019-04-01 00:00:00+01 | 50.00 |
1 | 2019-05-01 00:00:00+01 | 50.00 |
1 | 2019-06-01 00:00:00+01 | 50.00 |
1 | 2019-07-01 00:00:00+01 | 50.00 |
1 | 2019-08-01 00:00:00+01 | 50.00 |
1 | 2019-09-01 00:00:00+01 | 50.00 |
1 | 2019-10-01 00:00:00+01 | 50.00 |
1 | 2019-11-01 00:00:00+00 | 50.00 |
1 | 2019-12-01 00:00:00+00 | 50.00 |
1 | 2020-02-03 00:00:00+00 | 39.99 |
1 | 2020-03-03 00:00:00+00 | 39.99 |
1 | 2020-04-03 00:00:00+01 | 39.99 |
1 | 2020-05-03 00:00:00+01 | 39.99 |
1 | 2020-06-03 00:00:00+01 | 39.99 |
1 | 2020-07-03 00:00:00+01 | 39.99 |
1 | 2020-08-03 00:00:00+01 | 39.99 |
2 | 2019-12-11 00:00:00+00 | 29.99 |
2 | 2020-01-11 00:00:00+00 | 29.99 |
2 | 2020-02-11 00:00:00+00 | 29.99 |
2 | 2020-03-11 00:00:00+00 | 29.99 |
2 | 2020-04-11 00:00:00+01 | 29.99 |
2 | 2020-05-11 00:00:00+01 | 29.99 |
2 | 2020-06-11 00:00:00+01 | 29.99 |
2 | 2020-07-11 00:00:00+01 | 29.99 |
2 | 2020-08-11 00:00:00+01 | 29.99 |
2 | 2020-09-11 00:00:00+01 | 29.99 |
2 | 2020-10-11 00:00:00+01 | 29.99 |
cust_id | subs_price_p_month |
---|---|
1 | January 2019 |
1 | February 2019 |
1 | March 2019 |
1 | April 2019 |
1 | May 2019 |
1 | June 2019 |
1 | July 2019 |
1 | August 2019 |
1 | September 2019 |
1 | October 2019 |
1 | November 2019 |
1 | December 2019 |
1 | February 2020 |
1 | March 2020 |
1 | April 2020 |
1 | May 2020 |
1 | June 2020 |
1 | July 2020 |
1 | August 2020 |
2 | December 2019 |
2 | January 2020 |
2 | February 2020 |
2 | March 2020 |
2 | April 2020 |
2 | May 2020 |
2 | June 2020 |
2 | July 2020 |
2 | August 2020 |
2 | September 2020 |
2 | October 2020 |