diff options
Diffstat (limited to 'pgsql_mib_pieces/pg_class.mib')
| -rw-r--r-- | pgsql_mib_pieces/pg_class.mib | 275 |
1 files changed, 275 insertions, 0 deletions
diff --git a/pgsql_mib_pieces/pg_class.mib b/pgsql_mib_pieces/pg_class.mib new file mode 100644 index 0000000..bd11b93 --- /dev/null +++ b/pgsql_mib_pieces/pg_class.mib @@ -0,0 +1,275 @@ +pgsqlPgClassTable OBJECT-TYPE + SYNTAX SEQUENCE OF pgsqlPgClassEntry + MAX-ACCESS not-accessible + STATUS current + DESCRIPTION + "The catalog pg_class catalogs tables and most everything else that has columns or is otherwise similar to a table. This includes indexes (but see also pg_index), sequences, views, composite types, and TOAST tables; see relkind. Below, when we mean all of these kinds of objects we speak of 'relations'. Not all columns are meaningful for all relation types." + ::= { pgsqlCatalogTables 11 } + +pgsqlPgClassEntry OBJECT-TYPE + SYNTAX PgsqlPgClassEntry + MAX-ACCESS not-accessible + STATUS current + DESCRIPTION + "pg_class entry" + INDEX { pgsnmpdConnID, rdbmsDbIndex, pgsqlPgClassEntryOID } + ::= { pgsqlPgClassTable 1 } + +PgsqlPgClassEntry ::= + SEQUENCE { + pgsqlPgClassEntryOID INTEGER, + pgsqlPgClassRelname DisplayString, + pgsqlPgClassRelnamespace INTEGER, + pgsqlPgClassReltype INTEGER, + pgsqlPgClassRelowner INTEGER, + pgsqlPgClassRelam INTEGER, + pgsqlPgClassRelfilenode INTEGER, + pgsqlPgClassReltablespace INTEGER, + pgsqlPgClassRelpages INTEGER, + pgsqlPgClassReltuples Float, + pgsqlPgClassReltoastrelid INTEGER, + pgsqlPgClassReltoastidxid INTEGER, + pgsqlPgClassRelhasindex TruthValue, + pgsqlPgClassRelisshared TruthValue, + pgsqlPgClassRelkind DisplayString, + pgsqlPgClassRelnatts INTEGER, + pgsqlPgClassRelchecks INTEGER, + pgsqlPgClassReltriggers INTEGER, + pgsqlPgClassRelukeys INTEGER, + pgsqlPgClassRelfkeys INTEGER, + pgsqlPgClassRelrefs INTEGER, + pgsqlPgClassRelhasoids TruthValue, + pgsqlPgClassRelhaspkey TruthValue, + pgsqlPgClassRelhasrules TruthValue, + pgsqlPgClassRelhassubclass TruthValue, + pgsqlPgClassRelfrozenxid INTEGER, + pgsqlPgClassRelacl DisplayString, + pgsqlPgClassReloptions DisplayString + } + +pgsqlPgClassEntryOID OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS not-accessible + STATUS current + DESCRIPTION + "OID of this entry" + ::= { pgsqlPgClassEntry 1 } + +pgsqlPgClassRelname OBJECT-TYPE + SYNTAX DisplayString + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Name of the table, index, view, etc." + ::= { pgsqlPgClassEntry 2 } + +pgsqlPgClassRelnamespace OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "The OID of the namespace that contains this relation" + ::= { pgsqlPgClassEntry 3 } + +pgsqlPgClassReltype OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "The OID of the data type that corresponds to this table's row type, if any (zero for indexes, which have no pg_type entry)" + ::= { pgsqlPgClassEntry 4 } + +pgsqlPgClassRelowner OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Owner of the relation" + ::= { pgsqlPgClassEntry 5 } + +pgsqlPgClassRelam OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "If this is an index, the access method used (B-tree, hash, etc.)" + ::= { pgsqlPgClassEntry 6 } + +pgsqlPgClassRelfilenode OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Name of the on-disk file of this relation; 0 if none" + ::= { pgsqlPgClassEntry 7 } + +pgsqlPgClassReltablespace OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "The tablespace in which this relation is stored. If zero, the database's default tablespace is implied. (Not meaningful if the relation has no on-disk file.)" + ::= { pgsqlPgClassEntry 8 } + +pgsqlPgClassRelpages OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Size of the on-disk representation of this table in pages (of size BLCKSZ ). This is only an estimate used by the planner. It is updated by VACUUM , ANALYZE , and a few DDL commands such as CREATE INDEX" + ::= { pgsqlPgClassEntry 9 } + +pgsqlPgClassReltuples OBJECT-TYPE + SYNTAX Float + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Number of rows in the table. This is only an estimate used by the planner. It is updated by VACUUM , ANALYZE , and a few DDL commands such as CREATE INDEX" + ::= { pgsqlPgClassEntry 10 } + +pgsqlPgClassReltoastrelid OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "OID of the TOAST table associated with this table, 0 if none. The TOAST table stores large attributes " + ::= { pgsqlPgClassEntry 11 } + +pgsqlPgClassReltoastidxid OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "For a TOAST table, the OID of its index. 0 if not a TOAST table" + ::= { pgsqlPgClassEntry 12 } + +pgsqlPgClassRelhasindex OBJECT-TYPE + SYNTAX TruthValue + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "True if this is a table and it has (or recently had) any indexes. This is set by CREATE INDEX , but not cleared immediately by DROP INDEX . VACUUM clears relhasindex if it finds the table has no indexes" + ::= { pgsqlPgClassEntry 13 } + +pgsqlPgClassRelisshared OBJECT-TYPE + SYNTAX TruthValue + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "True if this table is shared across all databases in the cluster. Only certain system catalogs (such as pg_database ) are shared" + ::= { pgsqlPgClassEntry 14 } + +pgsqlPgClassRelkind OBJECT-TYPE + SYNTAX DisplayString + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "r = ordinary table, i = index, S = sequence, v = view, c = composite type, t = TOAST table" + ::= { pgsqlPgClassEntry 15 } + +pgsqlPgClassRelnatts OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Number of user columns in the relation (system columns not counted). There must be this many corresponding entries in pg_attribute . See also pg_attribute.attnum" + ::= { pgsqlPgClassEntry 16 } + +pgsqlPgClassRelchecks OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Number of check constraints on the table; see pg_constraint catalog" + ::= { pgsqlPgClassEntry 17 } + +pgsqlPgClassReltriggers OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Number of triggers on the table; see pg_trigger catalog" + ::= { pgsqlPgClassEntry 18 } + +pgsqlPgClassRelukeys OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Unused ( not the number of unique keys)" + ::= { pgsqlPgClassEntry 19 } + +pgsqlPgClassRelfkeys OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Unused ( not the number of foreign keys on the table)" + ::= { pgsqlPgClassEntry 20 } + +pgsqlPgClassRelrefs OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Unused" + ::= { pgsqlPgClassEntry 21 } + +pgsqlPgClassRelhasoids OBJECT-TYPE + SYNTAX TruthValue + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "True if we generate an OID for each row of the relation" + ::= { pgsqlPgClassEntry 22 } + +pgsqlPgClassRelhaspkey OBJECT-TYPE + SYNTAX TruthValue + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "True if the table has (or once had) a primary key" + ::= { pgsqlPgClassEntry 23 } + +pgsqlPgClassRelhasrules OBJECT-TYPE + SYNTAX TruthValue + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "True if table has rules; see pg_rewrite catalog" + ::= { pgsqlPgClassEntry 24 } + +pgsqlPgClassRelhassubclass OBJECT-TYPE + SYNTAX TruthValue + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "True if table has (or once had) any inheritance children" + ::= { pgsqlPgClassEntry 25 } + +pgsqlPgClassRelfrozenxid OBJECT-TYPE + SYNTAX INTEGER + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "All transaction IDs before this one have been replaced with a permanent ( " + ::= { pgsqlPgClassEntry 26 } + +pgsqlPgClassRelacl OBJECT-TYPE + SYNTAX DisplayString + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Access privileges; see GRANT and REVOKE for details" + ::= { pgsqlPgClassEntry 27 } + +pgsqlPgClassReloptions OBJECT-TYPE + SYNTAX DisplayString + MAX-ACCESS read-only + STATUS current + DESCRIPTION + "Access-method-specific options, as " + ::= { pgsqlPgClassEntry 28 } + + +--------------------------------------- |