# LIST APPS heroku apps --team MYTEAM # PUSH git push heroku master # CONNECT TO DB heroku pg:psql --app app-name # POSTGRES SHOW INFO heroku pg:info --app myapp # GATHER STATS heroku pg:psql --app myapp -c "select datname,xact_commit,xact_rollback,blks_read,blks_hit,tup_returned,tup_fetched,tup_inserted,tup_updated,tup_deleted from pg_stat_database;" # SHOW DB CREDS heroku config:get DATABASE_URL -a myapp # CONNECT TO HEROKU POSTGRES psql -h xxx.compute-1.amazonaws.com -U user databasename # LIST PROCESSES heroku ps -a yourapp # SHOW RELEASE heroku releases -a app-name # SHOW LOGS heroku logs heroku logs --ps web.1 --tail # SHOW STATUS DB heroku pg:diagnose