- Mailing list pgsql-admin

From Monica Libero
Subject
Date
Msg-id 000201c499d0$9ca01280$d70106c0@fisso
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

Fabio RESTELLI




pgsql-admin by date:

Previous
From: Joepie Platteau
Date:
Subject: Trigger set to backup to other table NOT FUNCTIONING...
Next
From: "Andrew Janian"
Date:
Subject: Database size