| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> | 
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org | 
| Cc: | digoal(at)126(dot)com | 
| Subject: | BUG #15387: explain analyze timing on bug? | 
| Date: | 2018-09-18 02:45:35 | 
| Message-ID: | 153723873509.13484.12810806390117062364@wrigleys.postgresql.org | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-bugs | 
The following bug has been logged on the website:
Bug reference:      15387
Logged by:          Zhou Digoal
Email address:      digoal(at)126(dot)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 ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2018-09-18 03:22:34 | BUG #15388: time convert error when use AT TIME ZONE '+8' | 
| Previous Message | Ingoglia | 2018-09-17 17:03:48 | pgadmin4 docker build bug |