...
In the above example, the database is fairly idle as most of the processes are sleeping (Command=Sleep) and have been for awhile. When the database is busy executing long running queries they will show up with a Command=Query. The 'Time' column tells you how long the query has been running in seconds.
Killing a Process
To kill a process simply run the following using the ID of the process you want to kill:
Code Block |
---|
KILL 123; |
Historically: What has been slow?
...