AWS TimeStream Does TimeUnit influence the Query performance?

Yes, the TimeUnit on the timestamp can affect the query performance. If you only care about the minute the records were saved, then using the TimeUnit as second or miliseconds will make a difference in query performance.

When you use a lower TimeUnit, the query engine has to scan more data to find the records that match your criteria. This can lead to slower query performance.

For example, if you have 1M records and you use the TimeUnit as second, the query engine will have to scan 60 times more data than if you used the TimeUnit as minute. This can lead to a significant performance difference, especially for large datasets.

To improve query performance, you should use the highest TimeUnit that is still accurate enough for your application. In your case, since you only care about the minute the records were saved, you should use the TimeUnit as minute.