Re: investigating slow queries through pg_stat_activity

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: investigating slow queries through pg_stat_activity
Дата
Msg-id 19956.1119294704@sss.pgh.pa.us
обсуждение исходный текст
Ответ на investigating slow queries through pg_stat_activity  (Dan Harris <fbsd@drivefaster.net>)
Список pgsql-performance
Dan Harris <fbsd@drivefaster.net> writes:
> However, the problem I have is that pg_stat_activity only returns the
> first n (255?) characters of the SQL as "current_query", so it gets
> chopped off at the end.  I would very much like to find out how I can
> get the *entire* query that is active.  Is this possible?

I think the limit is ~1000 characters in 8.0 and later.  However, you
can't realistically have "unlimited" because of constraints of the stats
messaging mechanism.

            regards, tom lane

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

Предыдущее
От: Jacques Caron
Дата:
Сообщение: Re: investigating slow queries through
Следующее
От: George Essig
Дата:
Сообщение: Re: investigating slow queries through pg_stat_activity