From: Karl O. Pinc <kop@meme.com>
To: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance analysis of plpgsql code
Date: Tue, 28 Jun 2005 01:54:08 +0000
Message-ID: <1119923648l.11411l.0l@mofo> (raw)
In-Reply-To: <20050627233303.GA17069@winnie.fuhr.org>
References: <1119915045l.4428l.5l@mofo>
<20050627233303.GA17069@winnie.fuhr.org>
On 06/27/2005 06:33:03 PM, Michael Fuhr wrote:
> On Mon, Jun 27, 2005 at 11:30:45PM +0000, Karl O. Pinc wrote:
> >
> > Short of that I think I'm going to be reduced to
> > writing a C function that returns the real
> > system time so I can spatter my code with
> > RAISE statements that indicate actual execution
> > time.
>
> See timeofday().
That only gives you the time at the start of the transaction,
so you get no indication of how long anything in the
transaction takes.
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kop@meme.com, mike@fuhr.org
Subject: Re: Performance analysis of plpgsql code
In-Reply-To: <1119923648l.11411l.0l@mofo>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox