Fw: query total time im milliseconds

Поиск
Список
Период
Сортировка
От Radhya sahal
Тема Fw: query total time im milliseconds
Дата
Msg-id 1310322371.24647.YahooMailRC@web38604.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на Re: query total time im milliseconds  (Samuel Gendler <sgendler@ideasculptor.com>)
Ответы Re: Fw: query total time im milliseconds  (Craig Ringer <craig@postnewspapers.com.au>)
Список pgsql-performance
Дерево обсуждения


----- Forwarded Message ----
From: Radhya sahal <rad_cs_2006@yahoo.com>
To: Samuel Gendler <sgendler@ideasculptor.com>
Sent: Sun, July 10, 2011 11:25:46 AM
Subject: Re: [PERFORM] query total time im milliseconds

Thank's

long startTime = System.currentTimeMillis();
//execute query
long executionTime = System.currentTimeMillis() - startTime;

this executionTime is not an actual time for query ,
it includes time for access to postgresql server
 using JDBC

From: Samuel Gendler <sgendler@ideasculptor.com>
To: Radhya sahal <rad_cs_2006@yahoo.com>
Cc: pgsql-performance group <pgsql-performance@postgresql.org>
Sent: Sun, July 10, 2011 10:51:52 AM
Subject: Re: [PERFORM] query total time im milliseconds



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 ms
i want to know the command that can retentive the query total time in millisecond
if i connect with postgresql from java using JDBC
i need the query total time necessaryto use it in my project
i don't want run explian just query
thank's


long startTime = System.currentTimeMillis();
//execute query
long executionTime = System.currentTimeMillis() - startTime; 

В списке pgsql-performance по дате отправления:

Предыдущее
От: Radhya sahal
Дата:
Сообщение: query total time im milliseconds
Следующее
От: lars
Дата:
Сообщение: Re: UPDATEDs slowing SELECTs in a fully cached database