Fwd: explain analyse and nested loop joins

[Oliver Kohll - Mailing Lists <oliver.lists@xxxxxxxxxx>]

Oops, forgot to include the query, it's

SELECT b2deliveryorders.idb2deliveryorders, a2clientpremises.ida2clientpremises, a2clientpremises.premisesname, a2clientpremises.town, b2deliveryorders.expectedby, b2deliveryorders.dateordered, b2deliveryorders.invoicenumber, b2deliveryorders.deliverymethod, b2deliveryorders.driver, dbvcalc_delivery_charges.total, dbvcalc_delivery_charges.boxes, b2deliveryorders.createdbyauto
   FROM b2deliveryorders
   LEFT JOIN a2clientpremises ON b2deliveryorders.a2clientpremisespremisesname = a2clientpremises.ida2clientpremises
   LEFT JOIN dbvcalc_delivery_charges ON b2deliveryorders.idb2deliveryorders = dbvcalc_delivery_charges.idb2deliveryorders
  WHERE b2deliveryorders.complete = false AND b2deliveryorders.invoiced = false
  ORDER BY b2deliveryorders.expectedby NULLS FIRST;

Oliver

Begin forwarded message:

From: Oliver Kohll - Mailing Lists <oliver.lists@xxxxxxxxxx>

Subject: explain analyse and nested loop joins

Date: 5 November 2011 19:21:23 GMT

To: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>

Hi,

I have a query I'm trying to optimise.