Re: How can one see what queries are running withing a

Список
Период
Сортировка
От P.A.M. van Dam
Тема Re: How can one see what queries are running withing a
Дата
Msg-id 20040627172520.GA3038@pmg.xs4all.nl
обсуждение исходный текст
Ответ на Re: How can one see what queries are running withing a  (Christopher Kings-Lynne)
Список pgsql-performance
Дерево обсуждения
How can one see what queries are running withing a postgres instance?  ("P.A.M. van Dam", )
 Re: How can one see what queries are running withing a postgres instance?  (Hervé Piedvache, )
  Re: How can one see what queries are running withing a postgres instance?  (Hervé Piedvache, )
   Re: How can one see what queries are running withing a  (Christopher Kings-Lynne, )
    Re: How can one see what queries are running withing a  (Tom Lane, )
    Re: How can one see what queries are running withing a  ("P.A.M. van Dam ", )
 Re: How can one see what queries are running withing a  (Roger Ging, )
On Sat, Jun 26, 2004 at 04:58:16PM +0800, Christopher Kings-Lynne wrote:
>
> >>Let see in contrib/ the application pg_who ... you will see the process,
> >>the queries, and the CPU ... ;o)
>
> Even easier:
>
> SELECT * FROM pg_stat_activity;
>
> As a superuser.

Thanks!

That works as needed!

Best regards,

    Pascal

>
> Chris
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html

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

Предыдущее
От: "Mischa Sandberg"
Дата:
Сообщение: Re: Query performance
Следующее
От: Joseph Shraibman
Дата:
Сообщение: planner and worst case scenario