pg_tracing

pig build pkg pg_tracing         # build RPM / DEB packages

pig repo add pgsql -u          # Add repo and update cache

shared_preload_libraries = 'pg_tracing';

CREATE EXTENSION pg_tracing;

/*traceparent='00-00000000000000000000000000000123-0000000000000123-01'*/ SELECT 1;

BEGIN;
SET LOCAL pg_tracing.trace_context='traceparent=''00-00000000000000000000000000000005-0000000000000005-01''';
UPDATE pgbench_accounts SET abalance=1 WHERE aid=1;
COMMIT;

SET pg_tracing.sample_rate = 1.0;  -- trace all queries
SELECT 1;

-- Consume spans (removes them from buffer)
SELECT trace_id, parent_id, span_id, span_start, span_end, span_type, span_operation
FROM pg_tracing_consume_spans ORDER BY span_start;

-- Peek at spans (non-destructive)
SELECT * FROM pg_tracing_peek_spans;

-- Export as OTLP JSON
SELECT pg_tracing_json_spans();

SELECT * FROM pg_tracing_info;
SELECT pg_tracing_reset();

pg_tracing.otel_endpoint = http://127.0.0.1:4318/v1/traces
pg_tracing.otel_naptime = 2000