.TH alf\-explain
.PP
Show the logical (optimizer) and physical (compiler) plans of a query.
.SH Synopsis
.PP
\fB\fCalf\fR explain \fIQUERY\fP
.SH Description
.PP
This command prints the logical and physical query plans for QUERY to
standard output:
.RS
.IP \(bu 2
The logical plan is post\-optimizer and allows checking that the latter
performs correctly.
.IP \(bu 2
The physical plan provides information about compilation. In particular it
provides feedback about the effective delegation to underlying database
engines, as well as involved SQL queries.
.RE
.SH Example
.PP
\fB\fCalf\fR \fB\fC--examples\fR explain "restrict(suppliers, city: 'London')"