Awesome

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