ModifyTable, EXPLAIN ANALYZE and AFTER triggers
| От | Marko Tiikkaja |
|---|---|
| Тема | ModifyTable, EXPLAIN ANALYZE and AFTER triggers |
| Дата | |
| Msg-id | 4D6E2495.9010400@cs.helsinki.fi обсуждение |
| Ответы |
Re: ModifyTable, EXPLAIN ANALYZE and AFTER triggers
|
| Список | pgsql-docs |
Hi, The recent commit 09b49a8439fde63826f93f55430868cf2585644b claims: + Time spent firing triggers, if any, is charged to the Insert, + Update, or Delete node, and is also shown separately for each trigger. + Note, however, that deferred triggers will not be fired until end of + transaction and are thus not accounted for in the output of + <command>EXPLAIN ANALYZE</command>. But that's only part of the truth; the ModifyTable nodes queue AFTER triggers, but don't actually fire them. I remember there was some discussion during 9.0's development about making the ModifyTable nodes also count the time spent firing AFTER triggers, but I don't remember what we decided back then. Meanwhile, I think this part in the documentation needs a small clarification. Regards, Marko Tiikkaja
В списке pgsql-docs по дате отправления: