too short string for SQL in pg_stat_backend_activity

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема too short string for SQL in pg_stat_backend_activity
Дата
Msg-id Pine.LNX.4.44.0408171130150.4150-100000@kix.fsv.cvut.cz
обсуждение исходный текст
Ответы Re: too short string for SQL in pg_stat_backend_activity  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hello

I my work I have problem with some ugly SQL. Processing some query takes 2 
days and more (problem is in queries not in PostgreSQL). I can't wait on 
end of query and can't take text of query from serverlog. Text of queries 
has about 2 - 7 Kb. I have problem identifi queries in our is, becouse I 
can see only begin of queries in pg_stat_activity, and in this view is 
text of query cut on 1Kb. 

Can I set somewhere an long for text, which is in current_query in 
"pg_catalog.pg_stat_activity"?

Regards
Pavel Stehule



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

Предыдущее
От: "Hicham G. Elmongui"
Дата:
Сообщение: Re: pulling projection up in plans
Следующее
От: Devrim GUNDUZ
Дата:
Сообщение: psql's \l