GitHub - Query-farm/pyroscope: DuckDB Pyroscope Extension for Continuous Profiling

DuckDB Pyroscope Extension

This experimental extension adds pyroscope profiling features to DuckDB

For raw pprof generation use the pprof extension

Install

INSTALL pyroscope FROM community;
LOAD pyroscope;

Usage

---- Start the tracer, requires backend Pyroscope URL
D SELECT * FROM trace_start('https://pyroscope:4000');

---- Run a bunch of heavy queries to stream results to Pyroscope/qryn

---- Stop the tracer. This might hang due to a bug in the pyroscope crate.
D SELECT * FROM trace_stop();

Glory Shot in Pyroscope

Create a Free account on Grafana Cloud create a Token for Pyroscope profile sending and use the extension:

---- Start the tracer to Grafana Cloud Pyroscope
D SELECT * FROM trace_start('https://user:token@profiles-prod-xxx.grafana.net');