pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL Parallel Processing !
Date: Fri, 27 Jan 2012 10:52:44 +0100
Message-ID: <jfts34$1p0$1@dough.gmane.org> (raw)
In-Reply-To: <CAGuFTBWibLVRrS-yQZCvuZ_62T=DOustwtK1VaQhcQMdn1axWw@mail.gmail.com>
References: <CAFAjSHxCuDP6cN1d1zOvFeDsFvM9HJkOSooFNTOWSKpuo-XRJw@mail.gmail.com>
	<CAGuFTBXYSyDHYBuvBOm5gaHtuwg6wEkSu3xB++5SxXiSpNwv=Q@mail.gmail.com>
	<CAGTBQpbm2uSfsQ=B-ASH36dKMknnoYmJFwe+OmSqjX6X_vvgUg@mail.gmail.com>
	<CAHyXU0zRRWrV5p1U6zAhz=95m3y4Z_9WdYBGwNuKEFX_t1ySnw@mail.gmail.com>
	<CAGTBQpaS1DeN8hpq=Rb4Q9JkR4JrCucwgaP1wW7T48K9tbWO0Q@mail.gmail.com>
	<CAGuFTBWibLVRrS-yQZCvuZ_62T=DOustwtK1VaQhcQMdn1axWw@mail.gmail.com>

sridhar bamandlapally, 27.01.2012 05:31:
> SQL> explain plan for select * from hr.emp ;
> Explained.
> PLAN
> --------------------------------------------------------------------------
> | Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |
> --------------------------------------------------------------------------
> |   0 | SELECT STATEMENT  |      |  7444K|   944M| 16077   (4)| 00:03:13 |
> |   1 |  TABLE ACCESS FULL| EMP  |  7444K|   944M| 16077   (4)| 00:03:13 |
> --------------------------------------------------------------------------
> *WITH PARALLEL Option*
> SQL> explain plan for select /*+parallel(emp,4)*/ * from hr.emp ;
> Explained.
> PLAN
> ---------------------------------------------------------------------------------
> | Id  | Operation            | Name     | Rows  | Bytes | Cost (%CPU)| Time     |
> ---------------------------------------------------------------------------------
> |   0 | SELECT STATEMENT     |          |  7444K|   944M|  4442   (3)| 00:00:54 |
> |   1 |  PX COORDINATOR      |          |       |       |            |          |
> |   2 |   PX SEND QC (RANDOM)| :TQ10000 |  7444K|   944M|  4442   (3)| 00:00:54 |
> |   3 |    PX BLOCK ITERATOR |          |  7444K|   944M|  4442   (3)| 00:00:54 |
> |   4 |     TABLE ACCESS FULL| EMP      |  7444K|   944M|  4442   (3)| 00:00:54 |
> ---------------------------------------------------------------------------------
>
> In the above plan ( WITH PARALLEL Option )
> 1. "Cost" has been nearly reduced to 1/4th
> 2. "CPU" has been reduced
> 3. "Time" has been nearly reduced to 1/3rd

I have *never* seen the "time" column in the explain plan output come anywhere near the actual execution time in Oracle.






view thread (13+ messages)  latest in thread

Message-ID: <jfts34$1p0$1@dough.gmane.org>
Permalink:  ../jfts34$1p0$1@dough.gmane.org/
Also on:    postgresql.org/message-id/jfts34$1p0$1@dough.gmane.org

 · 

reply
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-performance@postgresql.org
  Cc: spam_eater@gmx.net
  Subject: Re: PostgreSQL Parallel Processing !
  In-Reply-To: <jfts34$1p0$1@dough.gmane.org>

* 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