| From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
|---|---|
| To: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Statistics information. |
| Date: | 2024-03-24 11:17:28 |
| Message-ID: | CAOBaU_YgDX9o1N6=gVFifjika3Ck+3q01+H1qNHKnCPpnt7FvQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Mar 23, 2024 at 6:51 PM Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:
>
> On Sat, Mar 23, 2024 at 12:33 AM arun chirappurath <arunsnmimt(at)gmail(dot)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/)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sud | 2024-03-24 14:25:40 | Is this a buggy behavior? |
| Previous Message | veem v | 2024-03-23 19:07:51 | Re: Not able to purge partition |