Method: PostgreStats#get_updates_per_table

Defined in:
lib/postgrestats.rb

#get_updates_per_table(db) ⇒ Object

  • number of updates rows per table



571
572
573
574
575
576
577
578
579
580
581
582
583
584
 
# File 'lib/postgrestats.rb', line 571

def get_updates_per_table(db)
   query = <<-END_GET_UPDATES_PER_TABLE_QUERY
     SELECT c.relname, pg_stat_get_tuples_updated(c.oid) FROM pg_catalog.pg_class c
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
     WHERE c.relkind IN ('r','') AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
     AND pg_catalog.pg_table_is_visible(c.oid)
   END_GET_UPDATES_PER_TABLE_QUERY

   ret = run_query(db, query)

   ret.map!{ |v| [v['relname'], v['pg_stat_get_tuples_updated'].to_i] }

   return Hash[*ret.flatten]
end