Truncated queries when select * from pg_stat_activity - wishlist/ feature request
in [PgSql]
|
Prev: CommitFest rules
Next: Truncated queries when select * frompg_stat_activity - wishlist / feature request
From: Dave Witt on 3 Jul 2008 20:06 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |