Re: Seeing foreign key lookups in explain output

Поиск
Список
Период
Сортировка
От Marti Raudsepp
Тема Re: Seeing foreign key lookups in explain output
Дата
Msg-id CABRT9RDBSG6ha-mE8R=UKm6n_6nkZQ2jiHTiGvrOAL7Y5bvVKA@mail.gmail.com
обсуждение исходный текст
Ответ на Seeing foreign key lookups in explain output  (Vincent de Phily <vincent.dephily@mobile-devices.fr>)
Ответы Re: Seeing foreign key lookups in explain output
Список pgsql-general
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 по дате отправления: