measure time intervals

Поиск
Список
Период
Сортировка
От Vincent Dautremont
Тема measure time intervals
Дата
Msg-id CAA4Vp4-Hcc9wsbnAquvthEe-_VCKr0P52gUyM6MEexo6y0qcFw@mail.gmail.com
обсуждение исходный текст
Ответы Re: measure time intervals
Re: measure time intervals
Список pgsql-general
Hi,
I'm wondering ig it is possible to measure elapsed time between 2 particular queries in PostgreSQL.

what I need is the equivalent of @@TIMETICKS in Transac-SQL
or CLOCK_MONOTONIC  in Unix
or GetTickCount in Windows

These are not affected by system time changes, so time interval can be calculated even if the system time is changed by NTP or the user.
That's why I can't use any function based on system time.

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

Предыдущее
От: Maxim Boguk
Дата:
Сообщение: Postgresql 9.0.7 weird planner decision (rows in plan close to reality but plan suboptimal)
Следующее
От: "hans wulf"
Дата:
Сообщение: 9.1.3 Standby catchup mode