Interpreting results of ``EXPLAIN``.
--- a/postgres.rst Sun Dec 20 13:00:45 2020 +0200
+++ b/postgres.rst Sun Dec 20 20:11:29 2020 +0200
@@ -251,8 +251,17 @@
EXPLAIN (TIMING false, COSTS false, ANALYSE) SELECT 1;
EXPLAIN (TIMING false, COSTS false, BUFFERS false, VERBOSE false, ANALYSE) SELECT 1;
+``EXPLAIN ANALYSE`` actually executes a query, if it is destructive enclose the query into a
+transaction::
+
+ BEGIN;
+ EXPLAIN ANALYZE ...;
+ ROLLBACK;
+
https://www.postgresql.org/docs/11/sql-explain.html
- ``EXPLAIN``.
+ Syntax of ``EXPLAIN``.
+https://www.postgresql.org/docs/11/using-explain.html
+ Interpreting results of ``EXPLAIN``.
List databases, schemas and tables
==================================