From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: Popeanga Marian <pmarian@cnlo.ro>
Cc: pgsql-sql@postgresql.org
Subject: Re: explain
Date: Sat, 22 Mar 2003 14:15:02 +0530
Message-ID: <200303221415.02040.mallah@trade-india.com> (raw)
In-Reply-To: <3E7BFE7F.2010500@cnlo.ro>
References: <1114.219.65.253.113.1048264331.squirrel@mail.trade-india.com>
<3E7BFE7F.2010500@cnlo.ro>
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.
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, pmarian@cnlo.ro
Subject: Re: explain
In-Reply-To: <200303221415.02040.mallah@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