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

alldb option doesn't work because of .psqlrc #207

Open
F-S-T opened this issue Jan 12, 2024 · 1 comment
Open

alldb option doesn't work because of .psqlrc #207

F-S-T opened this issue Jan 12, 2024 · 1 comment

Comments

@F-S-T
Copy link

F-S-T commented Jan 12, 2024

Hi,

When using alldb option in presence of (some) .psqlrc, fetching list of databases failed.

$ ./check_postgres.pl --action relation_size -w 1 -c 100 --perflimit 2 --alldb
POSTGRES_RELATION_SIZE CRITICAL: DB "" largest relation is table "pg_catalog.pg_proc": 784 kB | time=0.02s pg_catalog.pg_proc=802816B;1;100 pg_toast_2618=532480B;1;100

If we remove .psqlrc it works:

$ ./check_postgres.pl --action relation_size -w 1 -c 100 --perflimit 2 --alldb
POSTGRES_RELATION_SIZE CRITICAL: DB "postgres" largest relation is table "pg_catalog.pg_proc": 784 kB DB "repmgr" largest relation is table "pg_catalog.pg_proc": 784 kB DB "template1" largest relation is table "pg_catalog.pg_proc": 784 kB DB "toto" largest relation is table "public.big": 35 MB | time=0.01s pg_catalog.pg_proc=802816B;1;100 pg_toast_2618=532480B;1;100 time=0.03s pg_catalog.pg_proc=802816B;1;100 pg_toast_2618=540672B;1;100 time=0.03s pg_catalog.pg_proc=802816B;1;100 pg_toast_2618=532480B;1;100 time=0.03s public.big=36175872B;1;100 pg_catalog.pg_proc=802816B;1;100

Regards,
FST

@F-S-T
Copy link
Author

F-S-T commented Jan 12, 2024

PR: #208

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

1 participant