Feature request #8216
When slow, "Add PostGIS Tables" dialog needs to tell me which tables/views are taking too long to process
|Pull Request or Patch supplied:||No||Resolution:|
|Easy fix?:||No||Copied to github as #:||17030|
The Add PostGIS Tables dialog takes far too long to be ready. Part of my problem is that I have several views, so it is apparently having to process each view.
In my case, it is taking over 4 minutes to process.
I had to dig around to figure out which of my several views is too slow. QGIS should give me some clear indicator, if I need it, of slow-loading views.
#1 Updated by Sandro Santilli over 6 years ago
- Operating System changed from Windows 7 x64 to Windows 7 x64 Linux
I've a similar case and found out that dropping the "WHERE <geomcol> IS NOT NULL" portion from the query retriving estimated metadata (those with LIMIT 100 at the end) makes some query time go down from 5 seconds to 0.05 seconds (2 order of magnitude faster!).
Especially when "Use estimated metadata" is checked in the options (Do you have that, Aren?) I think the "not null" condition should be dropped. It helps the estimator finds a much faster path.
#5 Updated by Regis Haubourg 11 months ago
- Status changed from Open to Closed
- Description updated (diff)
Closing, please reopen if necessary. For the record, if checkbox "use geometry columns table" and "use estimated metadata" are not checked, this will actually query the features of each layer to compute unique id, geometrytype and extent... which can be a database killer. Don't forget to use typemod in postgis view to explicitly declare those geometry types and projections. Something like geom::Geometry(Polygon, 2154) for instance..