Postgres Pro
Downloads
Home   >   mailing lists

Re: Seeing foreign key lookups in explain output - Mailing list pgsql-general

From Marti Raudsepp
Subject Re: Seeing foreign key lookups in explain output
Date
Msg-id CABRT9RDBSG6ha-mE8R=UKm6n_6nkZQ2jiHTiGvrOAL7Y5bvVKA@mail.gmail.com
Whole thread Raw
In response to Seeing foreign key lookups in explain output  (Vincent de Phily <vincent.dephily@mobile-devices.fr>)
Responses Re: Seeing foreign key lookups in explain output
List pgsql-general
Tree view 
On Tue, Sep 20, 2011 at 15:35, Vincent de Phily
<vincent.dephily@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

pgsql-general by date:

Previous
From: Szymon Guz
Date:
Subject: not enough disk space
Next
From: Reid Thompson
Date:
Subject: Is libpq version indifferent? I.E. can 8.3.x compiled binaries run without issue against a 9.1 backend, or are clients required to be re-compiled against the 9.1 libpq