Search Postgresql Archives

measure time intervals

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux