[Qgis-user] Adding PostGIS Layer (Query Before Load)

[Peter Borissow]

 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:

SELECT * FROM "device_location"
Again, I wound expect the above query to include the filter (where clause) I defined in the Data Source Manager.

Thanks,Peter


    On Tuesday, August 6, 2019, 7:43:44 AM EDT, Peter Borissow <peter.borissow at yahoo.com> wrote:  
 
  OK, after enabling  "Use estimated metadata" on the connection, the Data Source Manager 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:
SELECT st_extent("coordinate") FROM "public"."device_location"
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 Data Source Manager.

To summarize, I am able to create a filter before loading data thanks to the   "Use estimated metadata" but I seem to have found a new issue.
Thanks,Peter

    On Tuesday, August 6, 2019, 3:34:06 AM EDT, Jürgen E. Fischer <jef at norbit.de> wrote:  
 
 Hi Peter,

On Mon, 05. Aug 2019 at 22:29:19 +0000, Peter Borissow wrote:
> I looked at the Data Source Manager (Layer -> Add Layer -> Add PostGIS
> Layers...) but I don't see any filtering options there and the app hangs when
> I hit the "Connect" button.

Did you enable "Use estimated metadata" on that connection?


Jürgen

-- 
Jürgen E. Fischer          norBIT GmbH            Tel. +49-4931-918175-31
Dipl.-Inf. (FH)            Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer          D-26506 Norden            https://www.norbit.de
QGIS release manager (PSC)  Germany                    IRC: jef on FreeNodenorBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Juergen Fischer, Nils Kutscher HR: Amtsgericht Aurich HRB 100827
Datenschutzerklaerung: https://www.norbit.de/83/
_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user    
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190806/746dde70/attachment.html>