aboutsummaryrefslogtreecommitdiff
path: root/src/man/explain.l
diff options
context:
space:
mode:
Diffstat (limited to 'src/man/explain.l')
-rw-r--r--src/man/explain.l63
1 files changed, 0 insertions, 63 deletions
diff --git a/src/man/explain.l b/src/man/explain.l
deleted file mode 100644
index ae708bbde62..00000000000
--- a/src/man/explain.l
+++ /dev/null
@@ -1,63 +0,0 @@
-.\" This is -*-nroff-*-
-.\" XXX standard disclaimer belongs here....
-.\" $Header: /cvsroot/pgsql/src/man/Attic/explain.l,v 1.12 1999/05/17 17:03:51 momjian Exp $
-.TH EXPLAIN SQL 06/12/97 PostgreSQL PostgreSQL
-.SH NAME
-explain - explains statement execution details
-.SH SYNOPSIS
-.nf
-\fBexplain [verbose]\fR query
-.fi
-.SH DESCRIPTION
-This command outputs details about the supplied query. The default
-output is the computed query cost. The cost value is only meaningful to
-the optimizer in comparing various query plans. \f2verbose\f1 displays
-the full query plan and cost to your screen, and pretty-prints the plan
-to the postmaster log file.
-
-.SH EXAMPLES
-In the examples, the table has a single column of float4.
-\fBcost\fR is the cost of scanning a base/join relation,
-\fBrows\fR is the expected number of rows from a scan,
-\fBwidth\fR is the length of a tuple.
-
-.nf
-tgl=> explain select a from test\g
-NOTICE:QUERY PLAN:
-
-Seq Scan on test (cost=0.00 rows=0 width=4)
-
-EXPLAIN
-tgl=> explain verbose select sum(a) from test;
-NOTICE:QUERY PLAN:
-
-{AGG :cost 0 :size 0 :width 0 :state <> :qptargetlist
- ({TLE :resdom {RESDOM :resno 1 :restype 700 :restypmod 4 :resname "sum"
- :reskey 0 :reskeyop 0 :resjunk false}
- :expr {AGGREG :aggname "sum" :basetype 700 :aggtype 700 :aggno 0
- :target {VAR :varno 1 :varattno 1 :vartype 700 :varnoold 1 :varoattno 1}}})
- :qpqual <> :lefttree {SEQSCAN :cost 0 :size 0 :width 4 :state <>
- :qptargetlist ({TLE :resdom {RESDOM :resno 1 :restype 700 :restypmod 4
- :resname "null" :reskey 0 :reskeyop 0 :resjunk false}
- :expr {VAR :varno 1 :varattno 1 :vartype 700 :varnoold 1 :varoattno 1}})
- :qpqual <> :lefttree <> :righttree <> :scanrelid 1} :righttree <> :numagg 1 }
-
-Aggregate (cost=0.00 rows=0 width=0)
- -> Seq Scan on test (cost=0.00 rows=0 width=4)
-.fi
-
-The Postgres optimizer has chosen to use a sequential scan to retrieve rows from
-this table. Indices will used by the optimizer
-after tables grow large enough to warrant the access
-overhead; typically this might happen when tables have a few hundred rows.
-
-.SH "SEE ALSO"
-delete(l),
-insert(l),
-select(l).
-
-.SH BUGS
-
-.PP
-The query cost and plan can be affected by running vacuum.
-