measure time intervals

From: Vincent Dautremont <vincent(at)searidgetech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: measure time intervals
Date: 2012-04-05 14:00:58
Message-ID: CAA4Vp4-Hcc9wsbnAquvthEe-_VCKr0P52gUyM6MEexo6y0qcFw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message iihero 2012-04-05 14:10:49 Re: PostgreSQL 8.4 crash on user defined C language function
Previous Message Alain 2012-04-05 13:52:03 BD impossible à recharger