Project

General

Profile

Actions

Bug #30053

closed

Audit page render very slow when organization is set

Added by Hao Yu over 4 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Audit Log
Target version:
-
Difficulty:
Triaged:
No
Fixed in Releases:
Found in Releases:

Description

Description of problem:
Audit page render very slow when organization is set even only 20 records per page.

2020-06-08T07:24:11 [I|app|6ec3a037] Started GET "/audits?page=1&per_page=20&search=" for 10.64.54.43 at 2020-06-08 07:24:11 +0000
2020-06-08T07:24:11 [I|app|6ec3a037] Processing by AuditsController#index as JSON
2020-06-08T07:24:11 [I|app|6ec3a037] Parameters: {"page"=>"1", "per_page"=>"20", "search"=>""}
2020-06-08T07:24:43 [I|app|6ec3a037] Completed 200 OK in 32188ms (Views: 30.9ms | ActiveRecord: 30341.6ms) <======== Took 32 seconds to load

  1. select count(*) from audits;
    count
    -------
    76620
    (1 row)
  1. select count(*) from taxable_taxonomies where taxable_type = 'Audited::Audit';
    count
    --------
    125586

Related issues 1 (0 open1 closed)

Related to Foreman - Refactor #32029: Add test coverage for Audit permissionsClosedOndřej EzrActions
Actions

Also available in: Atom PDF