[QGIS-Developer] Project loader profiler Postgres Layers

[Rémi Desgrange]

@Julien sorry for not being clear, I used the Debugging/Developement tool 😊

@René-Luc Thanks I’ll look into it.

From: QGIS-Developer <qgis-developer-bounces at lists.osgeo.org> on behalf of René-Luc Dhont via QGIS-Developer <qgis-developer at lists.osgeo.org>
Date: Wednesday, 16 November 2022 at 10:06
To: qgis-developer at lists.osgeo.org <qgis-developer at lists.osgeo.org>
Subject: Re: [QGIS-Developer] Project loader profiler Postgres Layers
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/967d3d14/attachment.htm>