Re: Displaying current queries on the database?

Поиск
Список
Период
Сортировка
От
Тема Re: Displaying current queries on the database?
Дата
Msg-id 44589.203.145.129.36.1031593961.squirrel@mail.trade-india.com
обсуждение исходный текст
Ответ на Displaying current queries on the database?  (Sloan Bowman <smileyq@nashlinux.com>)
Список pgsql-sql
its possible,


select * from pg_stat_activity after
AS connect as postgres.

THOUGH NEEd to configure postgresql.conf accordigly


regds
mallaH


> I was wondering if there is a way to display all of the current queries  that are being
> submitted to the database. Thanks in advance.
>
> -Sloan Bowman
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9'
> the postmaster



-----------------------------------------
Get your free web based email at trade-india.com.  "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/




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

Предыдущее
От: Sloan Bowman
Дата:
Сообщение: Displaying current queries on the database?
Следующее
От: Charles Hauser
Дата:
Сообщение: stored procedures: sybase -> postgreSQL ?