Re: Why doesn't EXPLAIN ANALYZE show UPDATE step?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Why doesn't EXPLAIN ANALYZE show UPDATE step?
Date: 2003-04-24 02:46:56
Message-ID: 10275.1051152416@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Josh Berkus <josh(at)agliodbs(dot)com> writes:
> I was just noticing that EXPLAIN ANALYZE in 7.3.2 *still* doesn't show a
> discrete UPDATE step for UPDATE queries. Is this going to be changed in
> 7.4?

No. There is no UPDATE step in the plan tree.

You can determine the time spent doing updates by subtracting the
topmost plan node's total time from the total runtime, as suggested
in the next-to-last paragraph of
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/performance-tips.html

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Vernon 2003-04-24 04:18:23 Unicode, RedHat Linux, & PostgreSQL
Previous Message Tom Lane 2003-04-24 02:37:38 Re: Optomizing left outer joins