MongoDB: Enable, Disable, Filter, and View Query Logs

Jan 12, 2023#MongoDB11

AI Translation

This post is translated from Japanese into English through AI.View Original

AI-generated summary

- Set the profiling level to 0 to disable query logging by default. - Set the profiling level to 2 to enable query logging for all queries. - Set the profiling level to 2 with a maximum record limit. - Get the current status of the query logging settings. - View query logs with sorting and limiting. - Filter query logs based on specific conditions. - Clear all query logs.

// Disable query logging (default)
db.setProfilingLevel(0)

// Enable query logging, with levels 0 (off), 1 (slow queries), or 2 (all queries)
db.setProfilingLevel(2)

// Enable query logging and configure maximum number of records
db.setProfilingLevel(2,0,100)

// Get the current query logging status
db.getProfilingStatus()

// Query logging (sorting, limit)
db.system.profile.find().sort({$natural:-1}).limit(50)

// Filter query logs based on conditions (latest records first)
db.system.profile.find({ op: "query", ns: "hospital-next.devices" }).sort({$natural:-1})

// Clear query logs
db.system.profile.drop()