Re: [GENERAL] Seeing foreign key lookups in explain output

2011-09-20 Thread Andreas Kretschmer
Marti Raudsepp wrote: > On Tue, Sep 20, 2011 at 16:12, Marti Raudsepp wrote: > > On Tue, Sep 20, 2011 at 15:35, Vincent de Phily > > 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 fo

Re: [GENERAL] Seeing foreign key lookups in explain output

2011-09-20 Thread Vincent de Phily
On Tuesday 20 September 2011 16:32:50 Marti Raudsepp wrote: > On Tue, Sep 20, 2011 at 16:12, Marti Raudsepp wrote: > > +1 for a TODO on adding foreign key trigger time to EXPLAIN ANALYZE > > output. > Sorry, that was too hasty. We already have that now in 9.0 and 9.1 > (not sure when it was introd

Re: [GENERAL] Seeing foreign key lookups in explain output

2011-09-20 Thread Marti Raudsepp
On Tue, Sep 20, 2011 at 16:12, Marti Raudsepp wrote: > On Tue, Sep 20, 2011 at 15:35, Vincent de Phily > 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). > >

Re: [GENERAL] Seeing foreign key lookups in explain output

2011-09-20 Thread Marti Raudsepp
On Tue, Sep 20, 2011 at 15:35, Vincent de Phily 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 ANAL