[QGIS-Developer] qgis_editor_widget_styles table, what is it ? How to create it?

[Régis Haubourg]

Hi all,
I'm facing very slow opening of project files for a customer here in QGIS
3.4.5. Something like 7 minutes, against 30 s in QGIS 2.18.

We are still investigating to narrow it down, but I faced a first query in
the logs that I fail to understand.

QGIS emits this at a point:

select count(*)

from information_schema.tables

where table_name = 'qgis_editor_widget_styles' ;

And this query is long in our context, 1.7s, because of a very high number
of tables and schemas in that production DB.

I found at [0] in the postgres provider where it comes from, I found the
associated PR [1], but I fail to understand in what workflow this table is
created using QGIS, and what it is used for.

Can someone put some light here ?

Best regards

Régis

[0]
https://github.com/qgis/QGIS/blob/master/src/providers/postgres/qgspostgresprovider.cpp#L1083
[1] https://github.com/qgis/QGIS/pull/3439
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20190524/133dd79f/attachment.html>