<html><head></head><body>Explain also gives approx row counts and other info.<br><br><div class="gmail_quote">On September 4, 2015 9:49:52 AM EDT, Sandro Santilli <strk@keybit.net> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k9mail">On Fri, Sep 04, 2015 at 08:31:39AM -0400, James Keener wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> Sorry for the double email. Also, I wonder how much we could extract<br /> from EXPLAIN SELECT * FROM view; (alternatively EXPLAIN SELECT * FROM<br /> view WHERE field1 = 1;) and if we could tease information out of that.<br /></blockquote><br />Information can be extracted from the result set with a LIMIT 0<br />select, and I believe this is what qgis already does.<br /><br />You can see which tables are being addressed and whether those<br />tables have a primary key, but it ain't easy to determine if<br />those primary keys will appear uniquely in the output.<br /><br />--strk;<br /></pre></blockquote></div><br>
-- <br>
Sent from my Android device with K-9 Mail. Please excuse my brevity.</body></html>