Re: Performance analysis of plpgsql code - Mailing list pgsql-performance

From Michael Glaesemann
Subject Re: Performance analysis of plpgsql code
Date
Msg-id 00AC59C9-7A32-40A6-80A7-B5428F02D0E6@myrealbox.com
Whole thread Raw
In response to Re: Performance analysis of plpgsql code  ("Karl O. Pinc" <kop@meme.com>)
List pgsql-performance
On Jun 28, 2005, at 10:54 AM, Karl O. Pinc wrote:

>
> 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.

I recommend you look again.

<http://www.postgresql.org/docs/8.0/interactive/functions-
datetime.html#FUNCTIONS-DATETIME-CURRENT>

Michael Glaesemann
grzm myrealbox com

pgsql-performance by date:

Previous
From: "Karl O. Pinc"
Date:
Subject: Re: Performance analysis of plpgsql code
Next
From: Leigh Dyer
Date:
Subject: Faster drives for WAL than for data?