On Tue, Sep 20, 2011 at 15:35, Vincent de Phily <vincent.deph...@mobile-devices.fr> wrote: > The explain output will tell me it's using the index on t1's id, but it tells > me nothing about the seqscan that happens on t2 (because I forgot to add an > index on t2.ref).
+1 for a TODO on adding foreign key trigger time to EXPLAIN ANALYZE output. Regards, Marti -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general