In heroku console, that should work:
ActiveRecord::Base.connection.execute("
SELECT
CURRENT_DATABASE(),
pg_size_pretty(sum(pg_total_relation_size(tablename))::int8)
AS size
FROM pg_tables
WHERE schemaname != 'pg_catalog'
AND schemaname != 'information_schema';
").res[0]
Or with this query to get a specific table usage:
SELECT
tablename,
pg_size_pretty(pg_total_relation_size(tablename)) AS total_usage,
pg_size_pretty((pg_total_relation_size(tablename)
- pg_relation_size(tablename))) AS external_table_usage
FROM pg_tables
WHERE schemaname != 'pg_catalog'
AND schemaname != 'information_schema'
ORDER BY pg_total_relation_size(tablename);
Garantied untested/
Baptiste
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Heroku" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/heroku?hl=en
-~----------~----~----~----~------~----~------~--~---
