Re: Tail -f or watch for postgres

On Tue, Apr 20, 2010 at 6:32 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:

> On Tue, Apr 20, 2010 at 1:20 AM, Renato Oliveira
> <renato(dot)oliveira(at)grant(dot)co(dot)uk> wrote:
> > Dear all,
> >
> > It may sounds crazy it may not sound so crazy.
> >
> > I was here think are there any commands to watch new transactions rolling
> > through the screen like a terminal monitor?
> >
> > For example, if you want to watch a log file you can execute the command;
> > tail –f <logfile> or watch.
> >
> > This will keep the log entries rolling and being displayed on screen.
> >
> > Is there something similar to postgreSQL?
>
> while true; do psql mydb -c "select * from pg_stat_activity where
> current_query <>'<IDLE>'";sleep 10;done
>
> or something like that.
>

That's a good one --

You could also set 'log_min_duration_statement = 1000 '

(This logs all statements taking 1 second or more into the logfile),
then do a 'tail -f ' on the latest log in the pg_log folder. The lower you
set log_min_duration_statement, the more overhead you place on your database
(this could be significant, so be careful).

--Scott

>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>