Re: explain
От | Rajesh Kumar Mallah |
---|---|
Тема | Re: explain |
Дата | |
Msg-id | 200303221415.02040.mallah@trade-india.com обсуждение исходный текст |
Ответ на | Re: explain (Popeanga Marian <pmarian@cnlo.ro>) |
Список | pgsql-sql |
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.
В списке pgsql-sql по дате отправления: