Nexpose SQL report queries taking too long / not responding

InsightVM SQL Queries
#1

Hi,
We are experiencing unusual delays in report SQL queries on our Nexpose console. This started happening after the recent 6.6.125 release. Has anyone experienced the same?
Here are the queries we ran…
Query 1: SELECT MAX(solution_id) FROM dim_solution took 8 minutes
Queriy 2: SELECT * FROM dim_solution where solution_id=26543 took 6 minutes

Query 3 & 4: (These two queries responded in a few seconds)
SELECT MAX(vulnerability_id) FROM dim_vulnerability
SELECT * FROM dim_vulnerability where vulnerability_id=16545

Looks like the recent update has affected the dim_solution dimension. Any query using/joining this dimension is taking too long or doesn’t respond at all.

Regards,
Sudhakar

#2

We have the same issue; but with the inbuilt Nexpose reports. The issue started last week. We have seen multiple postgres processes shoot up CPU utilization to 70% - 80% and as a result the entire console slows down. Have you observed similar CPU loads on when running the report SQL queries?

Thanks.

#3

We noticed CPU utilization (4 vCPU server on EC2) increasing to 20-25% and Memory (32 GB) utilization increasing to 60-65% during SQL query execution.

#4

That is interesting, thanks for the share. I’ve opened up a support case but yet to receive a response. I’ll post a reply if I find out anything useful.

#5

Hi, Your issue was solve? I has the same problem with simply report with where condition 1 Asset take time about 14 minutes.

#6

Not resolved. Working with Support to review nsc.log file and figure out what may be wrong.