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