def info
(name, database) = extract_db(:include_shared => true)
unless name.match("HEROKU_POSTGRESQL")
attrs = heroku.info(app)
display("=== #{app} database #{name}")
display_info("Data size",
"#{size_format(attrs[:database_size].to_i)}")
return
end
with_heroku_postgresql_database do |name, url|
database = heroku_postgresql_client(url).get_database
display("=== #{app} database #{name}")
display_info("State",
"#{database[:state]} for " +
"#{delta_format(Time.parse(database[:state_updated_at]))}")
if database[:num_bytes] && database[:num_tables]
display_info("Data size",
"#{size_format(database[:num_bytes])} in " +
"#{database[:num_tables]} table#{database[:num_tables] == 1 ? "" : "s"}")
end
if @heroku_postgresql_url
display_info("URL", @heroku_postgresql_url)
end
if version = database[:postgresql_version]
display_info("PG version", version)
end
display_info("Born", time_format(database[:created_at]))
display_info("Mem Used", "%0.2f %" % database[:mem_percent_used]) unless [nil, ""].include? database[:mem_percent_used]
display_info("CPU Used", "%0.2f %" % (100 - database[:cpu_idle].to_f)) unless [nil, ""].include? database[:cpu_idle]
end
end