Studio: Flame-graph Visualization of Profile

[gramian]

This is a feature request for a visualization of a PROFILE (SQL) query in the studio tool via flame-graph.
The idea is to add a tab to the query page which shows a flame-graph of a query. This may mean that a query needs to be wrapped in a PROFILE statement and resend to the server. The server JSON response then needs to be transformed such that the timings and their labels can be used to create a flame-graph.

Various projects used flame-graphs for SQL profiling, so these links maybe useful:

• http://www.brendangregg.com/flamegraphs.html
• https://github.com/spiermar/d3-flame-graph
• https://github.com/vgrippa/myflames
• https://tanelpoder.com/posts/sql-plan-flamegraph-loop-row-counts/
• https://www.p99conf.io/2023/09/21/visualizing-sql-plan-execution-time-with-flamegraphs/

[lvca]

Implemented with zero dependencies, just CSS. Please @gramian let me know what do you think.

[gramian]

@lvca This is super cool already!

• The help bubble next to the checkbox should include OpenCypher to the stated SQL and Gremlin.
• SELECT FROM (SELECT 1) does not produce a flamegraph
• It does not work for sqlscript, is this expected?
• It seems only one level is resolved, for example if one has SELECT ... LET $x = (SELECT ... FROM ...), the query in the LET` is only treated as one block and not as a new level where projection, filtrering, etc is resolved.

[lvca]

Good point, fixed now.