Hey everyone, I’m running into a weird issue with ...
# questions-and-troubleshooting
m
Hey everyone, I’m running into a weird issue with my query. For some reason, every time I try to query, for example, a partition with a 5GB bucket, the query profile shows that Max IOTimeRemote is at least 5 times the average IOTimeRemote; for example, the average is 7 seconds, and the max is 48 seconds. For context, I'm using shared-data 3.5.8 and GCS as object storage.
a
What about running an EXPLAIN query to identify the bottleneck? 👀
m
I checked, and it seems to be waiting for the GCS to send the data. I assume it is due to the GCS request limit, but I would love your feedback. Within the IORemoteTime, the max time for segment read matched the IOTimeRemote