Are there metrics to understand query performance?

Yes. You can see things like the number of subqueries, how many segments were processed on each server, how long it took to process each segment, and more. Read more about query metrics here, and here’s a bit of context.