Re: BUG #15387: explain analyze timing on bug?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: digoal(at)126(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15387: explain analyze timing on bug?
Date: 2018-09-18 03:27:03
Message-ID: 19889.1537241223@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?utf-8?q?PG_Bug_reporting_form?= <noreply(at)postgresql(dot)org> writes:
> why turn timing on increment about 26ms ?

That's the cost of reading the system clock 200000 times (once per
entry and exit to the SeqScan node). So apparently that takes about
130ns on your hardware, which is not great, but not awful either.

See

https://www.postgresql.org/message-id/flat/31856.1400021891%40sss.pgh.pa.us

for some more context.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2018-09-18 03:45:05 Re: BUG #15388: time convert error when use AT TIME ZONE '+8'
Previous Message PG Bug reporting form 2018-09-18 03:22:34 BUG #15388: time convert error when use AT TIME ZONE '+8'