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 по дате отправления: