Re: contrib/pg_stat_statements - Mailing list pgsql-hackers

From Martin Pihlak
Subject Re: contrib/pg_stat_statements
Date
Msg-id 48FCA095.8020709@gmail.com
Whole thread Raw
In response to contrib/pg_stat_statements  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: contrib/pg_stat_statements
List pgsql-hackers
ITAGAKI Takahiro wrote:
> I'd like to submit pg_stat_statements contrib module, that counts up
> incoming statements in shared memory and summarizes the result as a view.
> It is just a statements-version of pg_stat_user_functions.
> 
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?

PS. Similar feature would be useful for auto-explain as well.

regards,
Martin


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Index use during Hot Standby
Next
From: "Hitoshi Harada"
Date:
Subject: Re: Window Functions: buffering strategy