BUG #15387: explain analyze timing on bug?
От | PG Bug reporting form |
---|---|
Тема | BUG #15387: explain analyze timing on bug? |
Дата | |
Msg-id | 153723873509.13484.12810806390117062364@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15387: explain analyze timing on bug?
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15387 Logged by: Zhou Digoal Email address: digoal@126.com PostgreSQL version: 11beta3 Operating system: CentOS 7.x x64 Description: when turn on timing for explain analyze: ``` postgres=# explain (analyze on,verbose on,timing on,costs on,buffers on,summary on) select count(*) from item1; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------ Aggregate (cost=254.75..254.75 rows=1 width=8) (actual time=26.938..26.938 rows=1 loops=1) Output: count(*) Buffers: shared hit=1334 -> Seq Scan on public.item1 (cost=0.00..38.00 rows=100000 width=0) (actual time=0.011..15.674 rows=100000 loops=1) Output: i_id, i_im_id, i_name, i_price, i_data Buffers: shared hit=1334 Planning Time: 0.065 ms Execution Time: 26.967 ms (8 rows) Time: 27.291 ms ``` when turn off timing: ``` postgres=# explain (analyze on,verbose on,timing off,costs on,buffers on,summary on) select count(*) from item1; QUERY PLAN ----------------------------------------------------------------------------------------------------- Aggregate (cost=254.75..254.75 rows=1 width=8) (actual rows=1 loops=1) Output: count(*) Buffers: shared hit=1334 -> Seq Scan on public.item1 (cost=0.00..38.00 rows=100000 width=0) (actual rows=100000 loops=1) Output: i_id, i_im_id, i_name, i_price, i_data Buffers: shared hit=1334 Planning Time: 0.062 ms Execution Time: 11.050 ms (8 rows) Time: 11.394 ms ``` why turn timing on increment about 26ms ?
В списке pgsql-bugs по дате отправления: