<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Peter,</p>
<p>1) Normally, after clicking "Connect" you will get all layers.
You can select one of them and use "Set filter" to define a filter
before adding it to the map. Sorry for asking, but you are aware
of the "Set filter" button, right?<br>
</p>
<p>2) In your case, it hangs before that. It hangs before listing
all tables. When you click connect, QGIS will fetch some metadata
to fill the list of available tables with the correspondent
geometry type. One of such metadata queries is failing against
your tables.<br>
</p>
<p>Can you enable logging of all Postgresql statements and identify
the query that is hanging QGIS? It would help to identify the
problem.<br>
</p>
<p>Regards,</p>
<p>Jorge Gustavo<br>
</p>
<div class="moz-cite-prefix">Às 23:29 de 05/08/19, Peter Borissow
escreveu:<br>
</div>
<blockquote type="cite"
cite="mid:401304692.1501674.1565044159484@mail.yahoo.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div class="ydp4f1ab867yahoo-style-wrap"
style="font-family:Helvetica Neue, Helvetica, Arial,
sans-serif;font-size:13px;">
<div dir="ltr" data-setdir="false">Hello,</div>
<div dir="ltr" data-setdir="false"> <span><span>I have a
partitioned table in a PostgreSQL/PostGIS database with
~30 billion points. I would like to render a subset of
this data in QGIS and run some analytics. <br>
</span></span></div>
<div dir="ltr" data-setdir="false"><span><span><br>
</span></span></div>
<div dir="ltr" data-setdir="false"><span><span>Normally, with a
smaller dataset, I would simply navigate to the table I
want via the "Browser" and add it to the map via a double
click. Once the data is loaded, I can filter the data, run
analysis, etc. However, in my case, this is impossible. <span>What
I need is an option to filter the data before loading it
into the map.</span><br>
</span></span></div>
<div dir="ltr" data-setdir="false"><span><span><br>
</span></span></div>
<div dir="ltr" data-setdir="false"><span><span>I looked at the
Data Source Manager (<span>Layer -> Add Layer -> Add
PostGIS Layers...) </span><span>but I don't see any
filtering </span>options there and the app <span>hangs
when I hit the "Connect" button.</span><br>
</span></span></div>
<div dir="ltr" data-setdir="false"><span><span><br>
</span></span></div>
<div dir="ltr" data-setdir="false"><span><span>Obviously, I can
create views in the database to circumvent this issue but
I don't want to create dozens of custom views. <br>
</span></span></div>
<div dir="ltr" data-setdir="false"><span><span><br>
</span></span></div>
<div dir="ltr" data-setdir="false"><span><span>Is there another
way to create a layer from PostgreSQL/PostGIS using a
filter-first strategy in QGIS? <br>
</span></span></div>
<div dir="ltr" data-setdir="false"><span><span><br>
</span></span></div>
<div dir="ltr" data-setdir="false"><span><span>Thanks in
advance,</span></span></div>
<div dir="ltr" data-setdir="false"><span><span>Peter<br>
</span></span></div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false"><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<div class="moz-signature">-- <br>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div class="moz-signature">
<meta http-equiv="content-type" content="text/html;
charset=UTF-8">
<div class="moz-signature">
<meta http-equiv="content-type" content="text/html;
charset=UTF-8">
<div class="moz-signature">
<div class="moz-signature">
<div class="moz-signature"><img
src="cid:part1.316FED0B.E65E51EB@geomaster.pt"
alt="Logo" width="50" height="50" align="left"><span
class="im"><b><font size="+2"><font size="-2"> </font>Geomaster,
LDA</font></b></span><br>
<div class="moz-signature">
<div class="moz-signature"> <b><font size="-2"
color="#999999">VENHA DESCOBRIR O CAMINHO DO
OPEN SOURCE CONNOSC</font></b><b><font size="-2"
color="#999999">O<br>
<br>
</font></b>
<meta http-equiv="content-type" content="text/html;
charset=UTF-8">
<title></title>
<div class="moz-signature">
<div class="moz-signature">
<div class="moz-signature">
<div class="moz-signature">
<div class="moz-signature">
<div class="moz-signature">
<table width="450" height="126"
cellspacing="1" cellpadding="2"
border="0">
<tbody>
<tr>
<td width="150" valign="top"
height="50"><font size="-1"><span
class="im"><font size="-2"> </font><br>
Avenida Barros e Soares<br>
N.º 423, 4715-214 Braga<br>
VAT/NIF</span><span
class="im"> 510 906 109<br>
Phone</span><span class="im">
+351 253 680 323<br>
</span>Site <a
href="http://geomaster.pt"
rel="noreferrer"
target="_blank"
data-saferedirecturl="https://www.google.com/url?hl=pt-PT&q=http://geomaster.pt&source=gmail&ust=1532515644545000&usg=AFQjCNEUP4MdlcHYefwCgfNLz4DspDBtXA">geomaster.pt</a><br>
GPS 41.53322, -8.41929</font><br>
<span class="im"></span></td>
<td width="25" valign="top"
align="right"><font size="-1"><span
class="im"></span></font>
<hr width="2" size="100"
align="right"></td>
<td width="150" valign="top"
nowrap="nowrap" height="50"><font
size="-1"><font size="-1"><font
size="-2"> </font><br>
Jorge Gustavo Rocha</font><br>
<font size="-2"
color="#999999">CTO<br>
<br>
</font>Mobile</font><font
size="-1"><span class="im">
+351 910 333 888<br>
Email <a class="moz-txt-link-abbreviated" href="mailto:jgr@geomaster.pt">jgr@geomaster.pt</a></span></font></td>
</tr>
</tbody>
</table>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>