bayendor

WITH table_scans as (
    SELECT relid,
        tables.idx_scan + tables.seq_scan as all_scans,
        ( tables.n_tup_ins + tables.n_tup_upd + tables.n_tup_del ) as writes,
                pg_relation_size(relid) as table_size
        FROM pg_stat_user_tables as tables
),
all_writes as (
    SELECT sum(writes) as total_writes
    FROM table_scans

bayendor

class AuditInfo < ActiveRecord::Base
  belongs_to :arc_info

  def self.import(file)
    begin
      if file.path
        CSV.foreach(file.path, headers: true, col_sep: "\t") do |row|
          audit_info = AuditInfo.create! row.to_hash
          arc_info = audit_info.arc_info
          arc_info.update_attribute(:status, audit_info.computed_status)