# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1608487889 -7200
# Node ID ab3f4aad1b3749bcb3c82960481b9182bf9fd5ec
# Parent  2bf9b2739ecbf4ac10c4a00b369180936a1c03f3
Interpreting results of ``EXPLAIN``.

diff -r 2bf9b2739ecb -r ab3f4aad1b37 postgres.rst
--- 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
 ==================================