Get count of overdue invoice per company.

overdue_count.rb

switch_to_slave_db

companies = Company.joins(:subscription).merge(Subscription.live)
companies_count = companies.count
progress_bar = ProgressBar.new(companies_count)
ProgressBar.new(companies_count)

companies.find_each do |company|
  Rails.logger.info({
    event: "COMPANY_OVERDUE_INVOICE_COUNT",
    company_id: company.id,
    active: company.is_active?,
    count: company.invoices.overdue.where.not(cached_net_value: 0).unpaid.count
  }.to_json)
  progress_bar.increment!
end

LGTM