Re: pg_stat_statements cluttered with "DEALLOCATE dbdpg_p*"

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: pg_stat_statements cluttered with "DEALLOCATE dbdpg_p*"
Дата
Msg-id 533AD3D5.5080407@dunslane.net
обсуждение исходный текст
Ответ на pg_stat_statements cluttered with "DEALLOCATE dbdpg_p*"  (Fabien COELHO <coelho@cri.ensmp.fr>)
Ответы Re: pg_stat_statements cluttered with "DEALLOCATE dbdpg_p*"  (Fabien COELHO <coelho@cri.ensmp.fr>)
Список pgsql-hackers
On 04/01/2014 10:45 AM, Fabien COELHO wrote:
>
> Hello pgdevs,
>
> I noticed that my pg_stat_statements is cluttered with hundreds of 
> entries like "DEALLOCATE dbdpg_p123456_7", occuring each only once.
>
> It seems to me that it would be more helful if these similar entries 
> where aggregated together, that is if the query "normalization" could 
> ignore the name of the descriptor.
>
> Any thoughts about this?


You might find this relevant: 
<http://blog.endpoint.com/2014/02/perl-dbdpg-postgresql-prepared-statement.html>

cheers

andrew




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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Including replication slot data in base backups
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Including replication slot data in base backups