achfrag.net/2023/01/11/trace-postgresql-locks-with-pg-lock-tracer.html

Preview meta tags from the achfrag.net website.

Linked Hostnames

12

Thumbnail

Search Engine Appearance

Google

https://achfrag.net/2023/01/11/trace-postgresql-locks-with-pg-lock-tracer.html

Trace PostgreSQL locks with pg_lock_tracer

The DBMS PostgreSQL uses locks to synchronize access to resources like tables. To get more information about the locks, the table pg_locks shows which relation is currently locked by which process. However, this relation shows only the current state of the locks. To show the locking activity in real-time, the new lock tracing tool pg_lock_tracer can be used. pg_lock_tracer is an open-source tool that I have just recently created. It can be downloaded from the website of the project.



Bing

Trace PostgreSQL locks with pg_lock_tracer

https://achfrag.net/2023/01/11/trace-postgresql-locks-with-pg-lock-tracer.html

The DBMS PostgreSQL uses locks to synchronize access to resources like tables. To get more information about the locks, the table pg_locks shows which relation is currently locked by which process. However, this relation shows only the current state of the locks. To show the locking activity in real-time, the new lock tracing tool pg_lock_tracer can be used. pg_lock_tracer is an open-source tool that I have just recently created. It can be downloaded from the website of the project.



DuckDuckGo

https://achfrag.net/2023/01/11/trace-postgresql-locks-with-pg-lock-tracer.html

Trace PostgreSQL locks with pg_lock_tracer

The DBMS PostgreSQL uses locks to synchronize access to resources like tables. To get more information about the locks, the table pg_locks shows which relation is currently locked by which process. However, this relation shows only the current state of the locks. To show the locking activity in real-time, the new lock tracing tool pg_lock_tracer can be used. pg_lock_tracer is an open-source tool that I have just recently created. It can be downloaded from the website of the project.

  • General Meta Tags

    9
    • title
      Trace PostgreSQL locks with pg_lock_tracer | Jan’s website and blog
    • charset
      utf-8
    • viewport
      width=device-width, initial-scale=1, minimum-scale=0.5, maximum-scale=5
    • generator
      Jekyll v3.10.0
    • author
      Jan Nidzwetzki

  • Open Graph Meta Tags

    8
    • og:image
      https://jnidzwetzki.github.io/assets/img/flamegraph2.png
    • og:type
      website
    • og:title
      Trace PostgreSQL locks with pg_lock_tracer
    • US country flagog:locale
      en_US
    • og:description
      The DBMS PostgreSQL uses locks to synchronize access to resources like tables. To get more information about the locks, the table pg_locks shows which relation is currently locked by which process. However, this relation shows only the current state of the locks. To show the locking activity in real-time, the new lock tracing tool pg_lock_tracer can be used. pg_lock_tracer is an open-source tool that I have just recently created. It can be downloaded from the website of the project.

  • Twitter Meta Tags

    6
    • twitter:card
      summary
    • twitter:title
      Trace PostgreSQL locks with pg_lock_tracer
    • twitter:description
      The DBMS PostgreSQL uses locks to synchronize access to resources like tables. To get more information about the locks, the table pg_locks shows which relati...
    • twitter:card
      summary
    • twitter:image
      https://jnidzwetzki.github.io/assets/img/flamegraph2.png

  • Link Tags

    5
    • alternate
      https://jnidzwetzki.github.io/feed.xml
    • alternate
      https://jnidzwetzki.github.io/feed.xml
    • canonical
      https://jnidzwetzki.github.io/2023/01/11/trace-postgresql-locks-with-pg-lock-tracer.html
    • shortcut icon
      /assets/favicon.ico
    • stylesheet
      /assets/css/main.css

Emails

1

Links

28