Postgres Pro
Downloads
Home   >   mailing lists

something similar to explain - Mailing list pgsql-admin

From Lucas Rockwell
Subject something similar to explain
Date
Msg-id Pine.GSO.4.40.0203040713110.24352-100000@socrates.Berkeley.EDU
Whole thread Raw
In response to Re: Client Authentication  ("Craig Moon" <craig@usight.com>)
Responses Re: something similar to explain  ("Dan Langille" <dan@langille.org>)
Re: something similar to explain  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
hi,

i am running some tests and i would like to see how long it takes to run a
query. "explain" gives me query plan info, but i want to actually run the
query and then find out how long it took.

is there a way with psql to get the time it takes to perform a query?

thanks.

-lucas

------------------------
Lucas Rockwell
UAS Systems Group
510.642.6465
lr@socrates.berkeley.edu
------------------------

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Which trigger execute which function?
Next
From: Stephan Szabo
Date:
Subject: Re: Which trigger execute which function?