pgstat

Documentation

Index

• type Activity
  • func (a *Activity) List(ctx context.Context) error
• type Indexes
  • func (a *Indexes) List(ctx context.Context) error
• type Progress
  • func (a *Progress) List(ctx context.Context) error
• type Statements
  • func (a *Statements) List(ctx context.Context, order string, asc bool, filter string) error
• type TableStat
  • func (a *TableStat) List(ctx context.Context, table string) error
• type Tables
  • func (a *Tables) List(ctx context.Context) error

Types

type Activity

type Activity []struct {
	PID      int64  `db:"pid"`
	Duration string `db:"duration"`
	Query    string `db:"query"`
}

func (*Activity) List

func (a *Activity) List(ctx context.Context) error

type Indexes

type Indexes []struct {
	Table    string `db:"relname"`
	Size     int    `db:"size"`
	Index    string `db:"indexrelname"`
	Scan     int64  `db:"idx_scan"`
	TupRead  int64  `db:"idx_tup_read"`
	TupFetch int64  `db:"idx_tup_fetch"`
}

func (*Indexes) List

func (a *Indexes) List(ctx context.Context) error

type Progress

type Progress []struct {
	Table   string `db:"relname"`
	Command string `db:"command"`
	Phase   string `db:"phase"`
	Status  string `db:"status"`
}

func (*Progress) List

func (a *Progress) List(ctx context.Context) error

type Statements

type Statements []struct {
	Total      float64 `db:"total"`
	MeanTime   float64 `db:"mean_time"`
	MinTime    float64 `db:"min_time"`
	MaxTime    float64 `db:"max_time"`
	StdDevTime float64 `db:"stddev_time"`
	Calls      int     `db:"calls"`
	HitPercent float64 `db:"hit_percent"`
	QueryID    int64   `db:"queryid"`
	Query      string  `db:"query"`
}

func (*Statements) List

func (a *Statements) List(ctx context.Context, order string, asc bool, filter string) error

type TableStat

type TableStat []struct {
	AttName     string  `db:"attname"`
	NullFrac    float64 `db:"null_frac"`
	AvgWidth    int     `db:"avg_width"`
	NDistinct   float64 `db:"n_distinct"`
	Correlation float64 `db:"correlation"`
}

func (*TableStat) List

func (a *TableStat) List(ctx context.Context, table string) error

type Tables

type Tables []struct {
	Table   string `db:"relname"`
	SeqScan int64  `db:"seq_scan"`
	IdxScan int64  `db:"idx_scan"`
	SeqRead int64  `db:"seq_tup_read"`
	IdxRead int64  `db:"idx_tup_fetch"`

	LastVacuum      time.Time `db:"last_vacuum"`
	LastAutoVacuum  time.Time `db:"last_autovacuum"`
	LastAnalyze     time.Time `db:"last_analyze"`
	LastAutoAnalyze time.Time `db:"last_autoanalyze"`

	VacuumCount  int `db:"vacuum_count"`
	AnalyzeCount int `db:"analyze_count"`

	LiveTup         int64 `db:"n_live_tup"`
	DeadTup         int64 `db:"n_dead_tup"`
	ModSinceAnalyze int64 `db:"n_mod_since_analyze"`

	TableSize   int `db:"table_size"`
	IndexesSize int `db:"indexes_size"`
}

func (*Tables) List

func (a *Tables) List(ctx context.Context) error