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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group