Truncated queries when select * from pg_stat_activity - wishlist / feature request

Поиск
Список
Период
Сортировка
От Dave Witt
Тема Truncated queries when select * from pg_stat_activity - wishlist / feature request
Дата
Msg-id 486D698E.1050309@movenetworks.com
обсуждение исходный текст
Ответы Re: Truncated queries when select * from pg_stat_activity - wishlist / feature request  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Hi Everyone,

My first posting to the group..

I came from a mysql background (~7 years, small/mid database, about 
55gig), where I could do "SHOW FULL PROCESSLIST;" to see all the queries 
currently queued/running on the system.  I found it a very useful feature.

The Postgres equivalent is (roughly) "SELECT * FROM pg_stat_activity;".

..but Postgres only shows the first ~1000 chars from each queued/running 
query.  I know this is a long-standing issue (from reading other 
posts/sites), but I'd like to throw in my vote for showing the entire 
query, in some future version (easier said than done, I know).  After 5 
months of Postgres use, this is by far my biggest wishlist item.

Thanks, congratulations, great work, etc...!

-Dave


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

Предыдущее
От: Russell Smith
Дата:
Сообщение: Re: [PATCHES] Removal of the patches email list
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Truncated queries when select * from pg_stat_activity - wishlist / feature request