*** pgsql/doc/src/sgml/ref/explain.sgml 2009/07/26 23:34:17 1.45 --- pgsql/doc/src/sgml/ref/explain.sgml 2009/08/10 05:46:50 1.46 *************** *** 1,5 **** --- 1,5 ---- *************** PostgreSQL documentation *** 31,37 **** ! EXPLAIN [ ( { ANALYZE boolean | VERBOSE boolean | COSTS boolean } [, ...] ) ] statement EXPLAIN [ ANALYZE ] [ VERBOSE ] statement --- 31,37 ---- ! EXPLAIN [ ( { ANALYZE boolean | VERBOSE boolean | COSTS boolean | FORMAT { TEXT | XML | JSON } } [, ...] ) ] statement EXPLAIN [ ANALYZE ] [ VERBOSE ] statement *************** ROLLBACK; *** 109,115 **** Carry out the command and show the actual run times. This ! parameter defaults to FALSE. --- 109,115 ---- Carry out the command and show the actual run times. This ! parameter defaults to FALSE. *************** ROLLBACK; *** 118,125 **** VERBOSE ! Include the output column list for each node in the plan tree. This ! parameter defaults to FALSE. --- 118,129 ---- VERBOSE ! Display additional information regarding the plan. Specifically, include ! the output column list for each node in the plan tree, schema-qualify ! table and function names, always label variables in expressions with ! their range table alias, and always print the name of each trigger for ! which statistics are displayed. This parameter defaults to ! FALSE. *************** ROLLBACK; *** 130,136 **** Include information on the estimated startup and total cost of each plan node, as well as the estimated number of rows and the estimated ! width of each row. This parameter defaults to TRUE. --- 134,152 ---- Include information on the estimated startup and total cost of each plan node, as well as the estimated number of rows and the estimated ! width of each row. This parameter defaults to TRUE. ! ! ! ! ! ! FORMAT ! ! ! Specify the output format, which can be TEXT, XML, or JSON. ! XML or JSON output contains the same information as the text output ! format, but is easier for programs to parse. This parameter defaults to ! TEXT.