SQL · Transactions and integrity

explain

Shows the query plan and real timings. Use it before adding an index.

Syntax
explain analyze select …

Example

Open in the lab

More in this group

isolation levels lock rows rollback savepoint transaction

Learn this in the course

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.

Open the course