Reveal execution details.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Tue, 31 Dec 2019 17:59:09 +0200
changeset 2398 ac2b5bc2f2c1
parent 2397 320b2c43529b
child 2399 ed213cf36a1c
Reveal execution details.
postgres.rst
--- a/postgres.rst	Fri Dec 13 00:16:26 2019 +0200
+++ b/postgres.rst	Tue Dec 31 17:59:09 2019 +0200
@@ -240,6 +240,12 @@
   WHERE query LIKE '%some%'
   ORDER BY calls DESC;
 
+Reveal execution details::
+
+  EXPLAIN ANALYSE SELECT 1;
+  EXPLAIN (TIMING false, COSTS false, ANALYSE) SELECT 1;
+  EXPLAIN (TIMING false, COSTS false, BUFFERS false, VERBOSE false, ANALYSE) SELECT 1;
+
 https://www.postgresql.org/docs/current/pgstatstatements.html
   ``pg_stat_statements``.
 https://www.postgresql.org/docs/current/indexes-examine.html