Trying to profile a function, but weird stuff happens

Поиск
Список
Период
Сортировка
От Ericson Smith
Тема Trying to profile a function, but weird stuff happens
Дата
Msg-id 1052935026.11798.18.camel@localhost.localdomain
обсуждение исходный текст
Ответы Re: Trying to profile a function, but weird stuff happens  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@did-it.com>
--
Ericson Smith <eric@did-it.com>


В списке pgsql-admin по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: No flamefest please, MySQL vs. PostgreSQL AGAIN
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Trying to profile a function, but weird stuff happens