On 07/25/2016 11:50 AM, Matthew Musgrove wrote:
One of our instances has been behaving -- oddly. Most queries are blazing fast. It appears to just be some of the stat views that are slow.
Does anyone have any suggestions on how to: - see what the statistics collector is doing? - tell the postmaster to give the statistics collector the up to date config? - get stats working without restarting the instance? (I am not yet sure when that can happen but it would have to be scheduled [in advance] to occur during an after hours maintenance window.
Anything in the system logs that might help?
Thanks in advance, Matt --
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
