|
From: Alexandre P. <Ale...@ei...> - 2012-10-03 14:22:32
|
On Wed, Oct 03, 2012 5:17 AM, Gerd Wagner wrote: > On 03.10.2012 02:04, Chris Lopes wrote: > > Hi, > > > > Is there any way to know either of the following: > > 1) What time an in-progress query was initiated? > > 2) [related] How long an in-progress query has taken so far? > > > > Obviously the run time of a query is printed out in the log after the > > query completes, but I'd like to be able to know these things before > > it completes. (how long have I been waiting so far?) > No, we don't have that feature yet. But it makes sense and shouldn't be > hard to implement. > > Could you please post a feature request here: > http://sourceforge.net/tracker/?atid=393417&group_id=28383 What is wrong with just using built-in function for current date and time right before starting the query? For instance, in Oracle I would select sysdate from dual then run the query. -- Alexandre Peshansky, MS Senior Bioinformatics Analyst, Research Informatics Core (RIC) Einstein-Montefiore Institute for Clinical and Translational Research (ICTR) Albert Einstein College of Medicine 1300 Morris Park Ave, Mazer Bldg., Rm 534 Bronx, NY 10461 (718) 430-2440 (Mo, Th, Fr) (718) 920-4885 (Tu & We) |
