440
440
the related Insert, Update, or Delete node, although time spent executing
441
441
<literal>AFTER</> triggers is not. The time spent in each trigger
442
442
(either <literal>BEFORE</> or <literal>AFTER</>) is also shown separately
444
444
Note, however, that deferred constraint triggers will not be executed
445
445
until end of transaction and are thus not shown by
446
446
<command>EXPLAIN ANALYZE</command>.
451
451
<command>EXPLAIN ANALYZE</command> can deviate from normal execution of
452
452
the same query. First, since no output rows are delivered to the client,
453
453
network transmission costs and I/O formatting costs are not included.