- YourKit
- Add
Thread.sleep(60000)
to the START and END of the method you want to profile.
package commons | |
import scala.concurrent.ExecutionContext | |
import akka.actor.ActorSystem | |
case class Contexts(val actorSystem: ActorSystem) { | |
import Contexts._ | |
implicit val defaultCtx = DefaultExeCtx(play.api.libs.concurrent.Execution.defaultContext) | |
implicit val ctrlsCtx = CtrlExeCtx(defaultCtx.underlying) |
-- show running queries (pre 9.2) | |
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
FROM pg_stat_activity | |
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
ORDER BY query_start desc; | |
-- show running queries (9.2) | |
SELECT pid, age(clock_timestamp(), query_start), usename, query | |
FROM pg_stat_activity | |
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |