Trying to profile my function, but... - Mailing list pgsql-admin

From Ericson Smith
Subject Trying to profile my function, but...
Date
Msg-id 1052934212.11784.15.camel@localhost.localdomain
Whole thread Raw
List pgsql-admin
Hi,

I'm trying to figure out how long my function is taking to run, but it
keeps returning identical start and stop times. Here's a segment...

    seg := date_part(''second'', now())::float;

    FOR rec IN SELECT qcounter FROM tlogs_queue LOOP
      blah, blah, blah
    END LOOP;

    secs := date_part(''second'', now())::float;

    RAISE NOTICE ''Start %'', seg;
    RAISE NOTICE ''End   %'', secs;

seg and secs are the exact same number. Any pointers would be much
appreciated.

- Ericson Smith
eric@did-it.com
http://www.did-it.com

--
Ericson Smith <eric@briefme.com>


pgsql-admin by date:

Previous
From: jie zhang
Date:
Subject: authentication error
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: [GENERAL] TESTING the DATABASE