Re: Query preformence

Поиск
Список
Период
Сортировка
От Ferdinand Smit
Тема Re: Query preformence
Дата
Msg-id 200111081412.fA8ECNd31462@server9.telegraafnet.nl
обсуждение исходный текст
Ответ на Re: Query preformence  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Hoi Tom,

> Sure you do: you look at the execution statistics you don't like and
> then look back to see the most recent query logged by the same backend.

Our DB is heavily used so this would be a full-time job.

> I do see an issue here, which is that the STATISTICS messages should be
> emitted by elog() so that they will be tagged with a PID when log_pid is
> true.  But that's easily fixed.

This would be a good solution, so i can generate automatic reports.

Ferdinand

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

Предыдущее
От: Karel Zak
Дата:
Сообщение: Re: stupid patch of pg_dumplo
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Enhanced index details using \d in psql