Re: How to view the activity of postgresql

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@xentu.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@postgresql.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