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?.
version
PostgreSQL 12.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.4.1 20200928 (Red Hat 8.4.1-1), 64-bit
2 rows affected
the_date
2021-08-29 00:00:00+01
2021-08-30 00:00:00+01
2021-08-31 00:00:00+01
2021-09-01 00:00:00+01
2021-09-02 00:00:00+01
2021-09-03 00:00:00+01
2021-09-04 00:00:00+01
2021-09-05 00:00:00+01
2021-09-06 00:00:00+01
2021-09-07 00:00:00+01
2021-09-08 00:00:00+01
2021-09-09 00:00:00+01
2021-09-10 00:00:00+01
2021-09-11 00:00:00+01
2021-09-12 00:00:00+01
2021-09-13 00:00:00+01
2021-09-14 00:00:00+01
2021-09-15 00:00:00+01
2021-09-16 00:00:00+01
2021-09-17 00:00:00+01
2021-09-18 00:00:00+01
2021-09-19 00:00:00+01
2021-09-20 00:00:00+01
2021-09-21 00:00:00+01
2021-09-22 00:00:00+01
2021-09-23 00:00:00+01
2021-09-24 00:00:00+01
2021-09-25 00:00:00+01
2021-09-26 00:00:00+01
2021-09-27 00:00:00+01
2021-09-28 00:00:00+01
2021-09-29 00:00:00+01
the_date date_part to_char
2021-08-30 00:00:00+01 1 Monday
2021-08-31 00:00:00+01 2 Tuesday
2021-09-01 00:00:00+01 3 Wednesday
2021-09-02 00:00:00+01 4 Thursday
2021-09-03 00:00:00+01 5 Friday
2021-09-06 00:00:00+01 1 Monday
2021-09-07 00:00:00+01 2 Tuesday
2021-09-08 00:00:00+01 3 Wednesday
2021-09-09 00:00:00+01 4 Thursday
2021-09-10 00:00:00+01 5 Friday
2021-09-13 00:00:00+01 1 Monday
2021-09-14 00:00:00+01 2 Tuesday
2021-09-15 00:00:00+01 3 Wednesday
2021-09-16 00:00:00+01 4 Thursday
2021-09-17 00:00:00+01 5 Friday
2021-09-20 00:00:00+01 1 Monday
2021-09-21 00:00:00+01 2 Tuesday
2021-09-22 00:00:00+01 3 Wednesday
2021-09-23 00:00:00+01 4 Thursday
2021-09-24 00:00:00+01 5 Friday
2021-09-27 00:00:00+01 1 Monday
2021-09-28 00:00:00+01 2 Tuesday
2021-09-29 00:00:00+01 3 Wednesday
date
2021-01-01 00:00:00
2021-01-02 00:00:00
2021-01-03 00:00:00
2021-01-04 00:00:00
2021-01-05 00:00:00
2021-01-08 00:00:00
2021-01-09 00:00:00
2021-01-10 00:00:00
2021-01-11 00:00:00
2021-01-12 00:00:00
2021-01-15 00:00:00
2021-01-16 00:00:00
2021-01-17 00:00:00
2021-01-18 00:00:00
2021-01-19 00:00:00
2021-01-22 00:00:00
2021-01-23 00:00:00
2021-01-24 00:00:00
2021-01-25 00:00:00
2021-01-26 00:00:00
2021-01-29 00:00:00
2021-01-30 00:00:00
2021-01-31 00:00:00
2021-02-01 00:00:00
2021-02-02 00:00:00
the_date rn
2021-08-29 00:00:00+01 1
2021-08-30 00:00:00+01 2
2021-08-31 00:00:00+01 3
2021-09-01 00:00:00+01 4
2021-09-02 00:00:00+01 5
2021-09-03 00:00:00+01 6
2021-09-04 00:00:00+01 7
2021-09-05 00:00:00+01 8
2021-09-06 00:00:00+01 9
2021-09-07 00:00:00+01 10
2021-09-08 00:00:00+01 11
2021-09-09 00:00:00+01 12
2021-09-10 00:00:00+01 13
2021-09-11 00:00:00+01 14
2021-09-12 00:00:00+01 15
2021-09-13 00:00:00+01 16
2021-09-14 00:00:00+01 17
2021-09-15 00:00:00+01 18
2021-09-16 00:00:00+01 19
2021-09-17 00:00:00+01 20
2021-09-18 00:00:00+01 21
2021-09-19 00:00:00+01 22
2021-09-20 00:00:00+01 23
2021-09-21 00:00:00+01 24
2021-09-22 00:00:00+01 25
2021-09-23 00:00:00+01 26
2021-09-24 00:00:00+01 27
2021-09-25 00:00:00+01 28
2021-09-26 00:00:00+01 29
2021-09-27 00:00:00+01 30
2021-09-28 00:00:00+01 31
2021-09-29 00:00:00+01 32
the_date rn mod7 to_char
2021-08-29 00:00:00+01 1 1 Sunday
2021-08-30 00:00:00+01 2 2 Monday
2021-08-31 00:00:00+01 3 3 Tuesday
2021-09-01 00:00:00+01 4 4 Wednesday
2021-09-02 00:00:00+01 5 5 Thursday
2021-09-05 00:00:00+01 8 1 Sunday
2021-09-06 00:00:00+01 9 2 Monday
2021-09-07 00:00:00+01 10 3 Tuesday
2021-09-08 00:00:00+01 11 4 Wednesday
2021-09-09 00:00:00+01 12 5 Thursday
2021-09-12 00:00:00+01 15 1 Sunday
2021-09-13 00:00:00+01 16 2 Monday
2021-09-14 00:00:00+01 17 3 Tuesday
2021-09-15 00:00:00+01 18 4 Wednesday
2021-09-16 00:00:00+01 19 5 Thursday
2021-09-19 00:00:00+01 22 1 Sunday
2021-09-20 00:00:00+01 23 2 Monday
2021-09-21 00:00:00+01 24 3 Tuesday
2021-09-22 00:00:00+01 25 4 Wednesday
2021-09-23 00:00:00+01 26 5 Thursday
2021-09-26 00:00:00+01 29 1 Sunday
2021-09-27 00:00:00+01 30 2 Monday
2021-09-28 00:00:00+01 31 3 Tuesday
2021-09-29 00:00:00+01 32 4 Wednesday