Projet

Général

Profil

Révision f1952dc3

IDf1952dc3b06b8299758d058bedff829c3f32685d
Parent 8de0f083
Enfant a7c9b435

Ajouté par Clemens Schwaighofer il y a plus de 13 ans

postgres size detail

Added "other" in case this data exists.

Voir les différences:

plugins/postgresql/postgres_size_detail_
69 69 
	SUM(relpages::bigint * 8 * 1024) AS size
70 70 
	FROM pg_class pg, pg_namespace pgn WHERE pg.relnamespace = pgn.oid AND pgn.nspname NOT IN ('information_schema', 'pg_catalog') GROUP BY state",
71 71 
    configquery    => [
72 
        "VALUES ('db_detail_data','Data size'),('db_detail_index','Index size'),('db_detail_sequence','Sequence size'),('db_detail_view','View size')",
72 
        "VALUES ('db_detail_data','Data size'),('db_detail_index','Index size'),('db_detail_sequence','Sequence size'),('db_detail_view','View size'),('db_detail_other','Other size')",
73 73 
    ],
74 74 
    suggestquery =>
75 75 
        "SELECT datname FROM pg_database WHERE datallowconn AND NOT datistemplate AND NOT datname='postgres' UNION ALL SELECT 'ALL' ORDER BY 1 LIMIT 10",

Formats disponibles : Unified diff