Re: [HACKERS] Execution time

From: Mattias Kregert <matti(at)algonet(dot)se>
To: Shiby Thomas <sthomas(at)cise(dot)ufl(dot)edu>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Execution time
Date: 1998-03-06 10:47:23
Message-ID: 34FFD43B.12B4B185@algonet.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 */

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mattias Kregert 1998-03-06 10:58:30 Re: [HACKERS] PostgreSQL and DBI/DBD...vs Pg.pm
Previous Message Mattias Kregert 1998-03-06 10:45:46 Re: [HACKERS] AUTO_INCREMENT suggestion