postgres

type BasicInfo struct {
	DBName         string
	DBUser         string
	Version        string
	ServerVersion  string
	DBSizeBytes    int64
	StartTime      time.Time
	MaxConnections string
}

type BasicStats struct {
	RowCount          int64
	DeadRowCount      int64
	ModifiedCount     int64
	LastVacuum        sql.NullTime
	LastAutovacuum    sql.NullTime
	LastAnalyze       sql.NullTime
	LastAutoanalyze   sql.NullTime
	VacuumCount       int64
	AutovacuumCount   int64
	AnalyzeCount      int64
	AutoanalyzeCount  int64
	EstimatedRowCount float64
	PageCount         float64
	SizeBytes         int64
	TotalSizeBytes    int64
}

type ColumnStats struct {
	ColumnName       string
	DataType         string
	NullFraction     float64
	AverageWidth     float64
	DistinctValues   float64
	MostCommonValues sql.NullString
	MostCommonFreqs  sql.NullString
	HistogramBounds  sql.NullString
	Correlation      sql.NullString
}

type IndexRow struct {
	IndexName  string
	ColumnName string
	IsUnique   bool
	IndexType  string
	Direction  int
	Comment    *string // Using pointer for nullable string
}

type IndexStats struct {
	IndexName      string
	ScanCount      int64
	TuplesRead     int64
	TuplesFetched  int64
	IndexSizeBytes int64
}