public inbox for [email protected]
help / color / mirror / Atom feedFrom: Igor Neyman <[email protected]>
To: Neto pr <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Explain Analyze - actual time in loops
Date: Fri, 8 Sep 2017 12:46:45 +0000
Message-ID: <DM5PR17MB14993F6FD18158C593907D85DA950@DM5PR17MB1499.namprd17.prod.outlook.com> (raw)
In-Reply-To: <CA+wPC0OXdN+_8HxhYMWyV9nfD8v+xChvLROiWCiRo=qSve2MjQ@mail.gmail.com>
References: <CA+wPC0OXdN+_8HxhYMWyV9nfD8v+xChvLROiWCiRo=qSve2MjQ@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
From: [email protected] [mailto:[email protected]] On Behalf Of Neto pr
Sent: Thursday, September 07, 2017 11:17 PM
To: [email protected]
Subject: [PERFORM] Explain Analyze - actual time in loops
…
################################ ###################################
-> Index Scan using idx_l_partkeylineitem000x on lineitem (cost = 0.57..97.65 rows = 26 width = 36)
(current time = 23.615..419.113 rows = 30 loops = 26469)
Index Cond: (l_partkey = part.p_partkey)
################################################## #################
According to the documentation, one should multiply the Actual Time by the number of Loops.
That is: 419113 ms -> 419113/1000/60 = 6.9 minutes * 26469 (loops) = 182.6 minutes.
But how does this stretch take 182.6 minutes, if the entire query ran in 66 minutes?
……………….
thank you and best regards
[] 's Neto
Neto,
The time you see there is in ms, so the point (‘.’) you see is the digital point.
So, it is 419.113ms or a little less than half a second (0.419sec).
Igor Neyman
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]
Subject: Re: Explain Analyze - actual time in loops
In-Reply-To: <DM5PR17MB14993F6FD18158C593907D85DA950@DM5PR17MB1499.namprd17.prod.outlook.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