Fork me on GitHub
#sql
<
2021-08-13
>
vemv02:08:30

Random one, but I just discovered that YourKit (which I regularly use) has a handy jdbc integration. So, for example you visualize the relationship between the threads in your app and their emitted/executed SQL. Which can ease a bit the detection of bottlenecks. One can also see all SQL events under a single table so you can quickly assess the slowest-running queries etc. Wondering if someone has more experience with this or similar tools.

😎 3
thumbnail09:08:30

next.jdbc provides an API to log queries and their result, we use that to`tap>` to debug queries / do some performance work. I.e. we have a delayed-explain-analyze query in the tapped value so we get some idea of the characteristics of the query too when rebling through. The YourKit integration sure sounds nice, I don't use it as often as I should

👀 3