Statistics wrong ? Vaccum counts only 2
Statistics wrong ? Vaccum counts only 2
Hi guys!
I run a manual vacuum every Sunday on my database and have autovacuum on, but in pgadmin statistics show only 2 full and 26 auto. Where is the catch?
Thx.
Best regards,
Edgar
Re: Statistics wrong ? Vaccum counts only 2
От:
Guillaume Lelarge <guillaume@lelarge.info>
Дата:
2016-02-11 14:29 GMT+01:00 Edgar Delgado <edgdelgado@gmail.com>:
Hi guys!I run a manual vacuum every Sunday on my database and have autovacuum on, but in pgadmin statistics show only 2 full and 26 auto. Where is the catch?
Run this SQL query:
select vacuum_count,autovacuum_count from pg_stat_user_tables where schemaname='<schema name>' and relname='<table name>';
select vacuum_count,autovacuum_count from pg_stat_user_tables where schemaname='<schema name>' and relname='<table name>';
Replace <schema name> and <table name> with the right names, and run the SQL query. The result will tell us if the issue is with pgAdmin.
--