equal
deleted
inserted
replaced
237 ORDER BY calls DESC; |
237 ORDER BY calls DESC; |
238 |
238 |
239 SELECT * FROM pg_stat_statements |
239 SELECT * FROM pg_stat_statements |
240 WHERE query LIKE '%some%' |
240 WHERE query LIKE '%some%' |
241 ORDER BY calls DESC; |
241 ORDER BY calls DESC; |
|
242 |
|
243 Reveal execution details:: |
|
244 |
|
245 EXPLAIN ANALYSE SELECT 1; |
|
246 EXPLAIN (TIMING false, COSTS false, ANALYSE) SELECT 1; |
|
247 EXPLAIN (TIMING false, COSTS false, BUFFERS false, VERBOSE false, ANALYSE) SELECT 1; |
242 |
248 |
243 https://www.postgresql.org/docs/current/pgstatstatements.html |
249 https://www.postgresql.org/docs/current/pgstatstatements.html |
244 ``pg_stat_statements``. |
250 ``pg_stat_statements``. |
245 https://www.postgresql.org/docs/current/indexes-examine.html |
251 https://www.postgresql.org/docs/current/indexes-examine.html |
246 Examining Index Usage. |
252 Examining Index Usage. |