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
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
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).
>
>
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