The SQL Profiling page provides information about interactions between the database and commands and queries being issued from within the ]project-open[ interface. This is useful in tracking down lags and seeing the actions leading up to crashes. From the main page a list of every command run on the database within the parameter range of time can be seen.
The time and duration of the query are recorded along with the IP address and the file pathname containing the SQL. If you would like to see the SQL along with the statistics associated with each SQL commands, first turn on,
and make sure that the statistics have been enabled. Once they have been enabled, click on any of the commands that are listed and get a more detailed breakdown of what exactly was contained in each request.
To set the parameters on the time window and other viewing options click,
for an options menu.
Calle Aprestadora 19, 12o-2a
08902 Hospitalet de Llobregat (Barcelona)
Spain
Tel Europe: +34 609 953 751
Tel US: +1 415 200 2465
Mail: info@project-open.com