search

powa-team / pg_qualstats

A PostgreSQL extension for collecting statistics about predicates, helping find what indices are missing
Other
272 stars 26 forks source link

Detect columns with dependencies and suggest to create extended statistics on it #32

Open sfkeller opened 4 years ago

sfkeller commented 4 years ago

Detect correlated columns (i.e. columns with dependencies) based on slow queries. Then suggest a CREATE STATISTICS with dependencies. See discussion over at https://github.com/ossc-db/pg_plan_advsr/issues/7#issuecomment-637354545 .

rjuju commented 4 years ago

Thanks, as mentioned in the other thread that's already in my todo list, and I expect to work on this shortly!