What is the difference between "execution time" and "elapsed time" in the logs?

Follow

 

 

In the logs, the "execution time" is the time the query required to execute where "elapsed time" is the time from the when AMPS first receives the query (it incorporates the time taken for parallel query execution).  

Neither include the network trips to/from the client.

The "elapsed time" can be longer than the "execution time" for a # of reasons including that its part of a larger parallel query or there could be many queries from the same client that is causing queries to be serialized.

AMPS batches queries for efficiency so the overall delivery for everyone is much faster than having the queries performed sequentially.

Have more questions? Submit a request

Comments

Powered by Zendesk