equal
deleted
inserted
replaced
230 =============== |
230 =============== |
231 |
231 |
232 Stats on query execution time:: |
232 Stats on query execution time:: |
233 |
233 |
234 SELECT * FROM pg_stat_statements; |
234 SELECT * FROM pg_stat_statements; |
|
235 |
|
236 SELECT * FROM pg_stat_statements |
|
237 ORDER BY calls DESC; |
|
238 |
|
239 SELECT * FROM pg_stat_statements |
|
240 WHERE query LIKE '%some%' |
|
241 ORDER BY calls DESC; |
235 |
242 |
236 https://www.postgresql.org/docs/current/pgstatstatements.html |
243 https://www.postgresql.org/docs/current/pgstatstatements.html |
237 ``pg_stat_statements``. |
244 ``pg_stat_statements``. |
238 https://www.postgresql.org/docs/current/indexes-examine.html |
245 https://www.postgresql.org/docs/current/indexes-examine.html |
239 Examining Index Usage. |
246 Examining Index Usage. |