opt: calculate histogram ranges for more types #70320
Description
As pointed out in #68740, there are more non-numeric types we may be able to calculate a range for when filtering histograms.
Numeric types:
- Interval
- Enum
- Oid
Non-numeric types:
- CollatedStringFamily
- JSONFamily
- ArrayFamily
- TupleFamily
Jira issue: CRDB-10031