Re: auto_explain sample rate

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: auto_explain sample rate
Дата
Msg-id CAFj8pRABvcJ3K2tEav017=uqS=QfhpRsE6PqnWcUgX-hv42ShQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: auto_explain sample rate  (Craig Ringer <craig@2ndquadrant.com>)
Ответы Re: auto_explain sample rate  (Craig Ringer <craig@2ndquadrant.com>)
Список pgsql-hackers


2015-06-03 9:17 GMT+02:00 Craig Ringer <craig@2ndquadrant.com>:


On 2 June 2015 at 15:11, Pavel Stehule <pavel.stehule@gmail.com> wrote:


2015-06-02 9:07 GMT+02:00 Craig Ringer <craig@2ndquadrant.com>:

For the majority of users I'm sure it's sufficient to just have a sample rate. 

Anything that's trying to match individual queries could be interested in all sorts of different things. Queries that touch a particular table being one of the more obvious things, or queries that mention a particular literal. Rather than try to design something complicated in advance that anticipates all needs, I'm thinking it makes sense to just throw a hook in there. If some patterns start to emerge in terms of useful real world filtering criteria then that'd better inform any more user accessible design down the track.

same method can be interesting for interactive EXPLAIN ANALYZE too. TIMING has about 20%-30% overhead and usually we don't need a perfectly exact numbers

I don't understand what you are suggesting here.

using some sampling for EXPLAIN ANALYZE statement

Pavel



--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: auto_explain sample rate
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: auto_explain sample rate