Re: Fwd: [BUG] Print timing statistics of trigger execution under turned off timing option of EXPLAIN ANALYZE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: maksim <m(dot)milyutin(at)postgrespro(dot)ru>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Fwd: [BUG] Print timing statistics of trigger execution under turned off timing option of EXPLAIN ANALYZE
Date: 2016-08-12 15:35:19
Message-ID: 29520.1471016119@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

maksim <m(dot)milyutin(at)postgrespro(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-08-12 16:41:56 Re: Add hint for function named "is"
Previous Message Tom Lane 2016-08-12 15:27:38 Re: Why is box <-> point missing, and box <-> box not indexable?