Re: Seeing foreign key lookups in explain output

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: Vincent de Phily <vincent(dot)dephily(at)mobile-devices(dot)fr>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Seeing foreign key lookups in explain output
Date: 2011-09-20 13:12:58
Message-ID: CABRT9RDBSG6ha-mE8R=UKm6n_6nkZQ2jiHTiGvrOAL7Y5bvVKA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Sep 20, 2011 at 15:35, Vincent de Phily
<vincent(dot)dephily(at)mobile-devices(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marti Raudsepp 2011-09-20 13:32:50 Re: Seeing foreign key lookups in explain output
Previous Message Szymon Guz 2011-09-20 13:01:59 not enough disk space