profile

Definition

profile

Changed in version 4.4.2.

For a mongod instance, the command enables, disables, or configures the Database Profiler. The profiler captures and records data on the performance of write operations, cursors, and database commands on a running mongod instance. If the profiler is disabled, the command configures how slow operations are logged to the diagnostic log.

On mongod, if the database profiler level is 1 or 2 (i.e. the database profiler is enabled), the slowms, sampleRate, and filter affect the behavior of both the profiler and the diagnostic log.

If the database profiler level is 0 (i.e. database profiler is disabled), the slowms, sampleRate, and filter affect only the diagnostic log.

Starting in MongoDB 4.0, for a mongos instance, the command only configures how operations get written to the diagnostic log. You cannot enable the Database Profiler on a mongos instance because mongos does not have any collections that the profiler can write to.

Starting in MongoDB 4.4.2 (also available starting in 4.2.12), changes made to the database profiler level, slowms, sampleRate, or filter using the profile command or db.setProfilingLevel() wrapper method are recorded in the log file.

On mongos, you can set profile level to:

• 0 to set the slowms, sampleRate, and filter for the diagnostic log;

• -1 to read the current settings.

The profiler is off by default.

Warning

Profiling can degrade performance and expose unencrypted query data in the system log. Carefully consider any performance and security implications before configuring and enabling the profiler on a production deployment.

See Profiler Overhead for more information on potential performance degradation.

The profile command has the following syntax:

{
  profile: <level>,
  slowms: <threshold>,
  sampleRate: <rate>,
  filter: <filter expression>
}

Field	Type	Description
profile	int	Configures the profiler level. The following profiler levels are available: Level Description 0 The profiler is off and does not collect any data. This is the default profiler level. 1 The profiler collects data for operations that take longer than the value of slowms. 2 The profiler collects data for all operations. Since profiling is not available on mongos, the profile command cannot be used to set the profiling level to a value other than 0 on a mongos instance.
slowms	int	Optional. Default: 100 The slow operation time threshold, in milliseconds. Operations that run for longer than this threshold are considered slow. When logLevel is set to 0, MongoDB records slow operations to the diagnostic log at a rate determined by slowOpSampleRate. At higher logLevel settings, all operations appear in the diagnostic log regardless of their latency with the following exception: the logging of slow oplog entry messages by the secondaries. The secondaries log only the slow oplog entries; increasing the logLevel does not log all oplog entries. Note This argument affects the same setting as the configuration option slowOpThresholdMs.
sampleRate	double	Optional. Default: 1.0 The fraction of slow operations that should be profiled or logged. sampleRate accepts values between 0 and 1, inclusive. Note This argument affects the same setting as the configuration option slowOpSampleRate and does not affect the slow oplog entry log messages on secondaries (available starting in MongoDB 4.2). New in version 3.6.
filter	object	Optional. A filter expression that controls which operations are profiled and logged. The filter expression takes the following form: { <field1>: <expression1>, ... } The <field> can be any field in the profiler output. The <expression> is a query condition expression. Note This argument affects the same setting as the configuration option filter. When filter is set, the slowms and sampleRate options are not used for profiling and slow-query log lines. New in version 4.4.2.

The db.getProfilingStatus() and db.setProfilingLevel() shell methods provide wrappers around the profile command.

Behavior

The profile command obtains a write lock on the affected database while enabling or disabling the profiler. This is typically a short operation. The lock blocks other operations until the profile command has completed.

Starting in MongoDB 4.4.2, when connected to a sharded cluster through mongos, you can run the profile command against any database. In previous versions of MongoDB, when connected through mongos, you can only run the profile command against the admin database.