On Sun, Nov 4, 2012 at 1:35 AM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > Hello > > 2012/11/4 Satoshi Nagayasu <sn...@uptime.jp>: >>> >> >> Do we have something to add to auto_explain? > > Now I am working on expanding slow query record and auto_explain with > some locking times (lock on objects, lock on enhancing pages, other > locks).
But this would only work if you used 'auto_explain.log_analyze=1', which is has nasty performance implications. Or you planning on changing the way log_analyze works to get around this? > > Just statement time produces too less information in our complex and > "unpredictable" cloud environment with thousand databases and hundreds > servers. I think it would be easier to implement but still a big step forward over what we currently have if "explain analyze" and "\timing" would show the 'rusage' values in addition to the wall-clock time. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers