my-vegetable-has-exploded commented on issue #8492: URL: https://github.com/apache/arrow-datafusion/issues/8492#issuecomment-2016355077
>  Attaching Flamegraph for the query > > ``` > SELECT COUNT(*) FROM '*.parquet' WHERE > ARRAY_LENGTH( > REGEXP_EXTRACT_ALL(path, '\.(asm|c|cc|cpp|cxx|h|hpp|rs|[Ff][0-9]{0,2}(?:or)?|go)$') > ) > 0; > ``` Hi, could you share the method to draw the flamegraph? There is a large "unknown" in my flame graph, which prevents me from tracking the function call chain.  Here is my shell to generate the flamegraph using `datafusion-cli`. ```shell #!/bin/bash PERF_DATA_FILE="$1" ../../datafusion-cli/target/debug/datafusion-cli -f repro-range-query.sql & # datafusion-cli -f repro-range-query.sql & PID=$! # use perf to collect data sudo /usr/bin/perf_5.15 record --call-graph=dwarf -e cpu-clock -F 100 -p $PID -- sleep 30 sudo /usr/bin/perf_5.15 script -i perf.data >"perf.unfold" FLAMEGRAPH_DIR="/home/deepin/sdk/FlameGraph" "$FLAMEGRAPH_DIR/stackcollapse-perf.pl" "perf.unfold" >"perf.folded" "$FLAMEGRAPH_DIR/flamegraph.pl" "perf.folded" >"$1.svg" rm "perf.unfold" "perf.folded" echo "Flame graph SVG created: $1.svg" ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
