| From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Query Optimization |
| Date: | 2006-05-21 07:34:19 |
| Message-ID: | 20060521073419.GA5582@KanotixBox |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
shakil tanvir <tanvirshakil(at)yahoo(dot)com> schrieb:
> Hi Guys,
>
> Can anyone tell me, how i can see at psql that how fast my query is executing?
You can use "\timing" to switch timing on/off, and you can use explain
and explain analyse.
09:33 < akretschmer|home> ??explain
09:33 < rtfm_please> For information about explain
09:33 < rtfm_please> see http://techdocs.postgresql.org/oscon2005/robert.treat/OSCON_Explaining_Explain_Public.sxi
09:33 < rtfm_please> or http://www.postgresql.org/docs/current/static/sql-explain.html
Btw.: please no HTML, and please don't hijacking other threads.
HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sam karush | 2006-05-21 10:45:10 | Re: PG on zeta 1.0 |
| Previous Message | shakil tanvir | 2006-05-21 06:56:19 | Query Optimization |