Re: [HACKERS] Execution time - Mailing list pgsql-hackers

From Mattias Kregert
Subject Re: [HACKERS] Execution time
Date
Msg-id 34FFD43B.12B4B185@algonet.se
Whole thread Raw
In response to Execution time  (Shiby Thomas <sthomas@cise.ufl.edu>)
Responses Re: [HACKERS] Execution time  (Shiby Thomas <sthomas@cise.ufl.edu>)
List pgsql-hackers
Shiby Thomas wrote:
>
> Hi,
>
> In postgres, is there a way to get the CPU time and I/O time taken (separately)
> to execute a query? Does the profile info. help in some way to
> calculate the CPU/IO break up at least approximately.
>
> What is the best way to do it? Any kind of help is greatly appreciated.
>
> Thanks
> --shiby

How about running "time postgres ..." and connecting to the backend
without using the postmaster?

/* m */

pgsql-hackers by date:

Previous
From: Mattias Kregert
Date:
Subject: Re: [HACKERS] AUTO_INCREMENT suggestion
Next
From: Mattias Kregert
Date:
Subject: Re: [HACKERS] PostgreSQL and DBI/DBD...vs Pg.pm