pg_tracing

pig build pkg pg_tracing;		# build rpm/deb

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

pig install pg_tracing;		# install via package name, for the active PG version

pig install pg_tracing -v 18;   # install for PG 18
pig install pg_tracing -v 17;   # install for PG 17
pig install pg_tracing -v 16;   # install for PG 16
pig install pg_tracing -v 15;   # install for PG 15
pig install pg_tracing -v 14;   # install for PG 14

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();