X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 24517329E69 for ; Mon, 13 Sep 2004 21:32:24 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31057-10 for ; Mon, 13 Sep 2004 20:32:16 +0000 (GMT) Received: from smtp20.libero.it (smtp20.libero.it [193.70.192.147]) by svr1.postgresql.org (Postfix) with ESMTP id 18B21329DE0 for ; Mon, 13 Sep 2004 21:32:16 +0100 (BST) Received: from localhost (172.16.1.79) by smtp20.libero.it (7.0.027-DD01) id 40E3F8E700D0BBA3 for pgsql-admin@postgresql.org; Mon, 13 Sep 2004 22:32:15 +0200 Received: from fisso (151.29.243.58) by smtp3.libero.it (7.0.027-DD01) id 40D0721D03772CFC for pgsql-admin@postgresql.org; Mon, 13 Sep 2004 22:32:14 +0200 Message-ID: <000201c499d0$9ca01280$d70106c0@fisso> Reply-To: "Monica Libero" From: "Monica Libero" To: Subject: Date: Sat, 21 Aug 2004 00:26:47 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00F0_01C48715.8B353700" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Virus-Scanned: by amavisd-new at libero.it serv1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=4.3 tagged_above=0.0 required=5.0 tests=DATE_IN_PAST_96_XX, HTML_30_40, HTML_MESSAGE, RCVD_IN_BL_SPAMCOP_NET X-Spam-Level: **** X-Archive-Number: 200409/115 X-Sequence-Number: 14818 This is a multi-part message in MIME format. ------=_NextPart_000_00F0_01C48715.8B353700 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 ------=_NextPart_000_00F0_01C48715.8B353700 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

help me!
I want see all field od th= is=20 query:
SELECT pg_stat_get_backend_pid(s.backendid) AS=20 procpid,
pg_stat_get_backend_activity(s.backendid) AS current_query FROM= =20 (SELECT
pg_stat_get_backend_idset() AS backendid) s;

 procpi= d |=20 current_query
---------+---------------
    6449=20 |
    6397 |
    7905=20 |
    7932 |
    8509=20 |
    8018 |
    6638=20 |
    8046 |
    8627=20 |
    8068 |
    8077=20 |
    8103 |
    8104=20 |
    8105 |
    8126=20 |
    8164 |
    8173=20 |
    8198 |
    8208=20 |
    8242 |
    8590 |

I is sup= er=20 user and not see field current_quey

Fabio=20 RESTELLI




------=_NextPart_000_00F0_01C48715.8B353700--