Statistics & Metrics
Version coverage matrixDefinitions for PostgreSQL 18
Reading PG 18·Select a recorded version
Name of the application that is connected to this backend
Time when this process was started. For client backends, this is the time the client connected to the server.
Type of current backend. Possible types are autovacuum launcher, autovacuum worker, logical replication launcher, logical replication worker, parallel worker, background writer, client backend, checkpointer, archiver, standalone backend, startup, walreceiver, walsender, walwriter and walsummarizer. In addition, background workers registered by extensions may have additional types.
Top-level transaction identifier of this backend, if any; see Section 67.1.
The current backend's xmin horizon.
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.
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.
TCP port number that the client is using for communication with this backend, or -1 if a Unix socket is used. If this field is null, it indicates that this is an internal server process.
OID of the database this backend is connected to
Name of the database this backend is connected to
Process ID of the parallel group leader if this process is a parallel query worker, or process ID of the leader apply worker if this process is a parallel apply worker. NULL indicates that this process is a parallel group leader or leader apply worker, or does not participate in any parallel operation.
Process ID of this backend
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 bytes; this value can be changed via the parameter track_activity_query_size.
Identifier of this backend's most recent query. If state is active this field shows the identifier of the currently executing query. In all other states, it shows the identifier of last query that was executed. Query identifiers are not computed by default so this field will be null unless compute_query_id parameter is enabled or a third-party module that computes query identifiers is configured.
Time when the currently active query was started, or if state is not active, when the last query was started
Current overall state of this backend. Possible values are: starting: The backend is in initial startup. Client authentication is performed during this phase. active: The backend is executing a query. idle: The backend is waiting for a new client command. idle in transaction: The backend is in a transaction, but is not currently executing a query. idle in transaction (aborted): This state is similar to idle in transaction, except one of the statements in the transaction caused an error. fastpath function call: The backend is executing a fast-path function. disabled: This state is reported if track_activities is disabled in this backend.
Time when the state was last changed
Name of the user logged into this backend
OID of the user logged into this backend
Wait event name if backend is currently waiting, otherwise NULL. See Table 27.5 through Table 27.13.
The type of event for which the backend is waiting, if any; otherwise NULL. See Table 27.4.
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.
Number of index scans initiated on this index
Number of live table rows fetched by simple index scans using this index
Number of index entries returned by scans on this index
OID of this index
Name of this index
The time of the last scan on this index, based on the most recent transaction stop time
OID of the table for this index
Name of the table for this index
Name of the schema this index is in
Number of times this table has been manually analyzed
Number of times this table has been analyzed by the autovacuum daemon
Number of times this table has been vacuumed by the autovacuum daemon
Number of index scans initiated on this table
Number of live rows fetched by index scans
Last time at which this table was manually analyzed
Last time at which this table was analyzed by the autovacuum daemon
Last time at which this table was vacuumed by the autovacuum daemon
The time of the last index scan on this table, based on the most recent transaction stop time
The time of the last sequential scan on this table, based on the most recent transaction stop time
Last time at which this table was manually vacuumed (not counting VACUUM FULL)
Estimated number of dead rows
Estimated number of rows inserted since this table was last vacuumed (not counting VACUUM FULL)
Estimated number of live rows
Estimated number of rows modified since this table was last analyzed
Total number of rows deleted
Number of rows HOT updated. These are updates where no successor versions are required in indexes.
Total number of rows inserted
Number of rows updated where the successor version goes onto a new heap page, leaving behind an original version with a t_ctid field that points to a different heap page. These are always non-HOT updates.
Total number of rows updated. (This includes row updates counted in n_tup_hot_upd and n_tup_newpage_upd, and remaining non-HOT updates.)
OID of a table
Name of this table
Name of the schema that this table is in
Number of sequential scans initiated on this table
Number of live rows fetched by sequential scans
Total time this table has been manually analyzed, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)
Total time this table has been analyzed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)
Total time this table has been vacuumed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)
Total time this table has been manually vacuumed, in milliseconds (not counting VACUUM FULL). (This includes the time spent sleeping due to cost-based delays.)
Number of times this table has been manually vacuumed (not counting VACUUM FULL)
Number of WAL files that have been successfully archived
Number of failed attempts for archiving WAL files
Time of the most recent successful archive operation
Name of the WAL file most recently successfully archived
Time of the most recent failed archival operation
Name of the WAL file of the most recent failed archival operation
Time at which these statistics were last reset
Number of buffers allocated
Number of buffers written by the background writer
Number of times the background writer stopped a cleaning scan because it had written too many buffers
Time at which these statistics were last reset
Number of shared buffers written during checkpoints and restartpoints
Number of checkpoints that have been performed
Number of requested checkpoints
Number of scheduled checkpoints due to timeout
Number of restartpoints that have been performed
Number of requested restartpoints
Number of scheduled restartpoints due to timeout or after a failed attempt to perform it
Number of SLRU buffers written during checkpoints and restartpoints
Time at which these statistics were last reset
Total amount of time that has been spent in the portion of processing checkpoints and restartpoints where files are synchronized to disk, in milliseconds
Total amount of time that has been spent in the portion of processing checkpoints and restartpoints where files are written to disk, in milliseconds
Time spent executing SQL statements in this database, in milliseconds (this corresponds to the states active and fastpath function call in pg_stat_activity)
Time spent reading data file blocks by backends in this database, in milliseconds (if track_io_timing is enabled, otherwise zero)
Time spent writing data file blocks by backends in this database, in milliseconds (if track_io_timing is enabled, otherwise zero)
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)
Number of disk blocks read in this database
Number of data page checksum failures detected in this database (or on a shared object), or NULL if data checksums are disabled.
Time at which the last data page checksum failure was detected in this database (or on a shared object), or NULL if data checksums are disabled.
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.)
OID of this database, or 0 for objects belonging to a shared relation
Name of this database, or NULL for shared objects.
Number of deadlocks detected in this database
Time spent idling while in a transaction in this database, in milliseconds (this corresponds to the states idle in transaction and idle in transaction (aborted) in pg_stat_activity)
Number of backends currently connected to this database, or NULL for shared objects. 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.
Number of parallel workers launched by queries on this database
Number of parallel workers planned to be launched by queries on this database
Time spent by database sessions in this database, in milliseconds (note that statistics are only updated when the state of a session changes, so if sessions have been idle for a long time, this idle time won't be included)
Total number of sessions established to this database
Number of database sessions to this database that were terminated because connection to the client was lost
Number of database sessions to this database that were terminated by fatal errors
Number of database sessions to this database that were terminated by operator intervention
Time at which these statistics were last reset
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.
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.
Number of rows deleted by queries in this database
Number of live rows fetched by index scans in this database
Number of rows inserted by queries in this database
Number of live rows fetched by sequential scans and index entries returned by index scans in this database
Number of rows updated by queries in this database
Number of transactions in this database that have been committed
Number of transactions in this database that have been rolled back
Number of uses of logical slots in this database that have been canceled due to old snapshots or too low a wal_level on the primary
Number of queries in this database that have been canceled due to pinned buffers
Number of queries in this database that have been canceled due to deadlocks
Number of queries in this database that have been canceled due to lock timeouts
Number of queries in this database that have been canceled due to old snapshots
Number of queries in this database that have been canceled due to dropped tablespaces
OID of a database
Name of this database
True if GSSAPI credentials were delegated on this connection.
True if GSSAPI encryption is in use on this connection
True if GSSAPI authentication was used for this connection
Process ID of a backend
Principal used to authenticate this connection, or NULL if GSSAPI was not used to authenticate this connection. This field is truncated if the principal is longer than NAMEDATALEN (64 characters in a standard build).
Type of backend (e.g. background worker, autovacuum worker). See pg_stat_activity for more information on backend_types. Some backend_types do not accumulate I/O operation statistics and will not be included in the view.
The context of an I/O operation. Possible values are: normal: The default or standard context for a type of I/O operation. For example, by default, relation data is read into and written out from shared buffers. Thus, reads and writes of relation data to and from shared buffers are tracked in context normal. init: I/O operations performed while creating the WAL segments are tracked in context init. vacuum: I/O operations performed outside of shared buffers while vacuuming and analyzing permanent relations. Temporary table vacuums use the same local buffer pool as other temporary table I/O operations and are tracked in context normal. bulkread: Certain large read I/O operations done outside of shared buffers, for example, a sequential scan of a large table. bulkwrite: Certain large write I/O operations done outside of shared buffers, such as COPY.
Number of times a block has been written out from a shared or local buffer in order to make it available for another use. In context normal, this counts the number of times a block was evicted from a buffer and replaced with another block. In contexts bulkwrite, bulkread, and vacuum, this counts the number of times a block was evicted from shared buffers in order to add the shared buffer to a separate, size-limited ring buffer for use in a bulk I/O operation.
The total size of relation extend operations in bytes.
Time spent waiting for extend operations in milliseconds. (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero)
Number of relation extend operations.
Time spent waiting for fsync operations in milliseconds (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero)
Number of fsync calls. These are only tracked in context normal.
The number of times a desired block was found in a shared buffer.
Target object of an I/O operation. Possible values are: relation: Permanent relations. temp relation: Temporary relations. wal: Write Ahead Logs.
The total size of read operations in bytes.
Time spent waiting for read operations in milliseconds (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero)
Number of read operations.
The number of times an existing buffer in a size-limited ring buffer outside of shared buffers was reused as part of an I/O operation in the bulkread, bulkwrite, or vacuum contexts.
Time at which these statistics were last reset.
The total size of write operations in bytes.
Time spent waiting for write operations in milliseconds (if track_io_timing is enabled and object is not wal, or if track_wal_io_timing is enabled and object is wal, otherwise zero)
Time spent waiting for writeback operations in milliseconds (if track_io_timing is enabled, otherwise zero). This includes the time spent queueing write-out requests and, potentially, the time spent to write out the dirty data.
Number of units of size BLCKSZ (typically 8kB) which the process requested the kernel write out to permanent storage.
Number of write operations.
Number of child tables scanned. This counter only advances when the phase is acquiring inherited sample rows.
Number of child tables.
OID of the child table currently being scanned. This field is only valid when the phase is acquiring inherited sample rows.
OID of the database to which this backend is connected.
Name of the database to which this backend is connected.
Total time spent sleeping due to cost-based delay (see Section 19.10.2), in milliseconds (if track_cost_delay_timing is enabled, otherwise zero).
Number of extended statistics computed. This counter only advances when the phase is computing extended statistics.
Number of extended statistics.
Current processing phase. See Table 27.39.
Process ID of backend.
OID of the table being analyzed.
Number of heap blocks scanned.
Total number of heap blocks that will be sampled.
Amount of data streamed. This counter only advances when the phase is streaming database files or transferring wal files.
Total amount of data that will be streamed. This is estimated and reported as of the beginning of streaming database files phase. Note that this is only an approximation since the database may change during streaming database files phase and WAL log may be included in the backup later. This is always the same value as backup_streamed once the amount of data streamed exceeds the estimated total size. If the estimation is disabled in pg_basebackup (i.e., --no-estimate-size option is specified), this is NULL.
Current processing phase. See Table 27.48.
Process ID of a WAL sender process.
Number of tablespaces streamed. This counter only advances when the phase is streaming database files.
Total number of tablespaces that will be streamed.
If the table is being scanned using an index, this is the OID of the index being used; otherwise, it is zero.
The command that is running. Either CLUSTER or VACUUM FULL.
OID of the database to which this backend is connected.
Name of the database to which this backend is connected.
Number of heap blocks scanned. This counter only advances when the phase is seq scanning heap.
Total number of heap blocks in the table. This number is reported as of the beginning of seq scanning heap.
Number of heap tuples scanned. This counter only advances when the phase is seq scanning heap, index scanning heap or writing new heap.
Number of heap tuples written. This counter only advances when the phase is seq scanning heap, index scanning heap or writing new heap.
Number of indexes rebuilt. This counter only advances when the phase is rebuilding index.
Current processing phase. See Table 27.41.
Process ID of backend.
OID of the table being clustered.
Number of bytes already processed by COPY command.
Size of source file for COPY FROM command in bytes. It is set to 0 if not available.
The command that is running: COPY FROM, or COPY TO.
OID of the database to which this backend is connected.
Name of the database to which this backend is connected.
Process ID of backend.
OID of the table on which the COPY command is executed. It is set to 0 if copying from a SELECT query.
Number of tuples not processed because they were excluded by the WHERE clause of the COPY command.
Number of tuples already processed by COPY command.
Number of tuples skipped because they contain malformed data. This counter only advances when a value other than stop is specified to the ON_ERROR option.
The I/O type that the data is read from or written to: FILE, PROGRAM, PIPE (for COPY FROM STDIN and COPY TO STDOUT), or CALLBACK (used for example during the initial table synchronization in logical replication).
Number of blocks already processed in the current phase.
Total number of blocks to be processed in the current phase.
Specific command type: CREATE INDEX, CREATE INDEX CONCURRENTLY, REINDEX, or REINDEX CONCURRENTLY.
Process ID of the locker currently being waited for.
OID of the database to which this backend is connected.
Name of the database to which this backend is connected.
OID of the index being created or reindexed. During a non-concurrent CREATE INDEX, this is 0.
Number of lockers already waited for.
Total number of lockers to wait for, when applicable.
Number of partitions on which the index has already been created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned.
Total number of partitions on which the index is to be created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned.
Current processing phase of index creation. See Table 27.44.
Process ID of the backend creating indexes.
OID of the table on which the index is being created.
Number of tuples already processed in the current phase.
Total number of tuples to be processed in the current phase.
OID of the database to which this backend is connected.
Name of the database to which this backend is connected.
Amount of dead tuple data collected since the last index vacuum cycle.
Total time spent sleeping due to cost-based delay (see Section 19.10.2), in milliseconds (if track_cost_delay_timing is enabled, otherwise zero). This includes the time that any associated parallel workers have slept. However, parallel workers report their sleep time no more frequently than once per second, so the reported value may be slightly stale.
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.
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.
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.
Number of completed index vacuum cycles.
Number of indexes processed. This counter only advances when the phase is vacuuming indexes or cleaning up indexes.
Total number of indexes that will be vacuumed or cleaned up. This number is reported at the beginning of the vacuuming indexes phase or the cleaning up indexes phase.
Amount of dead tuple data that we can store before needing to perform an index vacuum cycle, based on maintenance_work_mem.
Number of dead item identifiers collected since the last index vacuum cycle.
Current processing phase of vacuum. See Table 27.46.
Process ID of backend.
OID of the table being vacuumed.
How many blocks ahead the prefetcher is looking
Number of blocks not prefetched because they were already in the buffer pool
How many prefetches have been initiated but are not yet known to have completed
Number of blocks prefetched because they were not in the buffer pool
Number of blocks not prefetched because a full page image was included in the WAL
Number of blocks not prefetched because they would be zero-initialized
Number of blocks not prefetched because they didn't exist yet
Number of blocks not prefetched because they were already recently prefetched
Time at which these statistics were last reset
How many bytes ahead the prefetcher is looking
Name of the application that is connected to this WAL sender
Time when this process was started, i.e., when the client connected to this WAL sender
This standby's xmin horizon reported by hot_standby_feedback.
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.
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.
TCP port number that the client is using for communication with this WAL sender, or -1 if a Unix socket is used
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.
Last write-ahead log location flushed to disk by this standby server
Process ID of a WAL sender process
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.
Last write-ahead log location replayed into the database on this standby server
Send time of last reply message received from standby server
Last write-ahead log location sent on this connection
Current WAL sender state. Possible values are: startup: This WAL sender is starting up. catchup: This WAL sender's connected standby is catching up with the primary. streaming: This WAL sender is streaming changes after its connected standby server has caught up with the primary. backup: This WAL sender is sending a backup. stopping: This WAL sender is stopping.
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.
Synchronous state of this standby server. Possible values are: async: This standby server is asynchronous. potential: This standby server is now asynchronous, but can potentially become synchronous if one of current synchronous ones fails. sync: This standby server is synchronous. quorum: This standby server is considered as a candidate for quorum standbys.
Name of the user logged into this WAL sender process
OID of the user logged into this WAL sender process
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.
Last write-ahead log location written to disk by this standby server
A unique, cluster-wide identifier for the replication slot
Amount of decoded transaction data spilled to disk while performing decoding of changes from WAL for this slot. This and other spill counters can be used to gauge the I/O which occurred during logical decoding and allow tuning logical_decoding_work_mem.
Number of times transactions were spilled to disk while decoding changes from WAL for this slot. This counter is incremented each time a transaction is spilled, and the same transaction may be spilled multiple times.
Number of transactions spilled to disk once the memory used by logical decoding to decode changes from WAL has exceeded logical_decoding_work_mem. The counter gets incremented for both top-level transactions and subtransactions.
Time at which these statistics were last reset
Amount of transaction data decoded for streaming in-progress transactions to the decoding output plugin while decoding changes from WAL for this slot. This and other streaming counters for this slot can be used to tune logical_decoding_work_mem.
Number of times in-progress transactions were streamed to the decoding output plugin while decoding changes from WAL for this slot. This counter is incremented each time a transaction is streamed, and the same transaction may be streamed multiple times.
Number of in-progress transactions streamed to the decoding output plugin after the memory used by logical decoding to decode changes from WAL for this slot has exceeded logical_decoding_work_mem. Streaming only works with top-level transactions (subtransactions can't be streamed independently), so the counter is not incremented for subtransactions.
Amount of transaction data decoded for sending transactions to the decoding output plugin while decoding changes from WAL for this slot. Note that this includes data that is streamed and/or spilled.
Number of decoded transactions sent to the decoding output plugin for this slot. This counts top-level transactions only, and is not incremented for subtransactions. Note that this includes the transactions that are streamed and/or spilled.
Number of blocks checked for existence for this SLRU
Number of times disk blocks were found already in the SLRU, so that a read was not necessary (this only includes hits in the SLRU, not the operating system's file system cache)
Number of disk blocks read for this SLRU
Number of disk blocks written for this SLRU
Number of blocks zeroed during initializations
Number of flushes of dirty data for this SLRU
Name of the SLRU
Time at which these statistics were last reset
Number of truncates for this SLRU
Number of bits in the encryption algorithm used, or NULL if SSL is not used on this connection
Name of SSL cipher in use, or NULL if SSL is not in use on this connection
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).
Serial number of the client certificate, or NULL if no client certificate was supplied or if SSL is not in use on this connection. The combination of certificate serial number and certificate issuer uniquely identifies a certificate (unless the issuer erroneously reuses serial numbers).
DN of the issuer of the client certificate, or NULL if no client certificate was supplied or if SSL is not in use on this connection. This field is truncated like client_dn.
Process ID of a backend or WAL sender process
True if SSL is used on this connection
Version of SSL in use, or NULL if SSL is not in use on this connection
Receipt time of last message received from origin WAL sender; NULL for parallel apply workers
Send time of last message received from origin WAL sender; NULL for parallel apply workers
Last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers
Time of last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers
Process ID of the leader apply worker if this process is a parallel apply worker; NULL if this process is a leader apply worker or a table synchronization worker
Process ID of the subscription worker process
Last write-ahead log location received, the initial value of this field being 0; NULL for parallel apply workers
OID of the relation that the worker is synchronizing; NULL for the leader apply worker and parallel apply workers
OID of the subscription
Name of the subscription
Type of the subscription worker process. Possible types are apply, parallel apply, and table synchronization.
Number of times an error occurred while applying changes. Note that any conflict resulting in an apply error will be counted in both apply_error_count and the corresponding conflict count (e.g., confl_*).
Number of times the tuple to be deleted was not found during the application of changes. See delete_missing for details about this conflict.
Number of times a delete operation was applied to row that had been previously modified by another source during the application of changes. See delete_origin_differs for details about this conflict.
Number of times a row insertion violated a NOT DEFERRABLE unique constraint during the application of changes. See insert_exists for details about this conflict.
Number of times a row insertion or an updated row values violated multiple NOT DEFERRABLE unique constraints during the application of changes. See multiple_unique_conflicts for details about this conflict.
Number of times that an updated row value violated a NOT DEFERRABLE unique constraint during the application of changes. See update_exists for details about this conflict.
Number of times the tuple to be updated was not found during the application of changes. See update_missing for details about this conflict.
Number of times an update was applied to a row that had been previously modified by another source during the application of changes. See update_origin_differs for details about this conflict.
Time at which these statistics were last reset
OID of the subscription
Name of the subscription
Number of times an error occurred during the initial table synchronization
Number of index scans initiated on this index
Number of live table rows fetched by simple index scans using this index
Number of index entries returned by scans on this index
OID of this index
Name of this index
The time of the last scan on this index, based on the most recent transaction stop time
OID of the table for this index
Name of the table for this index
Name of the schema this index is in
Number of times this table has been manually analyzed
Number of times this table has been analyzed by the autovacuum daemon
Number of times this table has been vacuumed by the autovacuum daemon
Number of index scans initiated on this table
Number of live rows fetched by index scans
Last time at which this table was manually analyzed
Last time at which this table was analyzed by the autovacuum daemon
Last time at which this table was vacuumed by the autovacuum daemon
The time of the last index scan on this table, based on the most recent transaction stop time
The time of the last sequential scan on this table, based on the most recent transaction stop time
Last time at which this table was manually vacuumed (not counting VACUUM FULL)
Estimated number of dead rows
Estimated number of rows inserted since this table was last vacuumed (not counting VACUUM FULL)
Estimated number of live rows
Estimated number of rows modified since this table was last analyzed
Total number of rows deleted
Number of rows HOT updated. These are updates where no successor versions are required in indexes.
Total number of rows inserted
Number of rows updated where the successor version goes onto a new heap page, leaving behind an original version with a t_ctid field that points to a different heap page. These are always non-HOT updates.
Total number of rows updated. (This includes row updates counted in n_tup_hot_upd and n_tup_newpage_upd, and remaining non-HOT updates.)
OID of a table
Name of this table
Name of the schema that this table is in
Number of sequential scans initiated on this table
Number of live rows fetched by sequential scans
Total time this table has been manually analyzed, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)
Total time this table has been analyzed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)
Total time this table has been vacuumed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)
Total time this table has been manually vacuumed, in milliseconds (not counting VACUUM FULL). (This includes the time spent sleeping due to cost-based delays.)
Number of times this table has been manually vacuumed (not counting VACUUM FULL)
Number of times this function has been called
OID of a function
Name of this function
Name of the schema this function is in
Total time spent in this function itself, not including other functions called by it, in milliseconds
Total time spent in this function and all other functions called by it, in milliseconds
Number of index scans initiated on this index
Number of live table rows fetched by simple index scans using this index
Number of index entries returned by scans on this index
OID of this index
Name of this index
The time of the last scan on this index, based on the most recent transaction stop time
OID of the table for this index
Name of the table for this index
Name of the schema this index is in
Number of times this table has been manually analyzed
Number of times this table has been analyzed by the autovacuum daemon
Number of times this table has been vacuumed by the autovacuum daemon
Number of index scans initiated on this table
Number of live rows fetched by index scans
Last time at which this table was manually analyzed
Last time at which this table was analyzed by the autovacuum daemon
Last time at which this table was vacuumed by the autovacuum daemon
The time of the last index scan on this table, based on the most recent transaction stop time
The time of the last sequential scan on this table, based on the most recent transaction stop time
Last time at which this table was manually vacuumed (not counting VACUUM FULL)
Estimated number of dead rows
Estimated number of rows inserted since this table was last vacuumed (not counting VACUUM FULL)
Estimated number of live rows
Estimated number of rows modified since this table was last analyzed
Total number of rows deleted
Number of rows HOT updated. These are updates where no successor versions are required in indexes.
Total number of rows inserted
Number of rows updated where the successor version goes onto a new heap page, leaving behind an original version with a t_ctid field that points to a different heap page. These are always non-HOT updates.
Total number of rows updated. (This includes row updates counted in n_tup_hot_upd and n_tup_newpage_upd, and remaining non-HOT updates.)
OID of a table
Name of this table
Name of the schema that this table is in
Number of sequential scans initiated on this table
Number of live rows fetched by sequential scans
Total time this table has been manually analyzed, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)
Total time this table has been analyzed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)
Total time this table has been vacuumed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)
Total time this table has been manually vacuumed, in milliseconds (not counting VACUUM FULL). (This includes the time spent sleeping due to cost-based delays.)
Number of times this table has been manually vacuumed (not counting VACUUM FULL)
Time at which these statistics were last reset
Number of times WAL data was written to disk because WAL buffers became full
Total amount of WAL generated in bytes
Total number of WAL full page images generated
Total number of WAL records generated
Connection string used by this WAL receiver, with security-sensitive fields obfuscated.
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
Receipt time of last message received from origin WAL sender
Send time of last message received from origin WAL sender
Last write-ahead log location reported to origin WAL sender
Time of last write-ahead log location reported to origin WAL sender
Process ID of the WAL receiver process
First write-ahead log location used when WAL receiver is started
First timeline number used when WAL receiver is started
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
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 /.)
Port number of the PostgreSQL instance this WAL receiver is connected to.
Replication slot name used by this WAL receiver
Activity status of the WAL receiver process
Last write-ahead log location already received and written to disk, but not flushed. This should not be used for data integrity checks.
Source-defined field pg_stat_xact_all_tables.idx_scan. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_all_tables.idx_tup_fetch. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_all_tables.n_tup_del. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_all_tables.n_tup_hot_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_all_tables.n_tup_ins. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_all_tables.n_tup_newpage_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_all_tables.n_tup_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_all_tables.relid. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_all_tables.relname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_all_tables.schemaname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_all_tables.seq_scan. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_all_tables.seq_tup_read. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_sys_tables.idx_scan. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_sys_tables.idx_tup_fetch. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_sys_tables.n_tup_del. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_sys_tables.n_tup_hot_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_sys_tables.n_tup_ins. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_sys_tables.n_tup_newpage_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_sys_tables.n_tup_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_sys_tables.relid. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_sys_tables.relname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_sys_tables.schemaname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_sys_tables.seq_scan. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_sys_tables.seq_tup_read. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_functions.calls. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_functions.funcid. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_functions.funcname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_functions.schemaname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_functions.self_time. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_functions.total_time. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_tables.idx_scan. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_tables.idx_tup_fetch. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_tables.n_tup_del. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_tables.n_tup_hot_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_tables.n_tup_ins. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_tables.n_tup_newpage_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_tables.n_tup_upd. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_tables.relid. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_tables.relname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_tables.schemaname. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_tables.seq_scan. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Source-defined field pg_stat_xact_user_tables.seq_tup_read. The same-version manual describes this view but does not enumerate this column; the exact SQL expression is retained below.
Number of buffer hits in this index
Number of disk blocks read from this index
OID of this index
Name of this index
OID of the table for this index
Name of the table for this index
Name of the schema this index is in
Number of buffer hits in this sequence
Number of disk blocks read from this sequence
OID of a sequence
Name of this sequence
Name of the schema this sequence is in
Number of buffer hits in this table
Number of disk blocks read from this table
Number of buffer hits in all indexes on this table
Number of disk blocks read from all indexes on this table
OID of a table
Name of this table
Name of the schema that this table is in
Number of buffer hits in this table's TOAST table indexes (if any)
Number of disk blocks read from this table's TOAST table indexes (if any)
Number of buffer hits in this table's TOAST table (if any)
Number of disk blocks read from this table's TOAST table (if any)
Number of buffer hits in this index
Number of disk blocks read from this index
OID of this index
Name of this index
OID of the table for this index
Name of the table for this index
Name of the schema this index is in
Number of buffer hits in this sequence
Number of disk blocks read from this sequence
OID of a sequence
Name of this sequence
Name of the schema this sequence is in
Number of buffer hits in this table
Number of disk blocks read from this table
Number of buffer hits in all indexes on this table
Number of disk blocks read from all indexes on this table
OID of a table
Name of this table
Name of the schema that this table is in
Number of buffer hits in this table's TOAST table indexes (if any)
Number of disk blocks read from this table's TOAST table indexes (if any)
Number of buffer hits in this table's TOAST table (if any)
Number of disk blocks read from this table's TOAST table (if any)
Number of buffer hits in this index
Number of disk blocks read from this index
OID of this index
Name of this index
OID of the table for this index
Name of the table for this index
Name of the schema this index is in
Number of buffer hits in this sequence
Number of disk blocks read from this sequence
OID of a sequence
Name of this sequence
Name of the schema this sequence is in
Number of buffer hits in this table
Number of disk blocks read from this table
Number of buffer hits in all indexes on this table
Number of disk blocks read from all indexes on this table
OID of a table
Name of this table
Name of the schema that this table is in
Number of buffer hits in this table's TOAST table indexes (if any)
Number of disk blocks read from this table's TOAST table indexes (if any)
Number of buffer hits in this table's TOAST table (if any)
Number of disk blocks read from this table's TOAST table (if any)