pgstats

type Option func(*connection) error

type PgStatActivityRow struct {
	// OID of the database this backend is connected to
	Datid nullable.Int64 `json:"datid"`
	// Name of the database this backend is connected to
	Datname nullable.String `json:"datname"`
	// Process ID of this backend
	Pid int64 `json:"pid"`
	// OID of the user logged into this backend
	Usesysid nullable.Int64 `json:"usesysid"`
	// Name of the user logged into this backend
	Usename nullable.String `json:"usename"`
	// Name of the application that is connected to this backend
	ApplicationName nullable.String `json:"application_name"`
	// IP address of the client connected to this backend.
	// If this field is null, it indicates either that the client is connected via a Unix socket on the server machine
	// or that this is an internal process such as autovacuum.
	ClientAddr nullable.String `json:"client_addr"`
	// Host name of the connected client, as reported by a reverse DNS lookup of client_addr.
	// This field will only be non-null for IP connections, and only when log_hostname is enabled.
	ClientHostname nullable.String `json:"client_hostname"`
	// TCP port number that the client is using for communication with this backend,
	// or -1 if a Unix socket is used
	ClientPort nullable.Int64 `json:"client_port"`
	// Time when this process was started.
	// For client backends, this is the time the client connected to the server.
	BackendStart nullable.Time `json:"backend_start"`
	// Time when this process' current transaction was started,
	// or null if no transaction is active.
	// If the current query is the first of its transaction, this column is equal to the query_start column.
	XactStart nullable.Time `json:"xact_start"`
	// Time when the currently active query was started,
	// or if state is not active, when the last query was started
	QueryStart nullable.Time `json:"query_start"`
	// ime when the state was last changed
	StateChange nullable.Time `json:"state_change"`
	// The type of event for which the backend is waiting, if any; otherwise NULL.
	// Supported since PostgreSQL 9.6.
	// For possible values, see:
	// https://www.postgresql.org/docs/current/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW
	WaitEventType nullable.String `json:"wait_event_type"`
	// Wait event name if backend is currently waiting, otherwise NULL.
	// Supported since PostgreSQL 9.6.
	// For details, see:
	// https://www.postgresql.org/docs/current/monitoring-stats.html#WAIT-EVENT-TABLE
	WaitEvent nullable.String `json:"wait_event"`
	// True if this backend is currently waiting on a lock.
	// Supported until PostgreSQL 9.5 (inclusive).
	Waiting nullable.Bool `json:"waiting"`
	// Current overall state of this backend.
	// For possible values, see:
	// https://www.postgresql.org/docs/current/monitoring-stats.html#PG-STAT-ACTIVITY-VIEW
	State nullable.String `json:"state"`
	// Top-level transaction identifier of this backend, if any.
	BackendXid nullable.Int64 `json:"backend_xid"`
	// The current backend's xmin horizon.
	BackendXmin nullable.Int64 `json:"backend_xmin"`
	// Text of this backend's most recent query.
	// If state is active this field shows the currently executing query.
	// In all other states, it shows the last query that was executed.
	// By default the query text is truncated at 1024 characters;
	// this value can be changed via the parameter track_activity_query_size.
	Query nullable.String `json:"query"`
	// Type of current backend.
	// Possible types are autovacuum launcher, autovacuum worker, logical replication launcher,
	// logical replication worker, parallel worker, background writer, client backend, checkpointer,
	// startup, walreceiver, walsender and walwriter.
	// In addition, background workers registered by extensions may have additional types.
	// Supported since PostgreSQL 10
	BackendType nullable.String `json:"backend_type"`
}

type PgStatActivityView []PgStatActivityRow

type PgStatAllIndexesView []PgStatIndexesRow

type PgStatAllTablesView []PgStatTablesRow

type PgStatArchiverView struct {
	// Number of WAL files that have been successfully archived
	ArchivedCount nullable.Int64 `json:"archived_count"`
	// Name of the last WAL file successfully archived
	LastArchivedWal nullable.String `json:"last_archived_wal"`
	// Time of the last successful archive operation
	LastArchivedTime nullable.Time `json:"last_archived_time"`
	// Number of failed attempts for archiving WAL files
	FailedCount nullable.Int64 `json:"failed_count"`
	// Name of the WAL file of the last failed archival operation
	LastFailedWal nullable.String `json:"last_failed_wal"`
	// Time of the last failed archival operation
	LastFailedTime nullable.Time `json:"last_failed_time"`
	// Time at which these statistics were last reset
	StatsReset nullable.Time `json:"stats_reset"`
}

type PgStatBgWriterView struct {
	// Number of scheduled checkpoints that have been performed
	CheckpointsTimed nullable.Int64 `json:"checkpoints_timed"`
	// Number of requested checkpoints that have been performed
	CheckpointsReq nullable.Int64 `json:"checkpoints_req"`
	// Total amount of time that has been spent in the portion of checkpoint processing
	// where files are written to disk, in milliseconds
	CheckpointWriteTime nullable.Float64 `json:"checkpoint_write_time"`
	// Total amount of time that has been spent in the portion of checkpoint processing
	// where files are synchronized to disk, in milliseconds
	CheckpointSyncTime nullable.Float64 `json:"checkpoint_sync_time"`
	// Number of buffers written during checkpoints
	BuffersCheckpoint nullable.Int64 `json:"buffers_checkpoint"`
	// Number of buffers written by the background writer
	BuffersClean nullable.Int64 `json:"buffers_clean"`
	// Number of times the background writer stopped a cleaning scan because it had written too many buffers
	MaxWrittenClean nullable.Int64 `json:"maxwritten_clean"`
	// Number of buffers written directly by a backend
	BuffersBackend nullable.Int64 `json:"buffers_backend"`
	// Number of times a backend had to execute its own fsync call
	// (normally the background writer handles those even when the backend does its own write)
	BuffersBackendFsync nullable.Int64 `json:"buffers_backend_fsync"`
	// Number of buffers allocated
	BuffersAlloc nullable.Int64 `json:"buffers_alloc"`
	// Time at which these statistics were last reset
	StatsReset nullable.Time `json:"stats_reset"`
}

type PgStatDatabaseConflictsRow struct {
	// OID of a database
	Datid int64 `json:"datid"`
	// Name of this database
	Datname string `json:"datname"`
	// Number of queries in this database that have been canceled due to dropped tablespaces
	ConflTablespace nullable.Int64 `json:"confl_tablespace"`
	// Number of queries in this database that have been canceled due to lock timeouts
	ConflLock nullable.Int64 `json:"confl_lock"`
	// Number of queries in this database that have been canceled due to old snapshots
	ConflSnapshot nullable.Int64 `json:"confl_snapshot"`
	// Number of queries in this database that have been canceled due to pinned buffers
	ConflBufferpin nullable.Int64 `json:"confl_bufferpin"`
	// Number of queries in this database that have been canceled due to deadlocks
	ConflDeadlock nullable.Int64 `json:"confl_deadlock"`
}

type PgStatDatabaseConflictsView []PgStatDatabaseConflictsRow

type PgStatDatabaseRow struct {
	// OID of a database
	Datid int64 `json:"datid"`
	// Name of this database
	Datname string `json:"datname"`
	// Number of backends currently connected to this database.
	// This is the only column in this view that returns a value reflecting current state;
	// all other columns return the accumulated values since the last reset.
	NumBackends int64 `json:"numbackends"`
	// Number of transactions in this database that have been committed
	XactCommit nullable.Int64 `json:"xact_commit"`
	//	Number of transactions in this database that have been rolled back
	XactRollback nullable.Int64 `json:"xact_rollback"`
	// Number of disk blocks read in this database
	BlksRead nullable.Int64 `json:"blks_read"`
	// Number of times disk blocks were found already in the buffer cache, so that a read was not necessary
	// (this only includes hits in the PostgreSQL buffer cache, not the operating system's file system cache)
	BlksHit nullable.Int64 `json:"blks_hit"`
	// Number of rows returned by queries in this database
	TupReturned nullable.Int64 `json:"tup_returned"`
	// Number of rows fetched by queries in this database
	TupFetched nullable.Int64 `json:"tup_fetched"`
	// Number of rows inserted by queries in this database
	TupInserted nullable.Int64 `json:"tup_inserted"`
	// Number of rows updated by queries in this database
	TupUpdated nullable.Int64 `json:"tup_updated"`
	// 	Number of rows deleted by queries in this database
	TupDeleted nullable.Int64 `json:"tup_deleted"`
	// Number of queries canceled due to conflicts with recovery in this database.
	// (Conflicts occur only on standby servers; see pg_stat_database_conflicts for details.)
	Conflicts nullable.Int64 `json:"conflicts"`
	// Number of temporary files created by queries in this database.
	// All temporary files are counted,
	// regardless of why the temporary file was created (e.g., sorting or hashing),
	// and regardless of the log_temp_files setting.
	TempFiles nullable.Int64 `json:"temp_files"`
	// Total amount of data written to temporary files by queries in this database.
	// All temporary files are counted,
	// regardless of why the temporary file was created,
	// and regardless of the log_temp_files setting.
	TempBytes nullable.Int64 `json:"temp_bytes"`
	// Number of deadlocks detected in this database
	Deadlocks nullable.Int64 `json:"deadlocks"`
	// Time spent reading data file blocks by backends in this database, in milliseconds
	BlkReadTime nullable.Float64 `json:"blk_read_time"`
	// Time spent writing data file blocks by backends in this database, in milliseconds
	BlkWriteTime nullable.Float64 `json:"blk_write_time"`
	// Time at which these statistics were last reset
	StatsReset nullable.Time `json:"stats_reset"`
}

type PgStatDatabaseView []PgStatDatabaseRow

type PgStatFunctionsRow struct {
	// OID of a function
	Funcid int64 `json:"funcid"`
	// Name of the schema this function is in
	Schemaname string `json:"schemaname"`
	// Name of this function
	Funcname string `json:"funcname"`
	// Number of times this function has been called
	Calls nullable.Int64 `json:"calls"`
	// Total time spent in this function and all other functions called by it, in milliseconds
	TotalTime nullable.Float64 `json:"total_time"`
	// Total time spent in this function itself, not including other functions called by it, in milliseconds
	SelfTime nullable.Float64 `json:"self_time"`
}

type PgStatIndexesRow struct {
	// OID of the table for this index
	Relid int64 `json:"relid"`
	// OID of this index
	Indexrelid int64 `json:"indexrelid"`
	// Name of the schema this index is in
	Schemaname string `json:"schemaname"`
	// Name of the table for this index
	Relname string `json:"relname"`
	// Name of this index
	Indexrelname string `json:"indexrelname"`
	// Number of index scans initiated on this index
	IdxScan nullable.Int64 `json:"idx_scan"`
	// Number of index entries returned by scans on this index
	IdxTupRead nullable.Int64 `json:"idx_tup_read"`
	// Number of live table rows fetched by simple index scans using this index
	IdxTupFetch nullable.Int64 `json:"idx_tup_fetch"`
}

type PgStatIoAllIndexesView []PgStatIoIndexesRow

type PgStatIoAllSequencesView []PgStatIoSequencesRow

type PgStatIoAllTablesView []PgStatIoTablesRow

type PgStatIoIndexesRow struct {
	// OID of the table for this index
	Relid int64 `json:"relid"`
	// OID of this index
	Indexrelid int64 `json:"indexrelid"`
	// Name of the schema this index is in
	Schemaname string `json:"schemaname"`
	// Name of the table for this index
	Relname string `json:"relname"`
	// Name of this index
	Indexrelname string `json:"indexrelname"`
	// Number of disk blocks read from this index
	IdxBlksRead nullable.Int64 `json:"idx_blks_read"`
	// Number of buffer hits in this index
	IdxBlksHit nullable.Int64 `json:"idx_blks_hit"`
}

type PgStatIoSequencesRow struct {
	// OID of a sequence
	Relid int64 `json:"relid"`
	// Name of the schema this sequence is in
	Schemaname string `json:"schemaname"`
	// Name of this sequence
	Relname string `json:"relname"`
	// Number of disk blocks read from this sequence
	BlksRead nullable.Int64 `json:"blks_read"`
	// Number of buffer hits in this sequence
	BlksHit nullable.Int64 `json:"blks_hit"`
}

type PgStatIoSystemIndexesView []PgStatIoIndexesRow

type PgStatIoSystemSequencesView []PgStatIoSequencesRow

type PgStatIoSystemTablesView []PgStatIoTablesRow

type PgStatIoTablesRow struct {
	// OID of a table
	Relid int64 `json:"relid"`
	// Name of the schema that this table is in
	Schemaname string `json:"schemaname"`
	// Name of this table
	Relname string `json:"relname"`
	// Number of disk blocks read from this table
	HeapBlksRead nullable.Int64 `json:"heap_blks_read"`
	// Number of buffer hits in this table
	HeapBlksHit nullable.Int64 `json:"heap_blks_hit"`
	// Number of disk blocks read from all indexes on this table
	IdxBlksRead nullable.Int64 `json:"idx_blks_read"`
	// Number of buffer hits in all indexes on this table
	IdxBlksHit nullable.Int64 `json:"idx_blks_hit"`
	// Number of disk blocks read from this table's TOAST table (if any)
	ToastBlksRead nullable.Int64 `json:"toast_blks_read"`
	// Number of buffer hits in this table's TOAST table (if any)
	ToastBlksHit nullable.Int64 `json:"toast_blks_hit"`
	// Number of disk blocks read from this table's TOAST table indexes (if any)
	TidxBlksRead nullable.Int64 `json:"tidx_blks_read"`
	// Number of buffer hits in this table's TOAST table indexes (if any)
	TidxBlksHit nullable.Int64 `json:"tidx_blks_hit"`
}

type PgStatIoUserIndexesView []PgStatIoIndexesRow

type PgStatIoUserSequencesView []PgStatIoSequencesRow

type PgStatIoUserTablesView []PgStatIoTablesRow

type PgStatProgressVacuumRow struct {
	// Process ID of backend.
	Pid int64 `json:"pid"`
	// OID of the database to which this backend is connected.
	Datid int64 `json:"datid"`
	// Name of the database to which this backend is connected.
	Datname string `json:"datname"`
	// OID of the table being vacuumed.
	Relid int64 `json:"relid"`
	// Current processing phase of vacuum. See:
	// https://www.postgresql.org/docs/current/progress-reporting.html#VACUUM-PHASES
	Phase string `json:"phase"`
	// Total number of heap blocks in the table. This number is reported as of the beginning of the scan;
	// blocks added later will not be (and need not be) visited by this VACUUM.
	HeapBlksTotal nullable.Int64 `json:"heap_blks_total"`
	// Number of heap blocks scanned.
	// Because the visibility map is used to optimize scans, some blocks will be skipped without inspection;
	// skipped blocks are included in this total, so that this number will eventually become equal to heap_blks_total
	// when the vacuum is complete. This counter only advances when the phase is scanning heap.
	HeapBlksScanned nullable.Int64 `json:"heap_blks_scanned"`
	// Number of heap blocks vacuumed. Unless the table has no indexes, this counter only advances when the phase is vacuuming heap.
	// Blocks that contain no dead tuples are skipped, so the counter may sometimes skip forward in large increments.
	HeapBlksVacuumed nullable.Int64 `json:"heap_blks_vacuumed"`
	// Number of completed index vacuum cycles.
	IndexVacuumCount nullable.Int64 `json:"index_vacuum_count"`
	// Number of dead tuples that we can store before needing to perform an index vacuum cycle, based on maintenance_work_mem.
	MaxDeadTuples nullable.Int64 `json:"max_dead_tuples"`
	// Number of dead tuples collected since the last index vacuum cycle.
	NumDeadTuples nullable.Int64 `json:"num_dead_tuples"`
}

type PgStatProgressVacuumView []PgStatProgressVacuumRow

type PgStatReplicationRow struct {
	// Process ID of a WAL sender process
	Pid int64 `json:"pid"`
	// OID of the user logged into this WAL sender process
	Usesysid nullable.Int64 `json:"usesysid"`
	// Name of the user logged into this WAL sender process
	Usename nullable.String `json:"usename"`
	// Name of the application that is connected to this WAL sender
	ApplicationName nullable.String `json:"application_name"`
	// IP address of the client connected to this WAL sender.
	// If this field is null, it indicates that the client is connected via a Unix socket on the server machine.
	ClientAddr nullable.String `json:"client_addr"`
	// Host name of the connected client, as reported by a reverse DNS lookup of client_addr.
	// This field will only be non-null for IP connections, and only when log_hostname is enabled.
	ClientHostname nullable.String `json:"client_hostname"`
	// TCP port number that the client is using for communication with this WAL sender, or -1 if a Unix socket is used
	ClientPort nullable.Int64 `json:"client_port"`
	// Time when this process was started, i.e., when the client connected to this WAL sender
	BackendStart nullable.Time `json:"backend_start"`
	// This standby's xmin horizon reported by hot_standby_feedback - see:
	// https://www.postgresql.org/docs/current/runtime-config-replication.html#GUC-HOT-STANDBY-FEEDBACK
	BackendXmin nullable.Int64 `json:"backend_xmin"`
	// Current WAL sender state.
	// For possible values, see:
	// https://www.postgresql.org/docs/current/monitoring-stats.html#PG-STAT-REPLICATION-VIEW
	State nullable.String `json:"state"`
	// Last write-ahead log location sent on this connection
	SentLsn nullable.Int64 `json:"sent_lsn"`
	// Last write-ahead log location written to disk by this standby server
	WriteLsn nullable.Int64 `json:"write_lsn"`
	// Last write-ahead log location flushed to disk by this standby server
	FlushLsn nullable.Int64 `json:"flush_lsn"`
	// Last write-ahead log location replayed into the database on this standby server
	ReplayLsn nullable.Int64 `json:"replay_lsn"`
	// Time elapsed between flushing recent WAL locally and receiving notification that this standby server
	// has written it (but not yet flushed it or applied it). This can be used to gauge the delay
	// that synchronous_commit level remote_write incurred while committing
	// if this server was configured as a synchronous standby.
	// Supported since PostgreSQL 10
	WriteLag nullable.Time `json:"write_lag"`
	// Time elapsed between flushing recent WAL locally and receiving notification that this standby server
	// has written 	// and flushed it (but not yet applied it). This can be used to gauge the delay
	// that synchronous_commit level on incurred while committing
	// if this server was configured as a synchronous standby.
	// Supported since PostgreSQL 10
	FlushLag nullable.Time `json:"flush_lag"`
	// Time elapsed between flushing recent WAL locally and receiving notification that this standby server
	// has written, flushed and applied it. This can be used to gauge the delay
	// that synchronous_commit level remote_apply incurred while committing
	// if this server was configured as a synchronous standby.
	// Supported since PostgreSQL 10
	ReplayLag nullable.Time `json:"replay_lag"`
	// Priority of this standby server for being chosen as the synchronous standby
	// in a priority-based synchronous replication. This has no effect in a quorum-based synchronous replication.
	SyncPriority nullable.Int64 `json:"sync_priority"`
	// Synchronous state of this standby server.
	// For possible values, see:
	// https://www.postgresql.org/docs/current/monitoring-stats.html#PG-STAT-REPLICATION-VIEW
	SyncState nullable.String `json:"sync_state"`
}

type PgStatReplicationView []PgStatReplicationRow

type PgStatSslRow struct {
	// Process ID of a backend or WAL sender process
	Pid int64 `json:"pid"`
	// True if SSL is used on this connection
	Ssl bool `json:"ssl"`
	// Version of SSL in use, or NULL if SSL is not in use on this connection
	Version nullable.String `json:"version"`
	// Name of SSL cipher in use, or NULL if SSL is not in use on this connection
	Cipher nullable.String `json:"cipher"`
	// Number of bits in the encryption algorithm used, or NULL if SSL is not used on this connection
	Bits nullable.Int64 `json:"bits"`
	// True if SSL compression is in use, false if not, or NULL if SSL is not in use on this connection
	Compression nullable.Bool `json:"compression"`
	// Distinguished Name (DN) field from the client certificate used,
	// or NULL if no client certificate was supplied or if SSL is not in use on this connection.
	// This field is truncated if the DN field is longer than NAMEDATALEN (64 characters in a standard build)
	Clientdn nullable.String `json:"clientdn"`
}

type PgStatSslView []PgStatSslRow

type PgStatStatementsRow struct {
	// OID of user who executed the statement
	Userid int64 `json:"userid"`
	// OID of database in which the statement was executed
	Dbid int64 `json:"dbid"`
	// Internal hash code, computed from the statement's parse tree
	Queryid int64 `json:"queryid"`
	// Text of a representative statement
	Query string `json:"query"`
	// Number of times executed
	Calls int64 `json:"calls"`
	// Total time spent in the statement, in milliseconds
	// Supported since PostgreSQL 9.5
	TotalTime float64 `json:"total_time"`
	// Minimum time spent in the statement, in milliseconds
	// Supported since PostgreSQL 9.5
	MinTime float64 `json:"min_time"`
	// Maximum time spent in the statement, in milliseconds
	// Supported since PostgreSQL 9.5
	MaxTime float64 `json:"max_time"`
	// Mean time spent in the statement, in milliseconds
	// Supported since PostgreSQL 9.5
	MeanTime float64 `json:"mean_time"`
	// Population standard deviation of time spent in the statement, in milliseconds
	// Supported since PostgreSQL 9.5
	StddevTime float64 `json:"stddev_time"`
	// Total number of rows retrieved or affected by the statement
	Rows int64 `json:"rows"`
	// Total number of shared block cache hits by the statement
	SharedBlksHit int64 `json:"shared_blks_hit"`
	// Total number of shared blocks read by the statement
	SharedBlksRead int64 `json:"shared_blks_read"`
	// Total number of shared blocks dirtied by the statement
	SharedBlksDirtied int64 `json:"shared_blks_dirtied"`
	// Total number of shared blocks written by the statement
	SharedBlksWritten int64 `json:"shared_blks_written"`
	// Total number of local block cache hits by the statement
	LocalBlksHit int64 `json:"local_blks_hit"`
	// Total number of local blocks read by the statement
	LocalBlksRead int64 `json:"local_blks_read"`
	// Total number of local blocks dirtied by the statement
	LocalBlksDirtied int64 `json:"local_blks_dirtied"`
	// Total number of local blocks written by the statement
	LocalBlksWritten int64 `json:"local_blks_written"`
	// Total number of temp blocks read by the statement
	TempBlksRead int64 `json:"temp_blks_read"`
	// Total number of temp blocks written by the statement
	TempBlksWritten int64 `json:"temp_blks_written"`
	// Total time the statement spent reading blocks, in milliseconds (if track_io_timing is enabled, otherwise zero)
	BlkReadTime float64 `json:"blk_read_time"`
	// Total time the statement spent writing blocks, in milliseconds (if track_io_timing is enabled, otherwise zero)
	BlkWriteTime float64 `json:"blk_write_time"`
}

type PgStatStatementsView []PgStatStatementsRow

type PgStatSubscriptionRow struct {
	// OID of the subscription
	Subid nullable.Int64 `json:"subid"`
	// Name of the subscription
	Subname nullable.String `json:"subname"`
	// Process ID of the subscription worker process
	Pid nullable.Int64 `json:"pid"`
	// OID of the relation that the worker is synchronizing; null for the main apply worker
	Relid nullable.Int64 `json:"relid"`
	// Last write-ahead log location received, the initial value of this field being 0
	ReceivedLsn nullable.Int64 `json:"received_lsn"`
	// Send time of last message received from origin WAL sender
	LastMsgSendTime nullable.Time `json:"last_msg_send_time"`
	// Receipt time of last message received from origin WAL sender
	LastMsgReceiptTime nullable.Time `json:"last_msg_receipt_time"`
	// Last write-ahead log location reported to origin WAL sender
	LatestEndLsn nullable.Int64 `json:"latest_end_lsn"`
	// Time of last write-ahead log location reported to origin WAL sender
	LatestEndTime nullable.Time `json:"latest_end_time"`
}

type PgStatSubscriptionView []PgStatSubscriptionRow

type PgStatSystemIndexesView []PgStatIndexesRow

type PgStatSystemTablesView []PgStatTablesRow

type PgStatTablesRow struct {
	// OID of a table
	Relid int64 `json:"relid"`
	// Name of the schema that this table is in
	Schemaname string `json:"schemaname"`
	// Name of this table
	Relname string `json:"relname"`
	// Number of sequential scans initiated on this table
	SeqScan nullable.Int64 `json:"seq_scan"`
	// Number of live rows fetched by sequential scans
	SeqTupRead nullable.Int64 `json:"seq_tup_read"`
	// Number of index scans initiated on this table
	IdxScan nullable.Int64 `json:"idx_scan"`
	// Number of live rows fetched by index scans
	IdxTupFetch nullable.Int64 `json:"idx_tup_fetch"`
	// Number of rows inserted
	NTupIns nullable.Int64 `json:"n_tup_ins"`
	// Number of rows updated (includes HOT updated rows)
	NTupUpd nullable.Int64 `json:"n_tup_upd"`
	// Number of rows deleted
	NTupDel nullable.Int64 `json:"n_tup_del"`
	// Number of rows HOT updated (i.e., with no separate index update required)
	NTupHotUpd nullable.Int64 `json:"n_tup_hot_upd"`
	// Estimated number of live rows
	NLiveTup nullable.Int64 `json:"n_live_tup"`
	// Estimated number of dead rows
	NDeadTup nullable.Int64 `json:"n_dead_tup"`
	// Estimated number of rows modified since this table was last analyzed
	NModSinceAnalyze nullable.Int64 `json:"n_mod_since_analyze"`
	// Last time at which this table was manually vacuumed (not counting VACUUM FULL)
	LastVacuum nullable.Time `json:"last_vacuum"`
	// Last time at which this table was vacuumed by the autovacuum daemon
	LastAutovacuum nullable.Time `json:"last_autovacuum"`
	// Last time at which this table was manually analyzed
	LastAnalyze nullable.Time `json:"last_analyze"`
	// Last time at which this table was analyzed by the autovacuum daemon
	LastAutoanalyze nullable.Time `json:"last_autoanalyze"`
	// Number of times this table has been manually vacuumed (not counting VACUUM FULL)
	VacuumCount nullable.Int64 `json:"vacuum_count"`
	// Number of times this table has been vacuumed by the autovacuum daemon
	AutovacuumCount nullable.Int64 `json:"autovacuum_count"`
	// Number of times this table has been manually analyzed
	AnalyzeCount nullable.Int64 `json:"analyze_count"`
	// Number of times this table has been analyzed by the autovacuum daemon
	AutoanalyzeCount nullable.Int64 `json:"autoanalyze_count"`
}

type PgStatUserFunctionsView []PgStatFunctionsRow

type PgStatUserIndexesView []PgStatIndexesRow

type PgStatUserTablesView []PgStatTablesRow

type PgStatWalReceiverView struct {
	// Process ID of the WAL receiver process
	Pid int64 `json:"pid"`
	// Activity status of the WAL receiver process
	Status string `json:"status"`
	// First write-ahead log location used when WAL receiver is started
	ReceiveStartLsn nullable.Int64 `json:"receive_start_lsn"`
	// First timeline number used when WAL receiver is started
	ReceiveStartTli nullable.Int64 `json:"receive_start_tli"`
	// Last write-ahead log location already received and flushed to disk,
	// the initial value of this field being the first log location used when WAL receiver is started
	ReceivedLsn nullable.Int64 `json:"received_lsn"`
	// Timeline number of last write-ahead log location received and flushed to disk,
	// the initial value of this field being the timeline number of the first log location used when WAL receiver is started
	ReceivedTli nullable.Int64 `json:"received_tli"`
	// Send time of last message received from origin WAL sender
	LastMsgSendTime nullable.Time `json:"last_msg_send_time"`
	// Receipt time of last message received from origin WAL sender
	LastMsgReceiptTime nullable.Time `json:"last_msg_receipt_time"`
	// Last write-ahead log location reported to origin WAL sender
	LatestEndLsn nullable.Int64 `json:"latest_end_lsn"`
	// Time of last write-ahead log location reported to origin WAL sender
	LatestEndTime nullable.Time `json:"latest_end_time"`
	// Replication slot name used by this WAL receiver
	SlotName nullable.String `json:"slot_name"`
	// Host of the PostgreSQL instance this WAL receiver is connected to.
	// This can be a host name, an IP address, or a directory path if the connection is via Unix socket.
	// (The path case can be distinguished because it will always be an absolute path, beginning with /.)
	// Supported since PostgreSQL 11
	SenderHost nullable.String `json:"sender_host"`
	// Port number of the PostgreSQL instance this WAL receiver is connected to.
	// Supported since PostgreSQL 11
	SenderPort nullable.Int64 `json:"sender_port"`
	// Connection string used by this WAL receiver, with security-sensitive fields obfuscated.
	Conninfo nullable.String `json:"conninfo"`
}

type PgStatXactAllTablesView []PgStatXactTablesRow

type PgStatXactSystemTablesView []PgStatXactTablesRow

type PgStatXactTablesRow struct {
	// OID of a table
	Relid int64 `json:"relid"`
	// Name of the schema that this table is in
	Schemaname string `json:"schemaname"`
	// Name of this table
	Relname string `json:"relname"`
	// Number of sequential scans initiated on this table
	SeqScan nullable.Int64 `json:"seq_scan"`
	// Number of live rows fetched by sequential scans
	SeqTupRead nullable.Int64 `json:"seq_tup_read"`
	// Number of index scans initiated on this table
	IdxScan nullable.Int64 `json:"idx_scan"`
	// Number of live rows fetched by index scans
	IdxTupFetch nullable.Int64 `json:"idx_tup_fetch"`
	// Number of rows inserted
	NTupIns nullable.Int64 `json:"n_tup_ins"`
	// Number of rows updated (includes HOT updated rows)
	NTupUpd nullable.Int64 `json:"n_tup_upd"`
	// Number of rows deleted
	NTupDel nullable.Int64 `json:"n_tup_del"`
	// Number of rows HOT updated (i.e., with no separate index update required)
	NTupHotUpd nullable.Int64 `json:"n_tup_hot_upd"`
}

type PgStatXactUserFunctionsView []PgStatFunctionsRow

type PgStatXactUserTablesView []PgStatXactTablesRow

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