On Mon, 2008-10-27 at 17:00 +0900, ITAGAKI Takahiro wrote: > Martin Pihlak <[EMAIL PROTECTED]> 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
