User Tools

Site Tools


dba:postgresql:postgresql_basic_querys

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
dba:postgresql:postgresql_basic_querys [2023/10/23 07:24] – [Locks] dodgerdba:postgresql:postgresql_basic_querys [2023/10/23 07:25] – [Locks] dodger
Line 604: Line 604:
 </code> </code>
  
-This query will list all //blocking sessions//:+This query will list all //blocking sessions//, see [[https://wiki.postgresql.org/wiki/Lock_Monitoring|official documentation]]:
 <code sql> <code sql>
 SET application_name='%your_logical_name%'; SET application_name='%your_logical_name%';
dba/postgresql/postgresql_basic_querys.txt · Last modified: 2024/04/19 07:37 by dodger