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 |