mini

테이블 (8)

DB정보 (XM_DB)

  • Key (no) — INT4 — 기본 키 — NOT NULL
  • Field (db_name) — TEXT
  • Field (ip) — IP
  • Field2 (port) — INT4
  • Field (db_id)
  • Field2 (db_pwd)

Untitled (XM_INFO)

  • Key (no) — 기본 키 — NOT NULL
  • Key (user_no) — INT4 — 외래 키 → 사용자.Key — NOT NULL
  • Key (db_no) — INT4 — 외래 키 → DB정보.Key — NOT NULL

경고 (XM_ALERT)

  • Key (no) — 기본 키 — NOT NULL
  • Field (db_id)
  • Field2 (cause)
  • Field3 (time)

사용자 (XM_USER)

  • Key (no) — 기본 키 — NOT NULL
  • Field (user_name) — VARCHAR2(30)
  • Field (user_id) — VARCHAR2(30)
  • Field2 (user_pwd) — VARCHAR2(30)

설정 (PG_STAT_ALL_TABLES_HOURS)

  • 아이디 (db_id) — INT4 — NOT NULL
  • Field (time) — TIMESTAMP
  • Field2 (name) — TEXT
  • Field3 (setting) — TEXT
  • Field4 (unit) — TEXT
  • Field5 (category) — TEXT
  • Field6 (short_desc) — TEXT
  • Field7 (extra_desc) — TEXT
  • Field8 (context) — TEXT
  • Field9 (vartype) — TEXT
  • Field (source) — TEXT
  • Field2 (min_val) — TEXT
  • Field3 (max_val) — TEXT
  • Field4 (enumvals) — _TEXT
  • Field (boot_val) — TEXT
  • Field2 (reset_val) — TEXT
  • Field3 (sourcefile) — TEXT
  • Field (sourceline) — INT4

초단위 (PG_STAT_SECONDS)

  • 아이디 (db_id) — INT4 — NOT NULL
  • 시간 (time) — TIMESTAMP
  • 백엔드 (numbackends) — INT8
  • 커밋 (xact_commit) — NUMERIC
  • 롤백 (xact_rollback) — NUMERIC
  • 읽기 (blks_read) — NUMERIC
  • 히트 (blks_hit) — NUMERIC
  • 반환 (tup_returned) — NUMERIC
  • 패치 (tup_fetched) — NUMERIC
  • 삽입 (tup_inserted) — NUMERIC
  • 수정 (tup_updated) — NUMERIC
  • 삭제 (tup_deleted) — NUMERIC
  • 충돌 (conflicts) — NUMERIC
  • 임시_수 (temp_files) — NUMERIC
  • 임시_양 (temp_bytes) — NUMERIC
  • 교착 (deadlocks) — NUMERIC
  • 읽기 시간 (blk_read_time) — FLOAT8
  • 쓰기 시간 (blk_write_time) — FLOAT8

테이블 정보 (PG_SETTINGS_DAY)

  • Key (db_id) — INT4 — NOT NULL
  • Field (time) — TIMESTAMP
  • Field2 (schemaname) — NAME
  • Field3 (relname) — NAME
  • Field4 (total_rel_size) — INT8
  • Field (re_size) — INT8
  • Field5 (ind_size) — INT8
  • Field6 (seq_scan) — INT8
  • Field7 (seq_tup_read) — INT8
  • Field (idx_scan) — INT8
  • Field2 (idx_tup_fetch) — INT8
  • Field3 (n_tup_ins) — INT8
  • Field4 (n_tup_upd) — INT8
  • Field (n_tup_del) — INT8
  • Field2 (n_tup_hot_upd) — INT8
  • Field3 (n_live_tup) — INT8
  • Field4 (n_dead_tup) — INT8
  • Field5 (n_mod_since_analyze) — INT8
  • Field6 (last_vacuum) — TIMESTAMPTZ
  • Field (last_autovacuum) — TIMESTAMPTZ
  • Field2 (last_analyze) — TIMESTAMPTZ
  • Field3 (last_autoanalyze) — TIMESTAMPTZ
  • Field4 (vacuum_count) — INT8
  • Field (autovacuum_count) — INT8
  • Field2 (analyze_count) — INT8
  • Field3 (autoanalyze_count) — INT8

파티셔닝 (XM_RETENTION)

  • Field (db_no)
  • Field2 (table_name) — VARCHAR(50)
  • Field3 (storage_time) — INT4