Re: contrib/pg_stat_statements

On Mon, 2008-10-27 at 17:00 +0900, ITAGAKI Takahiro wrote:
> Martin Pihlak <martin.pihlak@gmail.com> wrote:
> 
> > ITAGAKI Takahiro wrote:
> > > I'd like to submit pg_stat_statements contrib module
> > > 
> > Nice work! There is one feature I'd like to request -- we need to be able
> > to also track nested statements. This would greatly simplify diagnosing
> > performance problems in complex stored procedures. Perhaps the GUC
> > track_statements could be made an enum - none, top, all?
> 
> I tried your request, but found it's hard to determine query text
> where the executing plan comes. 

Are you sure you need query _text_ ?

Why not just aggregate on function OID and reslve OID to text only at
display stage ?

----------------
Hannu