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 по дате отправления:

Предыдущее
От: Szymon Guz
Дата:
Сообщение: not enough disk space
Следующее
От: Reid Thompson
Дата:
Сообщение: 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