| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Victor Spång Arthursson <victor(at)tosti(dot)dk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Newbie-question |
| Date: | 2003-10-28 15:38:28 |
| Message-ID: | 20031028073628.I60730@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 28 Oct 2003, [ISO-8859-1] Victor Spng Arthursson wrote:
> Are presently converting from mysql to postgresql, and my first
> newbiequestion is how to make all the rows in a result from a select
> just "swosh" by? That is, I dont want to see them page for page; just
> to scroll by so I can se the last line with the number of corresponding
> rows.
I believe
\pset pager off
will turn off the pager in psql
> And is there a way to see how long time a query took to execute without
> running a EXPLAIN ANALYSE on the query?
In psql you can also use \timing to turn on/off a printing of how many ms
the query took (including data transfer time iirc) after the result set is
printed.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2003-10-28 15:38:43 | Re: Newbie-question |
| Previous Message | Tom Lane | 2003-10-28 15:36:13 | Re: SCSI vs. IDE performance test |