cursor.comment()¶

On this page

Definition¶

cursor.comment()¶

New in version 3.2.

Adds a comment field to the query.

cursor.comment() has the following syntax:

cursor.comment( <string> )

comment() has the following parameter:

Parameter	Type	Description
`comment`	string	The comment to apply to the query.

Behavior¶

comment() associates a comment string with the find operation. This can make it easier to track a particular query in the following diagnostic outputs:

See configure log verbosity for the mongod log, the Database Profiler tutorial, or the db.currentOp() command.

Example¶

The following operation attaches a comment to a query on the restaurants collection:

db.restaurants.find(
   { "borough" : "Manhattan" }
).comment( "Find all Manhattan restaurants" )

Output Examples¶

`system.profile`¶

The following is an excerpt from the system.profile:

{
   "op" : "query",
   "ns" : "guidebook.restaurant",
   "query" : {
      "find" : "restaurant",
      "filter" : {
         "borough" : "Manhattan"
      },
      "comment" : "Find all Manhattan restaurants"
   },
   ...
}

`mongod` log ¶

The following is an excerpt from the mongod log. It has been formatted for readability.

Important

The verbosity level for QUERY must be greater than 0. See Configure Log Verbosity Levels

2015-11-23T13:09:16.202-0500 I COMMAND  [conn1]
   command guidebook.restaurant command: find {
      find: "restaurant",
      filter: { "borough" : "Manhattan" },
      comment: "Find all Manhattan restaurants"
   }
   ...

`db.currentOp()`¶

Suppose the following operation is currently running on a mongod instance:

db.restaurant.find(
   { "borough" : "Manhattan" }
).comment("Find all Manhattan restaurants")

Running the db.currentOp() command returns the following:

{
   "inprog" : [
      {
         "desc" : "conn5",
         "threadId" : "0x10772e000",
         "connectionId" : 5,
         "client" : "127.0.0.1:62560",
         "active" : true,
         "opid" : 2249279,
         "secs_running" : 0,
         "microsecs_running" : NumberLong(258562),
         "op" : "query",
         "ns" : "guidebook.restaurant",
         "query" : {
            "find" : "restaurant",
            "filter" : { "borough" : "Manhattan" },
            "comment" : "Find all Manhattan restaurants"
         },
         ...
      },
      ...
   ],
   "ok" : 1
}

← cursor.collation() cursor.count() →