... - Mailing list pgsql-admin

From restellifabio@libero.it
Subject ...
Date
Msg-id I2671U$905D7F4218E8FB0A1353F413E6A56EE3@libero.it
Whole thread Raw
List 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

by




pgsql-admin by date:

Previous
From: David Ecker
Date:
Subject: Re: Killing Long running query or user session
Next
From: Tomasz Myrta
Date:
Subject: Re: Install psql only?