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