DEV Community

sugiarto
sugiarto

Posted on

searchkick get total records

#searchkick #elasticsearch #ruby #rails

In one of my projects, I used searchkick gem and elasticsearch for implementing search feature.

Something weird happens when database records are over 10K records. The total records always show 10K, even though the actual records are 267K.

I fixed this issue by adding

body_options: { track_total_hits: true }
Enter fullscreen mode Exit fullscreen mode

As an argument for the search method.

Here is an example

collections = MyModel.pagy_search(query, fields: [:name], load: false, body_options: { track_total_hits: true })
pagy, properties = pagy_searchkick(collections)
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

kevinluo201 profile image

Use vite_rails to use Vue SFC(single file component, .vue) in >= Rails7

Kevin Luo -

eduardinni profile image

Kamal: Speed up the image builds using managed third-party builders and GitHub Actions

Eduardo Lomeli -

eduardinni profile image

Kamal: How to integrate with GitHub Actions using multiple destinations

Eduardo Lomeli -

matazou profile image

Introduction to Gem narabikae: A New Position Management Algorithm Inspired by Figma’s Fractional Indexing

matazou -