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)