Re: Statistics information.

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Statistics information.
Дата
Msg-id CANzqJaAP-Y0wc3zVBdeKMKemHMBCU+pc+awuYmo_OggW3iAtSA@mail.gmail.com
обсуждение исходный текст
Ответ на Statistics information.  (arun chirappurath <arunsnmimt@gmail.com>)
Ответы Re: Statistics information.
Список pgsql-general
On Sat, Mar 23, 2024 at 12:33 AM arun chirappurath <arunsnmimt@gmail.com> wrote:
Dear All,

Apologies the way i am asking question as i am more a SQL Server person and a new postgre man..

I have used a query store in SQL server. it provides me option to load statistics data to temp table and get  below important information.

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. 

В списке pgsql-general по дате отправления:

Предыдущее
От: Matthias Apitz
Дата:
Сообщение: Re: soft lockup - CPU#16 stuck for 3124s! [postmaster:2273]
Следующее
От: veem v
Дата:
Сообщение: Re: Not able to purge partition