# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1546545120 -7200
# Node ID 32dd4ce8e9b2f18f11d5a36408f9c8d8a8dbfe10
# Parent  03d20db65d79d59602f40d1dc10869679ae5ab62
Profile queries.

diff -r 03d20db65d79 -r 32dd4ce8e9b2 postgres.rst
--- a/postgres.rst	Thu Jan 03 19:36:18 2019 +0200
+++ b/postgres.rst	Thu Jan 03 21:52:00 2019 +0200
@@ -89,6 +89,18 @@
 
    select * from pg_stat_activity;
 
+Profile queries
+===============
+
+Stats on query execution time::
+
+  SELECT * FROM pg_stat_statements;
+
+https://www.postgresql.org/docs/current/pgstatstatements.html
+  ``pg_stat_statements``.
+https://www.postgresql.org/docs/current/indexes-examine.html
+  Examining Index Usage.
+
 List databases, schemas and tables
 ==================================