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?.
4 rows affected
id user_id project_id start_date end_date closed_date
1 1 1 2019-05-27 00:00:00 2021-01-15 00:00:00 null
2 2 2 2020-05-27 00:00:00 2021-02-01 00:00:00 2021-02-05 00:00:00
3 3 3 2020-05-27 00:00:00 2024-02-01 00:00:00 2021-02-05 00:00:00
4 4 4 2020-05-27 00:00:00 2021-03-05 00:00:00 null
month_end count
2021-01-31 4
2021-02-28 3
2021-03-31 1
month_end count
2021-01-31 4
2021-02-28 3
2021-03-31 1