Re: query total time im milliseconds
| От | Samuel Gendler |
|---|---|
| Тема | Re: query total time im milliseconds |
| Дата | |
| Msg-id | CAEV0TzCZVv2Ge0t6-hc3rb2H2WJye8GOmo1X1CeFMoYkQvkYhg@mail.gmail.com обсуждение исходный текст |
| Ответ на | query total time im milliseconds (Radhya sahal <rad_cs_2006@yahoo.com>) |
| Ответы |
Fw: query total time im milliseconds
|
| Список | pgsql-performance |
On Sun, Jul 10, 2011 at 4:41 AM, Radhya sahal <rad_cs_2006@yahoo.com> wrote:
Dear all ,could any one help me?when i use pgadmin to exceute a query it shows the total time for query ..such as(select * form table_name.........)query total time is for example 100 msi want to know the command that can retentive the query total time in millisecondif i connect with postgresql from java using JDBCi need the query total time necessaryto use it in my projecti don't want run explian just querythank's
long startTime = System.currentTimeMillis();
//execute query
long executionTime = System.currentTimeMillis() - startTime;
В списке pgsql-performance по дате отправления: