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
Список
Дерево обсуждения
BUG #15387: explain analyze timing on bug? PG Bug reporting form <noreply@postgresql.org>
Re: BUG #15387: explain analyze timing on bug? Tom Lane <tgl@sss.pgh.pa.us>
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 по дате отправления
От: Ingoglia
Дата:
Сообщение: pgadmin4 docker build bug
От: PG Bug reporting form
Дата:
FAQ