Explain analyze

CrateDB
1

Hello all,

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

Many thanks in advance
David

2

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:

3

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.

4

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