Company
Date Published
Author
Jeremy Mikola
Word count
331
Language
English
Hacker News points
None

Summary

MongoQP: MongoDB Slow Query Profiler is a query profiler developed by Jeremy Mikola, PHP Evangelist at 10gen, as part of the company's Drivers and Innovations team. The project aggregates slow queries from the system.profile collection by their BSON structure using map/reduce JS, allowing for easier analysis of query statistics such as average query time, index scans, and counts. Initially, Jeremy aimed to develop a new UI for the profiler but instead created a quick frontend using Silex PHP micro-framework, with plans to port the functionality to Genghis, another MongoDB admin app. The project's JS innards may also be useful in Tyler Brock's mongo-hacker shell enhancement package. Additionally, Dan Crosta's professor already provides many of the features Jeremy aimed to implement, including incremental data collection, and is available as a stand-alone query profile viewer. Contributions are welcome through Github.