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

From: "Monica Libero" <mparotti(at)libero(dot)it>
To: <pgsql-admin(at)postgresql(dot)org>
Subject:
Date: 2004-08-20 22:26:47
Message-ID: 000201c499d0$9ca01280$d70106c0@fisso (view raw or flat)
Thread:
Lists: pgsql-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: Bruno Wolff IIIDate: 2004-08-21 14:38:00
Subject: Re: question
Previous:From: Bruno Wolff IIIDate: 2004-08-20 20:57:27
Subject: Re: question

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