From: Tom Lane <tgl@sss.pgh.pa.us>
To: josh@agliodbs.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Why doesn't EXPLAIN ANALYZE show UPDATE step?
Date: Wed, 23 Apr 2003 22:46:56 -0400
Message-ID: <10275.1051152416@sss.pgh.pa.us> (raw)
In-Reply-To: <200304231123.38477.josh@agliodbs.com>
References: <200304231123.38477.josh@agliodbs.com>
Josh Berkus <josh@agliodbs.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, josh@agliodbs.com
Subject: Re: Why doesn't EXPLAIN ANALYZE show UPDATE step?
In-Reply-To: <10275.1051152416@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox