- 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%' |