Matthew Musgrove <mmusgrove@xxxxxxxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
