Last Updated: February 25, 2016
·
304
· timurkhafizov

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