Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

purge_after for statements Not Functioning as Expected for temboard-agent #1550

Open
bsislow opened this issue Feb 21, 2025 · 2 comments
Open

Comments

@bsislow
Copy link

bsislow commented Feb 21, 2025

we are on temboard-agent-8.2.1-1.el8.noarch.

our configuration includes the following in temboard-agent.conf:

[statements]
# DB name hosting pg_stat_statements view (the one where the extension has
# been created with "CREATE EXTENSION")
dbname = postgres
purge_after = 60

we restarted temboard-agent and after several days it is still using a retention of 7 days for statements:

Image

today is the 21st so you can see the 7 days is still being followed, not 60.

please advise; we need to see further into history for pg_stat_statements with trending so we can resolve some prior performance issues.

thanks.

@bersace
Copy link
Member

bersace commented Feb 21, 2025

Hello @bsislow . purge is on UI, not agent. Where did you read to configure retention in agent configuration ? Is this an error un documentation ?

@bsislow
Copy link
Author

bsislow commented Feb 21, 2025

that may be my fault! i read it as a setting agent by agent. i will update temboard.conf on the UI now, restart it, then check back in on this case!

however, i'm making an update to this comment; i do not see statements in temboard.conf - do i just need to add that section?

[temboard]
ssl_cert_file = ************
ssl_key_file = ************
cookie_secret = ************
home = /var/lib/temboard

[repository]
host =
port = ************
user = ************
password = ************
dbname = ************

[logging]
method = file
destination = /var/log/temboard/temboard.log
level = INFO

[monitoring]
purge_after = 30                            <----- this is all i see

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants