Feature request #8216

When slow, "Add PostGIS Tables" dialog needs to tell me which tables/views are taking too long to process

Added by Aren Cambre almost 4 years ago. Updated about 3 years ago.

Status:Open Start Date:07/04/2013
Priority:Normal Due date:
Assigned to:- % Done:

0%

Category:PostGIS Data Provider
Target version:Future Release - High Priority
Platform:Windows 7 x64 Linux Resolution:
Platform version: Pull Request or Patch supplied:No
Status info: Tag:

Description

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.

History

Updated by Sandro Santilli over 3 years ago

  • Platform 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.

Updated by Sandro Santilli over 3 years ago

Jurgen committed a fix for the "NOT NULL" condition (thank you!):
https://github.com/qgis/QGIS/commit/4ea85fe50a0e2390917347b7218de13e6c57ed26

Aren: does that help you ?

See also #8730, which may help

Updated by Paolo Cavallini about 3 years ago

  • Target version changed from Version 2.0.0 to Future Release - High Priority

Also available in: Atom