You may also try PgFouine (http://pgfouine.projects.postgresql.org/) for log analysis, I found it very useful in similar situation. On 5/17/06, Ruben Rubio Rey <ruben@xxxxxxxxxxxx> wrote:
Hi, I have a web page, that executes several SQLs. So, I would like to know witch one of those SQLs consumes more CPU. For example, I have SQL1 that is executed in 1.2 secs and a SQL2 that is executed in 200 ms. But SQL2 is executed 25 times and SQL1 is executed 1 time, so really SQL2 consumes more CPU time. Is there any way to know this? I have think that logging all SQLs and then cheking it is a way to do it ... any other idea? Thanks in advance ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
