[QGIS-Developer] Project loader profiler Postgres Layers

René-Luc Dhont rldhont at gmail.com
Wed Nov 16 01:06:13 PST 2022


Hi Rémi,

During the provider creation, a lot of SQL requests are made to check a 
lot of thing even if the use estimated metadata is checked :
* Fields list
* geometry type
* primary key
* extent
* capabilities (read, insert, update, delete)

You can take a look at these PRs to have an idea on all the SQL request 
made at the creation :
* https://github.com/qgis/QGIS/pull/49440
* https://github.com/qgis/QGIS/pull/50186

Regards,
René-Luc

Le 16/11/2022 à 09:55, Julien Cabieces via QGIS-Developer a écrit :
> Hi Remi,
>
> Which profiler are you talking about ?
>
> Did you try to use the the new Debugging/Developement tool ? It's new
> since QGIS 3.26 and will give you the list of requests and the time
> spent for each one when loading a project/layer or opening the attribute
> table.
>
> Regards,
> Julien
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20221116/9fad57ff/attachment.htm>


More information about the QGIS-Developer mailing list