Posted By: BigFoot (go!go!go!) on 'CZdatabases'
Title:     Re: postgreSQL administrace
Date:      Mon Sep 22 20:04:43 2003

> Nema naodou postgresql nejakou moznost jak si zjistiti informace o prave
> probihajicich dotazech spojenich na databazi?
>
> Neco jako select * from sys_tables?
>
> Potrebuju vedet kdo je spojeny s databazi, kolik jeho konekce zere
> systemovcyh prostredku, popr jakou query provadi.

SELECT * FROM pg_stat_activity;

kdyby to nestacilo, dalsi jsou tady:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=monitoring-stat
s.html#MONITORING-STATS-VIEWS

BigFoot, aka Yaroukh; yaroukh@email.cz
"Budiz svetlo", rekl Booh - a bylo svetlo ...
"Budiz k nicemu", rekl Booh - and here I am !
8}__ __ _