search

qgis / QGIS

QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS)
https://qgis.org
GNU General Public License v2.0
10.03k stars 2.92k forks source link

DB Manager shows 0.000s execution time for queries on Virtual Layers #30512

Open kannes opened 5 years ago

kannes commented 5 years ago

Describe the bug DB Manager on Virtual Layers does not display real execution time. It is always "0.000 seconds", regardless how long the query ran.

How to Reproduce

  1. Load a vector file
  2. Open a DB Manager Query tab for it
  3. Run a query that takes a while, e.g. something like SELECT ST_Union(ST_Buffer(geometry, 10)) FROM yourlayer
  4. Wait until your query finishes, it should be one that takes a while to make sure the described problem is obvious
  5. Look at the displayed execution time, it is "0.000 seconds"

QGIS and OS versions

QGIS version | 3.6.3-Noosa

gioman commented 5 years ago

@kannes same on 3.8 (3.6 is "old")?

kannes commented 5 years ago

I don't know and I currently can not test. I saw nothing related in the issues or commits so I strongly assume so.

kannes commented 5 years ago

Yes, same 0.000 in QGIS 3.8.0-Zanzibar

kgjenkins commented 4 years ago

Same issue with 3.14.0 as well

Pedro-Murteira commented 2 years ago

This issue is still valid on QGIS 3.16.15 and 3.22.2.