LOG: duration: xxxxx ms statement: BEGIN;declare "SQL_CUR0x7f48d2fa0750" cursor with hold for SELECT sc.stat_id, d.device_name FROM vpx_stat_counter sc, vpx_device d WHERE sc.entity_id = 12535 and coalesce(sc.device_id,1) = coalesce(d.device_id,1) GROUP BY sc.stat_id, d.device_name ORDER BY sc.stat_id, d.device_name ;fetch 1024 in "SQL_CUR0x7f48d2fa0750"
LOG: duration: xxxxx ms statement: BEGIN;declare "SQL_CUR0x7ffa7dc92bf0" cursor with hold for SELECT EVENT_ID, CHAIN_ID, EVENT_TYPE, EXTENDED_CLASS, CREATE_TIME, USERNAME, CATEGORY, VM_ID, VM_NAME, HOST_ID, HOST_NAME, COMPUTERESOURCE_ID, COMPUTERESOURCE_TYPE, COMPUTERESOURCE_NAME, DATACENTER_ID, DATACENTER_NAME, DATASTORE_ID, DATASTORE_NAME, NETWORK_ID, NETWORK_NAME, NETWORK_TYPE, DVS_ID, DVS_NAME, STORAGEPOD_ID, STORAGEPOD_NAME, CHANGE_TAG_ID FROM VPXV_EVENT_ALL WHERE (EVENT_TYPE IN ('vim.event.VmMigratedEvent','vim.event.VmRelocatedEvent','vim.event.VmBeingRelocatedEvent','vim.event.VmSuspendedEvent')) AND EVENT_ID<ORDER BY EVENT_ID DESC LIMIT 10; ;fetch 1024 in "SQL_CUR0x7ffa7dc92bf0"
# /opt/vmware/vpostgres/current/bin/psql -U postgres VCDB -c "vacuum analyze;"