Re: Statistics wrong ? Vaccum counts only 2

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: Whole Thread | Raw Message | 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

In response to

Browse pgsql-admin by date

  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!