On Tue, Apr 20, 2010 at 6:32 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
On Tue, Apr 20, 2010 at 1:20 AM, Renato Oliveirawhile true; do psql mydb -c "select * from pg_stat_activity where
<renato.oliveira@xxxxxxxxxxx> 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?
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@xxxxxxxxxxxxxx)
To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-admin
