X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 606FFD1DFA3 for ; Fri, 12 Dec 2003 15:33:57 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 40164-08 for ; Fri, 12 Dec 2003 11:33:30 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 411DDD1E001 for ; Fri, 12 Dec 2003 11:33:26 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hBCFXU19019870; Fri, 12 Dec 2003 10:33:30 -0500 (EST) To: "david@shadovitz.com" Cc: "'pgsql-performance@postgresql.org'" Subject: Re: Query plan - now what? In-reply-to: <01C3C045.7EDD13C0.david@shadovitz.com> References: <01C3C045.7EDD13C0.david@shadovitz.com> Comments: In-reply-to David Shadovitz message dated "Fri, 12 Dec 2003 00:18:12 -0800" Date: Fri, 12 Dec 2003 10:33:30 -0500 Message-ID: <19869.1071243210@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/198 X-Sequence-Number: 5058 David Shadovitz writes: > Well, now that I have the plan for my slow-running query, what do I > do? This is not very informative when you didn't show us the query nor the table schemas (column datatypes and the existence of indexes are the important parts). I have a feeling that you might be well advised to fold the multiple tables into one "animals" table, but there's not enough info here to make that recommendation for sure. BTW, what did you do with this, print and OCR it? It's full of the most bizarre typos ... mostly "l" for "1", but others too ... regards, tom lane