Re: Transaction start in pg_stat_activity

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Transaction start in pg_stat_activity
Дата
Msg-id 7341.1164040342@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Transaction start in pg_stat_activity  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: Transaction start in pg_stat_activity  ("Simon Riggs" <simon@2ndquadrant.com>)
Список pgsql-patches
"Simon Riggs" <simon@2ndquadrant.com> writes:
> On Mon, 2006-11-20 at 10:58 -0500, Tom Lane wrote:
>> There is no way we are putting a gettimeofday() call into
>> GetSnapshotData.  I thought you were focused on performance??

> My understanding was there was already a gettimeofday() call per
> statement which is displayed in pg_stat_activity. It seems relatively
> straightforward to have another column which is *not* updated for each
> statement when we are in SERIALIZABLE mode and CommandId > 1.

What for?  The proposal already covers transaction start and statement
start, and those are the only two timestamps available (without adding
extra gettimeofday() calls).  What you propose will merely repeat one of
them.

            regards, tom lane

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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: Transaction start in pg_stat_activity
Следующее
От: "Simon Riggs"
Дата:
Сообщение: Re: Transaction start in pg_stat_activity