langgenius/dify-plugin-daemon
1
0
Fork 0
mirror of https://github.com/langgenius/dify-plugin-daemon.git synced 2026-07-21 17:25:23 -04:00
Code Issues 111 Packages Projects Releases 10 Wiki Activity

SLOW SQL #53

New Issue
Open
opened 2026-02-16 00:19:26 -05:00 by yindo · 4 comments
yindo commented 2026-02-16 00:19:26 -05:00
Owner
Copy Link
Copy Source

Originally created by @exitNA on GitHub (Mar 20, 2025).

how to solve the slow sql problem.

2025/03/20 09:39:27 /app/internal/db/pgsql.go:269 SLOW SQL >= 200ms
[224.446ms] [rows:1] SELECT * FROM "ai_model_installations" WHERE tenant_id = '0a3995a9-76e4-436e-a468-74e6db584a9c' LIMIT 256

I ran the same sql in container using psql, is fast, not slow.

Originally created by @exitNA on GitHub (Mar 20, 2025). how to solve the slow sql problem. ``` 2025/03/20 09:39:27 /app/internal/db/pgsql.go:269 SLOW SQL >= 200ms [224.446ms] [rows:1] SELECT * FROM "ai_model_installations" WHERE tenant_id = '0a3995a9-76e4-436e-a468-74e6db584a9c' LIMIT 256 ``` I ran the same sql in container using psql, is fast, not slow.
yindo commented 2026-02-16 00:19:26 -05:00
Author
Owner
Copy Link
Copy Source

@Yeuoly commented on GitHub (Mar 21, 2025):

Which version are you using now? for some elder codes, declaration will be used to store a large JSON, but it should not happen now, or you should check your network

@Yeuoly commented on GitHub (Mar 21, 2025): Which version are you using now? for some elder codes, `declaration` will be used to store a large JSON, but it should not happen now, or you should check your network
yindo commented 2026-02-16 00:19:26 -05:00
Author
Owner
Copy Link
Copy Source

@exitNA commented on GitHub (Mar 22, 2025):

first occurred in v1.0.0, but now I update to v1.1.0, the problem still there.

@exitNA commented on GitHub (Mar 22, 2025): first occurred in v1.0.0, but now I update to v1.1.0, the problem still there.
yindo commented 2026-02-16 00:19:26 -05:00
Author
Owner
Copy Link
Copy Source

@Yeuoly commented on GitHub (Mar 25, 2025):

first occurred in v1.0.0, but now I update to v1.1.0, the problem still there.

Cannot reproduce, pls provide more detailed information of your environment

@Yeuoly commented on GitHub (Mar 25, 2025): > first occurred in v1.0.0, but now I update to v1.1.0, the problem still there. Cannot reproduce, pls provide more detailed information of your environment
yindo commented 2026-02-16 00:19:26 -05:00
Author
Owner
Copy Link
Copy Source

@skCNA commented on GitHub (Aug 6, 2025):

Dify 1.6.0 still has this issue. It happens every day. When executed directly through PostgreSQL, the query usually runs fine, but occasionally it becomes slow.

the daemon is using langgenius/dify-plugin-daemon:0.1.3-local

`2025/08/04 08:50:46 /app/internal/db/executor.go:259 SLOW SQL >= 200ms
[208.312ms] [rows:1] SELECT * FROM "plugin_installations" WHERE tenant_id = '4f4bb5ef-d14c-492b-b2a1-30e105b4d670' AND plugin_id = 'langgenius/zhipuai' ORDER BY "plugin_installations"."id" LIMIT 1
[GIN] 2025/08/04 - 08:50:48 | 200 | 2.077824445s | 172.25.0.6 | POST "/plugin/4f4bb5ef-d14c-492b-b2a1-30e105b4d670/dispatch/llm/invoke"
[GIN] 2025/08/04 - 08:50:48 | 200 | 5.5859ms | 172.25.0.6 | GET "/plugin/4f4bb5ef-d14c-492b-b2a1-30e105b4d670/management/models?page=1&page_size=256"

`

2025/08/05 01:33:15 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 03:29:12 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 03:37:56 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 03:48:36 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 03:54:26 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 04:06:31 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 04:32:06 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 05:09:00 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 05:09:21 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 05:42:40 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 05:47:11 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 05:47:21 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 06:42:41 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 07:01:06 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 07:11:00 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 07:46:31 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 08:04:06 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 08:05:46 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 08:24:56 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 08:45:56 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 08:50:45 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 08:51:24 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 08:59:01 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 09:04:16 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 09:18:50 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 09:31:31 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 10:36:46 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 10:58:51 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 11:18:00 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 11:29:06 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 11:34:11 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 12:04:30 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 12:26:11 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 14:02:10 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 14:22:51 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 14:29:11 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 14:30:51 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 15:00:21 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/06 00:06:11 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 01:33:56 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 01:51:50 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 02:25:41 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 02:45:57 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 02:47:48 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/06 02:55:01 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 02:58:26 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 03:00:08 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 03:07:21 /app/internal/db/executor.go:259 SLOW SQL >= 200ms

Image
@skCNA commented on GitHub (Aug 6, 2025): Dify 1.6.0 still has this issue. It happens every day. When executed directly through PostgreSQL, the query usually runs fine, but occasionally it becomes slow. the daemon is using langgenius/dify-plugin-daemon:0.1.3-local `2025/08/04 08:50:46 /app/internal/db/executor.go:259 SLOW SQL >= 200ms [208.312ms] [rows:1] SELECT * FROM "plugin_installations" WHERE tenant_id = '4f4bb5ef-d14c-492b-b2a1-30e105b4d670' AND plugin_id = 'langgenius/zhipuai' ORDER BY "plugin_installations"."id" LIMIT 1 [GIN] 2025/08/04 - 08:50:48 | 200 | 2.077824445s | 172.25.0.6 | POST "/plugin/4f4bb5ef-d14c-492b-b2a1-30e105b4d670/dispatch/llm/invoke" [GIN] 2025/08/04 - 08:50:48 | 200 | 5.5859ms | 172.25.0.6 | GET "/plugin/4f4bb5ef-d14c-492b-b2a1-30e105b4d670/management/models?page=1&page_size=256" -- ` `2025/08/05 01:33:15 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 03:29:12 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 03:37:56 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 03:48:36 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 03:54:26 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 04:06:31 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 04:32:06 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 05:09:00 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 05:09:21 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 05:42:40 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 05:47:11 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 05:47:21 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 06:42:41 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 07:01:06 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 07:11:00 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 07:46:31 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 08:04:06 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 08:05:46 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 08:24:56 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 08:45:56 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 08:50:45 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 08:51:24 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 08:59:01 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 09:04:16 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 09:18:50 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 09:31:31 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 10:36:46 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 10:58:51 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 11:18:00 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 11:29:06 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 11:34:11 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/05 12:04:30 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 12:26:11 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 14:02:10 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 14:22:51 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 14:29:11 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 14:30:51 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/05 15:00:21 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/06 00:06:11 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 01:33:56 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 01:51:50 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 02:25:41 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 02:45:57 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 02:47:48 /app/internal/db/executor.go:269 SLOW SQL >= 200ms 2025/08/06 02:55:01 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 02:58:26 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 03:00:08 /app/internal/db/executor.go:259 SLOW SQL >= 200ms 2025/08/06 03:07:21 /app/internal/db/executor.go:259 SLOW SQL >= 200ms ` <img width="1131" height="219" alt="Image" src="https://github.com/user-attachments/assets/d8e98f47-1ae6-4a76-a3a3-b4f06a8e51d4" />
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Windows
bug
cmd
documentation
enhancement
go
good first issue
plugin-daemon
pull-request
Mirrored from GitHub Pull Request
 question
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
yindo
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langgenius/dify-plugin-daemon#53
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?