Discovering the most searched values for a field - Mailing list pgsql-performance

From alexandre - aldeia digital
Subject Discovering the most searched values for a field
Date
Msg-id 4F10733B.3000704@gmail.com
Whole thread Raw
Responses Re: Discovering the most searched values for a field  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Hi,

Is there a simple way (or a tool) to discover the most searched values
in a field from a table ?

In the pg_stats, I can see the most common values generated by ANALYZE,
but I want to know how many queries are using this values. With this
information and the other statistics, I want to create partial indexes
or use table partitioning to create some benchmarks to speed up the
database access.

Best regards.

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: auto vacuum, not working?
Next
From: Josh Berkus
Date:
Subject: Re: Partitioning by status?