diff -r eddb9a8153b5 -r 6f68472e27d9 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