On 2014-01-28 07:27:52 -0800, Greg Stark wrote: > > And all of that without removing a valuable debugging/tracing tool from > > other users. > > Why is application_name useful for users who aren't the DBA and aren't > the user in question. The sql_query would probably be more useful than > application_name but we hide that...
It is useful to find out what the backend blocking you by taking out locks or using all CPU is doing. And a sql query obviously can contain actually sensitive data that you can't really hide. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
