Skip site navigation (1) Skip section navigation (2)

Re:

From: "Bender, Cheryl" <cbender(at)mriresearch(dot)org>
To: "Monica Libero" <mparotti(at)libero(dot)it>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re:
Date: 2004-09-14 19:53:00
Message-ID: D5DB5D0D27171247AFEC9648EE98752F03220126@KCEX2KV1.mri-kc.int (view raw or flat)
Thread:
Lists: pgsql-admin
Are you sure there is current activity on your backend when you are
running this query?  I get the same result because there are no queries
executing.   
 

Cheryl Bender 
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Monica Libero
Sent: Friday, August 20, 2004 5:27 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] 



	
	help me!
	I want see all field od this query:
	SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
	pg_stat_get_backend_activity(s.backendid) AS current_query FROM
(SELECT
	pg_stat_get_backend_idset() AS backendid) s;
	
	 procpid | current_query
	---------+---------------
	    6449 |
	    6397 |
	    7905 |
	    7932 |
	    8509 |
	    8018 |
	    6638 |
	    8046 |
	    8627 |
	    8068 |
	    8077 |
	    8103 |
	    8104 |
	    8105 |
	    8126 |
	    8164 |
	    8173 |
	    8198 |
	    8208 |
	    8242 |
	    8590 |
	
	I is super user and not see field current_quey
	
	Fabio RESTELLI
	
	
	
	
	

pgsql-admin by date

Next:From: Jeff StoutDate: 2004-09-14 19:58:34
Subject: Postgres and Funk Radius
Previous:From: Goulet, DickDate: 2004-09-14 19:39:51
Subject: Re: Setup for a db class

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group