Postgres Pro
Downloads
Home   >   mailing lists

Re: Tailing queries - Mailing list pgsql-novice

From Keith
Subject Re: Tailing queries
Date
Msg-id CAHw75vt-mce-GUqT=ws=TtagLES60pn-cAT47tPmbGDx=J1G7g@mail.gmail.com
Whole thread Raw
In response to Tailing queries  (Aravind Kumar <aravindc26@gmail.com>)
List pgsql-novice
Tree view


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

pgsql-novice by date:

Previous
From: richard@xentu.com
Date:
Subject: Re: Tailing queries
Next
From: Jim McNamara
Date:
Subject: \o permission denied