On Thu, Oct 22, 2009 at 2:38 AM, Julius Tuskenis <julius@xxxxxxxx> wrote: > Thank you. I'll ask to log long lasting queries, but still - isn't there a > way to see on what postgres works in real time? I don't know. You can adjust it per database btw, so if you have permissions on the db itself, a simple alter database smarlowe set log_min_duration_statement=1000; Pretty sure you have to be a superuser to set that. But no need to even reload your db. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin