SQL: Outlier query information gathering #784
Labels
No labels
approved, awaiting change
bug
configuration
documentation
duplicate
enhancement
extremely low priority
feature request
Fix it yourself
help wanted
invalid
mastodon_api
needs docs
needs tests
not a bug
planned
pleroma_api
privacy
question
static_fe
triage
wontfix
No milestone
No project
No assignees
4 participants
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference: AkkomaGang/akkoma#784
Loading…
Reference in a new issue
No description provided.
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?
If you see this issue, go to
/phoenix/live_dashboard/ecto_stats?nav=outliers
and copy the outlier data here for query analysis to see if we can improve query design in any common places
template table
Mine:
Worth noting that the
pg_stat_statements
extension required for this data isn't enabled by default in Postgres.To enable the extension, modify
postgresql.conf
with the following settings:Then restart Postgres. Next connect to the akkoma database with psql and run
Steps copied from here.
Hi, here are mine. I actived the PG extenstion 9 hours ago to let it collect some stats.
Ill can post a update in a few days again, if you want.
Here's mine after about 12 hours (deleted the original since it wasn't run for long enough):
worth noting the top offender by far for ihba and akko is the query of the attachment cleanup worker; also see #765 for this one
@YokaiRick since it doesn’t show up at all on your instance, can you confirm whether
:instance, :cleanup_attachments
is set to false (the default)?@Oneric nope, i didn't deactivate it: here is my instance part:
and i grepped for the default stuff also:
i have a single user instance and tbh i can't remember when it was the last time i did delete a post.. maybe thats why?
Yeah, if you didn’t set it at all it defaults to
false
; but never deleting posts would amount to the same effect; thanks!