Mini_v12

Tables (8)

AlertLogger (ALERT_LOGGER)

  • schema (SCHEMA) — VARCHAR — Primary key — NOT NULL
  • before (BEFORE) — BOOLEAN
  • after (AFTER) — BOOLEAN
  • time (TIME) — TIMESTAMP

InitialInformation (INITIAL_INFORMATION)

  • alias (ALIAS) — VARCHAR — Primary key
  • aliasNum (ALIAS_NUM) — INTEGER
  • address (ADDRESS) — VARCHAR
  • port (PORT) — INTEGER
  • name (NAME) — VARCHAR
  • dbId (DB_ID) — VARCHAR
  • dbPasswd (DB_PASSWD) — VARCHAR
  • liveState (LIVE_STATE) — BOOLEAN

MfoPgSettings1day (MFO_PG_SETTINGS_1DAY)

  • name (NAME) — TEXT
  • setting (SETTING) — TEXT
  • unit (UNIT) — TEXT
  • category (CATEGORY) — TEXT
  • shortDesc (SHORT_DESC) — TEXT
  • extraDesc (EXTRA_DESC) — TEXT
  • context (CONTEXT) — TEXT
  • vartype (VARTYPE) — TEXT
  • source (SOURCE) — TEXT
  • minVal (MIN_VAL) — TEXT
  • maxVal (MAX_VAL) — TEXT
  • enumvals (ENUMVALS) — TEXT
  • bootVal (BOOT_VAL) — TEXT
  • resetVal (RESET_VAL) — TEXT
  • sourcefile (SOURCEFILE) — TEXT
  • sourceline (SOURCELINE) — INTEGER
  • db_id (DB_ID) — INTEGER
  • time (TIME) — TIMESTAMP

MfoPgStatAllTables1hour (MFO_PG_STAT_ALL_TABLES_1HOUR)

  • schemaname (SCHEMANAME) — NAME
  • relname (RELNAME) — NAME
  • totalRelSize (TOTAL_REL_SIZE) — BIGINT
  • reSize (RE_SIZE) — BIGINT
  • tabSize (TAB_SIZE) — BIGINT
  • indSize (IND_SIZE) — BIGINT
  • seqScan (SEQ_SCAN) — BIGINT
  • seqTupRead (SEQ_TUP_READ) — BIGINT
  • idxScan (IDX_SCAN) — BIGINT
  • idxTupFetch (IDX_TUP_FETCH) — BIGINT
  • nTupIns (N_TUP_INS) — BIGINT
  • nTupUpd (N_TUP_UPD) — BIGINT
  • nTupDel (N_TUP_DEL) — BIGINT
  • nTupHotUpd (N_TUP_HOT_UPD) — BIGINT
  • nLiveTup (N_LIVE_TUP) — BIGINT
  • nDeadTup (N_DEAD_TUP) — BIGINT
  • nModSinceAnalyze (N_MOD_SINCE_ANALYZE) — BIGINT
  • lastVacuum (LAST_VACUUM) — TIMESTAMP
  • lastAutovacuum (LAST_AUTOVACUUM) — TIMESTAMP
  • lastAnalyze (LAST_ANALYZE) — TIMESTAMP
  • lastAutoanalyze (LAST_AUTOANALYZE) — TIMESTAMP
  • vacuumCount (VACUUM_COUNT) — BIGINT
  • autovacuumCount (AUTOVACUUM_COUNT) — BIGINT
  • analyzeCount (ANALYZE_COUNT) — BIGINT
  • autoanalyzeCount (AUTOANALYZE_COUNT) — BIGINT
  • db_id (DB_ID) — INTEGER
  • time (TIME) — TIMESTAMP

MfoPgStatDatabase5sec (MFO_PG_STAT_DATABASE_5SEC)

  • numBackends (NUMBACKENDS) — BIGINT
  • xactCommit (XACT_COMMIT) — BIGINT
  • xactRollback (XACT_ROLLBACK) — BIGINT
  • blksRead (BLKS_READ) — BIGINT
  • blksHit (BLKS_HIT) — BIGINT
  • tupReturned (TUP_RETURNED) — BIGINT
  • tupFetched (TUP_FETCHED) — BIGINT
  • tupInserted (TUP_INSERTED) — BIGINT
  • upUpdated (TUP_UPDATED) — BIGINT
  • tupDeleted (TUP_DELETED) — BIGINT
  • conflicts (CONFLICTS) — BIGINT
  • tempFiles (TEMP_FILES) — BIGINT
  • tempBytes (TEMP_BYTES) — BIGINT
  • deadlocks (DEADLOCKS) — BIGINT
  • blkReadTime (BLK_READ_TIME) — DOUBLE PRECISION
  • blkWriteTime (BLK_WRITE_TIME) — DOUBLE PRECISION
  • db_id (DB_ID) — INTEGER
  • time (TIME) — TIMESTAMP

StorageCycle (STORAGE_CYCLE)

  • aliasNum (ALIAS_NUM) — INTEGER — Primary key — NOT NULL
  • tableName (TABLE_NAME) — VARCHAR — Primary key
  • tableCycle (TABLE_CYCLE) — INTEGER

TableSchedule (TABLE_SCHEDULE)

  • aliasNum (ALIAS_NUM) — INTEGER — Primary key — NOT NULL
  • pgStatDatabase5secSec (PG_STAT_DATABASE_5SEC_SEC) — INTEGER

User (USER)

  • id (USER_PK) — SERIAL — Primary key — NOT NULL
  • userId (USER_ID) — VARCHAR
  • password (PASSWD) — VARCHAR
  • userName (USER_NAME) — VARCHAR
  • roleType (ROLE_TYPE) — VARCHAR