MiniPJ
Tables (7)
PG_STAT_DATABASE_5SEC (5초마다 수집하는 정보)
- db_id (Field)
- numbackends (Field2)
- xact_commit (Field3)
- xact_rollback (Field4)
- blks_read (Field5)
- blks_hit (Field6)
- tup_returned (Field7)
- tup_fetched (Field8)
- tup_inserted (Field9)
- tup_updated (Field10)
- tup_deleted (Field11)
- conflicts (Field12)
- temp_files (Field13)
- temp_bytes (Field14)
- deadlocks (Field15)
- blk_read_time (Field16)
- blk_write_time (Field17)
- time (Field18)
XM_DB_INFO (모니터링대상 DB 정보)
- db_id (DB_ID) — number — Primary key — NOT NULL
- instance_name (INSTANCE_NAME) — varchar
- db_user (DB_USER) — varchar
- password (PASSWORD) — varchar
- host_ip (HOST_IP)
- port (PORT)
XM_DB_STATUS (모니터링대상DB 연결여부)
- db_id (Key) — number — Primary key — NOT NULL
- status (Field) — boolean
- time (Field2)
XM_PARTITION_MANAGE (파티셔닝 주기 관리)
- db_id (Field3)
- table_name (Field)
- retention_days (Field2)
XM_USER_INFO (사용 유저 정보)
- db_id (Key) — Primary key — NOT NULL
- user_id (Field)
- password (Field2)
pg_settings_1day(PA_1day) (수집 주기 1번)
- db_id (Field17)
- name (Field)
- setting (Field2)
- unit (Field3)
- category (Field4)
- short_desc (Field5)
- extra_desc (Field6)
- context (Field7)
- vartype (Field8)
- min_val (Field9)
- max_val (Field10)
- enumvals (Field11)
- boot_val (Field12)
- reset_val (Field13)
- sourcefile (Field14)
- sourceline (Field15)
- time (Field16)
pg_stat_all_tables_1hour(PA_1hour) (수집주기 1시간)
- db_id (Field27)
- schemaname (Field)
- relname (Field2)
- pg_total_relation_size (Field3)
- pg_relation_size (Field4)
- pg_table_size (Field5)
- pg_indexes_size (Field6)
- seq_scan (Field7)
- seq_tup_read (Field8)
- idx_scan (Field9)
- idx_tup_fetch (Field10)
- n_tup_ins (Field11)
- n_tup_upd (Field12)
- n_tup_del (Field13)
- n_tup_hot_upd (Field14)
- n_live_tup (Field15)
- n_dead_tup (Field16)
- n_mod_since_analyze (Field17)
- last_vacuum (Field18)
- last_autovacuum (Field19)
- last_analyze (Field20)
- last_autoanalyze (Field21)
- vacuum_count (Field22)
- autovacuum_count (Field23)
- analyze_count (Field24)
- autoanalyze_count (Field25)
- time (Field26)