Re: [ADMIN] Query performance difference

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(at)optionshouse(dot)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(at)postgresql(dot)org [mailto:
> pgsql-admin-owner(at)postgresql(dot)org] *On Behalf Of *c k
> *Sent:* Thursday, August 21, 2008 2:49 PM
> *To:* pgsql-general(at)postgresql(dot)org; pgsql-admin(at)postgresql(dot)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
>