Very slow to load pages @1.21.7

[Ai-ZJ]

Description

It's very fast when i visit admin/config page.
But when visit the pull page, load time may be longer than 7000ms

Gitea Version

1.21.7

Can you reproduce the bug on the Gitea demo site?

Yes

Log Gist

No response

Screenshots

2024/03/04 19:50:27 ...s/process/manager.go:231:remove() [T] Done 65e5b583-4: git(dir:/var/lib/gitea/data/gitea-repositories/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff --shortstat 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a...fc14063a434695f92b5ce614e411f3df05f4c489
2024/03/04 19:50:29 ...eb/routing/logger.go:68:func1() [W] router: slow      GET /libs-self-dev/pulls/1 for 36.24.136.57:58283, elapsed 3197.5ms @ repo/issue.go:1329(repo.ViewIssue)
2024/03/04 19:50:29 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse

Git Version

No response

Operating System

No response

How are you running Gitea?

running gitea downloaded as a binary from https://dl.gitea.com/gitea/1.21.7/gitea-1.21.7-darwin-10.12-amd64 as a systemd service under ubuntu

Database

MySQL/MariaDB

[lunny]

How many comments and attachments on this issue?

[Ai-ZJ]

How many comments and attachments on this issue?
How to solve this issue, or it will be solvedd by next version?
Thanks!

[lunny]

We need more details because currently only 1 report for this.

[yp05327]

I have met a similar issue last week in gitea.com, but after several times of refreshing the page, it became a bit faster, so I didn't create an issue about this. 😕

If the changes are very big, this one maybe related: #29164

[Ai-ZJ]

May this help more?

issues

user/settings

/pulls/1 pulls request will be very slow.

2024/03/05 16:40:17 ...s/process/manager.go:188:Add() [T] Start 65e6da71: GET: /test/libs-self-dev/pulls/1 (request)
2024/03/05 16:40:17 ...eb/routing/logger.go:47:func1() [T] router: started   GET /test/libs-self-dev/pulls/1 for 36.27.85.214:0
2024/03/05 16:40:17 ...ices/auth/session.go:50:SessionUser() [T] Session Authorization: Found user[5]
2024/03/05 16:40:17 ...ices/auth/session.go:66:SessionUser() [T] Session Authorization: Logged in user <User 5:steven>
2024/03/05 16:40:17 models/repo/repo.go:352:LoadUnits() [T] repo.Units, ID=7, Types: [TypeCode, TypeIssues, TypePullRequests, TypeReleases, TypeWiki, TypeProjects, TypePackages]
2024/03/05 16:40:17 ...s/repo_permission.go:140:func1() [T] Permission Loaded for <User 5:steven> in <Repository 7:test/libs-self-dev>:
Permissions: {AccessMode:admin Units:[0xc007801a70 0xc007801ad0 0xc007801b60 0xc007801c20 0xc007801c80 0xc007801ce0 0xc007801d40] UnitsMode:map[TypeCode:admin TypeIssues:admin TypePullRequests:admin TypeReleases:admin TypeWiki:admin TypeProjects:admin TypePackages:admin]}
2024/03/05 16:40:18 ...eb/routing/logger.go:102:func1() [I] router: completed GET /user/events for 36.27.85.214:0, 200 OK in 9619.4ms @ events/events.go:18(events.Events)
2024/03/05 16:40:18 ...s/process/manager.go:231:remove() [T] Done 65e6da68-2: GET: /user/events
2024/03/05 16:40:18 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse
2024/03/05 16:40:18 ...s/process/manager.go:188:Add() [T] Start 65e6da72: /usr/bin/git rev-parse [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (from 65e6da71) (normal)
2024/03/05 16:40:18 ...s/process/manager.go:231:remove() [T] Done 65e6da72: /usr/bin/git rev-parse [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git]
2024/03/05 16:40:18 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch
2024/03/05 16:40:18 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check
2024/03/05 16:40:18 ...s/process/manager.go:188:Add() [T] Start 65e6da72-3: /usr/bin/git cat-file --batch-check [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631) (from 65e6da71) (normal)
2024/03/05 16:40:18 ...s/process/manager.go:188:Add() [T] Start 65e6da72-2: /usr/bin/git cat-file --batch [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631) (from 65e6da71) (normal)
2024/03/05 16:40:18 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff --shortstat 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a...fc14063a434695f92b5ce614e411f3df05f4c489
2024/03/05 16:40:18 ...s/process/manager.go:188:Add() [T] Start 65e6da72-4: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff --shortstat 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a...fc14063a434695f92b5ce614e411f3df05f4c489 (from 65e6da71) (normal)
2024/03/05 16:40:18 ...s/process/manager.go:231:remove() [T] Done 65e6da72-4: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff --shortstat 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a...fc14063a434695f92b5ce614e411f3df05f4c489
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74: /usr/bin/git rev-parse [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74: /usr/bin/git rev-parse [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git]
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-2: /usr/bin/git cat-file --batch-check [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (routers/web/repo/pull.go:569) (from 65e6da71) (normal)
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-3: /usr/bin/git cat-file --batch [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (routers/web/repo/pull.go:569) (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/repo_permission.go:140:func1() [T] Permission Loaded for <User 5:steven> in <Repository 7:test/libs-self-dev>:
Permissions: {AccessMode:admin Units:[0xc007801a70 0xc007801ad0 0xc007801b60 0xc007801c20 0xc007801c80 0xc007801ce0 0xc007801d40] UnitsMode:map[TypeCode:admin TypeIssues:admin TypePullRequests:admin TypeReleases:admin TypeWiki:admin TypeProjects:admin TypePackages:admin]}
2024/03/05 16:40:20 ...eb/routing/logger.go:68:func1() [W] router: slow      GET /test/libs-self-dev/pulls/1 for 36.27.85.214:0, elapsed 3101.1ms @ repo/issue.go:1329(repo.ViewIssue)
2024/03/05 16:40:20 ...s/repo_permission.go:140:func1() [T] Permission Loaded for <User 5:steven> in <Repository 7:test/libs-self-dev>:
Permissions: {AccessMode:admin Units:[0xc007801a70 0xc007801ad0 0xc007801b60 0xc007801c20 0xc007801c80 0xc007801ce0 0xc007801d40] UnitsMode:map[TypeCode:admin TypeIssues:admin TypePullRequests:admin TypeReleases:admin TypeWiki:admin TypeProjects:admin TypePackages:admin]}
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-list --max-count 50 --skip 0 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a..fc14063a434695f92b5ce614e411f3df05f4c489
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-4: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-list --max-count 50 --skip 0 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a..fc14063a434695f92b5ce614e411f3df05f4c489 (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-4: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-list --max-count 50 --skip 0 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a..fc14063a434695f92b5ce614e411f3df05f4c489
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse refs/pull/1/head
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-5: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse refs/pull/1/head (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-5: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse refs/pull/1/head
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= merge-base -- refs/heads/main refs/pull/1/head
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-6: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= merge-base -- refs/heads/main refs/pull/1/head (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-6: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= merge-base -- refs/heads/main refs/pull/1/head
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse refs/heads/main
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-7: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse refs/heads/main (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-7: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse refs/heads/main
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --pretty=format:%H 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a...refs/pull/1/head --
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-8: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --pretty=format:%H 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a...refs/pull/1/head -- (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-8: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= log --pretty=format:%H 43258f1f35c85176b5b74a36f315c2bd1cc8ec1a...refs/pull/1/head --
2024/03/05 16:40:20 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff -z --name-only refs/heads/main...refs/pull/1/head --
2024/03/05 16:40:20 ...s/process/manager.go:188:Add() [T] Start 65e6da74-9: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff -z --name-only refs/heads/main...refs/pull/1/head -- (from 65e6da71) (normal)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-9: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= diff -z --name-only refs/heads/main...refs/pull/1/head --
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-3: /usr/bin/git cat-file --batch [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (routers/web/repo/pull.go:569)
2024/03/05 16:40:20 ...s/process/manager.go:231:remove() [T] Done 65e6da74-2: /usr/bin/git cat-file --batch-check [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (routers/web/repo/pull.go:569)
2024/03/05 16:40:23 ...s/repo_permission.go:140:func1() [T] Permission Loaded for <User 5:steven> in <Repository 7:test/libs-self-dev>:
Permissions: {AccessMode:admin Units:[0xc007801ce0 0xc007801d40 0xc007801a70 0xc007801ad0 0xc007801b60 0xc007801c20 0xc007801c80] UnitsMode:map[TypeCode:admin TypeIssues:admin TypePullRequests:admin TypeReleases:admin TypeWiki:admin TypeProjects:admin TypePackages:admin]}
2024/03/05 16:40:23 ...s/repo_permission.go:140:func1() [T] Permission Loaded for <User 5:steven> in <Repository 7:test/libs-self-dev>:
Permissions: {AccessMode:admin Units:[0xc007801b60 0xc007801c20 0xc007801c80 0xc007801ce0 0xc007801d40 0xc007801a70 0xc007801ad0] UnitsMode:map[TypeCode:admin TypeIssues:admin TypePullRequests:admin TypeReleases:admin TypeWiki:admin TypeProjects:admin TypePackages:admin]}
2024/03/05 16:40:24 ...s/repo_permission.go:140:func1() [T] Permission Loaded for <User 5:steven> in <Repository 7:test/libs-self-dev>:
Permissions: {AccessMode:admin Units:[0xc007801ad0 0xc007801b60 0xc007801c20 0xc007801c80 0xc007801ce0 0xc007801d40 0xc007801a70] UnitsMode:map[TypeCode:admin TypeIssues:admin TypePullRequests:admin TypeReleases:admin TypeWiki:admin TypeProjects:admin TypePackages:admin]}
2024/03/05 16:40:24 ...ource/manager_run.go:46:Run() [T] Event source has no listeners
2024/03/05 16:40:24 ...ource/manager_run.go:56:Run() [T] Pausing the eventsource
2024/03/05 16:40:24 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= config --get commit.gpgsign
2024/03/05 16:40:24 ...s/process/manager.go:188:Add() [T] Start 65e6da78: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= config --get commit.gpgsign (from 65e6da71) (normal)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da78: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= config --get commit.gpgsign
2024/03/05 16:40:24 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= show-ref --verify -- refs/heads/dev
2024/03/05 16:40:24 ...s/process/manager.go:188:Add() [T] Start 65e6da78-2: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= show-ref --verify -- refs/heads/dev (from 65e6da71) (normal)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da78-2: git(dir:/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= show-ref --verify -- refs/heads/dev
2024/03/05 16:40:24 .../context_response.go:68:HTML() [D] Template: repo/issue/view
2024/03/05 16:40:24 ...dules/git/command.go:344:Run() [D] slow git.Command.Run: /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch (6.402329802s)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da72-2: /usr/bin/git cat-file --batch [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631)
2024/03/05 16:40:24 ...dules/git/command.go:344:Run() [D] slow git.Command.Run: /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check (6.402561066s)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da72-3: /usr/bin/git cat-file --batch-check [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631)
2024/03/05 16:40:24 ...eb/routing/logger.go:102:func1() [I] router: completed GET /test/libs-self-dev/pulls/1 for 36.27.85.214:0, 200 OK in 7420.0ms @ repo/issue.go:1329(repo.ViewIssue)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da71: GET: /test/libs-self-dev/pulls/1
2024/03/05 16:40:25 ...s/process/manager.go:188:Add() [T] Start 65e6da79: GET: /test/libs-self-dev/issues/1/content-history/overview?_csrf=fLhQZbkHaYRFdqWcZ_oPBSSaseQ6MTcwOTYyNzQ4MzgyNjUzNzk0OA (request)
2024/03/05 16:40:25 ...eb/routing/logger.go:47:func1() [T] router: started   GET /test/libs-self-dev/issues/1/content-history/overview?_csrf=fLhQZbkHaYRFdqWcZ_oPBSSaseQ6MTcwOTYyNzQ4MzgyNjUzNzk0OA for 36.27.85.214:0
2024/03/05 16:40:25 ...ices/auth/session.go:50:SessionUser() [T] Session Authorization: Found user[5]
2024/03/05 16:40:25 ...ices/auth/session.go:66:SessionUser() [T] Session Authorization: Logged in user <User 5:steven>
2024/03/05 16:40:25 ...s/process/manager.go:188:Add() [T] Start 65e6da79-2: GET: /user/events (request)
2024/03/05 16:40:25 ...eb/routing/logger.go:47:func1() [T] router: started   GET /user/events for 36.27.85.214:0
2024/03/05 16:40:25 ...ices/auth/session.go:50:SessionUser() [T] Session Authorization: Found user[5]
2024/03/05 16:40:25 ...ices/auth/session.go:66:SessionUser() [T] Session Authorization: Logged in user <User 5:steven>
2024/03/05 16:40:25 models/repo/repo.go:352:LoadUnits() [T] repo.Units, ID=7, Types: [TypeCode, TypeIssues, TypePullRequests, TypeReleases, TypeWiki, TypeProjects, TypePackages]
2024/03/05 16:40:25 ...ource/manager_run.go:61:Run() [T] Connection detected - restarting the eventsource
2024/03/05 16:40:25 ...s/repo_permission.go:140:func1() [T] Permission Loaded for <User 5:steven> in <Repository 7:test/libs-self-dev>:
Permissions: {AccessMode:admin Units:[0xc0044eb380 0xc0044ec720 0xc0044ecc30 0xc0044ecf60 0xc0044ed140 0xc0044ed9e0 0xc0044edd70] UnitsMode:map[TypeCode:admin TypeIssues:admin TypePullRequests:admin TypeReleases:admin TypeWiki:admin TypeProjects:admin TypePackages:admin]}
2024/03/05 16:40:26 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= rev-parse
2024/03/05 16:40:26 ...s/process/manager.go:188:Add() [T] Start 65e6da7a: /usr/bin/git rev-parse [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (from 65e6da79) (normal)
2024/03/05 16:40:26 ...s/process/manager.go:231:remove() [T] Done 65e6da7a: /usr/bin/git rev-parse [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git]
2024/03/05 16:40:26 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch
2024/03/05 16:40:26 ...dules/git/command.go:290:Run() [D] git.Command.RunDir(/var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git): /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check
2024/03/05 16:40:26 ...s/process/manager.go:188:Add() [T] Start 65e6da7a-3: /usr/bin/git cat-file --batch-check [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631) (from 65e6da79) (normal)
2024/03/05 16:40:26 ...s/process/manager.go:188:Add() [T] Start 65e6da7a-2: /usr/bin/git cat-file --batch [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631) (from 65e6da79) (normal)
2024/03/05 16:40:27 ...dules/git/command.go:344:Run() [D] slow git.Command.Run: /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch (1.233275091s)
2024/03/05 16:40:27 ...s/process/manager.go:231:remove() [T] Done 65e6da7a-2: /usr/bin/git cat-file --batch [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631)
2024/03/05 16:40:27 ...dules/git/command.go:344:Run() [D] slow git.Command.Run: /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check (1.233502703s)
2024/03/05 16:40:27 ...s/process/manager.go:231:remove() [T] Done 65e6da7a-3: /usr/bin/git cat-file --batch-check [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631)
2024/03/05 16:40:27 ...eb/routing/logger.go:102:func1() [I] router: completed GET /test/libs-self-dev/issues/1/content-history/overview?_csrf=fLhQZbkHaYRFdqWcZ_oPBSSaseQ6MTcwOTYyNzQ4MzgyNjUzNzk0OA for 36.27.85.214:0, 200 OK in 2239.0ms @ repo/issue_content_history.go:24(repo.GetContentHistoryOverview)
2024/03/05 16:40:27 ...s/process/manager.go:231:remove() [T] Done 65e6da79: GET: /test/libs-self-dev/issues/1/content-history/overview?_csrf=fLhQZbkHaYRFdqWcZ_oPBSSaseQ6MTcwOTYyNzQ4MzgyNjUzNzk0OA
2024/03/05 16:40:28 ...eb/routing/logger.go:68:func1() [I] router: polling   GET /user/events for 36.27.85.214:0, elapsed 3208.3ms @ events/events.go:18(events.Events)

[yp05327]

2024/03/05 16:40:24 ...dules/git/command.go:344:Run() [D] slow git.Command.Run: /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch (6.402329802s)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da72-2: /usr/bin/git cat-file --batch [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631)
2024/03/05 16:40:24 ...dules/git/command.go:344:Run() [D] slow git.Command.Run: /usr/bin/git -c credential.helper= -c filter.lfs.required= -c filter.lfs.smudge= -c filter.lfs.clean= cat-file --batch-check (6.402561066s)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da72-3: /usr/bin/git cat-file --batch-check [repo_path: /var/lib/gitea/data/gitea-repositories/test/libs-self-dev.git] (modules/context/repo.go:631)
2024/03/05 16:40:24 ...eb/routing/logger.go:102:func1() [I] router: completed GET /test/libs-self-dev/pulls/1 for 36.27.85.214:0, 200 OK in 7420.0ms @ repo/issue.go:1329(repo.ViewIssue)
2024/03/05 16:40:24 ...s/process/manager.go:231:remove() [T] Done 65e6da71: GET: /test/libs-self-dev/pulls/1

maybe related

[yp05327]

https://gitea.com/gitea/act/pulls/84

[yp05327]

I think this is not related to #29164 as diff page is very fast, it will also display the diff-stats.
Maybe it is caused by DB query.