Re: Logging functions executed by queries in 8.2?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Logging functions executed by queries in 8.2?
Дата
Msg-id 24628.1170725927@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Logging functions executed by queries in 8.2?  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Logging functions executed by queries in 8.2?  (<korryd@enterprisedb.com>)
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> In recent versions, we've changed the logging of function executions so 
> that only the function call is logged, and not any of the queries which it 
> may execute internally.  While most of the time this method is superior 
> for performance analysis, in applications with extensive multi-line stored 
> procedures sometimes you want to log each individual query.

ISTM that the wave of the future for this is an instrumentation plug-in,
not further kluging of the query logging functionality.  I had the
impression that Korry and EDB had some prototype capability in that
direction already, and surely it shouldn't be that hard to write if not.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Logging functions executed by queries in 8.2?
Следующее
От: ITAGAKI Takahiro
Дата:
Сообщение: Re: Proposed adjustments in MaxTupleSize andtoastthresholds