Re: Newbie-question

Поиск
Список
Период
Сортировка
От Brendan Jurd
Тема Re: Newbie-question
Дата
Msg-id 3F9E7C38.9030209@blakjak.sytes.net
обсуждение исходный текст
Ответ на Newbie-question  (Victor Spång Arthursson <victor@tosti.dk>)
Ответы Re: Newbie-question
Re: Newbie-question
Список pgsql-general
If you're querying from within the psql client program (and it seems
from your question that you are), then the results are reported back via
the utility "less" (or a less-like program internal to psql, can someone
else clarify?) if the results are more than a single page in length.  I
don't think you can make the results "swosh", but you can instantly move
to the bottom of the output by hitting "G".  That's uppercase "G", not
to be confused with lowercase "g", which is a different command and will
take you to the *top* of the output.

I hope that answers your first question.

As for getting timing information on your queries, the psql client will
do this for you if you enable the option by entering "\timing".  Query
timing is off by default, so ordinarily you'd need to enable it every
time you start a new psql session.

Good hunting

BJ

Victor Spång 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.
>
> And is there a way to see how long time a query took to execute
> without running a EXPLAIN ANALYSE on the query?
>
> Sincerely
>
> Victor - Copenhagen/Malmoe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html



В списке pgsql-general по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Newbie-question
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: SELECT with row>32k hangs over SSL-Connection