Re: cannot EXPLAIN query... - Mailing list pgsql-sql

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-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NestedLoop  (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_idon                    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'::charactervarying) AND (email                          IS NOT NULL))               ->  Subquery Scan "*SELECT* 2"
(cost=0.00..9288.33rows=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.79rows=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_paidIS NULL) AND (iid_paid IS NULL))                                       ->  Hash  (cost=331.00..331.00
rows=3339width=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_keyon 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/