[Monetdb-developers] slow query log

Fabian Groffen Fabian.Groffen at cwi.nl
Tue Oct 21 11:01:32 CEST 2008


On 21-10-2008 09:50:41 +0200, Martin Kersten wrote:
> Stefan de Konink wrote:
> > Is there currently a syntax to log every incoming SQL query to a file?
> >
> > I found options like:
> > 1) ODBCDEBUG [1]
> > 2) mapi_log(...) [2]
> >   
> mclient links into the Linux history mechanism and logfile may help

That's only for the console input, isn't it?

> > But is there something easy to capture all incoming query with their 
> > timings; so a real slow queries log can be created?
> >   
> If you run from an application, then it is easy to keep the log there.
> It includes valuable information about connections too.

what about the SQL server's PROFILE capabilities [1]?


[1] http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/PROFILE-Statement.html#PROFILE-Statement




More information about the developers-list mailing list