[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Statistics information.
From:       Julien Rouhaud <rjuju123 () gmail ! com>
Date:       2024-03-24 11:17:28
Message-ID: CAOBaU_YgDX9o1N6=gVFifjika3Ck+3q01+H1qNHKnCPpnt7FvQ () mail ! gmail ! com
[Download RAW message or body]

On Sat, Mar 23, 2024 at 6:51 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
> 
> On Sat, Mar 23, 2024 at 12:33 AM arun chirappurath <arunsnmimt@gmail.com> wrote:
> > 
> > 1. Last run duration
> > 2. Average time for execution.
> > 3. Filter statistics for a specific function(stored procedure)
> > 4. Filter for specific texts.
> > 5 top queries
> > 6. query plans...
> 
> 
> I see 1, 2, 5 & 6 via AppDynamics, after installing the pg_stat_statements \
> extension.  Vanilla Postgresql does not retain those statistics.

You can use PoWA for that (https://powa.readthedocs.io/en/latest/)


[prev in list] [next in list] [prev in thread] [next in thread]