How to track query execution time in N1QL of couchbase server?

Question

Is there any easy way to get query time in couchbase server's N1QL like .explain() in mongodb?

I have a query like SELECT c.name, c.description from customer c and I would like to trace the time.

Answer 1

in N1QL, responses are JSON and include metadata. the metrics field contains statistics, including the time taken to execute the query (so notably elapsedTime and executionTime).

in the 2.2.0 developer preview of the Java SDK, you can access these metrics as a QueryMetrics object using the info() method on the QueryResult.