Couchbase Execution Plan in UI

Couchbase Server
1

Hi Team,

While checking the plan of an NQL query in UI, a percentage is showing in each phase. The percentage is in terms of the time the entire query is taking or what it actually is. While checking the plan in text mode there is no such percentage. The screenshot
UI_Plan
is attached for your reference.

Thanks,
Debasis

2

That is the percentage of the sum of all “#time_absolute” figures in the plan. “#time_absolute” is just the execution time (“execTime”) as seconds (rather than variable units).

You can get the exec time outside the Query Workbench (e.g. using the REST API) by setting the request parameter “profile” to “timings”. (“#time_absolute” is a Workbench conversion.)

HTH.

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.