Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YagFK-0005Wn-J9 for pgsql-admin@arkaria.postgresql.org; Wed, 25 Mar 2015 08:01:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YagFJ-0008Ni-WF for pgsql-admin@arkaria.postgresql.org; Wed, 25 Mar 2015 08:01:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YagFI-0008LQ-89 for pgsql-admin@postgresql.org; Wed, 25 Mar 2015 08:01:00 +0000 Received: from eu1sys200aog132.obsmtp.com ([207.126.144.207]) by magus.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YagFD-0008SM-Nf for pgsql-admin@postgresql.org; Wed, 25 Mar 2015 08:00:58 +0000 Received: from mail-qg0-f43.google.com ([209.85.192.43]) (using TLSv1) by eu1sys200aob132.postini.com ([207.126.147.11]) with SMTP ID DSNKVRJrM/NGvtINV/nR69DFZk1sOZXNzqE/@postini.com; Wed, 25 Mar 2015 08:00:55 UTC Received: by qgfa8 with SMTP id a8so28272341qgf.0 for ; Wed, 25 Mar 2015 01:00:50 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:mime-version:thread-index:date:message-id :subject:to:content-type; bh=6VEuqDnAQFJ9MrZKk3UHHba7cP/eR724ksD8srXP9n8=; b=QD1IVfJ8SKywfDqyv9HKgyTU6jJTD+PVu9aqDngAU+3QgB3FexdIshPfZyPxVEv1nQ h6WcjzKMwgYrDmiOIdpmtBnI383NmlH3tqnQ2x86656niDjopIZ/pU2qGlzXukRN6fc6 8vTYOXX/88ZqZOun3SKThprYB0UN5hXZt2wC2DBDEuX9EknVMyZYjMSwT0WIIy38xxO4 whvmH8hSnO1e40eWADEJznxFk1w1Atirucg/PKlolWONeu96GYxMByWCsqC7ky8pC0SC AISYA1ngSc0UdeLDI9eNKziky97joZerGXWZd2hkjrudiorOA42a3CvEr+nKOetzCjZF zg3g== X-Gm-Message-State: ALoCoQnJR58aO7L29OsGH164AXQRVG2JxID5ej7pH2rW6buhgLsb8W6r/Et2tpcydDvtWdRrghqZLPS5MRU050qsTCvpK54HnJpkUT1tQUHX9lc7hiVQVDUZT/SMtggK40wghanyT4vhJGRqI3KaK/Rz6kWbhQcMxg== X-Received: by 10.229.68.136 with SMTP id v8mr10897554qci.16.1427270450528; Wed, 25 Mar 2015 01:00:50 -0700 (PDT) X-Received: by 10.229.68.136 with SMTP id v8mr10897549qci.16.1427270450396; Wed, 25 Mar 2015 01:00:50 -0700 (PDT) From: Khangelani Gama MIME-Version: 1.0 X-Mailer: Microsoft Outlook 14.0 thread-index: AdBm0a2xmPYr/ZaNTZ6J3dU26v98vw== Date: Wed, 25 Mar 2015 10:00:49 +0200 Message-ID: Subject: Postgres 9 : - How to interpret the EXPLAIN query results To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=001a1133984431da8b0512184cc4 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --001a1133984431da8b0512184cc4 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Please help, how can I interpret the following results of my EXPLAIN query ?, I can see that the query will through 18586018 rows, but what=E2=80=99s = the meaning of cost and width? GroupAggregate (cost=3D762381141.96..768375132.77 rows=3D18586018 width=3D= 32) CONFIDENTIALITY NOTICE The contents of and attachments to this e-mail are intended for the addre= ssee only, and may contain the confidential information of Argility (Proprietary) Limited and/or its subsidiaries. An= y review, use or dissemination thereof by anyone other than the intended addressee is prohibited.If you are not the intend= ed addressee please notify the writer immediately and destroy the e-mail. Argility (Proprietary) Limited and its subsidiari= es distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other tha= n strictly for business purposes. =0D --001a1133984431da8b0512184cc4 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Hi

=C2=A0

Please help, how can I interpret the foll= owing results of my EXPLAIN query ?, I can see that the query will through = 18586018 rows, but what=E2=80=99s the meaning of cost and width?

=C2=A0

GroupAggregate=C2=A0 (cos= t=3D762381141.96..768375132.77 rows=3D18586018 width=3D32)

=C2=A0

=C2=A0

=C2=A0

=C2=A0


CONFIDENTIALITY NOTICE
The contents of and attachments to this e-mail are intended for the addre=
ssee only, and may contain the confidential
information of Argility (Proprietary) Limited and/or its subsidiaries. An=
y review, use or dissemination thereof by anyone
other than the intended addressee is prohibited.If you are not the intend=
ed addressee please notify the writer immediately
and destroy the e-mail. Argility (Proprietary) Limited and its subsidiari=
es distance themselves from and accept no liability
for unauthorised use of their e-mail facilities or e-mails sent other tha=
n strictly for business purposes.
=0D
--001a1133984431da8b0512184cc4--