[GENERAL] measure time intervals

2012-04-06 Thread Vincent Dautremont
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 calcula

Re: [GENERAL] measure time intervals

2012-04-10 Thread Vincent Dautremont
Thank you but my problem is precisely because I'm using Postrgresql on a windows computer and I cannot change that :-/ Vincent. On Fri, Apr 6, 2012 at 1:40 PM, John R Pierce wrote: > On 04/05/12 7:00 AM, Vincent Dautremont wrote: > >> These are not affected by system time

Re: [GENERAL] measure time intervals

2012-04-10 Thread Vincent Dautremont
x one does. Vincent. On Tue, Apr 10, 2012 at 9:48 AM, Raymond O'Donnell wrote: > On 10/04/2012 14:39, Vincent Dautremont wrote: > > Thank you but my problem is precisely because I'm using Postrgresql on a > > windows computer and I cannot change that :-/ > > W