Skip site navigation (1) Skip section navigation (2)

Re: Logging just SQL commands in an SQL script format

From: Rigmor Ukuhe <rigmor(dot)ukuhe(at)finestmedia(dot)ee>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Logging just SQL commands in an SQL script format
Date: 2007-01-25 13:21:25
Message-ID: 45B8AED5.3090905@finestmedia.ee (view raw or flat)
Thread:
Lists: pgsql-admin
Campbell, Lance wrote:
> I want to log all SQL commands as an executable script file for use in 
> performance testing.  Currently there is a lot of information in the log 
> that is generated that would not be executable.  Below is an example of 
> what I would want to see; which is just the SQL.
> 
>  
> 
> Example of log output:
> 
> Select a,b,c from calendar where a=12;
> 
> Select a,b,c from calendar where a=13;
> 
>  

Hi,

Wouldn't SQL statements in log possible be out of order, also transaction info 
would be missing?

Even if you do it in application-side, logging query start time and transaction 
info, and feed this data to some application that starts to excecute them in 
correct time and context, you wouldnt be able to reliably replicate exact 
behavior, cause configuration change might change query times too much.
But i see it _can_ be useful in some cases.

Rigmor

> 
>  
> 
> How do I do this?
> 
>  
> 
> Thanks,
> 
>  
> 
>  
> 
>  
> 
> Lance Campbell
> 
> Project Manager/Software Architect
> 
> Web Services at Public Affairs
> 
> University of Illinois
> 
> 217.333.0382
> 
> http://webservices.uiuc.edu
> 
>  
> 
> !DSPAM:5,45b7c785287772091230466!


-- 
Rigmor Ukuhe
Finestmedia Ltd | Software Development Team Manager
gsm : (+372)56467729 | tel : (+372)6558043 | e-mail : rigmor(dot)ukuhe(at)finestmedia(dot)ee

In response to

Responses

pgsql-admin by date

Next:From: Daniel Cristian CruzDate: 2007-01-25 14:56:00
Subject: Re: Logging just SQL commands in an SQL script format
Previous:From: Shoaib MirDate: 2007-01-25 12:44:37
Subject: Re: Case-sensitive

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group