Re: postgresql query runtime

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2011/10/11 Radhya sahal <rad_cs_2006@xxxxxxxxx>:
> Hi
> I want to know how can i measure runtime query in postgresql if i use
> command line psql?
> not explain rutime for the query such as the runtime which appear in pgadmin
> ?
> such as Total query runtime: 203 ms.
>

Hello

use

\timing

\? is your friend :)

Regards

Pavel Stehule

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux