Postgres Pro
Downloads
Home   >   mailing lists

wiki edit - Mailing list pgsql-www

From Filip Rembiałkowski
Subject wiki edit
Date
Msg-id CAP_rww=ptwEUNpd=jZQTJDp=Q46gqxVRezYxYF=nYFwXd=yWfg@mail.gmail.com
Whole thread Raw
Responses Re: wiki edit
List pgsql-www
Tree view
Good day,

Could someone update the last query here (it no longer works with current postgres)?


New query:

SELECT a.datname,
         l.relation::regclass,
         l.transactionid,
         l.mode,
         l.GRANTED,
         a.usename,
         a.query,
         a.query_start,
         age(now(), a.query_start) AS "age",
         a.pid
FROM pg_stat_activity a
JOIN pg_locks l ON l.pid = a.pid
ORDER BY a.query_start;

Thanks!

pgsql-www by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Namespace projects.postgresql.org
Next
From: Tom Lane
Date:
Subject: Re: Namespace projects.postgresql.org