<html><head></head><body><div></div>
<div dir="ltr" data-setdir="false">Also, after successfully adding the layer, if I go to Layers and right click on the layer and select "Update SQL Layer..." the DB Manager dialog pops up but hangs. The offending query seems to be:<br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><span>SELECT * FROM "device_location"</span></div><div dir="ltr" data-setdir="false"><span><br></span></div><div dir="ltr" data-setdir="false"><span><span>Again, I
wound expect the above query to include the filter (where clause) I
defined in the <span><span><span><span><span>Data Source Manager</span></span></span>.</span></span></span><br></span></div><div dir="ltr" data-setdir="false"><span><br></span></div><div dir="ltr" data-setdir="false"><span>Thanks,</span></div><div dir="ltr" data-setdir="false"><span>Peter<br></span></div><div dir="ltr" data-setdir="false"><span></span><br></div><div><br></div>
<div id="ydp9e78fa2yahoo_quoted_6002876791" class="ydp9e78fa2yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Tuesday, August 6, 2019, 7:43:44 AM EDT, Peter Borissow <peter.borissow@yahoo.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div class="ydpd74580b5yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div dir="ltr" data-setdir="false"><div><div dir="ltr" data-setdir="false">OK, after enabling <span> "Use estimated metadata" on the connection, the <span><span><span>Data Source Manager</span></span></span>
comes up (doesn't hang). I am able to select a table and apply a
filter. After a brief delay, QGIS starts to load data. However, is see
an odd query consuming resources in the database</span>:</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><span>SELECT st_extent("coordinate") FROM "public"."device_location"</span></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">The
device_location table is the partitioned table with billions of rows. I
wound expect the above query to include the filter (where clause) I
defined in the <span><span><span><span><span>Data Source Manager</span></span></span>.</span></span><br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">To summarize, I am able to create a filter before loading data thanks to the <span> <span> "Use estimated metadata" </span></span>but I seem to have found a new issue.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Thanks,</div>Peter</div><div><br></div></div><div><br></div>
</div><div id="ydp12e26e74yahoo_quoted_5955704130" class="ydp12e26e74yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Tuesday, August 6, 2019, 3:34:06 AM EDT, Jürgen E. Fischer <jef@norbit.de> wrote:
</div>
<div><br></div>
<div><br></div>
<div>Hi Peter,<br clear="none"><div class="ydp12e26e74yqt5651119402" id="ydp12e26e74yqtfd08988"><br clear="none">On Mon, 05. Aug 2019 at 22:29:19 +0000, Peter Borissow wrote:<br clear="none">> I looked at the Data Source Manager (Layer -> Add Layer -> Add PostGIS<br clear="none">> Layers...) but I don't see any filtering options there and the app hangs when<br clear="none">> I hit the "Connect" button.</div><br clear="none"><br clear="none">Did you enable "Use estimated metadata" on that connection?<br clear="none"><br clear="none"><br clear="none">Jürgen<br clear="none"><br clear="none">-- <br clear="none">Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31<br clear="none">Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50<br clear="none">Software Engineer D-26506 Norden <a shape="rect" href="https://www.norbit.de" rel="nofollow" target="_blank">https://www.norbit.de</a><br clear="none">QGIS release manager (PSC) Germany IRC: jef on FreeNodenorBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH<br clear="none">Rheinstrasse 13, 26506 Norden<br clear="none">GF: Juergen Fischer, Nils Kutscher HR: Amtsgericht Aurich HRB 100827<br clear="none">Datenschutzerklaerung: <a shape="rect" href="https://www.norbit.de/83/" rel="nofollow" target="_blank">https://www.norbit.de/83/</a><div class="ydp12e26e74yqt5651119402" id="ydp12e26e74yqtfd43764"><br clear="none"></div>_______________________________________________<br clear="none">Qgis-user mailing list<br clear="none"><a shape="rect" href="mailto:Qgis-user@lists.osgeo.org" rel="nofollow" target="_blank">Qgis-user@lists.osgeo.org</a><br clear="none">List info: <a shape="rect" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br clear="none">Unsubscribe: <a shape="rect" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
</div>
</div></div>
</div>
</div></body></html>