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

[GENERAL] Query timing

2007-03-04 Thread Naz Gassiep
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 pages and pages of planning info between

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 pages

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: [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