[check_postgres] /bin/check_postgres.pl
osi-nadot.consultant
osi-nadot.consultant at dgfip.finances.gouv.fr
Tue Sep 20 09:06:27 UTC 2022
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>
More information about the Check_postgres
mailing list