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
Дата
Msg-id 40DD3AA8.3040708@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: How can one see what queries are running withing a postgres instance?  (Hervé Piedvache <footcow@noos.fr>)
Ответы Re: How can one see what queries are running withing a  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How can one see what queries are running withing a  ("P.A.M. van Dam " <pam@ramoth.xs4all.nl>)
Список pgsql-performance
>>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.

Chris

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

Предыдущее
От: Chris Cheston
Дата:
Сообщение: Re: postgres 7.4 at 100%
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: postgres 7.4 at 100%