Pergormance monitoring for queries
Fri, 12/04/2009 - 09:14
Hi.
GreenSQL great tool, thank you for your work.
I have a suggestion.
Now that we get through a GreenSQL all queries to the database, it would be a good idea to add performance monitoring SQL queries and stored procedures.
I understand that this is outside the concept of the application, but I think that this functionality will add the product's popularity.
GreenSQL
Hi Jazzdabbler,
You are most welcome, it's our pleasure!
When you are writing "performance monitoring", can you be more specific?
Do you mean number of queries and bandwidth statistics?
During the next releases we'll add some auditing and logging features, if
you'll be more specific regarding your needs, we'll be happy to add it to
our road map..
Thanks,
David
The GreenSQL Team
Hello David :)
>>Do you mean number of queries and bandwidth statistics?
I mean execution time and query counter for different query types.
In the picture below an example of a profiler, which I use:
http://www.yourkit.com/docs/80/help/j2ee_statistics.gif
Such statistics is enough to quickly diagnose potential problems and to obtain data on the distribution of types of queries.
Also, more complex statistics you see at http://pgfouine.projects.postgresql.org/reports/sample_default.html
Thanks,
Stanislav.