Project

General

Profile

Actions

Bug #2982

closed

Non Admin user Dashboard load is very slow with a large number of mangaged nodes

Added by Chuck Schweizer over 10 years ago. Updated over 5 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

This is on Foreman 1.2.1

A non admin user takes a very long time to load the Dashboard page if they have many nodes. In this instance there were 18,700 nodes returned. The following is the query most/all of the time is spent on. Possibly this should be a join or something more efficient than an IN list.

Report Load (181884.5ms)  SELECT "reports".* FROM "reports" WHERE "reports"."host_id" IN (15632, 1364, 6679, 12390, 7214, 1387, 8102, 10022, 14954, 782, 9807, 16707, 19704, 14674, 9565, 10311, 2396, 638, 8698, 10085, 278, 371, 16729, 586, 642,
<-----cut ------>
12460, 1717, 10215, 10568, 10469, 9631, 5912, 2390, 2434, 11247, 5749, 5275, 15752, 8620, 59, 7299, 7696, 6026, 8782, 11067, 13031, 8884, 18279, 10776, 19298, 19214, 17388, 294, 2033, 3398) AND (status != 0) AND (("reports"."reported_at" >= '2013-08-22')) ORDER BY "reports"."reported_at" DESC NULLS LAST LIMIT 6

Related issues 2 (0 open2 closed)

Related to Foreman - Bug #5841: Foreman dashboard slow in 1.5 for non admin usersClosedDominic Cleal05/20/2014Actions
Blocked by Foreman - Bug #3122: when fact filters are added to a user, error column reference "id" is ambiguous for dashboard and fact_valuesClosed09/19/2013Actions
Actions #1

Updated by Chuck Schweizer over 10 years ago

Confirmed this is still an issue on 1.3

Actions #2

Updated by Dominic Cleal over 10 years ago

  • Category set to Database
Actions #3

Updated by Dominic Cleal over 10 years ago

  • Blocked by Bug #3122: when fact filters are added to a user, error column reference "id" is ambiguous for dashboard and fact_values added
Actions #4

Updated by Dominic Cleal over 10 years ago

  • Status changed from New to Resolved
  • Target version set to 1.15.0
  • % Done changed from 0 to 100
  • translation missing: en.field_release set to 1
  • Assignee set to Anonymous

Happened to be fixed by #3122.

Actions #5

Updated by Dominic Cleal almost 10 years ago

  • Related to Bug #5841: Foreman dashboard slow in 1.5 for non admin users added
Actions

Also available in: Atom PDF