Hi,
up to parallel executions, when we had node in explain analyze showing
"loops=x" with x more than 1, it meant that the "actual time" had to be
multiplied by loops to get real time spent in a node.
For example, check step 13 in https://explain.depesz.com/s/gNBd
It shows time of 3ms, but loops
On Wed, Nov 1, 2017 at 1:19 PM, David G. Johnston
wrote:
> On Wed, Nov 1, 2017 at 11:59 AM, Scott Marlowe
> wrote:
>>
>> So some of my output from an explain analyze here has a line that says
>> this:
>>
>> ex Scan using warranty_order_item_warranty_order_id_idx on
>> warranty_order_item woi_1 (c
On Wed, Nov 1, 2017 at 12:25 PM, Justin Pryzby wrote:
> On Wed, Nov 01, 2017 at 12:19:21PM -0700, David G. Johnston wrote:
> > On Wed, Nov 1, 2017 at 11:59 AM, Scott Marlowe
> > wrote:
> >
> > > So some of my output from an explain analyze here has a line that says
> > > this:
> > >
> > > ex Sca
On Wed, Nov 01, 2017 at 12:19:21PM -0700, David G. Johnston wrote:
> On Wed, Nov 1, 2017 at 11:59 AM, Scott Marlowe
> wrote:
>
> > So some of my output from an explain analyze here has a line that says
> > this:
> >
> > ex Scan using warranty_order_item_warranty_order_id_idx on
> > warranty_order
On Wed, Nov 1, 2017 at 11:59 AM, Scott Marlowe
wrote:
> So some of my output from an explain analyze here has a line that says
> this:
>
> ex Scan using warranty_order_item_warranty_order_id_idx on
> warranty_order_item woi_1 (cost=0.57..277.53 rows=6 width=137) (actual
> time=0.110..0.111 rows=0
So some of my output from an explain analyze here has a line that says this:
ex Scan using warranty_order_item_warranty_order_id_idx on
warranty_order_item woi_1 (cost=0.57..277.53 rows=6 width=137) (actual
time=0.110..0.111 rows=0 loops=1,010,844)
How can you have 1M loops over 0 rows?
Running
David Rysdam <[EMAIL PROTECTED]> writes:
> According to what I've been able to find:
> A = predicted time to first returned row in milliseconds
arbitrary units
> B = total cost in arbitrary units
> C = actual time to first returned row in
There's been plenty of vacuuming and analyzing on these tables, so
outdated stats are not the answer.
No but it could be incorrect stats do to the statistics parameter not
being set high enough.
Joshua D. Drake
---(end of broadcast)---
TIP
I'm afraid I still don't understand the output of EXPLAIN ANALYZE. The
output I get is like this:
blah blah blah (cost=A..B blah blah) (actual time=C..D blah blah)
According to what I've been able to find:
A = predicted time to first returned row in milliseconds
B = total cost in arbitrary un
