show the execution plan of a statement NAME EXPLAIN - show the execution plan of a statement SYNOPSIS EXPLAIN [ ( option [, ...] ) ] statemen...explain error codes NAME perror - explain error codes SYNOPSIS perror [ options ] errorcode ... D......of events that would occur but do not actually change the system. -v , --verbose Verbose; explain what is being done. -w , --warnings Enable warnings. This option has not been i…...of events that would occur but do not actually change the system. -v , --verbose Verbose; explain what is being done. -w , --warnings Enable warnings. This option has not been i…...000) s(i); ANALYZE t1; -- the number of matching rows will be drastically underestimated: EXPLAIN ANALYZE SELECT * FROM t1 WHERE (a = 1) AND (b = 0); CREATE STATISTICS s1 (depen…...f each existing destination file -b like --backup but does not accept an argument --debug explain how a file is copied. Implies -v --exchange exchange source and destination -f …...ts of special files when recursive -d same as --no-dereference --preserve = links --debug explain how a file is copied. Implies -v -f , --force if an existing destination file c…...custom plan. To examine the query plan PostgreSQL is using for a prepared statement, use EXPLAIN , for example EXPLAIN EXECUTE name ( parameter_values ); If a generic plan is in…...s and its own process. You can toggle these on and off with the 'i' and 'a' keys. You can EXPLAIN a query from this mode with the 'e' key. This displays the query's full text, t…...ctories and their contents recursively -d , --dir remove empty directories -v , --verbose explain what is being done --help display this help and exit --version output version i…...cept the last, or all components of --target-directory , then copy SOURCE to DEST --debug explain how a file is copied. Implies -v -g , --group = GROUP set group ownership, inst…...' B C This explanation comes for "free" because there was no change. Similarly C could be explained using 1 , but that comes at some cost c>0 because of the modification: 1 ----…...a line: |A brief introduction $ | $ |$ |A new paragraph$ |# with a commented-out line $ |explaining lots of stuff.$ |$ |# An old paragraph, also commented-out. $ | $ |The end.$ …...ION While git creates a basic commit message automatically, it is strongly recommended to explain why the original commit is being reverted. In addition, repeatedly reverting re…...porary table; all CREATE, ALTER, and DROP commands; COMMENT, GRANT, REVOKE, TRUNCATE; and EXPLAIN ANALYZE and EXECUTE if the command they would execute is among those listed. Th…...(when the kernel compares resources, it uses their memory addresses). The easiest way to explain is to consider an example. Suppose that v1 and v2 are the addresses of appropria…...modification is different. This is usually a good choice. -v , --verbose Verbose output, explain to the user what is being done. If specified once, every hardlinked file is disp…...not change. This might result in small changes in the planner's estimated costs shown by EXPLAIN . In rare situations, this non-determinism will cause the planner's choices of q…...does not match the signal being used to kill it, the capsh program exits with status 1. --explain= cap_xxx Give a brief textual description of what privileges the specified capa…...ges" section of gitrevisions (7). [--] <path>... Consider only commits that are enough to explain how the files that match the specified paths came to be. Paths may need to be p…