add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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