pg_search

https://github.com/casecommons/pg_search

Ruby

pg_search builds ActiveRecord named scopes that take advantage of PostgreSQL’s full text search

IssuableFinder#count_by_state

We often get counts for each state by running a query per state, and
counting those results. This is typically slower than running one query
(even if that query is slower than any of the individual state queries) and
grouping and counting within that query.

Source | Google | Stack overflow

Edit

git clone [email protected]:casecommons/pg_search.git
cd pg_search
open

Contribute

# Make a new branch

git checkout -b -your-name--update-docs-IssuableFinder-count_by_state-for-pr

# Commit to git

git add git commit -m "better docs for IssuableFinder#count_by_state"

# Open pull request

gem install hub # on a mac you can `brew install hub`

hub fork

git push <your name> -your-name--update-docs-IssuableFinder-count_by_state-for-pr

hub pull-request

# Celebrate!