Postgres Pro
Downloads
Home   >   mailing lists

Thread: Tailing queries

Tailing queries

From
Aravind Kumar
Date:
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.

Re: Tailing queries

From
richard@xentu.com
Date:
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

Re: Tailing queries

From
Keith
Date:


On Sat, Jun 18, 2016 at 2:26 AM, Aravind Kumar <aravindc26@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-novice@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