Re: Performance issues in query with multiple joins

=?UTF-8?B?zqDOsc+BzrHPg866zrXPhc63IM6gzrHPg8+DzrHPgc63?= writes: > We are facing a performance issue with the following query. Executing this > query takes about 20 seconds. Raising join_collapse_limit (to more than the number of joins in the query) might help. But I think really if

Performance issues in query with multiple joins

On Friday, April 28, 2023, Παρασκευη Πασσαρη wrote: > Dear all, > > We are facing a performance issue with the following query. Executing this > query takes about 20 seconds. > (the database version is 14.1) > Given the possibility of this working better in the supported 14.7 I suggest starting

Performance issues in query with multiple joins

Dear all, We are facing a performance issue with the following query. Executing this query takes about 20 seconds. (the database version is 14.1) The query: - SLOW QUERY - SELECT lead_record.id AS id FROM "lead_record" lead_record LEFT JOIN