wiki edit

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

wiki edit

Filip Rembiałkowski-4
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!
Reply | Threaded
Open this post in threaded view
|

Re: wiki edit

Marcin Cieslak
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

smime.p7s (4K) Download Attachment