Re: Fwd: [BUG] Print timing statistics of trigger execution under turned off timing option of EXPLAIN ANALYZE - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Fwd: [BUG] Print timing statistics of trigger execution under turned off timing option of EXPLAIN ANALYZE
Date
Msg-id 29520.1471016119@sss.pgh.pa.us
Whole thread Raw
In response to Fwd: [BUG] Print timing statistics of trigger execution under turned off timing option of EXPLAIN ANALYZE  (maksim <m.milyutin@postgrespro.ru>)
List pgsql-hackers
maksim <m.milyutin@postgrespro.ru> writes:
> postgres=# EXPLAIN (ANALYZE, timing false) insert INTO foo 
> values(1000001, '');
>                                  QUERY PLAN
> --------------------------------------------------------------------------
>   Insert on foo  (cost=0.00..0.01 rows=1 width=36) (actual rows=0 loops=1)
>     ->  Result  (cost=0.00..0.01 rows=1 width=36) (actual rows=1 loops=1)
>   Planning time: 0.038 ms
>   Trigger unique_foo_c1:*/time=0.000/* calls=1
>   Execution time: 340.766 ms
> (5 rows)

Hmm, yeah, it shouldn't do that.

> My patch fixes this problem.

Will push, thanks.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why is box <-> point missing, and box <-> box not indexable?
Next
From: Robert Haas
Date:
Subject: Re: Add hint for function named "is"