Re: [GENERAL] Query timing

2007-03-05 Thread Robert Treat
On Monday 05 March 2007 02:38, Naz Gassiep wrote: > That's not quite as fast as I would like to do it, that throws in a few > more steps which slow down the development process. However if there is > no way I will persevere with the method I have now. > Thanks, > - Naz. > There are several logging

Re: [GENERAL] Query timing

2007-03-04 Thread Naz Gassiep
That's not quite as fast as I would like to do it, that throws in a few more steps which slow down the development process. However if there is no way I will persevere with the method I have now. Thanks, - Naz. Jorge Godoy wrote: Naz Gassiep <[EMAIL PROTECTED]> writes: Using EXPLAIN ANALY

Re: [GENERAL] Query timing

2007-03-04 Thread A. Kretschmer
am Mon, dem 05.03.2007, um 15:28:29 +1100 mailte Naz Gassiep folgendes: > Using EXPLAIN ANALYZE I can get the execution time of a query. Is there > a command I can use to get the execution time without the planning Within psql, the command-line-interface, you can use \timing to switch on/off re

Re: [GENERAL] Query timing

2007-03-04 Thread Jorge Godoy
Naz Gassiep <[EMAIL PROTECTED]> writes: > Using EXPLAIN ANALYZE I can get the execution time of a query. Is there a > command I can use to get the execution time without the planning information? > I just need to time lots of queries that have complex plans and it'd be easier > if I didn't have pa