开发者

Can JProfiler tell me how long queries are taking?

开发者 https://www.devze.com 2023-04-09 09:46 出处:网络
Wouldn\'t it be nice if I could drill down into the JProfiler CPU Vi开发者_StackOverflow中文版ew, and find a percentage of time running a certain query against the database?Does anyone know if this is

Wouldn't it be nice if I could drill down into the JProfiler CPU Vi开发者_StackOverflow中文版ew, and find a percentage of time running a certain query against the database? Does anyone know if this is possible?


The call tree in JProfiler shows JDBC queries with the default settings:

Can JProfiler tell me how long queries are taking?

If this is not the case, open the session settings, go to the probe settings, select the JDBC probe and ensure that "Enabled", "Record on startup" and "Annotate JDBC calls in call tree" are selected:

Can JProfiler tell me how long queries are taking?

Another way to look at JDBC query strings is the "hot spot" view of the JDBC probe:

Can JProfiler tell me how long queries are taking?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号