postgres.rst
changeset 2479 ab3f4aad1b37
parent 2436 41f79c1242b2
child 2507 8e8c8adde585
--- 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
 ==================================