Measuring CPU time use? (Another stupid question)

Поиск
Список
Период
Сортировка
От Jessica Blank
Тема Measuring CPU time use? (Another stupid question)
Дата
Msg-id Pine.LNX.4.44.0212181306360.392-100000@ensim.rackshack.net
обсуждение исходный текст
Ответы Re: Measuring CPU time use? (Another stupid question)  (Joe Conway <mail@joeconway.com>)
Re: Measuring CPU time use? (Another stupid question)  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-general
Hi.. again, I feel stupid. But I Googled for this info, and could not find
it (and I call myself the Goddess of Google, and with good reason...)

I wish to find a way to measure the CPU time used by any given query (or
set of queries).

I could not find any information on how to do this...

Is there some secret internal table (like the V$ virtual tables in Oracle)
that contains this info?

I'd love to find a V$CPUTIME table or something, so I could best optimize
my SQL...

I don't want to have to do it the inefficient way... e.g. by running the
same group of queries 1000 times or so several times, and averaging the
times...

--
J e s s i c a    L e a h    B l a n k


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

Предыдущее
От: Jessica Blank
Дата:
Сообщение: Re: ERROR: fmgr_info: function 24809: cache lookup failed
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: ORDER BY random() LIMIT 1 slowness