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
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
version |
---|
PostgreSQL 14.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit |
continous_contract | contract_days | client_id | contract_id | autopay_status | start_date | end_date |
---|---|---|---|---|---|---|
t | 183 | 1 | 1111 | Inactive | 2019-08-30 | 2020-02-29 |
t | 182 | 1 | 1112 | Inactive | 2020-02-29 | 2020-08-29 |
t | 183 | 1 | 1113 | Active | 2020-08-29 | 2021-02-28 |
t | 183 | 2 | 2221 | Inactive | 2019-08-30 | 2020-02-29 |
t | 182 | 2 | 2222 | Inactive | 2020-02-29 | 2020-08-29 |
t | 183 | 2 | 2223 | Active | 2020-08-29 | 2021-02-28 |
t | 183 | 3 | 3331 | Inactive | 2019-08-30 | 2020-02-29 |
f | 184 | 3 | 3332 | Inactive | 2020-03-29 | 2020-09-29 |
t | 180 | 3 | 3333 | Inactive | 2020-09-29 | 2021-03-28 |
f | 183 | 3 | 3334 | Inactive | 2021-04-28 | 2021-10-28 |
t | 182 | 3 | 3335 | Inactive | 2021-10-28 | 2022-04-28 |
t | 183 | 3 | 3336 | Active | 2022-04-28 | 2022-10-28 |