ruby on rails - Get only count of all records after group clause?

Question

records = Market
            .joins('LEFT JOIN fruits f on f.id = markets.recruiter_id')
            .joins('LEFT JOIN sellers s on s.id = markets.seller_id')
            .joins('LEFT JOIN users u on u.id = s.user-id')
            .group('markets.id, s.id, u.id').order('markets.id').limit(10)

For the above query, records.count is giving output like {1=>7072, 21=>432}. But I want the no of records of uniq markets.id, s.id, u.id after grouping instead of a hash like {1=>7072, 21=>432}. `

Any help would be really appreciated. Thanks in advance. Please comment for any clarification

question from:https://stackoverflow.com/questions/66059137/get-only-count-of-all-records-after-group-clause

Answer 1

You can get the count by doing this.

sql = records.limit(nil).reorder(nil).select('COUNT(*) OVER () AS TotalRecords').to_sql
output = ActiveRecord::Base.connection.execute(sql)
output.values.first