db

type ColumnInfo struct {
	Name      string
	DataType  string
	Nullable  bool
	Default   string
	IsPrimary bool
}

type ConnectionGroup struct {
	User  string
	App   string
	State string
	Count int
}

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

type DatabaseInfo struct {
	Name  string
	Size  int64
	Owner string
}

type DatabaseStats struct {
	XactCommit    int64
	XactRollback  int64
	BlksHit       int64
	BlksRead      int64
	CacheHitRatio float64
}

type IndexInfo struct {
	Schema    string
	Table     string
	IndexName string
	Scans     int64
	TupRead   int64
	TupFetch  int64
	Size      int64
}

type Lock struct {
	BlockedPID    int
	BlockingPID   int
	BlockedUser   string
	BlockingUser  string
	BlockedApp    string
	BlockingApp   string
	LockType      string
	Mode          string
	WaitDuration  time.Duration
	BlockedQuery  string
	BlockingQuery string
}

type Query struct {
	ResourceBase
	Duration      time.Duration
	QueryStart    time.Time // when this query started executing
	WaitEventType string
	WaitEvent     string
	QueryText     string
	Comment       SQLComment
	BlockedBy     int
	QueryID       int64
}

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

type QueryHistoryEntry struct {
	Query     string
	State     string
	Timestamp time.Time
}

type ResourceBase struct {
	PID          int
	User         string
	App          string
	Database     string
	ClientAddr   string
	State        string
	BackendStart time.Time // when this backend process started — unique with PID
}

type RoleInfo struct {
	Name          string
	IsSuperuser   bool
	CanCreateRole bool
	CanCreateDB   bool
	CanLogin      bool
	ConnLimit     int
}

type SQLComment struct {
	App        string
	Route      string
	Controller string
	Action     string
	Framework  string
}

type ServerInfo struct {
	Version        string
	Uptime         time.Duration
	MaxConnections int
}

type SlowQuery struct {
	QueryID   int64
	Query     string
	Calls     int64
	TotalTime float64
	MeanTime  float64
	Rows      int64
	HitRatio  float64
}

type TableDetail struct {
	Schema         string
	Name           string
	TotalSize      int64
	LiveTuples     int64
	DeadTuples     int64
	SeqScan        int64
	IdxScan        int64
	LastVacuum     *time.Time
	LastAutoVacuum *time.Time
	LastAnalyze    *time.Time
	Columns        []ColumnInfo
	Indexes        []IndexInfo
}

type TableInfo struct {
	Schema         string
	Name           string
	TotalSize      int64
	LiveTuples     int64
	DeadTuples     int64
	SeqScan        int64
	IdxScan        int64
	LastVacuum     *time.Time
	LastAutoVacuum *time.Time
}

type Transaction struct {
	ResourceBase
	XactStart     time.Time // when this transaction began — unique with PID
	XactDuration  time.Duration
	QueryDuration time.Duration
	QueryText     string
	LockCount     int
}