MIME-Version: 1.0
In-Reply-To: <1469112481.11501.12.camel@kth.se>
References: <1464351030.15267.14.camel@kth.se>
 <32524.1464356784@sss.pgh.pa.us>
 <1464593729.16712.2.camel@kth.se> <1464616618.19212.3.camel@kth.se>
 <1469112481.11501.12.camel@kth.se>
From: Claudio Freire <klaussfreire@gmail.com>
Date: Thu, 21 Jul 2016 15:24:17 -0300
Message-ID: 
 <CAGTBQpa8ktuwBPnR7bMW3fyzO-mfsttfaPwK82GaEyT3_5OeSA@mail.gmail.com>
Subject: Re: Performance problems with 9.2.15
To: Johan Fredriksson <eskil@kth.se>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Content-Type: text/plain; charset=UTF-8
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On Thu, Jul 21, 2016 at 11:48 AM, Johan Fredriksson <eskil@kth.se> wrote:
> EXPLAIN ANALYZE VERBOSE SELECT DISTINCT main.* FROM Users main CROSS
> JOIN ACL ACL_3 JOIN Principals Principals_1  ON ( Principals_1.id =
> main.id ) JOIN CachedGroupMembers CachedGroupMembers_2  ON
> ( CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN
> CachedGroupMembers CachedGroupMembers_4  ON
> ( CachedGroupMembers_4.MemberId = Principals_1.id )  WHERE
> ((ACL_3.ObjectType = 'RT::Queue' AND ACL_3.ObjectId   = 85) OR
> (ACL_3.ObjectType = 'RT::System' AND ACL_3.ObjectId   = 1)) AND
> (ACL_3.PrincipalId = CachedGroupMembers_4.GroupId) AND
> (ACL_3.PrincipalType = 'Group') AND (ACL_3.RightName = 'OwnTicket') AND
> (CachedGroupMembers_2.Disabled = '0') AND (CachedGroupMembers_2.GroupId
> = '4') AND (CachedGroupMembers_4.Disabled = '0') AND
> (Principals_1.Disabled = '0') AND (Principals_1.PrincipalType = 'User')
> AND (Principals_1.id != '1')  ORDER BY main.Name ASC;


That cross join doesn't look right. It has no join condition.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance