Today, we have introduced a new feature in Pinot U...
# general
g
Today, we have introduced a new feature in Pinot UI. As you may know, each query in the Multi-Stage Queries includes a bunch of very useful stats stageStats. But they are pretty tricky to read, especially in large queries. This is why we merged a new feature that presents these stats in a pretty, easy-to-read diagram. This is still the first version, but it will be super helpful. Sadly, this feature didn’t get included in 1.3.0, but will be included in 1.4.0 for sure! You can see the change on https://github.com/apache/pinot/pull/14848, but let me link the video here as well.
BTW, we plan to present similar charts for the explain plans. Also, as you can see in the PR, the diagram is rendered on the front end, and no change was necessary on the back end. As always, we are open to receiving further PRs to improve these diagrams!
r
@Jayesh Choudhary Thank you for this contribution!
How difficult would it be to add time (in terms of timeUsedMs and %) at each node or branch?
j
we can add labels to edge (time used in ms) But I did notice not every node has time used in ms value (cc @Gonzalo Ortiz ) or even colour code an edge if it is taking the most time It is configurable and easy yes.
UI is using react-flow (node and edge based plotting library) https://v10.reactflow.dev/
g
If they don’t have time it is because it is 0 (meaning that it was executed in less than 1 ms)