Re: Script and tool to monitoring sessions

On Thu, Sep 24, 2015 at 5:58 AM, abdujaparov <afmulone@gmail.com> wrote:
> IO
> CPU
> WAIT
> CONCURRENCY
> CLUSTER
> CONFIGURATION
> NETWORK
> etc

Check describe_*.sh and stat_*.sh scripts from pgcookbook
https://github.com/grayhemp/pgcookbook/tree/master/bin/.

> and for each type of waits the wait event for example

You might find log_lock_waits intersting here
http://www.postgresql.org/docs/9.4/static/runtime-config-logging.html#GUC-LOG-LOCK-WAITS.

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (499) 346-7196, +7 (988) 888-1979
gray.ru@gmail.com