Re: Tailing queries

On Sat, Jun 18, 2016 at 2:26 AM, Aravind Kumar <aravindc26(at)gmail(dot)com> wrote:

> Hi,
>
> I am an application developer, I would like to watch the live logs of
> queries to postgres. This would would be of great help for debugging.
>
> Thanks
>
> Aravind.
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

Check out pg_activity for a live look at what is running

https://github.com/julmon/pg_activity

pg_badger is a good tool for going back and analyzing what gets put into
the postgres logs

http://dalibo.github.io/pgbadger/

Another commercial tool that can do both of these things together is
Vividcortex

http://vividcortex.com/

Keith