Prepare explain command section of documentation.
Though SQL command list contains EXPLAIN, there is no good description how to read explain output.
- Need to explain the user how to read the plans. I.e. we want to form a guide for the user how to read each line in the plan from the simplest one (
select * from t) to some complicated examples with joins, subqueries and aggregates. These examples would be introduced step-by-step in the next issues. - Mention that
explaindoesn't really execute the plan, but rather builds its plan on the router node. - Introduce relational operators that modify pulled up tuples (SCAN, SELECTION, PROJECTION, etc) and expressions (i.e. tuple modifiers).
Edited by Denis Smirnov