Changes between Initial Version and Version 1 of Ticket #5337, comment 3


Ignore:
Timestamp:
02/13/23 23:01:48 (21 months ago)
Author:
Björn Harrtell

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #5337, comment 3

    initial v1  
    1 Also tried _postgis_selectivity with the same bbox as mentioned in description which is POLYGON ((716905.5 6168346.1, 716905.5 6185703.38, 741648.19 6185703.38, 741648.19 6168346.1, 716905.5 6168346.1)) and I get 0.055185432031709364. Assuming that means 5.5% of 28 million that seems to be a good estimate, it doesn't make sense to me why the row estimate is 2819 rows (->  Bitmap Heap Scan on geodkobjekt g  (cost=68.27..5625.92 rows=2819 width=472)).
     1Also tried _postgis_selectivity with the same bbox as mentioned in description which is {{{POLYGON ((716905.5 6168346.1, 716905.5 6185703.38, 741648.19 6185703.38, 741648.19 6168346.1, 716905.5 6168346.1))}}} and I get 0.055185432031709364. Assuming that means 5.5% of 28 million that seems to be a good estimate, it doesn't make sense to me why the row estimate is 2819 rows (->  Bitmap Heap Scan on geodkobjekt g  (cost=68.27..5625.92 rows=2819 width=472)).