Examining database queries

You can view the query expressions Jive uses as it interacts with its database. This is helpful when you're troubleshooting or looking for ways to improve performance. For example, you might use it to look for long-running queries or queries that are running too often.
Fastpath: Admin Console: System > Management > Query Stats

When you turn on this feature, the Admin Console displays the query expressions executed (without the actual values used), the number of times a query is executed, the time it took in milliseconds to execute a query, and the average time the query took.

Note: Turning this feature on and leaving it on slow performance. It's best to use this feature only while you're collecting performance information.

Database query statistics