[check_postgres] /bin/check_postgres.pl

[osi-nadot.consultant]

Hello,

I use /bin/check_postgres.pl  version 2.25.0.

with option    bloat                 - Check for table and index bloat.


(pglgsd052)-[postgres] dicdb=# \dt+
                                     Liste des relations
  Schéma |         Nom          |        Type        | Propriétaire | 
Taille  | Description
--------+----------------------+--------------------+--------------+---------+-------------
  public | demo_bloat           | table              | postgres     | 0 
bytes |
  public | large_test           | table              | postgres     | 
100 MB  |
  public | pkslow_person_r      | table partitionnée | postgres     | 0 
bytes |
  public | pkslow_person_r1     | table              | postgres     | 16 
kB   |
  public | pkslow_person_r2     | table              | postgres     | 16 
kB   |
  public | pkslow_person_r3     | table              | postgres     | 16 
kB   |
  public | pkslow_person_r4     | table              | postgres     | 16 
kB   |
  public | tbl_itemtransactions | table              | postgres     | 24 
kB   |
  public | test                 | table              | postgres     | 24 
kB   |
  public | test1_bloat          | table              | postgres     | 
346 MB  |
(10 lignes)

(pglgsd052)-[postgres] dicdb=# exit
-(mar. sept. 20 11:01:11)--(pglgsd052:~)-
[postgres] $ */bin/check_postgres.pl  --action=bloat --db=dicdb *
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

why doesn't it show me all the tables ?why doesn't it show my table 
test1_bloat ?

however, if I do :

[postgres] $ */bin/check_postgres.pl  --action=bloat --db=dicdb 
--include=test1_bloat*
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

Thank you for your reply

Best regards.


-- 
Cordialement

Laurent Nadot
consultant socle technique PostgreSQL et Oracle

DGFiP/SI3/DESIGN/OSI
Pièce   :  4352
Poste   : Poste 01 57 33 72 50
balf :bureau.si3-osi at dgfip.finances.gouv.fr
4 av. Montaigne - 93160 Noisy-le-Gd
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/check_postgres/attachments/20220920/aac6e90c/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: osi-nadot_consultant.vcf
Type: text/vcard
Size: 4 bytes
Desc: not available
URL: <https://bucardo.org/pipermail/check_postgres/attachments/20220920/aac6e90c/attachment.vcf>