Skip to content

Query-farm/pyroscope

Repository files navigation

DuckDB Pyroscope Extension

This experimental extension adds pyroscope profiling features to DuckDB

duckdb_flamegraph

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

pyroscope_duckdb_large