Very slow GUI on 2.2.2

[Jason]

Since the upgrade to 2.2.2 from 2.0.11 the GUI has been very slow. Some pages take 15 to 20 seconds to load. Also when selecting some hosts from drop down it resets after 30 seconds (when hitting php timeout i guess) and i then have to try again....

No errors in any of the logs i can see. About to enable slow query logging to ser if this shows anything, but has anyone else seen this?

Database is postgresql 9.2 and we use table partitioning.

[Jason]

I've enabled slow query logging and I'm seeing a lot of these in the logs...

slow query: 5.530342 sec, "select clock,ns,value from history_uint where itemid=32952 and clock<=1396940055 and clock>1396335255 order by clock desc,ns desc"
15279:20140409:085424.185 slow query: 3.100979 sec, "select clock,ns,value from history_uint where itemid=32947 and clock<=1396940061 and clock>1396335261 order by clock desc,ns desc"

However, when moving between hosts (for example on latest data) and it's still taking ages, but nothing in the logs.

[Jason]

I've increased memory allocation to postgres and will see how this performs.

[Jason]

Nope, still having problem when moving around in the gui...

If I'm in latest data in GroupA machines and then try and select GroupB machines then the GUI thinks for 10-20 seconds before just returning me to GroupA machines.

It takes a lot of attempts to get it to display another group/machine. This shouldn't be the case.

Also seeing a lot of these in my logs...
3050:20140409:211017.533 slow query: 42.493830 sec, "select clock,ns,value from history_uint where itemid=66415 and clock<=1396984175 and clock>1396379375 order by clock desc,ns desc"
2956:20140409:211115.382 slow query: 13.744450 sec, "select clock,ns,value from history_uint where itemid=66725 and clock<=1396984261 and clock>1396379461 order by clock desc,ns desc"
2955:20140409:211115.382 slow query: 20.125237 sec, "select clock,ns,value from history_uint where itemid=66727 and clock<=1396984255 and clock>1396379455 order by clock desc,ns desc"
2952:20140409:211115.382 slow query: 19.118743 sec, "select clock,ns,value from history_uint where itemid=66728 and clock<=1396984256 and clock>1396379456 order by clock desc,ns desc"
2951:20140409:211115.384 slow query: 19.874276 sec, "select clock,ns,value from history_uint where itemid=66726 and clock<=1396984255 and clock>1396379455 order by clock desc,ns desc"
2954:20140409:211115.385 slow query: 20.357546 sec, "select clock,ns,value from history_uint where itemid=66725 and clock<=1396984255 and clock>1396379455 order by clock desc,ns desc"

Didn't some indexes upgrade correctly moving up to 2.2?

[Jason]

Upgraded to 2.2.3 and now if I try to go to latest data and change the group then it seems to hang and the page never loads.

I've increased the ValueCacheSize to 64M as I'd seen others reported this as an issue, but it hasn't seem to made a difference.

About to try rolling back to 2.2.2 to see if that helps the page at least load.

[pc99096]

https://www.zabbix.com/forum/showthread.php?t=44594