4 ms·

So? Just make sure you regularly refresh the statistics...

• sgarland 3y ago
  Ideally yes, but sometimes your tables get so monstrously large that the auto-analyze is sampling thousandths of a percent of rows, and fiddling with sampling targets can throw off seemingly unconnected queries. Planners are mysterious black boxes, which we can at best influence.
  • ako 3y ago
    Yes, a bit like machine learning models.