Thread: query total time im milliseconds

query total time im milliseconds

From
Radhya sahal
Date:
 
 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