Database Reference
In-Depth Information
The pg:ps command
The
pg:ps
command checks the
pg_stat_statements
table and provides you a con-
cise overview of all the queries that are currently running. It is useful for you to understand
how your database is behaving before taking any decision.
$ heroku pg:ps --app your-app-name
pid | state | source |running_for | waiting |
query
-----+--------+--------+-----------------+---------+------
26857| active | | -00:00:00.00103 | f | SELECT
"doctors".* FROM "doctors" ORDER BY name asc LIMIT 1
(1 row)
