{"id":262,"date":"2025-02-05T10:08:20","date_gmt":"2025-02-05T08:08:20","guid":{"rendered":"http:\/\/mariospavlidis.site\/?p=262"},"modified":"2025-02-05T10:08:33","modified_gmt":"2025-02-05T08:08:33","slug":"locks-in-postgresql","status":"publish","type":"post","link":"http:\/\/130.61.57.200\/index.php\/2025\/02\/05\/locks-in-postgresql\/","title":{"rendered":"Locks in PostgreSQL"},"content":{"rendered":"\n<pre class=\"wp-block-preformatted\">  <strong>SELECT<\/strong> blocked_locks.pid     <strong>AS<\/strong> blocked_pid,<br>         blocked_activity.usename  <strong>AS<\/strong> blocked_user,<br>         blocking_locks.pid     <strong>AS<\/strong> blocking_pid,<br>         blocking_activity.usename <strong>AS<\/strong> blocking_user,<br>         blocked_activity.query    <strong>AS<\/strong> blocked_statement,<br>         blocking_activity.query   <strong>AS<\/strong> current_statement_in_blocking_process<br>   <strong>FROM<\/strong>  pg_catalog.pg_locks         blocked_locks<br>    <strong>JOIN<\/strong> pg_catalog.pg_stat_activity blocked_activity  <strong>ON<\/strong> blocked_activity.pid = blocked_locks.pid<br>    <strong>JOIN<\/strong> pg_catalog.pg_locks         blocking_locks <br>        <strong>ON<\/strong> blocking_locks.locktype = blocked_locks.locktype<br>        <strong>AND<\/strong> blocking_locks.<strong>database<\/strong> <strong>IS<\/strong> <strong>NOT<\/strong> <strong>DISTINCT<\/strong> <strong>FROM<\/strong> blocked_locks.<strong>database<\/strong><br>        <strong>AND<\/strong> blocking_locks.relation <strong>IS<\/strong> <strong>NOT<\/strong> <strong>DISTINCT<\/strong> <strong>FROM<\/strong> blocked_locks.relation<br>        <strong>AND<\/strong> blocking_locks.page <strong>IS<\/strong> <strong>NOT<\/strong> <strong>DISTINCT<\/strong> <strong>FROM<\/strong> blocked_locks.page<br>        <strong>AND<\/strong> blocking_locks.tuple <strong>IS<\/strong> <strong>NOT<\/strong> <strong>DISTINCT<\/strong> <strong>FROM<\/strong> blocked_locks.tuple<br>        <strong>AND<\/strong> blocking_locks.virtualxid <strong>IS<\/strong> <strong>NOT<\/strong> <strong>DISTINCT<\/strong> <strong>FROM<\/strong> blocked_locks.virtualxid<br>        <strong>AND<\/strong> blocking_locks.transactionid <strong>IS<\/strong> <strong>NOT<\/strong> <strong>DISTINCT<\/strong> <strong>FROM<\/strong> blocked_locks.transactionid<br>        <strong>AND<\/strong> blocking_locks.classid <strong>IS<\/strong> <strong>NOT<\/strong> <strong>DISTINCT<\/strong> <strong>FROM<\/strong> blocked_locks.classid<br>        <strong>AND<\/strong> blocking_locks.objid <strong>IS<\/strong> <strong>NOT<\/strong> <strong>DISTINCT<\/strong> <strong>FROM<\/strong> blocked_locks.objid<br>        <strong>AND<\/strong> blocking_locks.objsubid <strong>IS<\/strong> <strong>NOT<\/strong> <strong>DISTINCT<\/strong> <strong>FROM<\/strong> blocked_locks.objsubid<br>        <strong>AND<\/strong> blocking_locks.pid != blocked_locks.pid<br>    <strong>JOIN<\/strong> pg_catalog.pg_stat_activity blocking_activity <strong>ON<\/strong> blocking_activity.pid = blocking_locks.pid<br>   <strong>WHERE<\/strong> <strong>NOT<\/strong> blocked_locks.<strong>granted<\/strong>;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SELECT blocked_locks.pid AS blocked_pid, blocked_activity.usename AS blocked_user, blocking_locks.pid AS blocking_pid, blocking_activity.usename AS blocking_user, blocked_activity.query AS blocked_statement, blocking_activity.query AS current_statement_in_blocking_process FROM pg_catalog.pg_locks blocked_locks JOIN pg_catalog.pg_stat_activity blocked_activity ON blocked_activity.pid = blocked_locks.pid JOIN pg_catalog.pg_locks blocking_locks ON blocking_locks.locktype = blocked_locks.locktype AND blocking_locks.database IS NOT DISTINCT FROM blocked_locks.database AND blocking_locks.relation IS NOT DISTINCT FROM blocked_locks.relation AND blocking_locks.page IS NOT DISTINCT [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":130,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-262","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql"],"blocksy_meta":[],"_links":{"self":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/262","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/comments?post=262"}],"version-history":[{"count":2,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/262\/revisions"}],"predecessor-version":[{"id":264,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/262\/revisions\/264"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/media\/130"}],"wp:attachment":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/media?parent=262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/categories?post=262"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/tags?post=262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}