| Lists: | pgsql-www |
|---|
| 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 |
| 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: | Marcin Cieslak <saper(at)saper(dot)info> |
|---|---|
| To: | Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com> |
| Cc: | pgsql-www(at)postgresql(dot)org |
| Subject: | Re: wiki edit |
| Date: | 2019-03-14 15:37:07 |
| Message-ID: | nycvar.OFS.7.76.444.1903141536550.21421@z.fncre.vasb |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-www |
On Thu, 14 Mar 2019, Filip Rembiałkowski wrote:
> Good day,
>
> Could someone update the last query here (it no longer works with current
> postgres)?
>
> https://wiki.postgresql.org/wiki/Lock_Monitoring
Is it better now?
https://wiki.postgresql.org/index.php?title=Lock_Monitoring&diff=33141&oldid=28526
Marcin