Обсуждение: Fwd: [BUG] Print timing statistics of trigger execution under turned off timing option of EXPLAIN ANALYZE

Поиск
Список
Период
Сортировка

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

От
maksim
Дата:
Hello, hackers!


At this moment EXPLAIN ANALYZE with turned off timing option after execution query that expires trigger prints time of total execution of trigger function:

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)

My patch fixes this problem.

-- 
Maksim Milyutin
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
Вложения

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

От
Tom Lane
Дата:
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