From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Edgar Delgado <edgdelgado(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Statistics wrong ? Vaccum counts only 2 |
Date: | 2016-02-15 21:25:56 |
Message-ID: | CAECtzeXy1Xut1+KRkcKo6+KivrfhT2kWWhsm09EBjc+3NKyrnQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
2016-02-11 14:29 GMT+01:00 Edgar Delgado <edgdelgado(at)gmail(dot)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>';
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.
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2016-02-15 22:19:28 | Re: Could not open file pg_clog , Please help! |
Previous Message | Guillaume Lelarge | 2016-02-15 21:20:05 | Re: Could not open file pg_clog , Please help! |