{"repo":"jnidzwetzki/pg-lock-tracer","free":true,"listed":false,"github":"https://github.com/jnidzwetzki/pg-lock-tracer","clone":"git clone https://github.com/jnidzwetzki/pg-lock-tracer.git","description":"An eBPF based lock tracer for PostgreSQL","language":"Python","stars":166,"topics":["bpf","locking","postgresql","tracing","postgres","ebpf","observability","spinlocks"],"license":"Apache-2.0","category":"analytics","readme_excerpt":"Lock tracing tools for PostgreSQL A set of eBPF-based tools designed to observe and visualize PostgreSQL 🐘 locking activity. These tools help users understand lock timing and contention behavior. Key components: - pg lock tracer : heavy lock tracer (e.g., table level locks) - pg lw lock tracer : lightweight lock (LWLock) tracer - pg row lock tracer : row-level lock tracer - pg spinlock delay tracer : spinlock delay tracer - animate lock graph : render animated lock graphs from pg lock tracer tracer output Note: These tools rely on eBPF ( Extended Berkeley Packet Filter ) technology. At the moment, PostgreSQL 14, 15, 16, 17, and 18 are supported (see additional information below). ⚡ Quickstart 1. Install the pg-lock-tracer tools: 2. Identify the PostgreSQL server binary used by your instance (e.g., /usr/lib/postgresql/X/bin/postgres ). 3. Start tracing a running Postgres PID (requires root privileges): This shows the locking activity of all processes running this PostgreSQL binary. pg lock tracer pg lock tracer observes the locking activity of a running PostgreSQL process (using eBPF and UProbes ). In contrast to the information that is present in the table pg locks (which provides information about which locks are currently requested), pg lock tracer gives you a continuous view of the locking activity and collects statistics and timings. The tracer also allows dumping the output as JSON-formatted lines, which allows further processing with additional tools. This repository a","default_branch":null,"files":null,"tree":[],"storefront":"/r/jnidzwetzki","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/jnidzwetzki/pg-lock-tracer/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}