CODEWITHSUNDEEP
amazon-web-servicesamazon-athena
Cornelius Roemer
Cornelius Roemer

Reputation: 8228

Athena Query Queuing Time: What affects it?

I've started using Athena recently and it appears useful. However, one thing that bugs me is that Query Queuing times can sometimes be very long (around a minute). At other times, queries are executed almost immediately.

I have not been able to identify reasons why queries sometimes queue for so long, and not at other times. The only thing I noticed is that Table Creation and other DDL statements don't queue for long.

What are the factors that affect queuing time? Server load? Query length? Query complexity?

How can I reduce queuing time? There's no information on this available in the documents as far as I'm aware.

Upvotes: 1

Views: 2489

Answers (1)

Kaplan Ilya
Kaplan Ilya

Reputation: 703

Around a minute it's not that long. We had a few weeks during which we had a random queuing time up to 10m. After a lot of back-and-forth with the support they finally tweaked something and queuing time was reduced to up to 1m, with average 10s. The queuing is unrelated to your specific query or even "max concurrent queries" settings on your account, it's related to global region Athena load and many other hidden settings that AWS engineers can tweak.

Upvotes: 2

Related Questions