Matthew Musgrove <[email protected]> writes:
> 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.
It sounds like requests for stats updates are not getting through to the
collector. I wonder if your kernel is blocking those packets for some
reason (probably ill-considered iptables filters?). There is a test
for packet filtering conducted during postmaster startup, but we don't
repeat it after that.
> Does anyone have any suggestions on how to:
> - see what the statistics collector is doing?
strace? You could at least confirm whether it's receiving anything.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
