From: Rajesh Kumar Mallah <mallah@trade-india.com>
Organization: Infocom Network Limited
To: Popeanga Marian <pmarian@cnlo.ro>
Subject: Re: explain
Date: Sat, 22 Mar 2003 14:15:02 +0530
User-Agent: KMail/1.5
Cc: pgsql-sql@postgresql.org
References: <1114.219.65.253.113.1048264331.squirrel@mail.trade-india.com>
	<3E7BFE7F.2010500@cnlo.ro>
In-Reply-To: <3E7BFE7F.2010500@cnlo.ro>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200303221415.02040.mallah@trade-india.com>


Sorry ,

I am not sure about this.

ie, if a query does not have enough previliegs to run,
will its explain be allowed?
i hope someone else can throw some light.


But i have one suggestion regarding your project
spend a *couple* of week studying docs and using postgresql.
just a quick weekend may not be enough to gather much 
understanding for your project.


regds
mallah.


On Saturday 22 Mar 2003 11:41 am, Popeanga Marian wrote:
> Mallah,
> 
> 
>         Thanks for your info,
> 
>  
>         I runned the query with explain yesterday and it didn't work for 
> a user where i didn't had enough privileges i think !?    
> Why db didn't say anythink  ?
> 
> I created a new user and a new table.
> 
>      Explain for this table worked just as you said and for any other 
> querys.
> 
> Is there any way to know if a user has wright privileges to explain a 
> query ?
> 
> mallah@trade-india.com wrote:
> 
> >Popeanga  ,
> >
> >Its basically possible to get the info programatically.
> >see below is an example perl code that is getting the
> >plan data:
> >
> >############### file test.pl #################
> >
> >#!/usr/bin/perl
> >
> >use DBI;
> >$dbh = DBI->connect('dbi:Pg:dbname=rmallah' , '','');
> >$your_query_here= 'select * from test';
> >$rows = $dbh -> selectall_arrayref("EXPLAIN ANALYZE $your_query_here");
> >foreach (@$rows) {
> >        print "$_->[0]\n";
> >}
> >$dbh -> disconnect();
> >#############################################
> >
> >on running you get:
> >
> >[rmallah@subho rmallah]$ ./test.pl
> >Seq Scan on test  (cost=0.00..20.00 rows=1000 width=32) (actual time=0.02..0.05 rows=11 loops=1)
> >Total runtime: 0.19 msec
> >
> >But be careful abt explain analyzing
> >queries that potentially modify data. (read more on docs of EXPLAIN)
> >we have to put the explain analyze in a transaction block which
> >shud eventually be rollbacked.
> >
> >now that you have seen how to get lines of output from EXPLAIN using/hadling this
> >data is upto you application.
> >
> >also note that the last like of EXPLAIN analyze carries  the runtime.
> >
> >hope it helps
> >Mallah.
> >
> >
> >
> >
> >
> >
> >-----------------------------------------
> >Get your free web based email at trade-india.com.
> >   "India's Leading B2B eMarketplace.!"
> >http://www.trade-india.com/
> >
> >
> >  
> >
> 
> -- 
> Popeanga Marian
> DBA Oracle
> CNLO Romania
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 
> 

-- 
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.