Projects / JDBC SQL Profiler

JDBC SQL Profiler

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
Licenses
Operating Systems
Implementation

Recent releases

  •  23 Nov 2003 05:18

    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.

    •  15 Oct 2003 04:03

      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.

      •  14 May 2003 18:54

        No changes have been submitted for this release.

        Screenshot

        Project Spotlight

        OpenStack4j

        A Fluent OpenStack client API for Java.

        Screenshot

        Project Spotlight

        TurnKey TWiki Appliance

        A TWiki appliance that is easy to use and lightweight.