| From: | Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com> |
|---|---|
| To: | pgsql-www(at)postgresql(dot)org |
| Subject: | wiki edit |
| Date: | 2019-03-14 14:54:23 |
| Message-ID: | CAP_rww=ptwEUNpd=jZQTJDp=Q46gqxVRezYxYF=nYFwXd=yWfg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-www |
Good day,
Could someone update the last query here (it no longer works with current
postgres)?
https://wiki.postgresql.org/wiki/Lock_Monitoring
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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-03-14 15:27:03 | Re: Namespace projects.postgresql.org |
| Previous Message | Magnus Hagander | 2019-03-14 14:50:36 | Re: Namespace projects.postgresql.org |