Re: Performance analysis of plpgsql code

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance analysis of plpgsql code
Date: 2005-06-27 23:33:03
Message-ID: 20050627233303.GA17069@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches pgsql-performance

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

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

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2005-06-27 23:49:41 Re: regexp_replace
Previous Message Karl O. Pinc 2005-06-27 23:30:45 Performance analysis of plpgsql code

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Glaesemann 2005-06-28 01:15:50 Re: Performance analysis of plpgsql code
Previous Message Karl O. Pinc 2005-06-27 23:30:45 Performance analysis of plpgsql code