From: c k <shreeseva.learning@gmail.com>
To: Travis Smith <tsmith@optionshouse.com>
To: pgsql-general@postgresql.org
Subject: Re: [ADMIN] Query performance difference
Date: Fri, 22 Aug 2008 01:51:45 +0530
Message-ID: <d8e7a1e30808211321v4cb216ak700f9063524cbf2a@mail.gmail.com> (raw)
In-Reply-To: <D337038284820142B2A3196D1BFE2B470F78E403@spswchi6mail1.peak6.net>
References: <d8e7a1e30808211248p18ecab8fx4ee3f35fdf6a404b@mail.gmail.com>
<D337038284820142B2A3196D1BFE2B470F78E403@spswchi6mail1.peak6.net>
What do you want to say?
Please give details. I got an explain from PGAdmin,
as follows
"GroupAggregate (cost=28927.37..35594.39 rows=156871 width=24)"
" -> Sort (cost=28927.37..29319.55 rows=156871 width=24)"
" Sort Key: docacctransactions.accgroupid, docs.docid, docs.docdate"
" -> Hash Join (cost=3337.89..12170.02 rows=156871 width=24)"
" Hash Cond: (docacctransactions.docid = docs.docid)"
" -> Seq Scan on docacctransactions (cost=0.00..3665.71
rows=156871 width=20)"
" -> Hash (cost=2545.06..2545.06 rows=48306 width=8)"
" -> Seq Scan on docs (cost=0.00..2545.06 rows=48306
width=8)"
Can you please give why there is a time difference?
CPK
On Fri, Aug 22, 2008 at 1:44 AM, Travis Smith <tsmith@optionshouse.com>wrote:
> It may be worth-wile to generate an explain plan
>
>
>
> http://www.postgresql.org/docs/8.3/interactive/sql-explain.html
>
>
>
>
>
>
>
>
>
> *From:* pgsql-admin-owner@postgresql.org [mailto:
> pgsql-admin-owner@postgresql.org] *On Behalf Of *c k
> *Sent:* Thursday, August 21, 2008 2:49 PM
> *To:* pgsql-general@postgresql.org; pgsql-admin@postgresql.org
> *Subject:* [ADMIN] Query performance difference
>
>
>
> Hello,
> I have a question regarding query performance from two pgsql applications.
> PGadmin III 1.8 and Navicat for postgresql 8. Both connected to same server
> on local machine 8.3 and runs a same query for appox. 1,60,000 rows with one
> min, one max and addition of the min and max values on two tables joined on
> an integer column gives different query execution times with noticible
> difference. PGAdmin gives 9350ms and Navicat gives 2110ms. Why? What will be
> the difference?
> Is it in their query execution methods, with/without indexes etc?.
> Thanks
>
> CPK
> ------------------------------
>
> The information in this email or in any file attached hereto is intended
> only for the personal and confidential use of the individual or entity to
> which it is addressed and may contain information that is proprietary and
> confidential. If you are not the intended recipient of this message you are
> hereby notified that any review, dissemination, distribution or copying of
> this message is strictly prohibited. This communication is for information
> purposes only and should not be regarded as an offer to sell or as a
> solicitation of an offer to buy any financial product. Email transmission
> cannot be guaranteed to be secure or error-free. P6070214
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: shreeseva.learning@gmail.com, tsmith@optionshouse.com, pgsql-general@postgresql.org
Subject: Re: [ADMIN] Query performance difference
In-Reply-To: <d8e7a1e30808211321v4cb216ak700f9063524cbf2a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox