richrines

# FOR BUSY JOBS
# take the process_id from the /busy page in sidekiq and kill the longest running one.
workers = Sidekiq::Workers.new
workers.each do |process_id, thread_id, work|
  process = Sidekiq::Process.new('identity' => process_id)
  process.stop! if process_id == 'integration.3:4:71d1d7f4ef5a'
end

# FOR SCHEDULED JOBS
# you need to know the jid to make this happen

richrines

/**************************\
  Basic Modal Styles
\**************************/

.modal {
  font-family: -apple-system,BlinkMacSystemFont,avenir next,avenir,helvetica neue,helvetica,ubuntu,roboto,noto,segoe ui,arial,sans-serif;
}

.modal__overlay {
  position: fixed;

richrines

# 1. Clear retry set

Sidekiq::RetrySet.new.clear

# 2. Clear scheduled jobs 

Sidekiq::ScheduledSet.new.clear

# 3. Clear 'Processed' and 'Failed' jobs

richrines

if Rails.env.development?
  require 'active_record/connection_adapters/postgresql_adapter'

  class ActiveRecord::ConnectionAdapters::PostgreSQLAdapter
    def __explain_analyze(sql, command, *args)
      meth = "#{command}_without_explain_analyze".to_sym
      if /\A\s*SELECT/i.match(sql)
        newsql = "EXPLAIN ANALYZE #{sql}"
        plan = send(meth, newsql, *args).map { |row| row['QUERY PLAN'] }.join("\n")
        Rails.logger.debug("\e[1m\e[31mQUERY PLAN FOR: #{sql.strip};\n#{plan}\e[0m")