# HG changeset patch # User Oleksandr Gavenko # Date 1577808000 -7200 # Node ID ed213cf36a1c5d88b319f2735816e8ee1bbd98a9 # Parent ac2b5bc2f2c18ff739a7b33d7ae5f4c5cd57d838 Added link to docs. diff -r ac2b5bc2f2c1 -r ed213cf36a1c postgres.rst --- a/postgres.rst Tue Dec 31 17:59:09 2019 +0200 +++ b/postgres.rst Tue Dec 31 18:00:00 2019 +0200 @@ -240,16 +240,19 @@ WHERE query LIKE '%some%' ORDER BY calls DESC; +https://www.postgresql.org/docs/current/pgstatstatements.html + ``pg_stat_statements``. +https://www.postgresql.org/docs/current/indexes-examine.html + Examining Index Usage. + 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 - Examining Index Usage. +https://www.postgresql.org/docs/11/sql-explain.html + ``EXPLAIN``. List databases, schemas and tables ==================================