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

От: Tom Lane
Тема: Re: How can one see what queries are running withing a
Дата: ,
Msg-id: 9873.1088261157@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: 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, )

Christopher Kings-Lynne <> writes:
> Even easier:
> SELECT * FROM pg_stat_activity;

But note you must enable stats_command_string to make this very useful.

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: How can one see what queries are running withing a
От: Chris Cheston
Дата:
Сообщение: Re: postgres 7.4 at 100%