Dashboard times out when more than about 24 hours of data is queried

nope. is nodename a field or a tag?

create a bucket + token in influxdb2
enable metric export in Proxmox VE. <--- this section is a concern

how much faster is your query now with the regex change