Date: Fri, 8 Oct 2021 11:40:23 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Thomas Kellerer <shammat@gmx.net>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Better, consistent instrumentation for postgreSQL using a
 similar API as Oracle
Message-ID: <20211008154023.GC31533@momjian.us>
References: 
 <CAMzkAgGAwh=vsUmtEOC-57GhbFo4eh_B7gJCWMqH4yR7hHJjgA@mail.gmail.com>
 <CAH2-Wzn-+=aYrMw4pHbV7yYVyRYskJkNLaV6HeHj94oyKJiRKA@mail.gmail.com>
 <efbd4d1a-48d5-99ac-549f-5e3f37812273@ardentperf.com>
 <4d9e6ac5-5b13-84fe-74b5-07421501318e@gmail.com>
 <20211008152132.GB31533@momjian.us>
 <738e0157-da3f-01aa-4e43-2b6e3c08ecca@gmx.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <738e0157-da3f-01aa-4e43-2b6e3c08ecca@gmx.net>
User-Agent: Mutt/1.10.1 (2018-07-13)
Archived-At: 
 <https://www.postgresql.org/message-id/20211008154023.GC31533%40momjian.us>
Precedence: bulk

On Fri, Oct  8, 2021 at 05:28:37PM +0200, Thomas Kellerer wrote:
> Bruce Momjian schrieb am 08.10.2021 um 17:21:
> > However, I also need to ask how the wait event information, whether
> > tracing or sampling, can be useful for Postgres because that will drive
> > the solution.
> 
> I guess everyone will use that information in a different way.
> 
> We typically use the AWR reports as a post-mortem analysis tool if
> something goes wrong in our application (=customer specific projects)
> 
> E.g. if there was a slowdown "last monday" or "saving something took minutes yesterday morning",
> then we usually request an AWR report from the time span in question. Quite frequently
> this already reveals the culprit. If not, we ask them to poke in more detail into v$session_history.
> 
> So in our case it's not really used for active monitoring, but for
> finding the root cause after the fact.
> 
> I don't know how representative this usage is though.

OK, that's a good usecase, and something that certainly would apply to
Postgres.  Don't you often need more than just wait events to find the
cause, like system memory usage, total I/O, etc?

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.