gistfile1.md

HEROKU PSQL

  heroku pg:psql --app [app-name]

WITHOUT CACHE

  SELECT schemaname,relname,n_live_tup
  FROM pg_stat_user_tables
  ORDER BY n_live_tup DESC

WITH CACHE

  SELECT
    nspname AS schemaname,relname,reltuples
  FROM pg_class C
  LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
  WHERE
    nspname NOT IN ('pg_catalog', 'information_schema') AND
    relkind='r'
  ORDER BY reltuples DESC;