project

Tables (5)

public (target_info)

  • . (db_id) — int(2) — NOT NULL
  • Field (db_name) — varchar(20) UNIQUE — NOT NULL
  • Field (ip) — varchar(50) UNIQUE — NOT NULL
  • Field (port) — varchar(10) UNIQUE — NOT NULL
  • Field (username) — varchar(20) — NOT NULL
  • Field (password) — varchar(50) — NOT NULL

public (partition_management)

  • . (db_id) — int2 — NOT NULL
  • . (partition_table_name) — varchar(50) — NOT NULL
  • . (period) — int2 — NOT NULL

target_db_schema (system_stats)

  • . (db_id) — int(2) — NOT NULL
  • . (time) — date — NOT NULL
  • . (num_backends) — bigint — NOT NULL
  • . (xact_commit) — bigint — NOT NULL
  • . (xact_rollback) — bigint — NOT NULL
  • . (blks_read) — bigint — NOT NULL
  • . (blks_hit) — bigint — NOT NULL
  • . (tup_fetched) — bigint — NOT NULL
  • . (tup_returned) — bigint — NOT NULL
  • . (tup_inserted) — bigint — NOT NULL
  • . (tup_updated) — bigint — NOT NULL
  • . (tup_deleted) — bigint — NOT NULL
  • . (conflicts) — bigint — NOT NULL
  • . (temp_files) — bigint — NOT NULL
  • . (temp_bytes) — bigint — NOT NULL
  • . (deadlocks) — bigint — NOT NULL
  • . (blk_read_time) — bigint — NOT NULL
  • . (blk_write_time) — bigint — NOT NULL

target_db_schema (table_info)

  • . (db_id) — int(2) — NOT NULL
  • . (time) — date — NOT NULL
  • . (schemaname) — varchar(100)
  • . (relname) — varchar(255)
  • . (total_rel_size) — bigint
  • . (re_size) — bigint
  • . (tab_size) — bigint
  • . (ind_size) — bigint
  • . (seq_scan) — bigint
  • . (seq_tub_read) — bigint
  • . (idx_scan) — bigint
  • . (idx_tup_fetch) — bigint
  • . (n_tup_ins) — bigint
  • . (n_tup_upd) — bigint
  • . (n_tup_del) — bigint
  • . (n_tup_hot_upd) — bigint
  • . (n_live_tup) — bigint
  • . (n_dead_tup) — bigint
  • . (n_mod_since_analyze) — bigint
  • . (last_vacuum) — date
  • . (last_autovacuum) — date
  • . (last_analyze) — date
  • . (last_autoanalyze) — date
  • . (vacuum_count) — bigint
  • . (autovacuum_count) — bigint
  • . (analyze_count) — bigint
  • . (autoanalyze_count) — bigint

target_db_schema (settings)

  • . (db_id) — int(2) — NOT NULL
  • . (time) — date — NOT NULL
  • . (name) — varchar(100)
  • . (setting) — varchar(255)
  • . (unit) — varchar(10)
  • . (category) — varchar(100)
  • . (short_desc) — varchar(255)
  • . (extra_desc) — varchar(255)
  • . (context) — varchar(100)
  • . (var_type) — varchar(100)
  • . (source) — varchar(100)
  • . (min_val) — varchar(100)
  • . (max_val) — varchar(100)
  • . (enum_vals) — enum
  • . (boot_val) — varchar(100)
  • . (reset_val) — varchar(100)
  • . (source_file) — varchar(100)
  • . (source_line) — int