Difference between revisions of "EXPLAIN ANALYZE (PostgreSQL)"

From wikieduonline
Jump to navigation Jump to search
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<pre>EXPLAIN [ ( option [, ...] ) ] statement
+
[[EXPLAIN]] [ ( option [, ...] ) ] statement
EXPLAIN [ ANALYZE ] [ VERBOSE ] statement
+
EXPLAIN [ ANALYZE ]
 
 
where option can be one of:
 
 
 
    ANALYZE [ boolean ]
 
    VERBOSE [ boolean ]
 
    COSTS [ boolean ]
 
    BUFFERS [ boolean ]
 
    FORMAT { TEXT | XML | JSON | YAML } </pre>
 
  
  
Line 15: Line 7:
 
* [[EXPLAIN ANALYZE (MySQL)]]
 
* [[EXPLAIN ANALYZE (MySQL)]]
 
* [[EXPLAIN]]
 
* [[EXPLAIN]]
* [[EXPLAIN VERBOSE]] (PostgresSQL)
+
* [[EXPLAIN VERBOSE]]
 
 
 
== See also ==
 
== See also ==
 +
* {{Explain}}
 
* {{SQL}}
 
* {{SQL}}
* {{PostgreSQL}}
 
  
 
[[Category:PosgreSQL]]
 
[[Category:PosgreSQL]]
 
[[Category:SQL]]
 
[[Category:SQL]]

Latest revision as of 14:22, 9 May 2023

Advertising: