QueryTrack
Tool for finding time-consuming database queries for ActiveRecord-based RailsĀ Apps. Provides Slack notifications for with backtrace, raw SQL, time duration, etc.
Installation
Add this line to your application's Gemfile:
gem 'query_track'
And then execute:
$ bundle
Or install it yourself as:
$ gem install query_track
Usage
SQL Duration Limit
Specify SQL duration query limit:
QueryTrack::Settings.configure do |config|
config.duration = 0.5
end
Console Log
Enable console logs from config:
QueryTrack::Settings.configure do |config|
config.duration = 0.5
config.logs = true
end
Slack Notifications
To receive notifications about slow queries into Slack, you need to install incoming-webhooks and put link into config file:
QueryTrack::Settings.configure do |config|
config.duration = 0.5
config.notifications.slack = 'https://hooks.slack.com/services/T0000000/B0000000/C0000000'
end
Filters
To avoid noisy warnings from used gems, and places where fat queries are justified, you can filters SQL by backtrace.
For example, you have installed activeadmin
and want to skip everything from app/admin
:
QueryTrack::Settings.configure do |config|
config.duration = 0.5
config.filters = ['app/admin']
end
Contributing
Bug reports and pull requests are welcome on GitHub at https://github.com/kirillshevch/query_track.
License
The gem is available as open source under the terms of the MIT License.