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?.
ticket_number datetime status
1 2020-08-03 03:52:58.048196 replied
1 2020-08-02 19:55:49.121455 new
2 2020-07-30 03:52:58.048196 pending
2 2020-07-28 20:15:41.213842 replied
2 2020-07-26 03:52:58.482911 new
3 2020-06-17 19:55:49.394628 closed
3 2020-06-14 03:52:58.513141 replied
3 2020-06-11 19:55:49.242859 new
4 2020-05-14 07:13:50.527481 new
5 2020-05-13 11:24:38.558921 new
status count
closed 1
pending 1
replied 1
new 2