pgcompare

type BenchResult struct {
	Phase string
	Stats []Stats
	Plans []*PlanNode
}

type Config struct {
	ProjectDir string

	Migration struct {
		EnvVar        string `yaml:"env_var"`
		BeforeVersion string `yaml:"before_version"`
		AfterVersion  string `yaml:"after_version"`
	} `yaml:"migration"`

	Setup struct {
		Command string `yaml:"command"`
	} `yaml:"setup"`

	Benchmark struct {
		BeforeQueries string `yaml:"before_queries"`
		AfterQueries  string `yaml:"after_queries"`
		Iterations    int    `yaml:"iterations"`
		Concurrency   int    `yaml:"concurrency"`
	} `yaml:"benchmark"`

	Report struct {
		Description []DescriptionEntry `yaml:"description"`
	} `yaml:"report"`

	DSN string
}

type DescriptionEntry struct {
	Query    string `yaml:"query"`
	What     string `yaml:"what"`
	Changes  string `yaml:"changes"`
	Expected string `yaml:"expected"`
}

type PlanDiff struct {
	QueryName string
	Before    *PlanNode
	After     *PlanNode
	Summary   []string
}

type PlanNode struct {
	NodeType        string
	RelationName    string
	IndexName       string
	ActualRows      float64
	ActualTotalTime time.Duration
	Children        []*PlanNode
}

type Query struct {
	Name string
	SQL  string
}

type ReportData struct {
	GeneratedAt time.Time
	Iterations  int
	Concurrency int
	Speedups    []float64
	Before      *BenchResult
	After       *BenchResult
	Diffs       []PlanDiff
	Description []DescriptionEntry
}

type Stats struct {
	QueryName                             string
	Min, Max, P50, P95, P99, Mean, StdDev time.Duration
	QPS                                   float64
	ErrorRate                             float64
	Errors                                []string
}