Re: BUG #15387: explain analyze timing on bug? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15387: explain analyze timing on bug?
Date
Msg-id 19889.1537241223@sss.pgh.pa.us
Whole thread Raw
In response to BUG #15387: explain analyze timing on bug?  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.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


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15388: time convert error when use AT TIME ZONE '+8'
Next
From: Tom Lane
Date:
Subject: Re: BUG #15388: time convert error when use AT TIME ZONE '+8'