From: | Naz Gassiep <naz(at)mira(dot)net> |
---|---|
To: | |
Cc: | Postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Query timing |
Date: | 2007-03-05 07:38:13 |
Message-ID: | 45EBC8E5.1040706@mira.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <naz(at)mira(dot)net> 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 and pages of planning info between tries. The queries
>> themselves are one line each, but refer to views, which make the plans pretty
>> complex. Being able to see several times in one terminal window would be
>> easier.
>>
>
> Write the queries in a file, run them with psql -f and grep for the desired
> lines only.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2007-03-05 07:57:18 | Re: real multi-master replication? |
Previous Message | Tino Wildenhain | 2007-03-05 06:14:32 | Re: date format |