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

654 views Asked by At

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.

1

There are 1 answers

1
Simon Baslé On BEST ANSWER

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.