The Query Plan Visualization Tool is one of the quickest ways to understand your query behavior, with it you can easily identify how your queries will be executed. This knowledge is essential for boosting your queries, as you can get some hints of which types of optimizations should be implemented.

The Couchbase 5.5 the Query Plan Visualization Tool got a brand-new design, which allows you to zoom in/out and rearrange the orientation of the graph. Let’s see an example of how the new interface will look like for a query using UNION:

Query plan in Couchbase 5.5

Query plan in Couchbase 5.0

Let’s see another example of how a query using JOIN will look like:

Query plan in Couchbase 5.5

Query plan in Couchbase 5.0

If you have any questions, feel free to tweet me at @deniswsrosa

 

Author

Posted by Denis Rosa, Developer Advocate, Couchbase

Denis Rosa is a Developer Advocate for Couchbase and lives in Munich - Germany. He has a solid experience as a software engineer and speaks fluently Java, Python, Scala and Javascript. Denis likes to write about search, Big Data, AI, Microservices and everything else that would help developers to make a beautiful, faster, stable and scalable app.

Leave a reply