Database Reference
In-Depth Information
prove,weran
EXPLAIN ANALYZE VERBOSE
tofindoutwhatwasconsumingmost
of the query-execution time. We learned that the
ST_Distance()
function con-
sumedthemosttimefromtheexecutionplan.Finally,weusedthe
<->
operatorof
PostgreSQL9.1todramaticallyimprovethequery-executiontimetounderasecond.
Theoutputof
EXPLAIN ANALYZE VERBOSE
usedinthisrecipeisnoteasytoun-
derstand. For complex queries, it is encouraged that you use the visual output in
pgAdminIII (discussed in a separate chapter's recipe) or the color coding provided
by the
http://explain.depesz.com/
web service shown in the following screenshot: