# HG changeset patch # User Oleksandr Gavenko # Date 1577807949 -7200 # Node ID ac2b5bc2f2c18ff739a7b33d7ae5f4c5cd57d838 # Parent 320b2c43529b58f526df28180be8321cb8de0a48 Reveal execution details. diff -r 320b2c43529b -r ac2b5bc2f2c1 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