explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QiJ3

Settings
# exclusive inclusive rows x rows loops node
1. 29,654.812 29,654.812 ↑ 5.0 106 1

GroupAggregate (cost=619,445.15..619,503.01 rows=526 width=248) (actual time=29,653.189..29,654.812 rows=106 loops=1)

  • Group Key: (((((((w.desthub).hubcode)::text || ':'::text) || (w.suppliercode)::text) || ':'::text) || (COALESCE(COALESCE(b.bagid, w.regionalbagid), (-1)))::text)), (COALESCE(((((((w.desthub).hubname)::text || ' (Bag:'::text) || (COALESCE(bb.id, rbb.id))::text) || ') '::text) || CASE WHEN (rbb.viahub IS NOT NULL) THEN (((' regional '::text || (rbb.desthub)::text) || '/'::text) || (rbb.viahub)::text) ELSE ' '::text END), ((w.desthub).hubname)::text)), (COALESCE(rbb.viahub, ((w.desthub).hubcode)::character varying)), w.suppliercode, (COALESCE(b.bagid, w.regionalbagid)), (CASE WHEN (((w.sourcehub).hubcode = ANY ('{jhb,cpt,kzn}'::bpchar[])) AND (NOT hub.courier) AND hub.couriermi: