Is there a gsql equivalent of mysql explain?
Cheers,
Rene
Is there a gsql equivalent of mysql explain?
Cheers,
Rene
no. We will provide it in the near future.
What would be awesome would be if the “explain plan” was ALSO a graph…
There is this : http://docs.tigergraph.com/dev/gsql-ref/querying/query-operations#diagnose-d-option
We use it internally. It is a bit techie for now, but is very useful to see where time goes in queries.
Just to add on this, we have been using this tool a bit. It would be great to see the required consumed memory in the GPE for the query as well.
Is there a way to see how the query get executed internally?
@ferrishu3886 You can put together the picture of how the query is being executed internally by looking at the logs. But you need to understand how the system works in order to stitch the picture together.
The TigerGraph team is getting closer to deliver these insights directly into the GraphStudio interface. It reminds me of the “inspect” tool on the web browser
Please NOTE this is the web-browser and not the actual implementation in TigerGraph