Re: Script and tool to monitoring sessions

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: abdujaparov <afmulone(at)gmail(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Script and tool to monitoring sessions
Date: 2015-09-25 04:00:42
Message-ID: CAL_0b1sPd2zz_E+cR2K2=+vbReW52p_XtfZTGc91MzUL2BnkwQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, Sep 24, 2015 at 5:58 AM, abdujaparov <afmulone(at)gmail(dot)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(dot)ru(at)gmail(dot)com

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message abdujaparov 2015-09-25 08:38:37 Re: Script and tool to monitoring sessions
Previous Message Thomas Kellerer 2015-09-24 16:59:08 Re: Script and tool to monitoring sessions