From 0c61cff57a1dc7685fcac9f09451b261f14cb711 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 29 Nov 2009 18:14:32 +0000 Subject: Make pg_stat_activity.application_name visible to all users, rather than being hidden when current_query is. Relocate it to a column position more consistent with that behavior. Per discussion. --- doc/src/sgml/monitoring.sgml | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) (limited to 'doc') diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 94fbce63ad6..f56fd214ae4 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1,4 +1,4 @@ - + Monitoring Database Activity @@ -235,15 +235,15 @@ postgres: user database host pg_stat_activity One row per server process, showing database OID, database - name, process ID, user OID, user name, current query, - query's waiting status, time at which the current transaction and - current query began execution, time at which the process was - started, client's address and port number, and application name. + name, process ID, user OID, user name, application name, + current query, query's waiting status, time at which the current + transaction and current query began execution, time at which the + process was started, and client's address and port number. The columns that report data on the current query are available unless the parameter track_activities has been turned off. - Furthermore, these columns and the application name are only visible if - the user examining the view is a superuser or the same as the user - owning the process being reported on. + Furthermore, these columns are only visible if the user examining + the view is a superuser or the same as the user owning the process + being reported on. -- cgit v1.2.3