author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Tue, 10 Dec 2019 22:24:50 +0200 (2019-12-10) | |
changeset 2393 | 6f68472e27d9 |
parent 2392 | eddb9a8153b5 |
child 2394 | 7df4f3650b8a |
postgres.rst | file | annotate | diff | comparison | revisions |
--- 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