The DripStat Agent will collect samples of SQL Statements that take too long to execute.
Threshold for collecting SQL Samples
The threshold for this is specified in the Config File using the
If a SQL statement takes longer than
stackThreshold time to execute, a sample will be collected for it.
A sample includes, among other data, the full SQL statement, with values obfuscated, and the stacktrace of the method that tried to execute it.
Viewing Slow Queries
Go to the 'SQL' tab. Select a category of Statements, (eg: SELECT - customers). Click the 'Slow Queries' tab.
You should see different slow SQL statement for which the samples were collected.
Clicking on a statement will show you the full details of it.
You can browse through the different samples collected, using the Previous and Next buttons.
The samples are shown in descending order of duration, ie from slowest sample to fastest.