Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution - Mailing list pgsql-bugs

From Thomas Munro
Subject Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution
Date
Msg-id CAEepm=0OFFHRkDUYzdHFPpQeki6b5U59PjOF7KW17PseH4vSCA@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14889: explain analyze is taking much more time than actual execution  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Tue, Nov 7, 2017 at 3:43 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The size of the overhead in this case implies that gettimeofday() is doing
> a kernel call, which I wouldn't really have expected on any modern Linux
> kernel.  What hardware is this on?  Is there virtualization involved?

A virtual server with no vDSO, I'll bet.  Like this:

https://stackoverflow.com/questions/42622427/gettimeofday-not-using-vdso

-- 
Thomas Munro
http://www.enterprisedb.com


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: Re: [BUGS] BUG #14889: explain analyze is taking much more time thanactual execution
Next
From: Yan Maystrenko
Date:
Subject: [BUGS] Returning same row twice in certain conditions