Docs Menu
Docs Home
/ /
Atlas CLI
/ / /

atlas performanceAdvisor suggestedIndexes list

On this page

  • Syntax
  • Options
  • Inherited Options
  • Examples

Return the suggested indexes for collections experiencing slow queries.

The Performance Advisor monitors queries that MongoDB considers slow and suggests new indexes to improve query performance.

To use this command, you must authenticate with a user account or an API key with the Project Read Only role.

Command Syntax
atlas performanceAdvisor suggestedIndexes list [options]
Name
Type
Required
Description
--duration
int
false
Length of time in milliseconds for which you want to return results. If you specify the since option, the duration starts at the date and time specified. If you don't set the since option, this command returns data from the duration before the current time.
-h, --help
false
help for list
--nExamples
int
false
Maximum number of example queries to provide that a suggested index will improve.
--nIndexes
int
false
Maximum number of indexes to suggest.
--namespaces
strings
false
Namespaces from which to retrieve suggested indexes.
-o, --output
string
false
Output format. Valid values are json, json-path, go-template, or go-template-file. To see the full output, use the -o json option.
--processName
string
true
Unique identifier for the host of a MongoDB process in the following format: {hostname}:{port}. You can obtain a list of possible values from the 'id' field when you run the 'atlas processes list' command.
--projectId
string
false
Hexadecimal string that identifies the project to use. This option overrides the settings in the configuration file or environment variable.
--since
int
false
Date and time from which the query retrieves the suggested indexes. Specify this value as the number of seconds that have elapsed since the UNIX epoch. If you don't set the duration option, this command returns data from the since value to the current time.
Name
Type
Required
Description
-P, --profile
string
false
Name of the profile to use from your configuration file. To learn about profiles for the Atlas CLI, see https://dochub.mongodb.org/core/atlas-cli-save-connection-settings.
# Return a JSON-formatted list of suggested indexes for the atlas-111ggi-shard-00-00.111xx.mongodb.net:27017 host in the project with the ID 5e2211c17a3e5a48f5497de3:
atlas performanceAdvisor suggestedIndexes list --processName atlas-111ggi-shard-00-00.111xx.mongodb.net:27017 --projectId 5e2211c17a3e5a48f5497de3 --output json

Back

suggestedIndexes