pg_stat_statements
authorOleksandr Gavenko <gavenkoa@gmail.com>
Tue, 10 Dec 2019 22:24:50 +0200
changeset 2393 6f68472e27d9
parent 2392 eddb9a8153b5
child 2394 7df4f3650b8a
pg_stat_statements
postgres.rst
--- a/postgres.rst	Tue Dec 10 19:34:24 2019 +0200
+++ b/postgres.rst	Tue Dec 10 22:24:50 2019 +0200
@@ -233,6 +233,13 @@
 
   SELECT * FROM pg_stat_statements;
 
+  SELECT * FROM pg_stat_statements
+  ORDER BY calls DESC;
+
+  SELECT * FROM pg_stat_statements
+  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