Re: Tuning queries inside a function

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Tuning queries inside a function
Дата
Msg-id 42729017.9060805@commandprompt.com
обсуждение исходный текст
Ответ на Re: Tuning queries inside a function  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Ответы Re: Tuning queries inside a function  (Mike Nolan <nolan@gw.tssi.com>)
Список pgsql-general
>
> Huh, sorry, this doesn't work ... we don't allow DECLARE for EXPLAIN.
> It'd be neat though ...

What about having a debug mode for the function. E.g:

selet * from foo('bar','debug')

When you run with debug it actually runs the function but outputs
notices that are the explain anaylze of each function? You might
I would have to check be able to include a timestamp at the beginning
of each notice.

This will allow you to figure out where your slow downs are that are
not query related?

Sincerely,

Joshua D. Drake


>


--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedication Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Tuning queries inside a function
Следующее
От: typing80wpm@aol.com
Дата:
Сообщение: p2p ip connection problems