traceindex

A Rake task that helps you find missing indexes in your Rails app.

Install

Put this line in your Gemfile:

gem 'traceindex'

Then bundle:

% bundle

Usage

Just run the following command in your Rails app directory.

% rake traceindex

If you want the rake task to fail when errors are found.

% FAIL_ON_ERROR=1 rake traceindex

How do I tell it to ignore columns?

Create a .traceindex.yaml or .traceindex.yml file in your root directory.

ignore_columns:
  - users.created_user_id
ignore_models:
  - ActiveStorage::Blob
  - ActiveStorage::Attachment
  - ActionText::RichText
  - ActionMailbox::InboundEmail

Copyright

Copyright (c) 2020 Akira Kusumoto. See MIT-LICENSE file for further details.