<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello,</p>
<p><span class="VIiyi" lang="en"><span class="JLqJ4b ChMk0b"><span
class="Q4iAWc">I use </span></span></span>
/bin/check_postgres.pl version 2.25.0.<br>
</p>
<p>with option bloat - Check for table and index
bloat.</p>
<p><font size="1" face="Courier New, Courier, monospace"><br>
</font></p>
<p><font size="1" face="Courier New, Courier, monospace">(pglgsd052)-[postgres]
dicdb=# \dt+<br>
Liste des relations<br>
Schéma | Nom | Type |
Propriétaire | Taille | Description <br>
--------+----------------------+--------------------+--------------+---------+-------------<br>
public | demo_bloat | table |
postgres | 0 bytes | <br>
public | large_test | table |
postgres | 100 MB | <br>
public | pkslow_person_r | table partitionnée |
postgres | 0 bytes | <br>
public | pkslow_person_r1 | table |
postgres | 16 kB | <br>
public | pkslow_person_r2 | table |
postgres | 16 kB | <br>
public | pkslow_person_r3 | table |
postgres | 16 kB | <br>
public | pkslow_person_r4 | table |
postgres | 16 kB | <br>
public | tbl_itemtransactions | table |
postgres | 24 kB | <br>
public | test | table |
postgres | 24 kB | <br>
public | test1_bloat | table |
postgres | 346 MB | <br>
(10 lignes)<br>
<br>
(pglgsd052)-[postgres] dicdb=# exit<br>
-(mar. sept. 20 11:01:11)--(pglgsd052:~)-<br>
[postgres] $ <b>/bin/check_postgres.pl --action=bloat
--db=dicdb </b><br>
POSTGRES_BLOAT OK: DB "dicdb" (db dicdb) index test_x_idx
lignes:? pages:2745 devrait être:0 (0.0X) octets perdus:22487040
(21 MB) | test_x_idx=22487040B public.large_test=98304B
pg_depend_reference_index=81920B pg_catalog.pg_class=8192B
pg_catalog.pg_depend=8192B pg_catalog.pg_description=8192B
pg_catalog.pg_operator=8192B pg_catalog.pg_rewrite=8192B
pg_class_oid_index=0B pg_class_relname_nsp_index=0B
pg_depend_depender_index=0B pg_description_o_c_o_index=0B
pg_operator_oid_index=0B pg_operator_oprname_l_r_n_index=0B
pg_rewrite_rel_rulename_index=0B public.test=0B <br>
</font><span class="VIiyi" lang="en"><span class="JLqJ4b ChMk0b"><span
class="Q4iAWc"><br>
</span></span></span></p>
<p><span class="VIiyi" lang="en"><span class="JLqJ4b ChMk0b"><span
class="Q4iAWc">why doesn't it show me all the tables ?</span></span></span><span
class="VIiyi" lang="en"><span class="JLqJ4b ChMk0b"><span
class="Q4iAWc"> why doesn't it show my table test1_bloat ?</span></span></span><span
class="VIiyi" lang="en"><span class="JLqJ4b ChMk0b"><span
class="Q4iAWc"></span></span></span></p>
<p><span class="VIiyi" lang="en"><span class="JLqJ4b ChMk0b"><span
class="Q4iAWc">however, if I do :<br>
</span></span></span></p>
<p><font size="2" face="Courier New, Courier, monospace">[postgres]
$ <b>/bin/check_postgres.pl --action=bloat --db=dicdb
--include=test1_bloat</b><br>
POSTGRES_BLOAT OK: DB "dicdb" (db dicdb) index test1_bloat_i_idx
lignes:? pages:1 devrait être:0 (0.0X) octets perdus:8192 (8192
bytes) | test1_bloat_i_idx=8192B public.test1_bloat=0B</font><br>
</p>
<p><span class="VIiyi" lang="en"><span class="JLqJ4b ChMk0b"><span
class="Q4iAWc">Thank you for your reply</span></span></span></p>
<p><span class="VIiyi" lang="en"><span class="JLqJ4b ChMk0b"><span
class="Q4iAWc">Best regards.<br>
</span></span></span></p>
<p><span class="VIiyi" lang="en"><span class="JLqJ4b ChMk0b"><span
class="Q4iAWc"><br>
</span></span></span></p>
<pre class="moz-signature" cols="72">--
Cordialement
Laurent Nadot
consultant socle technique PostgreSQL et Oracle
DGFiP/SI3/DESIGN/OSI
Pièce : 4352
Poste : Poste 01 57 33 72 50
balf : <a class="moz-txt-link-abbreviated" href="mailto:bureau.si3-osi@dgfip.finances.gouv.fr">bureau.si3-osi@dgfip.finances.gouv.fr</a>
4 av. Montaigne - 93160 Noisy-le-Gd</pre>
</body>
</html>