Re: How to view the activity of postgresql

On Apr 28, 2016 2:42 AM, <richard(at)xentu(dot)com> wrote:
>
> On 2016-04-28 07:18, Wei Shan wrote:
>>
>> you can try pgbadger.
>>
>> https://github.com/dalibo/pgbadger [3]
>>
>>
>> On 28 April 2016 at 14:13, <richard(at)xentu(dot)com> wrote:
>>
>>> I want to see what statements are being executed on a remote
>>> postgresql server, ideally in a scrolling display in some gui tool.
>>> In MSSQL, there is a profiler application that gives this.
>>>
>>> The best I've found so far is to set postgresql to log to a csv file
>>> & then use pg_read_file to periodically read the log file & display
>>> it to the user.
>>>
>>> I've written a little tool that does that:
>>> http://www.xentu.com/pgprofiler/ [1]
>>>
>>>
>>> However, it seems a very akward way to achieve what I'm looking for
>>> and will probably slow the server with all the file reading &
>>> writing involved.
>>>
>>> Is there a more efficient way of doing this?
>>>
>>> --
>>> 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 [2]
>>
>>
>> --
>>
>> Regards,
>> Ang Wei Shan
>>
>
> Thanks Ang,
>
> As far as I can see, this is a postmortum analysis of the log files. I
want to somehow see the statements as they get received by the server, as
if I were tailing the log file.
>
> Regards
> Richard
>
>
>
> --
> 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

https://github.com/julmon/pg_activity

Keith