From 7d1e32b51c680eb0c6519f9f42cb8332f99e87ef Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Sat, 5 Sep 1998 06:02:57 +0000 Subject: Add new reference pages adapted from Jose'. --- doc/src/sgml/ref/explain.sgml | 162 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 162 insertions(+) create mode 100644 doc/src/sgml/ref/explain.sgml (limited to 'doc/src/sgml/ref/explain.sgml') diff --git a/doc/src/sgml/ref/explain.sgml b/doc/src/sgml/ref/explain.sgml new file mode 100644 index 00000000000..166bbbf4c32 --- /dev/null +++ b/doc/src/sgml/ref/explain.sgml @@ -0,0 +1,162 @@ + + + +EXPLAIN + +SQL - Language Statements + + + +EXPLAIN + + +Shows statement execution details. + + + + +1998-09-01 + + +EXPLAIN [ VERBOSE ] query + + + + +1998-09-01 + + +Inputs + + + + + + +VERBOSE + + + +Flag to show detailed query plan. + + + +query + + + +Any query. + + + + + + + +1998-04-15 + + +Outputs + + + + + + +NOTICE: QUERY PLAN: + + + +Explicit query plan from the Postgres backend. + + + +EXPLAIN + + + +Flag sent after query plan is shown. + + + + + + + + +1998-04-15 + + +Description + + + This command outputs details about the supplied query. + The default output is the computed query cost. + VERBOSE displays the full query plan and cost. + + + +1998-04-15 + + +Notes + + + + + + + +Usage + + +To show a query plan for a simple query: + + +postgres=> explain select * from foo; +NOTICE: QUERY PLAN: + +Seq Scan on foo (cost=0.00 size=0 width=4) + +EXPLAIN + + + + + + +Compatibility + + + + + + +1998-09-01 + + +SQL92 + + + There is no EXPLAIN statement defined in SQL92. + + + -- cgit v1.2.3