Select rows usage at Heroku postgres DB
- Open heroku database console:
heroku pg:psql YOUR_DB_URL
- Use this query:
SELECT schemaname,relname,n_live_tup
FROM pg_stat_user_tables
ORDER BY n_live_tup DESC;
Source: http://stackoverflow.com/questions/12701711/heroku-row-count-incorrect
Written by Timur Khafizov
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Heroku
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#