This small tool connects to the P6Spy JDBC logger and displays in real time the queries going to the database. It uses an integrated SQL parser to build statistics on the most accessed tables and columns to enable database index creation. Other information is also gathered and displayed, such as the request time for a single request, for a class of request, and for all the requests. Sorting may be done on these views to detect database problems efficiently.
|Tags||Database Database Engines/Servers Front-Ends Software Development Debuggers Testing Benchmark Monitoring|
|Operating Systems||OS Independent|
Release Notes: In this release, improvements include the handling of UPDATE, INSERT, and DELETE SQL queries that are now processed in the profiling results, but are not (yet) used to build index recommendations, as well as the ability to now export the profiling results in an CSV file.
Release Notes: This version features optimized request processing, a millisecond precise time display, a new charting view that displays the amount of requests per second as well as an experimental traffic indicator to/from the database, a new detail panel for the profile view, and an included p6spy.jar. The order of columns in request is now taken into account to build more efficient indexes.
No changes have been submitted for this release.