equal
deleted
inserted
replaced
249 |
249 |
250 EXPLAIN ANALYSE SELECT 1; |
250 EXPLAIN ANALYSE SELECT 1; |
251 EXPLAIN (TIMING false, COSTS false, ANALYSE) SELECT 1; |
251 EXPLAIN (TIMING false, COSTS false, ANALYSE) SELECT 1; |
252 EXPLAIN (TIMING false, COSTS false, BUFFERS false, VERBOSE false, ANALYSE) SELECT 1; |
252 EXPLAIN (TIMING false, COSTS false, BUFFERS false, VERBOSE false, ANALYSE) SELECT 1; |
253 |
253 |
|
254 ``EXPLAIN ANALYSE`` actually executes a query, if it is destructive enclose the query into a |
|
255 transaction:: |
|
256 |
|
257 BEGIN; |
|
258 EXPLAIN ANALYZE ...; |
|
259 ROLLBACK; |
|
260 |
254 https://www.postgresql.org/docs/11/sql-explain.html |
261 https://www.postgresql.org/docs/11/sql-explain.html |
255 ``EXPLAIN``. |
262 Syntax of ``EXPLAIN``. |
|
263 https://www.postgresql.org/docs/11/using-explain.html |
|
264 Interpreting results of ``EXPLAIN``. |
256 |
265 |
257 List databases, schemas and tables |
266 List databases, schemas and tables |
258 ================================== |
267 ================================== |
259 |
268 |
260 Default database is ``postgres``. |
269 Default database is ``postgres``. |