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?.
date_start date_end name
2022-01-16 2022-02-01 00:00:00 JANUARY
2022-02-01 2022-03-01 00:00:00 FEBRUARY
2022-03-01 2022-04-01 00:00:00 MARCH
2022-04-01 2022-05-01 00:00:00 APRIL
2022-05-01 2022-06-01 00:00:00 MAY
2022-06-01 2022-07-01 00:00:00 JUNE
2022-07-01 2022-08-01 00:00:00 JULY
2022-08-01 2022-09-01 00:00:00 AUGUST
2022-09-01 2022-10-01 00:00:00 SEPTEMBER
2022-10-01 2022-11-01 00:00:00 OCTOBER
2022-11-01 2022-12-01 00:00:00 NOVEMBER
2022-12-01 2023-01-01 00:00:00 DECEMBER
SELECT 12
date_start date_end name
2022-01-16 2022-01-16 JANUARY
2022-02-16 2022-02-16 FEBRUARY
2022-03-16 2022-03-16 MARCH
2022-04-16 2022-04-16 APRIL
2022-05-16 2022-05-16 MAY
2022-06-16 2022-06-16 JUNE
2022-07-16 2022-07-16 JULY
2022-08-16 2022-08-16 AUGUST
2022-09-16 2022-09-16 SEPTEMBER
2022-10-16 2022-10-16 OCTOBER
2022-11-16 2022-11-16 NOVEMBER
2022-12-16 2022-12-16 DECEMBER
SELECT 12
date_start date_end name
2022-01-16 2022-01-17 00:00:00 01-10
2022-01-17 2022-01-24 00:00:00 01-17
2022-01-24 2022-01-31 00:00:00 01-24
2022-01-31 2022-02-07 00:00:00 01-31
2022-02-07 2022-02-14 00:00:00 02-07
2022-02-14 2022-02-21 00:00:00 02-14
2022-02-21 2022-02-28 00:00:00 02-21
2022-02-28 2022-03-07 00:00:00 02-28
2022-03-07 2022-03-14 00:00:00 03-07
2022-03-14 2022-03-21 00:00:00 03-14
2022-03-21 2022-03-28 00:00:00 03-21
2022-03-28 2022-04-04 00:00:00 03-28
2022-04-04 2022-04-11 00:00:00 04-04
2022-04-11 2022-04-18 00:00:00 04-11
2022-04-18 2022-04-25 00:00:00 04-18
2022-04-25 2022-05-02 00:00:00 04-25
2022-05-02 2022-05-09 00:00:00 05-02
2022-05-09 2022-05-16 00:00:00 05-09
2022-05-16 2022-05-23 00:00:00 05-16
2022-05-23 2022-05-30 00:00:00 05-23
2022-05-30 2022-06-06 00:00:00 05-30
2022-06-06 2022-06-13 00:00:00 06-06
2022-06-13 2022-06-20 00:00:00 06-13
2022-06-20 2022-06-27 00:00:00 06-20
2022-06-27 2022-07-04 00:00:00 06-27
2022-07-04 2022-07-11 00:00:00 07-04
2022-07-11 2022-07-18 00:00:00 07-11
2022-07-18 2022-07-25 00:00:00 07-18
2022-07-25 2022-08-01 00:00:00 07-25
2022-08-01 2022-08-08 00:00:00 08-01
2022-08-08 2022-08-15 00:00:00 08-08
2022-08-15 2022-08-22 00:00:00 08-15
2022-08-22 2022-08-29 00:00:00 08-22
2022-08-29 2022-09-05 00:00:00 08-29
2022-09-05 2022-09-12 00:00:00 09-05
2022-09-12 2022-09-19 00:00:00 09-12
2022-09-19 2022-09-26 00:00:00 09-19
2022-09-26 2022-10-03 00:00:00 09-26
2022-10-03 2022-10-10 00:00:00 10-03
2022-10-10 2022-10-17 00:00:00 10-10
2022-10-17 2022-10-24 00:00:00 10-17
2022-10-24 2022-10-31 00:00:00 10-24
2022-10-31 2022-11-07 00:00:00 10-31
2022-11-07 2022-11-14 00:00:00 11-07
2022-11-14 2022-11-21 00:00:00 11-14
2022-11-21 2022-11-28 00:00:00 11-21
2022-11-28 2022-12-05 00:00:00 11-28
2022-12-05 2022-12-12 00:00:00 12-05
2022-12-12 2022-12-19 00:00:00 12-12
2022-12-19 2022-12-26 00:00:00 12-19
2022-12-26 2023-01-01 00:00:00 12-26
SELECT 51