Summary: It would be nice if logging included N1QL text / parameters / etc. Currently, assuming I'm doing it correctly, I only see text like "Sending query cid1::2: http://127.0.0.1:8093/query" in the log message.
- Enable logging in .NET app (e.g. https://developer.couchbase.com/documentation/server/4.5/sdk/dotnet/collecting-information-and-logging.html)
- Execute N1QL query through .NET SDK (e.g. var query = QueryRequest.Create("SELECT b.foo, b.bar FROM `" + _bucket.Name + "` b");
var results = _bucket.Query<FooBar>(query).Rows
- View log file that was setup in step 1
At least "SELECT b.foo. b.bar FROM `mybucket` b" somewhere in the message. Maybe also the scan consistency, parameters, and so on.
All I'm seeing at "DEBUG" level is:
2017-06-01 16:09:32,100  DEBUG Couchbase.N1QL.QueryClient - Sending query cid1::2: http://127.0.0.1:8093/query
2017-06-01 16:09:32,134  DEBUG Couchbase.N1QL.QueryClient - Received query cid1::2: ClientContextId: 1::2Message:
I should note that Linq2Couchbase does output the query text in the logs, so maybe this was a design decision?