Home > mailing lists

query total time im milliseconds - Mailing list pgsql-performance

From	Radhya sahal
Subject	query total time im milliseconds
Date	July 10, 2011 16:44:38
Msg-id	1310316270.63536.YahooMailRC@web38606.mail.mud.yahoo.com Whole thread Raw
List	pgsql-performance

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 retetive the query total time in millisecond

if i connect with postgresql from java using JDBC

i need the query total time necessary to use it in my project

i don't want run explian,explain gives estimated i want real total time for the query

thank's

From: Tom Lane
Date: 10 July 2011, 16:43:05
Subject: Re: INSERT query times

From: Samuel Gendler
Date: 10 July 2011, 17:52:00
Subject: Re: query total time im milliseconds