Profile queries.
--- 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
==================================