| From: | "restellifabio(at)libero(dot)it" <restellifabio(at)libero(dot)it> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | |
| Date: | 2004-08-09 08:17:54 |
| Message-ID: | I2671U$905D7F4218E8FB0A1353F413E6A56EE3@libero.it |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
by
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Izzet | 2004-08-09 10:04:49 | Re: psql won't stayed connected |
| Previous Message | Thomas Wegner | 2004-08-08 18:35:23 | Re: Win32 and Tablespaces |