Hannu Krosing <hannu@2ndQuadrant.com> wrote:
> > Martin Pihlak <martin.pihlak@gmail.com> wrote:
> > > we need to be able to also track nested statements.
> >
> > 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 ?
He wants to track pieces of functions.
Function OID and *positions in the source text* would be needed.
Per-function tracking is already done in pg_stat_user_functions,
that uses function OIDs.
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center