We did benchmarks a while back comparing TimescaleDB to Mongo[1], and TimescaleDB was quite a bit better. So I think you'd definitely see much improved query time.

Also it appears that Metabase supports a PostgreSQL connection[2], so you could probably continue to use it.

[1] https://blog.timescale.com/how-to-store-time-series-data-mon...

[2] https://metabase.com/docs/latest/operations-guide/start.html...