Pergormance monitoring for queries |

Database Security. Database Auditing. Database Caching. Database Masking. Get it now

Pergormance monitoring for queries

Posted December 4th, 2009 by jazzdabbler

General

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.

Comments

Hi Jazzdabbler, You are most

On December 5th, 2009 dmaman says:

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

On December 10th, 2009 jazzdabbler says:

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.

GreenSQL