Thread: SQL CPU time usage
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
On 17 May 2006, at 16:21, Ruben Rubio Rey wrote: > 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? Practical Query Analysis: <http://pqa.projects.postgresql.org/> does exactly that (scan historic logs). Very nice indeed and more than worth the money (it's BSD-licensed) -- John O'Shea Wordbank Limited 33 Charlotte Street, London W1T 1RR Direct line: +44 (0) 20 7903 8829 Fax: +44 (0) 20 7903 8888 <http://www.wordbank.com/>
john_oshea@wordbank.com wrote: > On 17 May 2006, at 16:21, Ruben Rubio Rey wrote: > >> 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? > > > Practical Query Analysis: <http://pqa.projects.postgresql.org/> does > exactly that (scan historic logs). Very nice indeed and more than > worth the money (it's BSD-licensed) > thanks
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@rentalia.com> 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 >