Explain analyze

Hello all,

Apart from the CrateDB docs is there anymore info on how to decipher the explain analyze statement ?

Many thanks in advance

Is there something specific that you are looking for?

Maybe an interesting start could be the recent blog post to better understand how CrateDB executes queries:

or the original posts this was based on:

Thanks I’ll take a look at these posts.

I’m not really looking for anything specific, but I’m using joins and CTEs (WITH) and so the output looks a little more complex than I’m used to ( coming from a RDB background )

I’m aware that the underlying system of Crate is not relational and so I’m trying to relearn how to use the SQL features better.

Thanks again.

There should also be quite some blog posts about how CrateDB does JOINs and some information the documentation: