Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46172=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1cP2zc-0001J6-MN
	for pgsql-admin@arkaria.postgresql.org; Thu, 05 Jan 2017 08:01:48 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46172=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1cP2zb-0005Ud-W3
	for pgsql-admin@arkaria.postgresql.org; Thu, 05 Jan 2017 08:01:48 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <gunnar.bluth.extern@elster.de>)
	id 1cP2xu-0003XK-BW
	for pgsql-admin@postgresql.org; Thu, 05 Jan 2017 08:00:02 +0000
Received: from edmmai02.een.elster.de ([217.237.175.35])
	by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
	(Exim 4.84_2)
	(envelope-from <gunnar.bluth.extern@elster.de>)
	id 1cP2xp-00016Q-Ap
	for pgsql-admin@postgresql.org; Thu, 05 Jan 2017 08:00:01 +0000
X-IronPort-AV: E=Sophos;i="5.33,320,1477954800";
   d="scan'208";a="4353853"
Received: from edmzrf02.een.elster.de ([192.168.20.13])
  by edmmai02.een.elster.de with ESMTP/TLS/DHE-RSA-AES256-GCM-SHA384;
 05 Jan 2017 08:59:55 +0100
Received: from [10.200.128.41] (unknown [10.200.128.41])
	by edmzrf02.een.elster.de (Postfix) with ESMTPSA id BF49C3E10C3
	for <pgsql-admin@postgresql.org>; Thu,  5 Jan 2017 08:59:55 +0100 (CET)
Subject: Re: Displaying ProcessList to Users
To: pgsql-admin@postgresql.org
References: 
 <CAAV2-mWau0uEutVKAD_xwqzwdivqyNhqMM5SJ2maz-GpoDj_vA@mail.gmail.com>
From: "Gunnar \"Nick\" Bluth" <gunnar.bluth.extern@elster.de>
Message-ID: <4a01458f-d8fd-c4f4-b7ed-57cb552e2e3c@elster.de>
Date: Thu, 5 Jan 2017 08:59:55 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.5.1
MIME-Version: 1.0
In-Reply-To: 
 <CAAV2-mWau0uEutVKAD_xwqzwdivqyNhqMM5SJ2maz-GpoDj_vA@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
X-Pg-Spam-Score: -7.4 (-------)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Am 05.01.2017 um 08:55 schrieb Günce Kaya:
> Hi All,

Hi Günce,


> I'm curious about can I display or list users who execute which queries
> in databases.
> 
> Any help would be appreciated.

Have a look at pg_stat_activity.

Regards,
-- 
Gunnar "Nick" Bluth
DBA ELSTER

Tel:   +49 911/991-4665
Mobil: +49 172/8853339


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin