We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
PGTracer: A Tracing Tool for Postgres Backends: Ronan Dunklau - PGCon 2023
PGTracer: Fine-grained analysis of query execution and optimization for Postgres backends.
- PGTracer is a tracing tool for Postgres backends, allowing for fine-grained analysis of query execution.
- The tool uses Linux kernel facilities, specifically eBPF, to perform tracing and gather information.
- PGTracer can capture individual node information, including instrumentation data, and reconstruct execution plans from running queries.
- The tool can also gather information about memory allocation, buffer usage, and wall time usage.
- PGTracer provides a way to instrument Postgres backends without modifying the source code or requiring configuration changes.
- It can be used to analyze query performance, identify bottlenecks, and optimize database performance.
- The tool is designed to be easy to use and can be scripted for automation.
- PGTracer can be used to gather information about specific queries, transactions, or workers.
- It can also be used to track system-level events, such as I/O access and memory allocation.
- The tool provides a way to correlate query execution with system-level events.
- PGTracer can be used to generate reports on query performance and execution plans.
- The tool is designed to work with Postgres 12 and later versions.