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
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
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
policy_id payment_date premium yearly_payment_freq monthly_premium_desired grp monthly_premium_calculated
1 2014-10-01 120 12 120 1 120
1 2014-11-01 360 4 120 2 120
1 2014-12-01 0 4 120 2 120
1 2015-01-01 0 4 120 2 120
1 2015-02-01 360 4 120 3 120
1 2015-03-01 0 4 120 3 120
1 2015-04-01 0 4 120 3 120
1 2015-05-01 720 2 120 4 120
1 2015-06-01 0 2 120 4 120
1 2015-07-01 0 2 120 4 120
1 2015-08-01 0 2 120 4 120
1 2015-09-01 0 2 120 4 120
1 2015-10-01 0 2 120 4 120
1 2015-11-01 120 12 120 5 120
2 2015-01-01 60 3 15 1 15
2 2015-02-01 0 3 15 1 15
2 2015-03-01 0 3 15 1 15
2 2015-04-01 0 3 15 1 15
2 2015-05-01 180 1 15 2 15
2 2015-06-01 0 1 15 2 15
2 2015-07-01 0 1 15 2 15
2 2015-08-01 0 1 15 2 15
2 2015-09-01 0 1 15 2 15
2 2015-10-01 0 1 15 2 15
2 2015-11-01 0 1 15 2 15
2 2015-12-01 0 1 15 2 15
2 2016-01-01 0 1 15 2 15
2 2016-02-01 0 1 15 2 15
2 2016-03-01 0 1 15 2 15
2 2016-04-01 0 1 15 2 15
2 2016-05-01 15 12 15 3 15
2 2016-06-01 15 12 15 4 15