Navigation

Get Slow Query Logs

Retrieves log lines for slow queries as determined by the Performance Advisor.

Note

Performance Advisor users must have the necessary access privileges to view performance data. Users who do not have the necessary permissions will not be able to view any log data in the slowQueryLogs API endpoint responses.

Base URL: https://{OPSMANAGER-HOST}:{PORT}/api/public/v1.0

Resource

GET /groups/{GROUP-ID}/hosts/{HOST-ID}/performanceAdvisor/slowQueryLogs

Request Path Parameters

Parameter Type Description
GROUP-ID string (Required.) Unique identifier of the group that owns this MongoDB process.
HOST-ID string (Required.) Unique identifier of the host for the MongoDB process.

Request Query Parameters

All parameters are optional.

pretty boolean Indicates whether the response body should be in a prettyprint format. false
envelope boolean Indicates whether or not to wrap the response in an envelope. false
since long Point in time from which to retrieve slow query logs, stated in milliseconds since epoch. previous 24 hours
duration long Length of time in milliseconds during which to find slow query logs among the managed namespaces in the cluster. up to the present time
namespaces string

Namespaces from which to retrieve suggested slow query logs. A namespace consists of the database and collection resource separated by a ., such as <database>.<collection>.

To specify multiple namespaces, pass the parameter multiple times using an ampersand (&) as a delimiter, once for each namespace.

Example

?namespaces=data.stocks&namespaces=data.zips&pretty=true

all
nLogs long Maximum number of log lines to return. 20000

Request Body Parameters

This endpoint does not use HTTP request body parameters.

Response

Name Type Description
slowQueries array of documents A list of documents with information about slow queries as detected by the Performance Advisor.
slowQueries[n].line string The raw log line pertaining to the slow query.
slowQueries[n].namespace string The namespace in which the slow query ran.

Example Request

curl --user '{USERNAME}:{APIKEY}' --digest \
 --header 'Accept: application/json' \
 --include \
 --request GET 'https://{OPSMANAGER-HOST}:{PORT}/api/public/v1.0/groups/{GROUP-ID}/hosts/{HOST-ID}/performanceAdvisor/slowQueryLogs?pretty=true'

Example Response

Response Header

HTTP/1.1 401 Unauthorized
Content-Type: application/json;charset=ISO-8859-1
Date: {dateInUnixFormat}
WWW-Authenticate: Digest realm="MMS Public API", domain="", nonce="{nonce}", algorithm=MD5, op="auth", stale=false
Content-Length: {requestLengthInBytes}
Connection: keep-alive
HTTP/1.1 200 OK
Vary: Accept-Encoding
Content-Type: application/json
Strict-Transport-Security: max-age=300
Date: {dateInUnixFormat}
Connection: keep-alive
Content-Length: {requestLengthInBytes}

Response Body

{
  "slowQueries" : [ {
    "line" : "2018-08-16T22:53:43.447+0000 I COMMAND  [conn10614] command myDb.users appName: \"MongoDB Shell\" command: find { find: \"users\", filter: { emails: \"tocde@fijoow.to\" }, lsid: { id: UUID(\"832b4b0e-085a-480e-b470-16a0994dc7cb\") }, $clusterTime: { clusterTime: Timestamp(1534460016, 1)...",
   "namespace" : "myDb.users"
  }, {
    "line" : "2018-08-16T22:54:32.705+0000 I COMMAND  [conn10614] command myDb.users appName: \"MongoDB Shell\" command: find { find: \"users\", filter: { emails: \"la@sa.kp\" }, lsid: { id: UUID(\"832b4b0e-085a-480e-b470-16a0994dc7cb\") }, $clusterTime: { clusterTime: Timestamp(1534460056, 1), ...",
    "namespace" : "myDb.users"
  } ]
}