Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_stat_statements cluttered with "DEALLOCATE dbdpg_p*" - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: pg_stat_statements cluttered with "DEALLOCATE dbdpg_p*"
Date
Msg-id 533AD3D5.5080407@dunslane.net
Whole thread Raw
In response to pg_stat_statements cluttered with "DEALLOCATE dbdpg_p*"  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: pg_stat_statements cluttered with "DEALLOCATE dbdpg_p*"
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Including replication slot data in base backups
Next
From: Andres Freund
Date:
Subject: Re: Including replication slot data in base backups