postgres

type ActiveLock struct {
	RelationName       string `db:"relname" table:"Relation Name"`
	LockType           string `db:"locktype" table:"Lock Type"`
	Page               string `db:"page"`
	VirtualTransaction string `db:"virtualtransaction" table:"Virtual Transaction"`
	PID                string `db:"pid"`
	Mode               string `db:"mode"`
	Granted            string `db:"granted"`
}

type Activity struct {
	ProcessID  string `db:"pid" table:"Process ID"`
	QueryStart string `db:"query_start" table:"Query Start"`
	State      string `db:"state"`
	Query      string `db:"query"`
}

type Bloat struct {
	Type       string `db:"type"`
	SchemaName string `db:"schemaname" table:"Schema Name"`
	ObjectName string `db:"object_name" table:"Object Name"`
	Bloat      string `db:"bloat"`
	Waste      string `db:"waste"`
}

type DBConnection struct {
	// contains filtered or unexported fields
}

type Database struct {
	Name           DatabaseName `db:"datname"`
	Size           int          `db:"size" table:"-"`
	FormattedSize  string       `db:"formatted_size" table:"Size"`
	CommitRatio    string       `db:"commit_ratio" table:"Commit Ratio"`
	CacheHitRation string       `db:"cache_hit_ratio" table:"Cache Hit Ratio"`
	BlocksRead     int          `db:"blks_read" table:"Blocks Read"`
}

type DatabaseName string

type MissingIndex struct {
	RelationName    string `db:"relname"`
	TooMuchSeq      int    `db:"too_much_seq" table:"Too Much Seq"`
	MissingIndex    string `db:"missing_index" table:"Missing Index?"`
	RelationSize    string `db:"rel_size" table:"Size"`
	SequentialScans int    `db:"seq_scan" table:"Sequential Scans"`
	IndexScans      int    `db:"idx_scan" table:"Index Scans"`
}

type PG struct {
	// contains filtered or unexported fields
}

type TableCacheHitRatio struct {
	Table            string `db:"table_name"`
	DiskHits         int    `db:"disk_hits" table:"Disk Hits"`
	PercentDiskHits  string `db:"percent_disk_hits" table:"% Disk Hits"`
	PercentCacheHits string `db:"percent_cache_hits" table:"% Cache Hits"`
	TotalHits        int    `db:"total_hits" table:"Total Hits"`
}

type TableSize struct {
	Schema      string `db:"table_schema"`
	TableName   string `db:"table_name" table:"Table Name"`
	RowEstimate string `db:"row_estimate" table:"Row Estimate"`
	Table       string `db:"table"`
	Index       string `db:"index"`
	TOAST       string `db:"toast"`
	Total       string `db:"total"`
}

type UselessIndex struct {
	Table      string `db:"table"`
	Index      string `db:"index"`
	IndexSize  string `db:"index_size" table:"Index Size"`
	IndexScans int    `db:"index_scans" table:"Index Scans"`
}

type VacuumStat struct {
	Table               string `db:"table"`
	LastVacuum          string `db:"last_vacuum" table:"Last Vacuum"`
	LastAutoVacuum      string `db:"last_autovacuum" table:"Last Auto-Vacuum"`
	RowCount            string `db:"rowcount" table:"Row Count"`
	DeadRowCount        string `db:"dead_rowcount" table:"Dead Row Count"`
	RowsPerPage         string `db:"rows_per_page" table:"Rows per Page"`
	AutoVacuumThreshold string `db:"autovacuum_threshold" table:"Auto-Vacuum Threshold"`
	WillVacuum          string `db:"will_vacuum" table:"Will Vacuum"`
}