Get completed query text from Admin WebUI Query Monitor

Couchbase Server
1

Is there a way to extract query text from Admin WebUI-Query-Monitor-Completed? I can see it when hovering over but can’t select to copy the text. Completed tab unlike Active does not have Edit option.
Motivation: The Monitor shows unexpected execution plan for long running queries which I want to investigate.
Community Edition 7.1.0 build 2556
Microsoft Edge Version 109.0.1518.115
Please help me to get exact text highlighted below

image

2

The text presented is just the results from:

select * from system:completed_requests

which you can run directly (and can add filters etc. to suit).

If you want the plan you have to select it directly:

select *,meta().plan from system:completed_requests where ...

HTH.

3

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