qatch

Slow query catcher

Installation

npm i -g qatch

Usage

Initialize profiling

qatch --begin --mongo-uri=mongodb://localhost:27017/yolo

Pulling a slow query profile

qatch --report --mongo-uri=mongodb://localhost:27017/yolo

When to use

qatch is meant to be used to catch unexpected queries that aren't using Mongo indices. A example usage would be to do something like the following as part of your CI pipeline:

# Assuming that `qatch` in installed, initialize profiling. 
qatch --begin --mongo-uri=mongodb://localhost:27017/yolo --clean
 
# Run your tests 
npm run test
 
# Pull the report, if any slow queries are found, `qatch` will exit with a 
# non-zero status code. 
qatch --report --mongo-uri=mongodb://localhost:27017/yolo --clean