pgmetrics

type AnalyzeProgressBackend struct {
	PID                     int    `json:"pid"`
	DBName                  string `json:"db_name"`
	TableOID                int    `json:"table_oid"`
	Phase                   string `json:"phase"`
	SampleBlocksTotal       int64  `json:"sample_blks_total"`
	SampleBlocksScanned     int64  `json:"sample_blks_scanned"`
	ExtStatsTotal           int64  `json:"ext_stats_total"`
	ExtStatsComputed        int64  `json:"ext_stats_computed"`
	ChildTablesTotal        int64  `json:"child_tables_total"`
	ChildTablesDone         int64  `json:"child_tables_done"`
	CurrentChildTableRelOID int    `json:"child_oid"`
	// following fields present only in schema 1.19 and later
	DelayTime float64 `json:"delay_time,omitempty"` // millisecs, pg >= v18
}

type AutoVacuum struct {
	At      int64   `json:"at"`         // time when activity was logged, as seconds since epoch
	Table   string  `json:"table_name"` // fully qualified, db.schema.table
	Elapsed float64 `json:"elapsed"`    // in seconds
}

type Azure struct {
	ResourceName   string             `json:"resource_name"`
	ResourceType   string             `json:"resource_type"`
	ResourceRegion string             `json:"resource_region"`
	Metrics        map[string]float64 `json:"metrics"`
}

type BGWriter struct {
	CheckpointsTimed     int64   `json:"checkpoints_timed,omitempty"`     // <=pg16
	CheckpointsRequested int64   `json:"checkpoints_req,omitempty"`       // <=pg16
	CheckpointWriteTime  float64 `json:"checkpoint_write_time,omitempty"` // <=pg16
	CheckpointSyncTime   float64 `json:"checkpoint_sync_time,omitempty"`  // <=pg16
	BuffersCheckpoint    int64   `json:"buffers_checkpoint,omitempty"`    // <=pg16
	BuffersClean         int64   `json:"buffers_clean"`
	MaxWrittenClean      int64   `json:"maxwritten_clean"`
	BuffersBackend       int64   `json:"buffers_backend,omitempty"`       // <=pg16
	BuffersBackendFsync  int64   `json:"buffers_backend_fsync,omitempty"` // <=pg16
	BuffersAlloc         int64   `json:"buffers_alloc"`
	StatsReset           int64   `json:"stats_reset"`
}

type Backend struct {
	DBName          string `json:"db_name"`
	RoleName        string `json:"role_name"`
	ApplicationName string `json:"application_name"`
	PID             int    `json:"pid"`
	ClientAddr      string `json:"client_addr"`
	BackendStart    int64  `json:"backend_start"`
	XactStart       int64  `json:"xact_start"`
	QueryStart      int64  `json:"query_start"`
	StateChange     int64  `json:"state_change"`
	WaitEventType   string `json:"wait_event_type"`
	WaitEvent       string `json:"wait_event"`
	State           string `json:"state"`
	BackendXid      int    `json:"backend_xid"`
	BackendXmin     int    `json:"backend_xmin"`
	Query           string `json:"query"`
	// following fields present only in schema 1.11 and later
	QueryID int64 `json:"query_id,omitempty"` // >= pg14
}

type BasebackupProgressBackend struct {
	PID                 int    `json:"pid"`
	Phase               string `json:"phase"`
	BackupTotal         int64  `json:"backup_total"`
	BackupStreamed      int64  `json:"backup_streamed"`
	TablespacesTotal    int64  `json:"tablespaces_total"`
	TablespacesStreamed int64  `json:"tablespaces_streamed"`
}

type Checkpointer struct {
	NumTimed               int64   `json:"num_timed"`
	NumRequested           int64   `json:"num_requested"`
	RestartpointsTimed     int64   `json:"restartpoints_timed"`
	RestartpointsRequested int64   `json:"restartpoints_req"`
	RestartpointsDone      int64   `json:"restartpoints_done"`
	WriteTime              float64 `json:"write_time"`
	SyncTime               float64 `json:"sync_time"`
	BuffersWritten         int64   `json:"buffers_written"`
	StatsReset             int64   `json:"stats_reset"`
	// following fields present only in schema 1.19 and later
	NumDone     int64 `json:"num_done,omitempty"`     // pg >= v18
	SLRUWritten int64 `json:"slru_written,omitempty"` // pg >= v18
}

type Citus struct {
	Version        string           `json:"version"`
	Nodes          []CitusNode      `json:"nodes"`
	Statements     []CitusStatement `json:"statements"`
	Backends       []CitusBackend   `json:"dist_activity,omitempty"`   // citus <=10.x
	WorkerBackends []CitusBackend   `json:"worker_activity,omitempty"` // citus <=10.x
	Locks          []CitusLock      `json:"locks"`
	// following fields present only in schema 1.13 and later
	AllBackends       []CitusBackendV11 `json:"activity,omitempty"`           // citus >=11.x
	Tables            []CitusTable      `json:"tables,omitempty"`             // citus >=11.x
	CoordinatorNodeID int               `json:"coordinator_nodeid,omitempty"` // citus >=11.x
	ConnectedNodeID   int               `json:"connected_nodeid,omitempty"`   // citus >=11.x, the node pgmetrics connected to
}

type CitusBackend struct {
	Backend                    // also include all fields from pg_stat_activity
	QueryHostname       string `json:"query_hostname"`
	QueryPort           int    `json:"query_port"`
	MasterQueryHostname string `json:"master_query_hostname"`
	MasterQueryPort     int    `json:"master_query_port"`
	TxNumber            int64  `json:"transaction_number"`
	TxStamp             int64  `json:"transaction_stamp"`
}

type CitusBackendV11 struct {
	Backend              // also include all fields from pg_stat_activity
	GlobalPID     int64  `json:"global_pid"`
	NodeID        int    `json:"node_id"`
	IsWorkerQuery bool   `json:"is_worker_query"`
	BackendType   string `json:"backend_type"`
}

type CitusLock struct {
	WaitingPID       int    `json:"waiting_pid,omitempty"`  // citus <=10.x, 0 otherwise
	BlockingPID      int    `json:"blocking_pid,omitempty"` // citus <=10.x, 0 otherwise
	BlockedStmt      string `json:"blocked_statement"`
	CurrStmt         string `json:"current_statement_in_blocking_process"`
	WaitingNodeID    int    `json:"waiting_node_id"`
	BlockingNodeID   int    `json:"blocking_node_id"`
	WaitingNodeName  string `json:"waiting_node_name,omitempty"`  // citus <=10.x, ” otherwise
	BlockingNodeName string `json:"blocking_node_name,omitempty"` // citus <=10.x, ” otherwise
	WaitingNodePort  int    `json:"waiting_node_port,omitempty"`  // citus <=10.x, 0 otherwise
	BlockingNodePort int    `json:"blocking_node_port,omitempty"` // citus <=10.x, 0 otherwise
	// following fields present only in schema 1.13 and later
	WaitingGPID  int64 `json:"waiting_gpid,omitempty"`  // citus >=11.x
	BlockingGPID int64 `json:"blocking_gpid,omitempty"` // citus >=11.x
}

type CitusNode struct {
	ID               int    `json:"nodeid"`
	GroupID          int    `json:"groupid"`
	Name             string `json:"nodename"`
	Port             int    `json:"nodeport"`
	Rack             string `json:"noderack"`
	IsActive         bool   `json:"isactive"`
	Role             string `json:"noderole"`
	Cluster          string `json:"nodecluster"`
	ShouldHaveShards bool   `json:"shouldhaveshards"`
}

type CitusStatement struct {
	QueryID      int64  `json:"queryid"`       // same as pg_stat_statements.queryid
	UserOID      int    `json:"useroid"`       // user who ran the query
	DBOID        int    `json:"db_oid"`        // database instance of coordinator
	Query        string `json:"query"`         // anonymized query string
	Executor     string `json:"executor"`      // Citus executor used: adaptive, real-time, task-tracker, router, or insert-select
	PartitionKey string `json:"partition_key"` // value of distribution column in router-executed queries, else NULL
	Calls        int64  `json:"calls"`         // number of times the query was run
}

type CitusTable struct {
	OID                int    `json:"oid"`
	TableName          string `json:"table_name"`
	TableType          string `json:"citus_table_type"`
	DistributionColumn string `json:"distribution_column"`
	ColocationID       int    `json:"colocation_id"`
	Size               int64  `json:"table_size"`
	ShardCount         int    `json:"shard_count"`
	TableOwner         string `json:"table_owner"`
	AccessMethod       string `json:"access_method"`
}

type ClusterProgressBackend struct {
	PID               int    `json:"pid"`
	DBName            string `json:"db_name"`
	TableOID          int    `json:"table_oid"`
	Command           string `json:"command"`
	Phase             string `json:"phase"`
	ClusterIndexOID   int    `json:"cluser_index_oid"`
	HeapTuplesScanned int64  `json:"heap_tuples_scanned"`
	HeapTuplesWritten int64  `json:"heap_tuples_written"`
	HeapBlksTotal     int64  `json:"heap_blks_total"`
	HeapBlksScanned   int64  `json:"heap_blks_scanned"`
	IndexRebuildCount int    `json:"index_rebuild_count"`
}

type CopyProgressBackend struct {
	PID             int    `json:"pid"`
	DBName          string `json:"db_name"`
	TableOID        int    `json:"table_oid"`
	Command         string `json:"command"`
	Type            string `json:"type"`
	BytesProcessed  int64  `json:"bytes_processed"`
	BytesTotal      int64  `json:"bytes_total"`
	TuplesProcessed int64  `json:"tuples_processed"`
	TuplesExcluded  int64  `json:"tuples_excluded"`
}

type CreateIndexProgressBackend struct {
	PID              int    `json:"pid"`
	DBName           string `json:"db_name"`
	TableOID         int    `json:"table_oid"`
	IndexOID         int    `json:"index_oid"`
	Command          string `json:"command"`
	Phase            string `json:"phase"`
	LockersTotal     int64  `json:"lockers_total"`
	LockersDone      int64  `json:"lockers_done"`
	CurrentLockerPID int    `json:"current_locker_pid"`
	BlocksTotal      int64  `json:"blocks_total"`
	BlocksDone       int64  `json:"blocks_done"`
	TuplesTotal      int64  `json:"tuples_total"`
	TuplesDone       int64  `json:"tuples_done"`
	PartitionsTotal  int64  `json:"partitions_total"`
	PartitionsDone   int64  `json:"partitions_done"`
}

type Database struct {
	OID             int     `json:"oid"`
	Name            string  `json:"name"`
	DatDBA          int     `json:"datdba"`
	DatTablespace   int     `json:"dattablespace"`
	DatConnLimit    int     `json:"datconnlimit"`
	AgeDatFrozenXid int     `json:"age_datfrozenxid"`
	NumBackends     int     `json:"numbackends"`
	XactCommit      int64   `json:"xact_commit"`
	XactRollback    int64   `json:"xact_rollback"`
	BlksRead        int64   `json:"blks_read"`
	BlksHit         int64   `json:"blks_hit"`
	TupReturned     int64   `json:"tup_returned"`
	TupFetched      int64   `json:"tup_fetched"`
	TupInserted     int64   `json:"tup_inserted"`
	TupUpdated      int64   `json:"tup_updated"`
	TupDeleted      int64   `json:"tup_deleted"`
	Conflicts       int64   `json:"conflicts"`
	TempFiles       int64   `json:"temp_files"`
	TempBytes       int64   `json:"temp_bytes"`
	Deadlocks       int64   `json:"deadlocks"`
	BlkReadTime     float64 `json:"blk_read_time"`
	BlkWriteTime    float64 `json:"blk_write_time"`
	StatsReset      int64   `json:"stats_reset"`
	Size            int64   `json:"size"`
	// following fields present only in schema 1.11 and later
	ChecksumFailures    int64   `json:"checksum_failures,omitempty"`        // >= pg12
	ChecksumLastFailure int64   `json:"checksum_last_failure,omitempty"`    // >= pg12
	SessionTime         float64 `json:"session_time,omitempty"`             // in milliseconds, pg >= v14
	ActiveTime          float64 `json:"active_time,omitempty"`              // in milliseconds, pg >= v14
	IdleInTxTime        float64 `json:"idle_in_transaction_time,omitempty"` // in milliseconds, pg >= v14
	Sessions            int64   `json:"sessions,omitempty"`                 // pg >= v14
	SessionsAbandoned   int64   `json:"sessions_abandoned,omitempty"`       // pg >= v14
	SessionsFatal       int64   `json:"sessions_fatal,omitempty"`           // pg >= v14
	SessionsKilled      int64   `json:"sessions_killed,omitempty"`          // pg >= v14
	// following fields present only in schema 1.19 and later
	ParallelWorkersToLaunch int64 `json:"parallel_workers_to_launch,omitempty"` // pg >= v18
	ParallelWorkersLaunched int64 `json:"parallel_workers_launched,omitempty"`  // pg >= v18
	// following fields present only in schema 1.20 and later
	// the Confl* fields are only relevant on standby servers
	ConflTablespace  int64 `json:"confl_tablespace,omitempty"`
	ConflLock        int64 `json:"confl_lock,omitempty"`
	ConflSnapshot    int64 `json:"confl_snapshot,omitempty"`
	ConflBufferpin   int64 `json:"confl_bufferpin,omitempty"`
	ConflDeadlock    int64 `json:"confl_deadlock,omitempty"`
	ConflLogicalslot int64 `json:"confl_active_logicalslot,omitempty"` // pg >= v16
}

type Deadlock struct {
	At     int64  `json:"at"`     // time when activity was logged, as seconds since epoch
	Detail string `json:"detail"` // information about the deadlocking processes
}

type Extension struct {
	Name             string `json:"name"`
	DBName           string `json:"db_name"`
	DefaultVersion   string `json:"default_version"`
	InstalledVersion string `json:"installed_version"`
	Comment          string `json:"comment"`
	// following fields present only in schema 1.18 and later
	SchemaName string `json:"schema_name"`
}

type Index struct {
	OID         int    `json:"oid"`
	DBName      string `json:"db_name"`
	SchemaName  string `json:"schema_name"`
	TableOID    int    `json:"table_oid"`
	TableName   string `json:"table_name"`
	Name        string `json:"name"`
	IdxScan     int64  `json:"idx_scan"`
	IdxTupRead  int64  `json:"idx_tup_read"`
	IdxTupFetch int64  `json:"idx_tup_fetch"`
	IdxBlksRead int64  `json:"idx_blks_read"`
	IdxBlksHit  int64  `json:"idx_blks_hit"`
	Size        int64  `json:"size"`
	Bloat       int64  `json:"bloat"`
	// following fields present only in schema 1.2 and later
	RelNAtts       int    `json:"relnatts"`
	AMName         string `json:"amname"`
	TablespaceName string `json:"tablespace_name"`
	// following fields present only in schema 1.8 and later
	Definition string `json:"def"`
	// following fields present only in schema 1.16 and later
	LastIdxScan int64 `json:"last_idx_scan,omitempty"` // pg >= v16
}

type Lock struct {
	LockType    string `json:"locktype"`
	DBName      string `json:"db_name,omitempty"`
	PID         int    `json:"pid"`
	Mode        string `json:"mode"`
	Granted     bool   `json:"granted"`
	RelationOID int    `json:"relation_oid,omitempty"`
	// following fields present only in schema 1.11 and later
	WaitStart int64 `json:"waitstart,omitempty"` // >= pg14
}

type LogEntry struct {
	At       int64           `json:"at"`
	AtFull   string          `json:"atfull"` // time, in RFC3339 format, tz will be UTC
	UserName string          `json:"user,omitempty"`
	DBName   string          `json:"db_name,omitempty"`
	QueryID  int64           `json:"queryid,omitempty"`
	Level    string          `json:"level,omitempty"`
	Line     string          `json:"line,omitempty"`
	Extra    []LogEntryExtra `json:"extra,omitempty"`
}

type LogEntryExtra struct {
	Level string `json:"level,omitempty"`
	Line  string `json:"line,omitempty"`
}

type Metadata struct {
	Version      string   `json:"version"`       // schema version, "semver" format
	At           int64    `json:"at"`            // time when this report was started
	CollectedDBs []string `json:"collected_dbs"` // names of dbs we collected db-level stats from
	Local        bool     `json:"local"`         // was connected to a local postgres server?
	UserAgent    string   `json:"user_agent"`    // "pgmetrics/1.8.1"
	Username     string   `json:"user"`          // user that pgmetrics connected as
	Mode         string   `json:"mode"`          // one of "postgres", "pgbouncer" or "pgpool", added schema 1.14
}

type Model struct {
	Metadata Metadata `json:"meta"` // metadata about this object

	StartTime        int64  `json:"start_time"`        // of postmaster
	SystemIdentifier string `json:"system_identifier"` // from pg_control

	// Checkpoint information
	CheckpointLSN   string `json:"checkpoint_lsn"`
	PriorLSN        string `json:"prior_lsn"`
	RedoLSN         string `json:"redo_lsn"`
	TimelineID      int    `json:"timeline_id"`
	NextXid         int    `json:"next_xid"`
	OldestXid       int    `json:"oldest_xid"`
	OldestActiveXid int    `json:"oldest_active_xid"`
	CheckpointTime  int64  `json:"checkpoint_time"`

	// wal
	WALFlushLSN  string `json:"wal_flush_lsn"`
	WALInsertLSN string `json:"wal_insert_lsn"`
	WALLSN       string `json:"wal_lsn"`

	// Recovery
	IsInRecovery            bool   `json:"is_in_recovery"`
	IsWalReplayPaused       bool   `json:"is_wal_replay_paused"`
	LastWALReceiveLSN       string `json:"last_wal_receive_lsn"`
	LastWALReplayLSN        string `json:"last_wal_replay_lsn"`
	LastXActReplayTimestamp int64  `json:"last_xact_replay_timestamp"`

	// last committed transaction (needs track_commit_timestamp = on)
	LastXactXid       int   `json:"last_xact_xid"`
	LastXactTimestamp int64 `json:"last_xact_time"`

	// wal - settings, archival stats
	WALArchiving  WALArchiving `json:"wal_archiving"`
	WALCount      int          `json:"wal_count"`
	WALReadyCount int          `json:"wal_ready_count"`

	// NotificationQueueUsage is the fraction of the asynchronous notification
	// queue currently occupied. Postgres v9.6 and above only. Added in
	// schema version 1.1.
	NotificationQueueUsage float64 `json:"notification_queue_usage"`

	// replication
	ReplicationOutgoing []ReplicationOut  `json:"replication_outgoing,omitempty"`
	ReplicationIncoming *ReplicationIn    `json:"replication_incoming,omitempty"`
	ReplicationSlots    []ReplicationSlot `json:"replication_slots,omitempty"`

	// other cluster-level stats
	BGWriter       BGWriter                `json:"bg_writer"`
	Backends       []Backend               `json:"backends"`
	VacuumProgress []VacuumProgressBackend `json:"vacuum_progress,omitempty"`

	// structural cluster-level information
	Roles       []Role       `json:"roles"`
	Databases   []Database   `json:"databases,omitempty"`
	Tablespaces []Tablespace `json:"tablespaces,omitempty"`

	// Database-specific
	Tables           []Table        `json:"tables,omitempty"`
	Indexes          []Index        `json:"indexes,omitempty"`
	Sequences        []Sequence     `json:"sequences,omitempty"`
	UserFunctions    []UserFunction `json:"user_functions,omitempty"`
	Extensions       []Extension    `json:"extensions,omitempty"`
	DisabledTriggers []Trigger      `json:"disabled_triggers,omitempty"`
	Statements       []Statement    `json:"statements,omitempty"`

	// System-level
	System *SystemMetrics `json:"system,omitempty"`

	// settings
	Settings map[string]Setting `json:"settings"` // all settings and their values

	// Logical replication (database-specific)
	Publications  []Publication  `json:"publications,omitempty"`
	Subscriptions []Subscription `json:"subscriptions,omitempty"`

	// Lock information
	Locks        []Lock        `json:"locks,omitempty"`
	BlockingPIDs map[int][]int `json:"blocking_pids,omitempty"`

	PgBouncer *PgBouncer `json:"pgbouncer,omitempty"`

	// the numerically highest wal segment number
	HighestWALSegment uint64 `json:"highwal,omitempty"`

	// query execution plans
	Plans []Plan `json:"plans,omitempty"`

	// autovacuum information
	AutoVacuums []AutoVacuum `json:"autovacuums,omitempty"`

	// deadlock information
	Deadlocks []Deadlock `json:"deadlocks,omitempty"`

	// metrics from AWS RDS
	RDS *RDS `json:"rds,omitempty"`

	// the types of running backends and their counts
	BackendTypeCounts map[string]int `json:"betypecounts,omitempty"`

	// citus-related information, per db
	Citus map[string]*Citus `json:"citus,omitempty"`

	// WAL activity info, from pg_stat_wal, pg >= v14
	WAL *WAL `json:"wal,omitempty"`

	// metrics from Azure PostgreSQL, via Azure Monitor APIs
	Azure *Azure `json:"azure,omitempty"`

	// progress information from pg_stat_progress_* (see above for vacuum)
	AnalyzeProgress     []AnalyzeProgressBackend     `json:"analyze_progress,omitempty"`
	BasebackupProgress  []BasebackupProgressBackend  `json:"basebackup_progress,omitempty"`
	ClusterProgress     []ClusterProgressBackend     `json:"cluster_progress,omitempty"`
	CopyProgress        []CopyProgressBackend        `json:"copy_progress,omitempty"`
	CreateIndexProgress []CreateIndexProgressBackend `json:"create_index_progress,omitempty"`

	// metrics from Pgpool
	Pgpool *Pgpool `json:"pgpool,omitempty"`

	// raw log entries during specified time span
	LogEntries []LogEntry `json:"log_entries,omitempty"`

	// contents of pg_stat_checkpointer, pg >= v17
	Checkpointer *Checkpointer `json:"checkpointer,omitempty"`

	// a 4-tuple of client address, client port, server address, server port
	// if connected via tcp, like SSH_CONNECTION
	ConnectionTuple string `json:"connection_tuple,omitempty"`

	// value of version()
	FullVersion string `json:"full_version,omitempty"`

	// value of pg_conf_load_time() as seconds since epoch
	ConfLoadTime int64 `json:"conf_load_time,omitempty"`

	StatIOs []StatIO `json:"stat_ios,omitempty"`
}

type PgBouncer struct {
	Pools     []PgBouncerPool     `json:"pools,omitempty"`
	Stats     []PgBouncerStat     `json:"stats,omitempty"`
	Databases []PgBouncerDatabase `json:"dbs,omitempty"`

	SCActive  int     `json:"sc_active"`  // no. of active server conns
	SCIdle    int     `json:"sc_idle"`    // no. of idle server conns
	SCUsed    int     `json:"sc_used"`    // no. of used server conns
	SCMaxWait float64 `json:"sc_maxwait"` // max wait time for server conns

	CCActive  int     `json:"cc_active"`  // no. of active client conns
	CCWaiting int     `json:"cc_waiting"` // no. of waiting client conns
	CCIdle    int     `json:"cc_idle"`    // no. of idle client conns
	CCUsed    int     `json:"cc_used"`    // no. of used client conns
	CCMaxWait float64 `json:"cc_maxwait"` // max wait time for *waiting* client conns
	CCAvgWait float64 `json:"cc_avgwait"` // avg wait time for *waiting* client conns
}

type PgBouncerDatabase struct {
	Database       string `json:"db_name"`
	Host           string `json:"host"`
	Port           int    `json:"port"`
	SourceDatabase string `json:"srcdb_name"`
	User           string `json:"force_user"`
	MaxConn        int    `json:"max_connections"`
	CurrConn       int    `json:"current_connections"`
	Paused         bool   `json:"paused"`
	Disabled       bool   `json:"disabled"`

	// following fields present only in schema 1.20 and later
	LoadBalanceHosts string `json:"load_balance_hosts,omitempty"`
	MaxClientConn    int64  `json:"max_client_connections,omitempty"`
	CurrClientConn   int64  `json:"current_client_connections,omitempty"`
}

type PgBouncerPool struct {
	Database  string  `json:"db_name"`
	UserName  string  `json:"user"`
	ClActive  int     `json:"cl_active"`
	ClWaiting int     `json:"cl_waiting"`
	SvActive  int     `json:"sv_active"`
	SvIdle    int     `json:"sv_idle"`
	SvUsed    int     `json:"sv_used"`
	SvTested  int     `json:"sv_tested"`
	SvLogin   int     `json:"sv_login"`
	MaxWait   float64 `json:"maxwait"` // seconds
	Mode      string  `json:"pool_mode"`

	// following fields present only in schema 1.11 and later
	ClCancelReq int `json:"cl_cancel_req,omitempty"` // only in pgbouncer v1.16 & v1.17

	// following fields present only in schema 1.14 and later
	ClActiveCancelReq  int `json:"cl_active_cancel_req,omitempty"`  // only in pgbouncer >= v1.18
	ClWaitingCancelReq int `json:"cl_waiting_cancel_req,omitempty"` // only in pgbouncer >= v1.18
	SvActiveCancel     int `json:"sv_active_cancel,omitempty"`      // only in pgbouncer >= v1.18
	SvBeingCanceled    int `json:"sv_being_canceled,omitempty"`     // only in pgbouncer >= v1.18

	// following fields present only in schema 1.20 and later
	LoadBalanceHosts string `json:"load_balance_hosts,omitempty"` // only in pgbouncer >= v1.24
}

type PgBouncerStat struct {
	Database        string  `json:"db_name"`
	TotalXactCount  int64   `json:"total_xact_count"`
	TotalQueryCount int64   `json:"total_query_count"`
	TotalReceived   int64   `json:"total_received"`   // bytes
	TotalSent       int64   `json:"total_sent"`       // bytes
	TotalXactTime   float64 `json:"total_xact_time"`  // seconds
	TotalQueryTime  float64 `json:"total_query_time"` // seconds
	TotalWaitTime   float64 `json:"total_wait_time"`  // seconds
	AvgXactCount    int64   `json:"avg_xact_count"`
	AvgQueryCount   int64   `json:"avg_query_count"`
	AvgReceived     int64   `json:"avg_received"`   // bytes
	AvgSent         int64   `json:"avg_sent"`       // bytes
	AvgXactTime     float64 `json:"avg_xact_time"`  // seconds
	AvgQueryTime    float64 `json:"avg_query_time"` // seconds
	AvgWaitTime     float64 `json:"avg_wait_time"`  // seconds

	// following fields present only in schema 1.17 and later
	TotalServerAssignmentCount int64 `json:"total_server_assignment_count,omitempty"` // only in pgbouncer >= v1.23
	AvgServerAssignmentCount   int64 `json:"avg_server_assignment_count,omitempty"`   // only in pgbouncer >= v1.23

	// following fields present only in schema 1.20 and later
	TotalClientParseCount int64 `json:"total_client_parse_count,omitempty"` // only in pgbouncer >= v1.24
	TotalServerParseCount int64 `json:"total_server_parse_count,omitempty"` // only in pgbouncer >= v1.24
	TotalBindCount        int64 `json:"total_bind_count,omitempty"`         // only in pgbouncer >= v1.24
	AvgClientParseCount   int64 `json:"avg_client_parse_count,omitempty"`   // only in pgbouncer >= v1.24
	AvgServerParseCount   int64 `json:"avg_server_parse_count,omitempty"`   // only in pgbouncer >= v1.24
	AvgBindCount          int64 `json:"avg_bind_count,omitempty"`           // only in pgbouncer >= v1.24
}

type Pgpool struct {
	Version    string           `json:"version"`
	Backends   []PgpoolBackend  `json:"backends"`
	QueryCache PgpoolQueryCache `json:"query_cache"`
}

type PgpoolBackend struct {
	NodeID                   int     `json:"node_id"`
	Hostname                 string  `json:"hostname"`
	Port                     int     `json:"port"`
	Status                   string  `json:"status"`
	PgStatus                 string  `json:"pg_status,omitempty"` // pgpool >= v4.3
	LBWeight                 float64 `json:"lb_weight"`
	Role                     string  `json:"role"`
	PgRole                   string  `json:"pg_role,omitempty"` // pgpool >= v4.3
	SelectCount              int64   `json:"select_cnt"`
	InsertCount              int64   `json:"insert_cnt,omitempty"` // pgpool >= v4.2
	UpdateCount              int64   `json:"update_cnt,omitempty"` // pgpool >= v4.2
	DeleteCount              int64   `json:"delete_cnt,omitempty"` // pgpool >= v4.2
	DDLCount                 int64   `json:"ddl_cnt,omitempty"`    // pgpool >= v4.2
	OtherCount               int64   `json:"other_cnt,omitempty"`  // pgpool >= v4.2
	PanicCount               int64   `json:"panic_cnt,omitempty"`  // pgpool >= v4.2
	FatalCount               int64   `json:"fatal_cnt,omitempty"`  // pgpool >= v4.2
	ErrorCount               int64   `json:"error_cnt,omitempty"`  // pgpool >= v4.2
	LoadBalanceNode          bool    `json:"load_balance_node"`
	ReplicationDelay         int64   `json:"replication_delay,omitempty"`
	ReplicationState         string  `json:"replication_state,omitempty"`      // pgpool >= v4.1
	ReplicationSyncState     string  `json:"replication_sync_state,omitempty"` // pgpool >= v4.1
	LastStatusChange         int64   `json:"last_status_change"`
	HCTotalCount             int64   `json:"total_count,omitempty"`                  // pgpool >= v4.2
	HCSuccessCount           int64   `json:"success_count,omitempty"`                // pgpool >= v4.2
	HCFailCount              int64   `json:"fail_count,omitempty"`                   // pgpool >= v4.2
	HCSkipCount              int64   `json:"skip_count,omitempty"`                   // pgpool >= v4.2
	HCRetryCount             int64   `json:"retry_count,omitempty"`                  // pgpool >= v4.2
	HCAvgRetryCount          float64 `json:"average_retry_count,omitempty"`          // pgpool >= v4.2
	HCMaxRetryCount          int64   `json:"max_retry_count,omitempty"`              // pgpool >= v4.2
	HCMaxDurationMillis      int64   `json:"max_duration,omitempty"`                 // pgpool >= v4.2
	HCMinDurationMillis      int64   `json:"min_duration,omitempty"`                 // pgpool >= v4.2
	HCAvgDurationMillis      float64 `json:"average_duration,omitempty"`             // pgpool >= v4.2
	HCLastHealthCheck        int64   `json:"last_health_check,omitempty"`            // pgpool >= v4.2
	HCLastSuccessHealthCheck int64   `json:"last_successful_health_check,omitempty"` // pgpool >= v4.2
	HCLastSkipHealthCheck    int64   `json:"last_skip_health_check,omitempty"`       // pgpool >= v4.2
	HCLastFailedHealthCheck  int64   `json:"last_failed_health_check,omitempty"`     // pgpool >= v4.2
	// following fields present only in schema 1.15 and later
	ReplicationDelaySeconds float64 `json:"replication_delay_secs,omitempty"`
}

type PgpoolQueryCache struct {
	NumCacheHits             int64   `json:"num_cache_hits"`
	NumSelects               int64   `json:"num_selects"`
	CacheHitRatio            float64 `json:"cache_hit_ratio"`
	NumHashEntries           int64   `json:"num_hash_entries"`
	UsedHashEntries          int64   `json:"used_hash_entries"`
	NumCacheEntries          int64   `json:"num_cache_entries"`
	UsedCacheEntriesSize     int64   `json:"used_cache_entries_size"`
	FreeCacheEntriesSize     int64   `json:"free_cache_entries_size"`
	FragmentCacheEntriesSize int64   `json:"fragment_cache_entries_size"`
}

type Plan struct {
	Database string `json:"db_name"` // might be empty
	UserName string `json:"user"`    // might be empty
	Format   string `json:"format"`  // text, json, yaml or xml
	At       int64  `json:"at"`      // time when plan was logged, as seconds since epoch
	Query    string `json:"query"`   // the sql query
	Plan     string `json:"plan"`    // the plan as a string

	// following fields present only in schema 1.12 and later
	QueryID int64 `json:"queryid,omitempty"` // query id
}

type Publication struct {
	OID        int    `json:"oid"`
	Name       string `json:"name"`
	DBName     string `json:"db_name"`
	AllTables  bool   `json:"alltables"`
	Insert     bool   `json:"insert"`
	Update     bool   `json:"update"`
	Delete     bool   `json:"delete"`
	TableCount int    `json:"table_count"`
}

type RDS struct {
	Basic    map[string]float64     `json:"basic"`              // Basic Monitoring Metrics
	Enhanced map[string]interface{} `json:"enhanced,omitempty"` // Enhanced Monitoring
}

type ReplicationIn struct {
	Status             string `json:"status"`
	ReceiveStartLSN    string `json:"receive_start_lsn"`
	ReceiveStartTLI    int    `json:"receive_start_tli"`
	ReceivedLSN        string `json:"received_lsn"` // empty in 13.x+
	ReceivedTLI        int    `json:"received_tli"`
	LastMsgSendTime    int64  `json:"last_msg_send_time"`
	LastMsgReceiptTime int64  `json:"last_msg_receipt_time"`
	Latency            int64  `json:"latency_micros"`
	LatestEndLSN       string `json:"latest_end_lsn"`
	LatestEndTime      int64  `json:"latest_end_time"`
	SlotName           string `json:"slot_name"`
	Conninfo           string `json:"conninfo"`
	// following fields present only in schema 1.9 and later (13.x+)
	WrittenLSN string `json:"written_lsn,omitempty"`
	FlushedLSN string `json:"flushed_lsn,omitempty"`
	// following fields present only in schema 1.11 and later
	SenderHost string `json:"sender_host,omitempty"` // >= pg11
}

type ReplicationOut struct {
	RoleName        string `json:"role_name"`
	ApplicationName string `json:"application_name"`
	ClientAddr      string `json:"client_addr"`
	BackendStart    int64  `json:"backend_start"`
	BackendXmin     int    `json:"backend_xmin"`
	State           string `json:"state"`
	SentLSN         string `json:"sent_lsn"`
	WriteLSN        string `json:"write_lsn"`
	FlushLSN        string `json:"flush_lsn"`
	ReplayLSN       string `json:"replay_lsn"`
	WriteLag        int    `json:"write_lag"`  // only in 10.x
	FlushLag        int    `json:"flush_lag"`  // only in 10.x
	ReplayLag       int    `json:"replay_lag"` // only in 10.x
	SyncPriority    int    `json:"sync_priority"`
	SyncState       string `json:"sync_state"`
	// following fields present only in schema 1.5 and later
	PID int `json:"pid,omitempty"`
	// following fields present only in schema 1.11 and later
	ReplyTime int64 `json:"reply_time,omitempty"` // >= pg12
}

type ReplicationSlot struct {
	SlotName          string `json:"slot_name"`
	Plugin            string `json:"plugin"`
	SlotType          string `json:"slot_type"`
	DBName            string `json:"db_name"`
	Active            bool   `json:"active"`
	Xmin              int    `json:"xmin"`
	CatalogXmin       int    `json:"catalog_xmin"`
	RestartLSN        string `json:"restart_lsn"`
	ConfirmedFlushLSN string `json:"confirmed_flush_lsn"`
	Temporary         bool   `json:"temporary"`
	// following fields present only in schema 1.11 and later
	WALStatus   string `json:"wal_status,omitempty"`    // >= pg13
	SafeWALSize int64  `json:"safe_wal_size,omitempty"` // >= pg13
	TwoPhase    bool   `json:"two_phase,omitempty"`     // >= pg14
	// following fields present only in schema 1.16 and later
	Conflicting bool `json:"conflicting,omitempty"` // >= pg16
}

type Role struct {
	OID            int      `json:"oid"`
	Name           string   `json:"name"`
	Rolsuper       bool     `json:"rolsuper"`
	Rolinherit     bool     `json:"rolinherit"`
	Rolcreaterole  bool     `json:"rolcreaterole"`
	Rolcreatedb    bool     `json:"rolcreatedb"`
	Rolcanlogin    bool     `json:"rolcanlogin"`
	Rolreplication bool     `json:"rolreplication"`
	Rolbypassrls   bool     `json:"rolbypassrls"`
	Rolconnlimit   int      `json:"rolconnlimit"`
	Rolvaliduntil  int64    `json:"rolvaliduntil"`
	MemberOf       []string `json:"memberof"`
}

type Sequence struct {
	OID        int    `json:"oid"`
	DBName     string `json:"db_name"`
	SchemaName string `json:"schema_name"`
	Name       string `json:"name"`
	BlksRead   int64  `json:"blks_read"`
	BlksHit    int64  `json:"blks_hit"`
}

type Setting struct {
	Setting string `json:"setting"`
	BootVal string `json:"bootval,omitempty"`
	Source  string `json:"source,omitempty"`
	// following fields present only in schema 1.11 and later
	Pending bool `json:"pending,omitempty"`
}

type StatIO struct {
	BackendType   string  `json:"backend_type"`
	Object        string  `json:"object"`
	Context       string  `json:"context"`
	Reads         int64   `json:"reads"`
	ReadBytes     int64   `json:"read_bytes"`
	ReadTime      float64 `json:"read_time"` // in milliseconds
	Writes        int64   `json:"writes"`
	WriteBytes    int64   `json:"write_bytes"`
	WriteTime     float64 `json:"write_time"` // in milliseconds
	Extends       int64   `json:"extends"`
	ExtendBytes   int64   `json:"extend_bytes"`
	ExtendTime    float64 `json:"extend_time"` // in milliseconds
	Writebacks    int64   `json:"writebacks"`
	WritebackTime float64 `json:"writeback_time"` // in milliseconds
	Hits          int64   `json:"hits"`
	Evictions     int64   `json:"evictions"`
	Reuses        int64   `json:"reuses"`
	Fsyncs        int64   `json:"fsyncs"`
	FsyncTime     float64 `json:"fsync_time"` // in milliseconds
	StatsReset    int64   `json:"stats_reset"`
}

type Statement struct {
	UserOID           int     `json:"useroid"`             // OID of user who executed the statement
	UserName          string  `json:"user"`                // Name of the user corresponding to useroid (might be empty)
	DBOID             int     `json:"db_oid"`              // OID of database in which the statement was executed
	DBName            string  `json:"db_name"`             // Name of the database corresponding to db_oid
	QueryID           int64   `json:"queryid"`             // Internal hash code, computed from the statement's parse tree
	Query             string  `json:"query"`               // Text of a representative statement
	Calls             int64   `json:"calls"`               // Number of times executed
	TotalTime         float64 `json:"total_time"`          // == total_exec_time in pg >= v13
	MinTime           float64 `json:"min_time"`            // == min_exec_time in pg >= v13
	MaxTime           float64 `json:"max_time"`            // == man_exec_time in pg >= v13
	StddevTime        float64 `json:"stddev_time"`         // == stddev_exec_time in pg >= v13
	Rows              int64   `json:"rows"`                // Total number of rows retrieved or affected by the statement
	SharedBlksHit     int64   `json:"shared_blks_hit"`     // Total number of shared block cache hits by the statement
	SharedBlksRead    int64   `json:"shared_blks_read"`    // Total number of shared blocks read by the statement
	SharedBlksDirtied int64   `json:"shared_blks_dirtied"` // Total number of shared blocks dirtied by the statement
	SharedBlksWritten int64   `json:"shared_blks_written"` // Total number of shared blocks written by the statement
	LocalBlksHit      int64   `json:"local_blks_hit"`      // Total number of local block cache hits by the statement
	LocalBlksRead     int64   `json:"local_blks_read"`     // Total number of local blocks read by the statement
	LocalBlksDirtied  int64   `json:"local_blks_dirtied"`  // Total number of local blocks dirtied by the statement
	LocalBlksWritten  int64   `json:"local_blks_written"`  // Total number of local blocks written by the statement
	TempBlksRead      int64   `json:"temp_blks_read"`      // Total number of temp blocks read by the statement
	TempBlksWritten   int64   `json:"temp_blks_written"`   // Total number of temp blocks written by the statement
	BlkReadTime       float64 `json:"blk_read_time"`       // == shared_blk_read_time in pg >= v17
	BlkWriteTime      float64 `json:"blk_write_time"`      // == shared_blk_write_time in pg >= v17
	// following fields present only in schema 1.10 and later (for Postgres v13+)
	Plans          int64   `json:"plans"`            // Number of times the statement was planned
	TotalPlanTime  float64 `json:"total_plan_time"`  // Total time spent planning the statement, in milliseconds
	MinPlanTime    float64 `json:"min_plan_time"`    // Minimum time spent planning the statement, in milliseconds
	MaxPlanTime    float64 `json:"max_plan_time"`    // Maximum time spent planning the statement, in milliseconds
	StddevPlanTime float64 `json:"stddev_plan_time"` // Population standard deviation of time spent planning the statement, in milliseconds
	WALRecords     int64   `json:"wal_records"`      // Total number of WAL records generated by the statement
	WALFPI         int64   `json:"wal_fpi"`          // Total number of WAL full page images generated by the statement
	WALBytes       int64   `json:"wal_bytes"`        // Total amount of WAL bytes generated by the statement
	// following fields present only in schema 1.17 and later
	TopLevel             bool    `json:"toplevel,omitempty"`               // pg >= v14
	TempBlkReadTime      float64 `json:"temp_blk_read_time,omitempty"`     // pg >= v15
	TempBlkWriteTime     float64 `json:"temp_blk_write_time,omitempty"`    // pg >= v15
	JITFuntions          int64   `json:"jit_functions,omitempty"`          // pg >= v15
	JITGenerationTime    float64 `json:"jit_generation_time,omitempty"`    // pg >= v15
	JITInliningCount     int64   `json:"jit_inlining_count,omitempty"`     // pg >= v15
	JITInliningTime      float64 `json:"jit_inlining_time,omitempty"`      // pg >= v15
	JITOptimizationCount int64   `json:"jit_optimization_count,omitempty"` // pg >= v15
	JITOptimizationTime  float64 `json:"jit_optimization_time,omitempty"`  // pg >= v15
	JITEmissionCount     int64   `json:"jit_emission_count,omitempty"`     // pg >= v15
	JITEmissionTime      float64 `json:"jit_emission_time,omitempty"`      // pg >= v15
	LocalBlkReadTime     float64 `json:"local_blk_read_time,omitempty"`    // pg >= v17
	LocalBlkWriteTime    float64 `json:"local_blk_write_time,omitempty"`   // pg >= v17
	JITDeformCount       int64   `json:"jit_deform_count,omitempty"`       // pg >= v17
	JITDeformTime        float64 `json:"jit_deform_time,omitempty"`        // pg >= v17
	StatsSince           int64   `json:"stats_since,omitempty"`            // pg >= v17
	MinMaxStatsSince     int64   `json:"minmax_stats_since,omitempty"`     // pg >= v17
	// following fields present only in schema 1.19 and later
	WALBuffersFull          int64 `json:"wal_buffers_full,omitempty"`           // pg >= v18
	ParallelWorkersToLaunch int64 `json:"parallel_workers_to_launch,omitempty"` // pg >= v18
	ParallelWorkersLaunched int64 `json:"parallel_workers_launched,omitempty"`  // pg >= v18
}

type Subscription struct {
	OID                int    `json:"oid"`
	Name               string `json:"name"`
	DBName             string `json:"db_name"`
	Enabled            bool   `json:"enabled"`
	PubCount           int    `json:"pub_count"`
	TableCount         int    `json:"table_count"`
	WorkerCount        int    `json:"worker_count"`
	ReceivedLSN        string `json:"received_lsn"`
	LatestEndLSN       string `json:"latest_end_lsn"`
	LastMsgSendTime    int64  `json:"last_msg_send_time"`
	LastMsgReceiptTime int64  `json:"last_msg_receipt_time"`
	LatestEndTime      int64  `json:"latest_end_time"`
	Latency            int64  `json:"latency_micros"`
	// following fields present only in schema 1.13 and later
	ApplyErrorCount int `json:"apply_error_count,omitempty"` // >= pg15
	SyncErrorCount  int `json:"sync_error_count,omitempty"`  // >= pg15
	// following fields present only in schema 1.20 and later
	ConflInsertExists           int64 `json:"confl_insert_exists,omitempty"`             // >= pg18
	ConflUpdateOriginDiffers    int64 `json:"confl_update_origin_differs,omitempty"`     // >= pg18
	ConflUpdateExists           int64 `json:"confl_update_exists,omitempty"`             // >= pg18
	ConflUpdateMissing          int64 `json:"confl_update_missing,omitempty"`            // >= pg18
	ConflDeleteOriginDiffers    int64 `json:"confl_delete_origin_differs,omitempty"`     // >= pg18
	ConflDeleteMissing          int64 `json:"confl_delete_missing,omitempty"`            // >= pg18
	ConflMultipleUniqueConflict int64 `json:"confl_multiple_unique_conflicts,omitempty"` // >= pg18
}

type SystemMetrics struct {
	CPUModel   string  `json:"cpu_model,omitempty"` // model of the CPU
	NumCores   int     `json:"num_cores"`           // number of cores
	LoadAvg    float64 `json:"loadavg"`             // 1-minute load average from the OS
	MemUsed    int64   `json:"memused"`             // used RAM, in bytes
	MemFree    int64   `json:"memfree"`             // free RAM, in bytes
	MemBuffers int64   `json:"membuffers"`          // RAM used for buffers, in bytes
	MemCached  int64   `json:"memcached"`           // RAM used for cache, in bytes
	SwapUsed   int64   `json:"swapused"`            // used swap memory in bytes, 0 if no swap
	SwapFree   int64   `json:"swapfree"`            // free swap memory in bytes, 0 if no swap
	Hostname   string  `json:"hostname"`            // hostname from the OS
	// following fields present only in schema 1.8 and later
	MemSlab int64 `json:"memslab"` // RAM used for slab in bytes
}

type Table struct {
	OID              int    `json:"oid"`
	DBName           string `json:"db_name"`
	SchemaName       string `json:"schema_name"`
	Name             string `json:"name"`
	SeqScan          int64  `json:"seq_scan"`
	SeqTupRead       int64  `json:"seq_tup_read"`
	IdxScan          int64  `json:"idx_scan"`
	IdxTupFetch      int64  `json:"idx_tup_fetch"`
	NTupIns          int64  `json:"n_tup_ins"`
	NTupUpd          int64  `json:"n_tup_upd"`
	NTupDel          int64  `json:"n_tup_del"`
	NTupHotUpd       int64  `json:"n_tup_hot_upd"`
	NLiveTup         int64  `json:"n_live_tup"`
	NDeadTup         int64  `json:"n_dead_tup"`
	NModSinceAnalyze int64  `json:"n_mod_since_analyze"`
	LastVacuum       int64  `json:"last_vacuum"`
	LastAutovacuum   int64  `json:"last_autovacuum"`
	LastAnalyze      int64  `json:"last_analyze"`
	LastAutoanalyze  int64  `json:"last_autoanalyze"`
	VacuumCount      int64  `json:"vacuum_count"`
	AutovacuumCount  int64  `json:"autovacuum_count"`
	AnalyzeCount     int64  `json:"analyze_count"`
	AutoanalyzeCount int64  `json:"autoanalyze_count"`
	HeapBlksRead     int64  `json:"heap_blks_read"`
	HeapBlksHit      int64  `json:"heap_blks_hit"`
	IdxBlksRead      int64  `json:"idx_blks_read"`
	IdxBlksHit       int64  `json:"idx_blks_hit"`
	ToastBlksRead    int64  `json:"toast_blks_read"`
	ToastBlksHit     int64  `json:"toast_blks_hit"`
	TidxBlksRead     int64  `json:"tidx_blks_read"`
	TidxBlksHit      int64  `json:"tidx_blks_hit"`
	Size             int64  `json:"size"`
	Bloat            int64  `json:"bloat"`
	// following fields present only in schema 1.2 and later
	RelKind         string `json:"relkind"`
	RelPersistence  string `json:"relpersistence"`
	RelNAtts        int    `json:"relnatts"`
	AgeRelFrozenXid int    `json:"age_relfrozenxid"`
	RelIsPartition  bool   `json:"relispartition"`
	TablespaceName  string `json:"tablespace_name"`
	ParentName      string `json:"parent_name"`
	PartitionCV     string `json:"partition_cv"` // partition constraint value
	// following fields present only in schema 1.7 and later
	ACL string `json:"acl,omitempty"`
	// following fields present only in schema 1.11 and later
	NInsSinceVacuum int64 `json:"n_ins_since_vacuum,omitempty"` // pg >= v13
	// following fields present only in schema 1.16 and later
	LastSeqScan    int64 `json:"last_seq_scan,omitempty"`     // pg >= v16
	LastIdxScan    int64 `json:"last_idx_scan,omitempty"`     // pg >= v16
	NTupNewpageUpd int64 `json:"n_tup_newpage_upd,omitempty"` // pg >= v16
	// following fields present only in schema 1.19 and later
	TotalVacuumTime      float64 `json:"total_vacuum_time,omitempty"`      // millisecs, pg >= v18
	TotalAutovacuumTime  float64 `json:"total_autovacuum_time,omitempty"`  // millisecs, pg >= v18
	TotalAnalyzeTime     float64 `json:"total_analyze_time,omitempty"`     // millisecs, pg >= v18
	TotalAutoanalyzeTime float64 `json:"total_autoanalyze_time,omitempty"` // millisecs, pg >= v18
}

type Tablespace struct {
	OID         int    `json:"oid"`
	Name        string `json:"name"`
	Owner       string `json:"owner"`
	Location    string `json:"location"`
	Size        int64  `json:"size"`
	DiskUsed    int64  `json:"disk_used"`
	DiskTotal   int64  `json:"disk_total"`
	InodesUsed  int64  `json:"inodes_used"`
	InodesTotal int64  `json:"inodes_total"`
}

type Trigger struct {
	OID        int    `json:"oid"`
	DBName     string `json:"db_name"`
	SchemaName string `json:"schema_name"`
	TableName  string `json:"table_name"`
	Name       string `json:"name"`
	ProcName   string `json:"proc_name"`
}

type UserFunction struct {
	OID        int     `json:"oid"`
	SchemaName string  `json:"schema_name"`
	DBName     string  `json:"db_name"`
	Name       string  `json:"name"`
	Calls      int64   `json:"calls"`
	TotalTime  float64 `json:"total_time"`
	SelfTime   float64 `json:"self_time"`
}

type VacuumProgressBackend struct {
	DBName           string `json:"db_name"`
	TableOID         int    `json:"table_oid"`
	TableName        string `json:"table_name"`
	Phase            string `json:"phase"`
	HeapBlksTotal    int64  `json:"heap_blks_total"`
	HeapBlksScanned  int64  `json:"heap_blks_scanned"`
	HeapBlksVacuumed int64  `json:"heap_blks_vacuumed"`
	IndexVacuumCount int64  `json:"index_vacuum_count"`
	MaxDeadTuples    int64  `json:"max_dead_tuples"` // pg <= v16
	NumDeadTuples    int64  `json:"num_dead_tuples"` // pg <= v16
	// following fields present only in schema 1.12 and later
	PID int `json:"pid,omitempty"`
	// following fields present only in schema 1.17 and later
	MaxDeadTupleBytes int64 `json:"max_dead_tuple_bytes"`        // pg >= v17
	DeadTupleBytes    int64 `json:"dead_tuple_bytess"`           // pg >= v17
	NumDeadItemIDs    int64 `json:"num_dead_item_ids,omitempty"` // pg >= v17
	IndexesTotal      int64 `json:"indexes_total,omitempty"`     // pg >= v17
	IndexesProcessed  int64 `json:"indexes_processed,omitempty"` // pg >= v17
	// following fields present only in schema 1.19 and later
	DelayTime float64 `json:"delay_time,omitempty"` // millisecs, pg >= v18
}

type WAL struct {
	Records     int64   `json:"records"`
	FPI         int64   `json:"fpi"`
	Bytes       int64   `json:"bytes"`
	BuffersFull int64   `json:"buffers_full"`
	Write       int64   `json:"write"`      // 0 in pg >= 18
	Sync        int64   `json:"sync"`       // 0 in pg >= 18
	WriteTime   float64 `json:"write_time"` // in milliseconds, 0 in pg >= 18
	SyncTime    float64 `json:"sync_time"`  // in milliseconds, 0 in pg >= 18
	StatsReset  int64   `json:"stats_reset"`
}

type WALArchiving struct {
	ArchivedCount    int    `json:"archived_count"`
	LastArchivedWAL  string `json:"last_archived_wal"`
	LastArchivedTime int64  `json:"last_archived_time"`
	FailedCount      int    `json:"failed_count"`
	LastFailedWAL    string `json:"last_failed_wal"`
	LastFailedTime   int64  `json:"last_failed_time"`
	StatsReset       int64  `json:"stats_reset"`
}