From: mallah@trade-india.com
To: mallah@trade-india.com
Cc: tgl@sss.pgh.pa.us
Cc: pgsql-sql@postgresql.org
Subject: Re: cannot EXPLAIN query...
Date: Mon, 3 Feb 2003 23:04:19 +0530 (IST)
Message-ID: <8600.219.65.233.83.1044293659.squirrel@mail.trade-india.com> (raw)
In-Reply-To: <200302032202.38296.mallah@trade-india.com>
References: <200302031932.08326.mallah@trade-india.com>
<200302032119.17934.mallah@trade-india.com>
<19324.1044287157@sss.pgh.pa.us>
<200302032202.38296.mallah@trade-india.com>
Hi ,
This is to confirm that the EXPLAIN problem
does not occur anymore after successfully upgrading
to 7.3.1 from 7.3.0
Thanks everyone.
Regards
Mallah.
explain select * from shippers1 where city='DELHI';
QUERY
PLAN------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Nested Loop (cost=0.00..26461.22 rows=1 width=339)
-> Subquery Scan b (cost=0.00..26448.53 rows=477 width=307)
Filter: (city = 'DELHI'::character varying)
-> Append (cost=0.00..26448.53 rows=477 width=307)
-> Subquery Scan "*SELECT* 1" (cost=0.00..6739.42 rows=249 width=307)
-> Index Scan using eyp_listing_category_id, eyp_listing_category_id,
eyp_listing_category_id, eyp_listing_category_id, eyp_listing_category_id on
eyp_listing (cost=0.00..6739.42 rows=249 width=307) Index Cond: ((category_id = 1142) OR (category_id = 1143) OR
(category_id = 1145) OR (category_id = 1259) OR (category_id = 1161)) Filter: ((amount > 0) AND (status = 'a'::character varying) AND (email
IS NOT NULL)) -> Subquery Scan "*SELECT* 2" (cost=0.00..9288.33 rows=77 width=286)
-> Seq Scan on iid_listing (cost=0.00..9288.33 rows=77 width=286)
Filter: (((category_id = 1142) OR (category_id = 1143) OR (category_id
= 1145) OR (category_id = 1259) OR (category_id = 1161)) AND (amount >
0) AND (status = 'a'::character varying) AND (email IS NOT NULL)) -> Subquery Scan "*SELECT* 3" (cost=10413.26..10420.79 rows=151 width=248)
-> Unique (cost=10413.26..10420.79 rows=151 width=248)
-> Sort (cost=10413.26..10417.02 rows=1506 width=248)
Sort Key: branding_master.company_id
-> Hash Join (cost=339.35..10333.74 rows=1506 width=248)
Hash Cond: ("outer".company_id = "inner".company_id)
-> Seq Scan on branding_master (cost=0.00..7171.80
rows=32985 width=242) Filter: ((old_company_id = 0) AND (status =
'a'::character varying) AND (email IS NOT NULL) AND
(eyp_paid IS NULL) AND (iid_paid IS NULL)) -> Hash (cost=331.00..331.00 rows=3339 width=6)
-> Seq Scan on branding_sp_category
(cost=0.00..331.00 rows=3339 width=6) Filter: ((category_id = 1142) OR (category_id =
1143) OR (category_id = 1145) OR (category_id =
1259) OR (category_id = 1161)) -> Index Scan using approved_profiles_id_key on approved_profiles a (cost=0.00..5.30 rows=1
width=15) Index Cond: ((a.id = "outer".id) AND (a.source = "outer".source))
(24 rows)
tradein_clients=#
>
>
> Hmmm... upgrade to 7.3.1 was not that smooth..
> after upgrade i could not run a single query..
>
> tradein_clients=> SELECT * from hogs;
> ERROR: current transaction is aborted, queries ignored until end of transaction block
> tradein_clients=>
> any other query seems to be giving the same ERROR.
>
> check the message below on psql start (7.3.1) with a 7.3.1 server.
>
> PS: i applied the heir patch though ... ;-) will try again without that.
>
> [postgres@ns3 postgres]$ psql -Upostgres -h66.234.10.12 tradein_clients
>
>>> ERROR: nodeRead: did not find '}' at end of plan node
>
> Welcome to psql 7.3.1, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help on internal slash commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> tradein_clients=>
>
>
>
>
> regds
> mallah.
>
>
> On Monday 03 February 2003 09:15 pm, Tom Lane wrote:
>> "Rajesh Kumar Mallah." <mallah@trade-india.com> writes:
>> > I think if i do that i will hve to immediately upgrade
>> > all the 7.3.0 clients in other machines to 7.3.1 rite?
>>
>> No.
>>
>> regards, tom lane
>
> --
>
>
> --------------------------------------------
> Regds Mallah
> Rajesh Kumar Mallah,
> Project Manager (Development)
> Infocom Network Limited, New Delhi
> phone: +91(11)26152172 (221) (L) 9811255597 (M)
> Visit http://www.trade-india.com ,
> India's Leading B2B eMarketplace.
>
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and
> unsubscribe commands go to majordomo@postgresql.org
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/
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-sql@postgresql.org
Cc: mallah@trade-india.com, tgl@sss.pgh.pa.us
Subject: Re: cannot EXPLAIN query...
In-Reply-To: <8600.219.65.233.83.1044293659.squirrel@mail.trade-india.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