Difference between revisions of "EXPLAIN ANALYZE (PostgreSQL)"

From wikieduonline
Jump to navigation Jump to search
(Created page with "<pre>EXPLAIN [ ( option [, ...] ) ] statement EXPLAIN [ ANALYZE ] [ VERBOSE ] statement where option can be one of: ANALYZE [ boolean ] VERBOSE [ boolean ] COSTS...")
 
 
(6 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>
 
  
 
== Related terms ==
 
== Related terms ==
Line 14: Line 7:
 
* [[EXPLAIN ANALYZE (MySQL)]]
 
* [[EXPLAIN ANALYZE (MySQL)]]
 
* [[EXPLAIN]]
 
* [[EXPLAIN]]
 
+
* [[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: