Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-patchespgsql-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

pgsql-performance by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group