diff options
Diffstat (limited to 'pgsql_mib_pieces/pg_index.tbldef')
| -rw-r--r-- | pgsql_mib_pieces/pg_index.tbldef | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/pgsql_mib_pieces/pg_index.tbldef b/pgsql_mib_pieces/pg_index.tbldef new file mode 100644 index 0000000..afda4a5 --- /dev/null +++ b/pgsql_mib_pieces/pg_index.tbldef @@ -0,0 +1,12 @@ +pg_index "The catalog pg_index contains part of the information about indexes. The rest is mostly in pg_class." "Represents a single index" pgsqlCatalogTables 17 "pgsnmpdConnID, rdbmsDbIndex, pgsqlPgIndexIndexrelid" +indexrelid INTEGER "The OID of the pg_class entry for this index" +indrelid INTEGER "The OID of the pg_class entry for the table this index is for" +indnatts INTEGER "The number of columns in the index (duplicates pg_class.relnatts )" +indisunique TruthValue "If true, this is a unique index" +indisprimary TruthValue "If true, this index represents the primary key of the table. ( indisunique should always be true when this is true.)" +indisclustered TruthValue "If true, the table was last clustered on this index" +indisvalid TruthValue "If true, the index is currently valid for queries. False means the index is possibly incomplete: it must still be modified by INSERT / UPDATE operations, but it cannot safely be used for queries. If it is unique, the uniqueness property is not true either" +indkey DisplayString "This is an array of indnatts values that indicate which table columns this index indexes. For example a value of 1 3 would mean that the first and the third table columns make up the index key. A zero in this array indicates that the corresponding index attribute is an expression over the table columns, rather than a simple column reference." +indclass DisplayString "For each column in the index key this contains the OID of the operator class to use. See pg_opclass for details" +indexprs DisplayString "Expression trees (in nodeToString() representation) for index attributes that are not simple column references. This is a list with one element for each zero entry in indkey . NULL if all index attributes are simple references" +indpred DisplayString "Expression tree (in nodeToString() representation) for partial index predicate. NULL if not a partial index" |