Qgis 2.18.5 Right click on layer, View Attribute Table does not display progress and cencel button

[qgib]

Author Name: baditaflorin - (baditaflorin -)
Original Redmine Issue: 16859
Affected QGIS version: 2.18.5
Redmine category:data_provider/postgis
Assignee: Jürgen Fischer

---

Use case : I have a Postgis database with million of rows.

I want to see the structure of the database, so i do right click on the layer and click View Attribute Table

I have to wait for over 5 minutes, while Qgis is frozen, to see the iloading dialog, from were i press cancel, because i just want to see some of the rows and the head of the table

In qgis 2.8.3 this happens instantaneous, loading first 10000 rows, then the next 10000 rows.

The query executed in Qgis 2.8.3 is "FETCH FORWARD 2000 FROM qgis_1"

The query that gets executed in Qgis 2.18.5 is "FETCH FORWARD 2000 FROM qgis_1"

So the query looks the same, but in Qgis 2.8.3 the loading is almost instant, and in the latest release of Qgis it can take up to 5 minutes on a larger database before loading the first rows

Step 1 http://i.imgur.com/YxrhvVI.png

Step 2 http://i.imgur.com/6ea2jvB.png

[qgib]

Author Name: baditaflorin - (baditaflorin -)

---

Upgraded to Qgis 2.18.10 and the problem is gone

---

• status_id was changed from Open to Closed

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• resolution was changed from to fixed/implemented