public inbox for [email protected]  

help / color / mirror / Atom feed

From: Neto pr <[email protected]>
To: Tom Lane <[email protected]>
Cc: Igor Neyman <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Explain Analyze - actual time in loops
Date: Fri, 8 Sep 2017 07:02:37 -0700
Message-ID: <CA+wPC0Otv5=9yHu30t_ovCiMe=GL3EU7NgTY5mEH6M_4kymdFA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CA+wPC0OXdN+_8HxhYMWyV9nfD8v+xChvLROiWCiRo=qSve2MjQ@mail.gmail.com>
	<DM5PR17MB14993F6FD18158C593907D85DA950@DM5PR17MB1499.namprd17.prod.outlook.com>
	<CA+wPC0ObeUigZk3Vf_EVtozKUoCcd91FDFUd4VR4L_3LkY6bbA@mail.gmail.com>
	<[email protected]>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

Thanks for reply Tom and Igor.

Just only more information:

I need to know the height of a B-tree index (level of the leaf node
farthest from the root).

I tried to find this data in PG_INDEXES and PG_CLASS views, but I did not
find it.
Does anyone know if Postgresql stores this information, referring to the
height of the index tree?

Regards


2017-09-08 6:44 GMT-07:00 Tom Lane <[email protected]>:

> Neto pr <[email protected]> writes:
> > After analyzing, I saw that in some places of the plan, it is being used
> > Parallelism. Does this explain why the final value spent (in minutes) to
> go
> > through the index (184 minutes) is greater than the total query time (66
> > minutes)?
>
> I was just about to ask you about that.  If this is under a Gather node,
> I believe that the numbers include time expended in all processes.
> So if you had three or more workers these results would make sense.
>
>                         regards, tom lane
>

view thread (6+ messages)  latest in thread

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Explain Analyze - actual time in loops
  In-Reply-To: <CA+wPC0Otv5=9yHu30t_ovCiMe=GL3EU7NgTY5mEH6M_4kymdFA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox