Selectivity

Selectivity is the number of unique values produced by an operation (e.g. an index scan or filter), relative to the total number of rows.

The higher the selectivity, the more likely PostgreSQL is able to use an index.

Source: https://docs.gitlab.com/ee/development/understanding_explain_plans.html#cardinality-and-selectivity

 

Igor Springer

I build web apps. From time to time I put my thoughts on paper. I hope that some of them will be valuable for you. To teach is to learn twice.

 

Leave a Reply

Your email address will not be published. Required fields are marked *