[NOVICE] Tailing queries

[Aravind Kumar]

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-...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

[ric...@xentu.com]

On 2016-06-18 07:26, Aravind Kumar 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.

Hi Aravind,

I had that same problem & ended up writing a little application that
reads the logs & displays them in a gui. Source at bitbucket.

http://www.xentu.com/pgprofiler/

The way I had to do it seems awkward, however I don't think postgresql
offers any better way of writing a tool like mssql's profiler.

Am happy to be proved wrong!

Richard

[Keith]

On Sat, Jun 18, 2016 at 2:26 AM, Aravind Kumar <aravi...@gmail.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-...@postgresql.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