Re: how do I find out how much space I have?
We're working on providing a lot of information about exactly what resources your app is using. The first small step toward this is that "heroku info" will now show some stats about your code and data size: $ heroku info --app adamblog === adamblog Web URL:http://adamblog.heroku.com/ Git Repo: g...@heroku.com:adamblog.git Repo size: 876k Slug size: 704k Data size: 360k in 1 table If you're running latest client gem (0.8) and you don't see one or more of these fields, it's because it's still being calculated. In the case of repo/slug size, you may not see them until you push your code again. Adam --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~--~~~~--~~--~--~---
Re: how do I find out how much space I have?
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 heroku@googlegroups.com
To unsubscribe from this group, send email to
heroku+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/heroku?hl=en
-~--~~~~--~~--~--~---
Re: how do I find out how much space I have?
In herokugarden you can find this under "Other" in your app settings. In heroku there doesn't appear to be a way to do that yet. On Apr 28, 1:36 am, Josh wrote: > Where do I go to see how much space I am using and have available? > > Thanks! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~--~~~~--~~--~--~---
