Wiki / 统计与指标

PostgreSQL 版本定义：18

• pg_stat_activity.application_namepg_stat_activity10 – 20

  Name of the application that is connected to this backend

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.backend_startpg_stat_activity10 – 20

  Time when this process was started. For client backends, this is the time the client connected to the server.

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.backend_typepg_stat_activity10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.backend_xidpg_stat_activity10 – 20

  Top-level transaction identifier of this backend, if any; see Section 67.1.

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.backend_xminpg_stat_activity10 – 20

  The current backend's xmin horizon.

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.client_addrpg_stat_activity10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.client_hostnamepg_stat_activity10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.client_portpg_stat_activity10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.datidpg_stat_activity10 – 20

  OID of the database this backend is connected to

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.datnamepg_stat_activity10 – 20

  Name of the database this backend is connected to

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.leader_pidpg_stat_activity13 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.pidpg_stat_activity10 – 20

  Process ID of this backend

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.querypg_stat_activity10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.query_idpg_stat_activity14 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.query_startpg_stat_activity10 – 20

  Time when the currently active query was started, or if state is not active, when the last query was started

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.statepg_stat_activity10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.state_changepg_stat_activity10 – 20

  Time when the state was last changed

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.usenamepg_stat_activity10 – 20

  Name of the user logged into this backend

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.usesysidpg_stat_activity10 – 20

  OID of the user logged into this backend

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.wait_eventpg_stat_activity10 – 20

  Wait event name if backend is currently waiting, otherwise NULL. See Table 27.5 through Table 27.13.

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.wait_event_typepg_stat_activity10 – 20

  The type of event for which the backend is waiting, if any; otherwise NULL. See Table 27.4.

  此定义以英文显示

  1011121314151617181920
• pg_stat_activity.xact_startpg_stat_activity10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_indexes.idx_scanpg_stat_all_indexes10 – 20

  Number of index scans initiated on this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_indexes.idx_tup_fetchpg_stat_all_indexes10 – 20

  Number of live table rows fetched by simple index scans using this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_indexes.idx_tup_readpg_stat_all_indexes10 – 20

  Number of index entries returned by scans on this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_indexes.indexrelidpg_stat_all_indexes10 – 20

  OID of this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_indexes.indexrelnamepg_stat_all_indexes10 – 20

  Name of this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_indexes.last_idx_scanpg_stat_all_indexes16 – 20

  The time of the last scan on this index, based on the most recent transaction stop time

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_indexes.relidpg_stat_all_indexes10 – 20

  OID of the table for this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_indexes.relnamepg_stat_all_indexes10 – 20

  Name of the table for this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_indexes.schemanamepg_stat_all_indexes10 – 20

  Name of the schema this index is in

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.analyze_countpg_stat_all_tables10 – 20

  Number of times this table has been manually analyzed

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.autoanalyze_countpg_stat_all_tables10 – 20

  Number of times this table has been analyzed by the autovacuum daemon

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.autovacuum_countpg_stat_all_tables10 – 20

  Number of times this table has been vacuumed by the autovacuum daemon

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.idx_scanpg_stat_all_tables10 – 20

  Number of index scans initiated on this table

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.idx_tup_fetchpg_stat_all_tables10 – 20

  Number of live rows fetched by index scans

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.last_analyzepg_stat_all_tables10 – 20

  Last time at which this table was manually analyzed

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.last_autoanalyzepg_stat_all_tables10 – 20

  Last time at which this table was analyzed by the autovacuum daemon

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.last_autovacuumpg_stat_all_tables10 – 20

  Last time at which this table was vacuumed by the autovacuum daemon

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.last_idx_scanpg_stat_all_tables16 – 20

  The time of the last index scan on this table, based on the most recent transaction stop time

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.last_seq_scanpg_stat_all_tables16 – 20

  The time of the last sequential scan on this table, based on the most recent transaction stop time

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.last_vacuumpg_stat_all_tables10 – 20

  Last time at which this table was manually vacuumed (not counting VACUUM FULL)

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.n_dead_tuppg_stat_all_tables10 – 20

  Estimated number of dead rows

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.n_ins_since_vacuumpg_stat_all_tables13 – 20

  Estimated number of rows inserted since this table was last vacuumed (not counting VACUUM FULL)

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.n_live_tuppg_stat_all_tables10 – 20

  Estimated number of live rows

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.n_mod_since_analyzepg_stat_all_tables10 – 20

  Estimated number of rows modified since this table was last analyzed

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.n_tup_delpg_stat_all_tables10 – 20

  Total number of rows deleted

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.n_tup_hot_updpg_stat_all_tables10 – 20

  Number of rows HOT updated. These are updates where no successor versions are required in indexes.

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.n_tup_inspg_stat_all_tables10 – 20

  Total number of rows inserted

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.n_tup_newpage_updpg_stat_all_tables16 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.n_tup_updpg_stat_all_tables10 – 20

  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.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.relidpg_stat_all_tables10 – 20

  OID of a table

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.relnamepg_stat_all_tables10 – 20

  Name of this table

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.schemanamepg_stat_all_tables10 – 20

  Name of the schema that this table is in

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.seq_scanpg_stat_all_tables10 – 20

  Number of sequential scans initiated on this table

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.seq_tup_readpg_stat_all_tables10 – 20

  Number of live rows fetched by sequential scans

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.total_analyze_timepg_stat_all_tables18 – 20

  Total time this table has been manually analyzed, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.total_autoanalyze_timepg_stat_all_tables18 – 20

  Total time this table has been analyzed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.total_autovacuum_timepg_stat_all_tables18 – 20

  Total time this table has been vacuumed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.total_vacuum_timepg_stat_all_tables18 – 20

  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.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_all_tables.vacuum_countpg_stat_all_tables10 – 20

  Number of times this table has been manually vacuumed (not counting VACUUM FULL)

  此定义以英文显示

  1011121314151617181920
• pg_stat_archiver.archived_countpg_stat_archiver10 – 20

  Number of WAL files that have been successfully archived

  此定义以英文显示

  1011121314151617181920
• pg_stat_archiver.failed_countpg_stat_archiver10 – 20

  Number of failed attempts for archiving WAL files

  此定义以英文显示

  1011121314151617181920
• pg_stat_archiver.last_archived_timepg_stat_archiver10 – 20

  Time of the most recent successful archive operation

  此定义以英文显示

  1011121314151617181920
• pg_stat_archiver.last_archived_walpg_stat_archiver10 – 20

  Name of the WAL file most recently successfully archived

  此定义以英文显示

  1011121314151617181920
• pg_stat_archiver.last_failed_timepg_stat_archiver10 – 20

  Time of the most recent failed archival operation

  此定义以英文显示

  1011121314151617181920
• pg_stat_archiver.last_failed_walpg_stat_archiver10 – 20

  Name of the WAL file of the most recent failed archival operation

  此定义以英文显示

  1011121314151617181920
• pg_stat_archiver.stats_resetpg_stat_archiver10 – 20

  Time at which these statistics were last reset

  此定义以英文显示

  1011121314151617181920
• pg_stat_bgwriter.buffers_allocpg_stat_bgwriter10 – 20

  Number of buffers allocated

  此定义以英文显示

  1011121314151617181920
• pg_stat_bgwriter.buffers_cleanpg_stat_bgwriter10 – 20

  Number of buffers written by the background writer

  此定义以英文显示

  1011121314151617181920
• pg_stat_bgwriter.maxwritten_cleanpg_stat_bgwriter10 – 20

  Number of times the background writer stopped a cleaning scan because it had written too many buffers

  此定义以英文显示

  1011121314151617181920
• pg_stat_bgwriter.stats_resetpg_stat_bgwriter10 – 20

  Time at which these statistics were last reset

  此定义以英文显示

  1011121314151617181920
• pg_stat_checkpointer.buffers_writtenpg_stat_checkpointer17 – 20

  Number of shared buffers written during checkpoints and restartpoints

  此定义以英文显示

  1011121314151617181920
• pg_stat_checkpointer.num_donepg_stat_checkpointer18 – 20

  Number of checkpoints that have been performed

  此定义以英文显示

  1011121314151617181920
• pg_stat_checkpointer.num_requestedpg_stat_checkpointer17 – 20

  Number of requested checkpoints

  此定义以英文显示

  1011121314151617181920
• pg_stat_checkpointer.num_timedpg_stat_checkpointer17 – 20

  Number of scheduled checkpoints due to timeout

  此定义以英文显示

  1011121314151617181920
• pg_stat_checkpointer.restartpoints_donepg_stat_checkpointer17 – 20

  Number of restartpoints that have been performed

  此定义以英文显示

  1011121314151617181920
• pg_stat_checkpointer.restartpoints_reqpg_stat_checkpointer17 – 20

  Number of requested restartpoints

  此定义以英文显示

  1011121314151617181920
• pg_stat_checkpointer.restartpoints_timedpg_stat_checkpointer17 – 20

  Number of scheduled restartpoints due to timeout or after a failed attempt to perform it

  此定义以英文显示

  1011121314151617181920
• pg_stat_checkpointer.slru_writtenpg_stat_checkpointer18 – 20

  Number of SLRU buffers written during checkpoints and restartpoints

  此定义以英文显示

  1011121314151617181920
• pg_stat_checkpointer.stats_resetpg_stat_checkpointer17 – 20

  Time at which these statistics were last reset

  此定义以英文显示

  1011121314151617181920
• pg_stat_checkpointer.sync_timepg_stat_checkpointer17 – 20

  Total amount of time that has been spent in the portion of processing checkpoints and restartpoints where files are synchronized to disk, in milliseconds

  此定义以英文显示

  1011121314151617181920
• pg_stat_checkpointer.write_timepg_stat_checkpointer17 – 20

  Total amount of time that has been spent in the portion of processing checkpoints and restartpoints where files are written to disk, in milliseconds

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.active_timepg_stat_database14 – 20

  Time spent executing SQL statements in this database, in milliseconds (this corresponds to the states active and fastpath function call in pg_stat_activity)

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.blk_read_timepg_stat_database10 – 20

  Time spent reading data file blocks by backends in this database, in milliseconds (if track_io_timing is enabled, otherwise zero)

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.blk_write_timepg_stat_database10 – 20

  Time spent writing data file blocks by backends in this database, in milliseconds (if track_io_timing is enabled, otherwise zero)

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.blks_hitpg_stat_database10 – 20

  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)

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.blks_readpg_stat_database10 – 20

  Number of disk blocks read in this database

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.checksum_failurespg_stat_database12 – 20

  Number of data page checksum failures detected in this database (or on a shared object), or NULL if data checksums are disabled.

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.checksum_last_failurepg_stat_database12 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.conflictspg_stat_database10 – 20

  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.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.datidpg_stat_database10 – 20

  OID of this database, or 0 for objects belonging to a shared relation

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.datnamepg_stat_database10 – 20

  Name of this database, or NULL for shared objects.

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.deadlockspg_stat_database10 – 20

  Number of deadlocks detected in this database

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.idle_in_transaction_timepg_stat_database14 – 20

  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)

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.numbackendspg_stat_database10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.parallel_workers_launchedpg_stat_database18 – 20

  Number of parallel workers launched by queries on this database

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.parallel_workers_to_launchpg_stat_database18 – 20

  Number of parallel workers planned to be launched by queries on this database

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.session_timepg_stat_database14 – 20

  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)

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.sessionspg_stat_database14 – 20

  Total number of sessions established to this database

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.sessions_abandonedpg_stat_database14 – 20

  Number of database sessions to this database that were terminated because connection to the client was lost

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.sessions_fatalpg_stat_database14 – 20

  Number of database sessions to this database that were terminated by fatal errors

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.sessions_killedpg_stat_database14 – 20

  Number of database sessions to this database that were terminated by operator intervention

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.stats_resetpg_stat_database10 – 20

  Time at which these statistics were last reset

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.temp_bytespg_stat_database10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.temp_filespg_stat_database10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.tup_deletedpg_stat_database10 – 20

  Number of rows deleted by queries in this database

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.tup_fetchedpg_stat_database10 – 20

  Number of live rows fetched by index scans in this database

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.tup_insertedpg_stat_database10 – 20

  Number of rows inserted by queries in this database

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.tup_returnedpg_stat_database10 – 20

  Number of live rows fetched by sequential scans and index entries returned by index scans in this database

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.tup_updatedpg_stat_database10 – 20

  Number of rows updated by queries in this database

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.xact_commitpg_stat_database10 – 20

  Number of transactions in this database that have been committed

  此定义以英文显示

  1011121314151617181920
• pg_stat_database.xact_rollbackpg_stat_database10 – 20

  Number of transactions in this database that have been rolled back

  此定义以英文显示

  1011121314151617181920
• pg_stat_database_conflicts.confl_active_logicalslotpg_stat_database_conflicts16 – 20

  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

  此定义以英文显示

  1011121314151617181920
• pg_stat_database_conflicts.confl_bufferpinpg_stat_database_conflicts10 – 20

  Number of queries in this database that have been canceled due to pinned buffers

  此定义以英文显示

  1011121314151617181920
• pg_stat_database_conflicts.confl_deadlockpg_stat_database_conflicts10 – 20

  Number of queries in this database that have been canceled due to deadlocks

  此定义以英文显示

  1011121314151617181920
• pg_stat_database_conflicts.confl_lockpg_stat_database_conflicts10 – 20

  Number of queries in this database that have been canceled due to lock timeouts

  此定义以英文显示

  1011121314151617181920
• pg_stat_database_conflicts.confl_snapshotpg_stat_database_conflicts10 – 20

  Number of queries in this database that have been canceled due to old snapshots

  此定义以英文显示

  1011121314151617181920
• pg_stat_database_conflicts.confl_tablespacepg_stat_database_conflicts10 – 20

  Number of queries in this database that have been canceled due to dropped tablespaces

  此定义以英文显示

  1011121314151617181920
• pg_stat_database_conflicts.datidpg_stat_database_conflicts10 – 20

  OID of a database

  此定义以英文显示

  1011121314151617181920
• pg_stat_database_conflicts.datnamepg_stat_database_conflicts10 – 20

  Name of this database

  此定义以英文显示

  1011121314151617181920
• pg_stat_gssapi.credentials_delegatedpg_stat_gssapi16 – 20

  True if GSSAPI credentials were delegated on this connection.

  此定义以英文显示

  1011121314151617181920
• pg_stat_gssapi.encryptedpg_stat_gssapi12 – 20

  True if GSSAPI encryption is in use on this connection

  此定义以英文显示

  1011121314151617181920
• pg_stat_gssapi.gss_authenticatedpg_stat_gssapi12 – 20

  True if GSSAPI authentication was used for this connection

  此定义以英文显示

  1011121314151617181920
• pg_stat_gssapi.pidpg_stat_gssapi12 – 20

  Process ID of a backend

  此定义以英文显示

  1011121314151617181920
• pg_stat_gssapi.principalpg_stat_gssapi12 – 20

  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).

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.backend_typepg_stat_io16 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.contextpg_stat_io16 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.evictionspg_stat_io16 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.extend_bytespg_stat_io18 – 20

  The total size of relation extend operations in bytes.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.extend_timepg_stat_io16 – 20

  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)

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.extendspg_stat_io16 – 20

  Number of relation extend operations.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.fsync_timepg_stat_io16 – 20

  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)

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.fsyncspg_stat_io16 – 20

  Number of fsync calls. These are only tracked in context normal.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.hitspg_stat_io16 – 20

  The number of times a desired block was found in a shared buffer.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.objectpg_stat_io16 – 20

  Target object of an I/O operation. Possible values are: relation: Permanent relations. temp relation: Temporary relations. wal: Write Ahead Logs.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.read_bytespg_stat_io18 – 20

  The total size of read operations in bytes.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.read_timepg_stat_io16 – 20

  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)

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.readspg_stat_io16 – 20

  Number of read operations.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.reusespg_stat_io16 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.stats_resetpg_stat_io16 – 20

  Time at which these statistics were last reset.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.write_bytespg_stat_io18 – 20

  The total size of write operations in bytes.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.write_timepg_stat_io16 – 20

  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)

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.writeback_timepg_stat_io16 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.writebackspg_stat_io16 – 20

  Number of units of size BLCKSZ (typically 8kB) which the process requested the kernel write out to permanent storage.

  此定义以英文显示

  1011121314151617181920
• pg_stat_io.writespg_stat_io16 – 20

  Number of write operations.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_analyze.child_tables_donepg_stat_progress_analyze13 – 20

  Number of child tables scanned. This counter only advances when the phase is acquiring inherited sample rows.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_analyze.child_tables_totalpg_stat_progress_analyze13 – 20

  Number of child tables.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_analyze.current_child_table_relidpg_stat_progress_analyze13 – 20

  OID of the child table currently being scanned. This field is only valid when the phase is acquiring inherited sample rows.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_analyze.datidpg_stat_progress_analyze13 – 20

  OID of the database to which this backend is connected.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_analyze.datnamepg_stat_progress_analyze13 – 20

  Name of the database to which this backend is connected.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_analyze.delay_timepg_stat_progress_analyze18 – 20

  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).

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_analyze.ext_stats_computedpg_stat_progress_analyze13 – 20

  Number of extended statistics computed. This counter only advances when the phase is computing extended statistics.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_analyze.ext_stats_totalpg_stat_progress_analyze13 – 20

  Number of extended statistics.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_analyze.phasepg_stat_progress_analyze13 – 20

  Current processing phase. See Table 27.39.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_analyze.pidpg_stat_progress_analyze13 – 20

  Process ID of backend.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_analyze.relidpg_stat_progress_analyze13 – 20

  OID of the table being analyzed.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_analyze.sample_blks_scannedpg_stat_progress_analyze13 – 20

  Number of heap blocks scanned.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_analyze.sample_blks_totalpg_stat_progress_analyze13 – 20

  Total number of heap blocks that will be sampled.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_basebackup.backup_streamedpg_stat_progress_basebackup13 – 20

  Amount of data streamed. This counter only advances when the phase is streaming database files or transferring wal files.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_basebackup.backup_totalpg_stat_progress_basebackup13 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_basebackup.phasepg_stat_progress_basebackup13 – 20

  Current processing phase. See Table 27.48.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_basebackup.pidpg_stat_progress_basebackup13 – 20

  Process ID of a WAL sender process.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_basebackup.tablespaces_streamedpg_stat_progress_basebackup13 – 20

  Number of tablespaces streamed. This counter only advances when the phase is streaming database files.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_basebackup.tablespaces_totalpg_stat_progress_basebackup13 – 20

  Total number of tablespaces that will be streamed.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_cluster.cluster_index_relidpg_stat_progress_cluster12 – 20

  If the table is being scanned using an index, this is the OID of the index being used; otherwise, it is zero.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_cluster.commandpg_stat_progress_cluster12 – 20

  The command that is running. Either CLUSTER or VACUUM FULL.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_cluster.datidpg_stat_progress_cluster12 – 20

  OID of the database to which this backend is connected.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_cluster.datnamepg_stat_progress_cluster12 – 20

  Name of the database to which this backend is connected.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_cluster.heap_blks_scannedpg_stat_progress_cluster12 – 20

  Number of heap blocks scanned. This counter only advances when the phase is seq scanning heap.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_cluster.heap_blks_totalpg_stat_progress_cluster12 – 20

  Total number of heap blocks in the table. This number is reported as of the beginning of seq scanning heap.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_cluster.heap_tuples_scannedpg_stat_progress_cluster12 – 20

  Number of heap tuples scanned. This counter only advances when the phase is seq scanning heap, index scanning heap or writing new heap.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_cluster.heap_tuples_writtenpg_stat_progress_cluster12 – 20

  Number of heap tuples written. This counter only advances when the phase is seq scanning heap, index scanning heap or writing new heap.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_cluster.index_rebuild_countpg_stat_progress_cluster12 – 20

  Number of indexes rebuilt. This counter only advances when the phase is rebuilding index.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_cluster.phasepg_stat_progress_cluster12 – 20

  Current processing phase. See Table 27.41.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_cluster.pidpg_stat_progress_cluster12 – 20

  Process ID of backend.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_cluster.relidpg_stat_progress_cluster12 – 20

  OID of the table being clustered.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_copy.bytes_processedpg_stat_progress_copy14 – 20

  Number of bytes already processed by COPY command.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_copy.bytes_totalpg_stat_progress_copy14 – 20

  Size of source file for COPY FROM command in bytes. It is set to 0 if not available.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_copy.commandpg_stat_progress_copy14 – 20

  The command that is running: COPY FROM, or COPY TO.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_copy.datidpg_stat_progress_copy14 – 20

  OID of the database to which this backend is connected.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_copy.datnamepg_stat_progress_copy14 – 20

  Name of the database to which this backend is connected.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_copy.pidpg_stat_progress_copy14 – 20

  Process ID of backend.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_copy.relidpg_stat_progress_copy14 – 20

  OID of the table on which the COPY command is executed. It is set to 0 if copying from a SELECT query.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_copy.tuples_excludedpg_stat_progress_copy14 – 20

  Number of tuples not processed because they were excluded by the WHERE clause of the COPY command.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_copy.tuples_processedpg_stat_progress_copy14 – 20

  Number of tuples already processed by COPY command.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_copy.tuples_skippedpg_stat_progress_copy17 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_copy.typepg_stat_progress_copy14 – 20

  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).

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.blocks_donepg_stat_progress_create_index12 – 20

  Number of blocks already processed in the current phase.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.blocks_totalpg_stat_progress_create_index12 – 20

  Total number of blocks to be processed in the current phase.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.commandpg_stat_progress_create_index12 – 20

  Specific command type: CREATE INDEX, CREATE INDEX CONCURRENTLY, REINDEX, or REINDEX CONCURRENTLY.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.current_locker_pidpg_stat_progress_create_index12 – 20

  Process ID of the locker currently being waited for.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.datidpg_stat_progress_create_index12 – 20

  OID of the database to which this backend is connected.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.datnamepg_stat_progress_create_index12 – 20

  Name of the database to which this backend is connected.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.index_relidpg_stat_progress_create_index12 – 20

  OID of the index being created or reindexed. During a non-concurrent CREATE INDEX, this is 0.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.lockers_donepg_stat_progress_create_index12 – 20

  Number of lockers already waited for.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.lockers_totalpg_stat_progress_create_index12 – 20

  Total number of lockers to wait for, when applicable.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.partitions_donepg_stat_progress_create_index12 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.partitions_totalpg_stat_progress_create_index12 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.phasepg_stat_progress_create_index12 – 20

  Current processing phase of index creation. See Table 27.44.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.pidpg_stat_progress_create_index12 – 20

  Process ID of the backend creating indexes.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.relidpg_stat_progress_create_index12 – 20

  OID of the table on which the index is being created.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.tuples_donepg_stat_progress_create_index12 – 20

  Number of tuples already processed in the current phase.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_create_index.tuples_totalpg_stat_progress_create_index12 – 20

  Total number of tuples to be processed in the current phase.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.datidpg_stat_progress_vacuum10 – 20

  OID of the database to which this backend is connected.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.datnamepg_stat_progress_vacuum10 – 20

  Name of the database to which this backend is connected.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.dead_tuple_bytespg_stat_progress_vacuum17 – 20

  Amount of dead tuple data collected since the last index vacuum cycle.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.delay_timepg_stat_progress_vacuum18 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.heap_blks_scannedpg_stat_progress_vacuum10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.heap_blks_totalpg_stat_progress_vacuum10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.heap_blks_vacuumedpg_stat_progress_vacuum10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.index_vacuum_countpg_stat_progress_vacuum10 – 20

  Number of completed index vacuum cycles.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.indexes_processedpg_stat_progress_vacuum17 – 20

  Number of indexes processed. This counter only advances when the phase is vacuuming indexes or cleaning up indexes.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.indexes_totalpg_stat_progress_vacuum17 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.max_dead_tuple_bytespg_stat_progress_vacuum17 – 20

  Amount of dead tuple data that we can store before needing to perform an index vacuum cycle, based on maintenance_work_mem.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.num_dead_item_idspg_stat_progress_vacuum17 – 20

  Number of dead item identifiers collected since the last index vacuum cycle.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.phasepg_stat_progress_vacuum10 – 20

  Current processing phase of vacuum. See Table 27.46.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.pidpg_stat_progress_vacuum10 – 20

  Process ID of backend.

  此定义以英文显示

  1011121314151617181920
• pg_stat_progress_vacuum.relidpg_stat_progress_vacuum10 – 20

  OID of the table being vacuumed.

  此定义以英文显示

  1011121314151617181920
• pg_stat_recovery_prefetch.block_distancepg_stat_recovery_prefetch15 – 20

  How many blocks ahead the prefetcher is looking

  此定义以英文显示

  1011121314151617181920
• pg_stat_recovery_prefetch.hitpg_stat_recovery_prefetch15 – 20

  Number of blocks not prefetched because they were already in the buffer pool

  此定义以英文显示

  1011121314151617181920
• pg_stat_recovery_prefetch.io_depthpg_stat_recovery_prefetch15 – 20

  How many prefetches have been initiated but are not yet known to have completed

  此定义以英文显示

  1011121314151617181920
• pg_stat_recovery_prefetch.prefetchpg_stat_recovery_prefetch15 – 20

  Number of blocks prefetched because they were not in the buffer pool

  此定义以英文显示

  1011121314151617181920
• pg_stat_recovery_prefetch.skip_fpwpg_stat_recovery_prefetch15 – 20

  Number of blocks not prefetched because a full page image was included in the WAL

  此定义以英文显示

  1011121314151617181920
• pg_stat_recovery_prefetch.skip_initpg_stat_recovery_prefetch15 – 20

  Number of blocks not prefetched because they would be zero-initialized

  此定义以英文显示

  1011121314151617181920
• pg_stat_recovery_prefetch.skip_newpg_stat_recovery_prefetch15 – 20

  Number of blocks not prefetched because they didn't exist yet

  此定义以英文显示

  1011121314151617181920
• pg_stat_recovery_prefetch.skip_reppg_stat_recovery_prefetch15 – 20

  Number of blocks not prefetched because they were already recently prefetched

  此定义以英文显示

  1011121314151617181920
• pg_stat_recovery_prefetch.stats_resetpg_stat_recovery_prefetch15 – 20

  Time at which these statistics were last reset

  此定义以英文显示

  1011121314151617181920
• pg_stat_recovery_prefetch.wal_distancepg_stat_recovery_prefetch15 – 20

  How many bytes ahead the prefetcher is looking

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.application_namepg_stat_replication10 – 20

  Name of the application that is connected to this WAL sender

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.backend_startpg_stat_replication10 – 20

  Time when this process was started, i.e., when the client connected to this WAL sender

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.backend_xminpg_stat_replication10 – 20

  This standby's xmin horizon reported by hot_standby_feedback.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.client_addrpg_stat_replication10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.client_hostnamepg_stat_replication10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.client_portpg_stat_replication10 – 20

  TCP port number that the client is using for communication with this WAL sender, or -1 if a Unix socket is used

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.flush_lagpg_stat_replication10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.flush_lsnpg_stat_replication10 – 20

  Last write-ahead log location flushed to disk by this standby server

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.pidpg_stat_replication10 – 20

  Process ID of a WAL sender process

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.replay_lagpg_stat_replication10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.replay_lsnpg_stat_replication10 – 20

  Last write-ahead log location replayed into the database on this standby server

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.reply_timepg_stat_replication12 – 20

  Send time of last reply message received from standby server

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.sent_lsnpg_stat_replication10 – 20

  Last write-ahead log location sent on this connection

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.statepg_stat_replication10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.sync_prioritypg_stat_replication10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.sync_statepg_stat_replication10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.usenamepg_stat_replication10 – 20

  Name of the user logged into this WAL sender process

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.usesysidpg_stat_replication10 – 20

  OID of the user logged into this WAL sender process

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.write_lagpg_stat_replication10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication.write_lsnpg_stat_replication10 – 20

  Last write-ahead log location written to disk by this standby server

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication_slots.slot_namepg_stat_replication_slots14 – 20

  A unique, cluster-wide identifier for the replication slot

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication_slots.spill_bytespg_stat_replication_slots14 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication_slots.spill_countpg_stat_replication_slots14 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication_slots.spill_txnspg_stat_replication_slots14 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication_slots.stats_resetpg_stat_replication_slots14 – 20

  Time at which these statistics were last reset

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication_slots.stream_bytespg_stat_replication_slots14 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication_slots.stream_countpg_stat_replication_slots14 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication_slots.stream_txnspg_stat_replication_slots14 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication_slots.total_bytespg_stat_replication_slots14 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_replication_slots.total_txnspg_stat_replication_slots14 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_slru.blks_existspg_stat_slru13 – 20

  Number of blocks checked for existence for this SLRU

  此定义以英文显示

  1011121314151617181920
• pg_stat_slru.blks_hitpg_stat_slru13 – 20

  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)

  此定义以英文显示

  1011121314151617181920
• pg_stat_slru.blks_readpg_stat_slru13 – 20

  Number of disk blocks read for this SLRU

  此定义以英文显示

  1011121314151617181920
• pg_stat_slru.blks_writtenpg_stat_slru13 – 20

  Number of disk blocks written for this SLRU

  此定义以英文显示

  1011121314151617181920
• pg_stat_slru.blks_zeroedpg_stat_slru13 – 20

  Number of blocks zeroed during initializations

  此定义以英文显示

  1011121314151617181920
• pg_stat_slru.flushespg_stat_slru13 – 20

  Number of flushes of dirty data for this SLRU

  此定义以英文显示

  1011121314151617181920
• pg_stat_slru.namepg_stat_slru13 – 20

  Name of the SLRU

  此定义以英文显示

  1011121314151617181920
• pg_stat_slru.stats_resetpg_stat_slru13 – 20

  Time at which these statistics were last reset

  此定义以英文显示

  1011121314151617181920
• pg_stat_slru.truncatespg_stat_slru13 – 20

  Number of truncates for this SLRU

  此定义以英文显示

  1011121314151617181920
• pg_stat_ssl.bitspg_stat_ssl10 – 20

  Number of bits in the encryption algorithm used, or NULL if SSL is not used on this connection

  此定义以英文显示

  1011121314151617181920
• pg_stat_ssl.cipherpg_stat_ssl10 – 20

  Name of SSL cipher in use, or NULL if SSL is not in use on this connection

  此定义以英文显示

  1011121314151617181920
• pg_stat_ssl.client_dnpg_stat_ssl12 – 20

  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).

  此定义以英文显示

  1011121314151617181920
• pg_stat_ssl.client_serialpg_stat_ssl12 – 20

  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).

  此定义以英文显示

  1011121314151617181920
• pg_stat_ssl.issuer_dnpg_stat_ssl12 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_ssl.pidpg_stat_ssl10 – 20

  Process ID of a backend or WAL sender process

  此定义以英文显示

  1011121314151617181920
• pg_stat_ssl.sslpg_stat_ssl10 – 20

  True if SSL is used on this connection

  此定义以英文显示

  1011121314151617181920
• pg_stat_ssl.versionpg_stat_ssl10 – 20

  Version of SSL in use, or NULL if SSL is not in use on this connection

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription.last_msg_receipt_timepg_stat_subscription10 – 20

  Receipt time of last message received from origin WAL sender; NULL for parallel apply workers

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription.last_msg_send_timepg_stat_subscription10 – 20

  Send time of last message received from origin WAL sender; NULL for parallel apply workers

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription.latest_end_lsnpg_stat_subscription10 – 20

  Last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription.latest_end_timepg_stat_subscription10 – 20

  Time of last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription.leader_pidpg_stat_subscription16 – 20

  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

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription.pidpg_stat_subscription10 – 20

  Process ID of the subscription worker process

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription.received_lsnpg_stat_subscription10 – 20

  Last write-ahead log location received, the initial value of this field being 0; NULL for parallel apply workers

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription.relidpg_stat_subscription10 – 20

  OID of the relation that the worker is synchronizing; NULL for the leader apply worker and parallel apply workers

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription.subidpg_stat_subscription10 – 20

  OID of the subscription

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription.subnamepg_stat_subscription10 – 20

  Name of the subscription

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription.worker_typepg_stat_subscription17 – 20

  Type of the subscription worker process. Possible types are apply, parallel apply, and table synchronization.

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription_stats.apply_error_countpg_stat_subscription_stats15 – 20

  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_*).

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription_stats.confl_delete_missingpg_stat_subscription_stats18 – 20

  Number of times the tuple to be deleted was not found during the application of changes. See delete_missing for details about this conflict.

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription_stats.confl_delete_origin_differspg_stat_subscription_stats18 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription_stats.confl_insert_existspg_stat_subscription_stats18 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription_stats.confl_multiple_unique_conflictspg_stat_subscription_stats18 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription_stats.confl_update_existspg_stat_subscription_stats18 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription_stats.confl_update_missingpg_stat_subscription_stats18 – 20

  Number of times the tuple to be updated was not found during the application of changes. See update_missing for details about this conflict.

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription_stats.confl_update_origin_differspg_stat_subscription_stats18 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription_stats.stats_resetpg_stat_subscription_stats15 – 20

  Time at which these statistics were last reset

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription_stats.subidpg_stat_subscription_stats15 – 20

  OID of the subscription

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription_stats.subnamepg_stat_subscription_stats15 – 20

  Name of the subscription

  此定义以英文显示

  1011121314151617181920
• pg_stat_subscription_stats.sync_error_countpg_stat_subscription_stats15 – 18

  Number of times an error occurred during the initial table synchronization

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_indexes.idx_scanpg_stat_sys_indexes10 – 20

  Number of index scans initiated on this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_indexes.idx_tup_fetchpg_stat_sys_indexes10 – 20

  Number of live table rows fetched by simple index scans using this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_indexes.idx_tup_readpg_stat_sys_indexes10 – 20

  Number of index entries returned by scans on this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_indexes.indexrelidpg_stat_sys_indexes10 – 20

  OID of this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_indexes.indexrelnamepg_stat_sys_indexes10 – 20

  Name of this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_indexes.last_idx_scanpg_stat_sys_indexes16 – 20

  The time of the last scan on this index, based on the most recent transaction stop time

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_indexes.relidpg_stat_sys_indexes10 – 20

  OID of the table for this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_indexes.relnamepg_stat_sys_indexes10 – 20

  Name of the table for this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_indexes.schemanamepg_stat_sys_indexes10 – 20

  Name of the schema this index is in

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.analyze_countpg_stat_sys_tables10 – 20

  Number of times this table has been manually analyzed

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.autoanalyze_countpg_stat_sys_tables10 – 20

  Number of times this table has been analyzed by the autovacuum daemon

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.autovacuum_countpg_stat_sys_tables10 – 20

  Number of times this table has been vacuumed by the autovacuum daemon

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.idx_scanpg_stat_sys_tables10 – 20

  Number of index scans initiated on this table

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.idx_tup_fetchpg_stat_sys_tables10 – 20

  Number of live rows fetched by index scans

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.last_analyzepg_stat_sys_tables10 – 20

  Last time at which this table was manually analyzed

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.last_autoanalyzepg_stat_sys_tables10 – 20

  Last time at which this table was analyzed by the autovacuum daemon

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.last_autovacuumpg_stat_sys_tables10 – 20

  Last time at which this table was vacuumed by the autovacuum daemon

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.last_idx_scanpg_stat_sys_tables16 – 20

  The time of the last index scan on this table, based on the most recent transaction stop time

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.last_seq_scanpg_stat_sys_tables16 – 20

  The time of the last sequential scan on this table, based on the most recent transaction stop time

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.last_vacuumpg_stat_sys_tables10 – 20

  Last time at which this table was manually vacuumed (not counting VACUUM FULL)

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.n_dead_tuppg_stat_sys_tables10 – 20

  Estimated number of dead rows

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.n_ins_since_vacuumpg_stat_sys_tables13 – 20

  Estimated number of rows inserted since this table was last vacuumed (not counting VACUUM FULL)

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.n_live_tuppg_stat_sys_tables10 – 20

  Estimated number of live rows

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.n_mod_since_analyzepg_stat_sys_tables10 – 20

  Estimated number of rows modified since this table was last analyzed

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.n_tup_delpg_stat_sys_tables10 – 20

  Total number of rows deleted

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.n_tup_hot_updpg_stat_sys_tables10 – 20

  Number of rows HOT updated. These are updates where no successor versions are required in indexes.

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.n_tup_inspg_stat_sys_tables10 – 20

  Total number of rows inserted

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.n_tup_newpage_updpg_stat_sys_tables16 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.n_tup_updpg_stat_sys_tables10 – 20

  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.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.relidpg_stat_sys_tables10 – 20

  OID of a table

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.relnamepg_stat_sys_tables10 – 20

  Name of this table

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.schemanamepg_stat_sys_tables10 – 20

  Name of the schema that this table is in

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.seq_scanpg_stat_sys_tables10 – 20

  Number of sequential scans initiated on this table

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.seq_tup_readpg_stat_sys_tables10 – 20

  Number of live rows fetched by sequential scans

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.total_analyze_timepg_stat_sys_tables18 – 20

  Total time this table has been manually analyzed, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.total_autoanalyze_timepg_stat_sys_tables18 – 20

  Total time this table has been analyzed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.total_autovacuum_timepg_stat_sys_tables18 – 20

  Total time this table has been vacuumed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.total_vacuum_timepg_stat_sys_tables18 – 20

  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.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_sys_tables.vacuum_countpg_stat_sys_tables10 – 20

  Number of times this table has been manually vacuumed (not counting VACUUM FULL)

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_functions.callspg_stat_user_functions10 – 20

  Number of times this function has been called

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_functions.funcidpg_stat_user_functions10 – 20

  OID of a function

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_functions.funcnamepg_stat_user_functions10 – 20

  Name of this function

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_functions.schemanamepg_stat_user_functions10 – 20

  Name of the schema this function is in

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_functions.self_timepg_stat_user_functions10 – 20

  Total time spent in this function itself, not including other functions called by it, in milliseconds

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_functions.total_timepg_stat_user_functions10 – 20

  Total time spent in this function and all other functions called by it, in milliseconds

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_indexes.idx_scanpg_stat_user_indexes10 – 20

  Number of index scans initiated on this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_indexes.idx_tup_fetchpg_stat_user_indexes10 – 20

  Number of live table rows fetched by simple index scans using this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_indexes.idx_tup_readpg_stat_user_indexes10 – 20

  Number of index entries returned by scans on this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_indexes.indexrelidpg_stat_user_indexes10 – 20

  OID of this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_indexes.indexrelnamepg_stat_user_indexes10 – 20

  Name of this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_indexes.last_idx_scanpg_stat_user_indexes16 – 20

  The time of the last scan on this index, based on the most recent transaction stop time

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_indexes.relidpg_stat_user_indexes10 – 20

  OID of the table for this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_indexes.relnamepg_stat_user_indexes10 – 20

  Name of the table for this index

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_indexes.schemanamepg_stat_user_indexes10 – 20

  Name of the schema this index is in

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.analyze_countpg_stat_user_tables10 – 20

  Number of times this table has been manually analyzed

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.autoanalyze_countpg_stat_user_tables10 – 20

  Number of times this table has been analyzed by the autovacuum daemon

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.autovacuum_countpg_stat_user_tables10 – 20

  Number of times this table has been vacuumed by the autovacuum daemon

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.idx_scanpg_stat_user_tables10 – 20

  Number of index scans initiated on this table

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.idx_tup_fetchpg_stat_user_tables10 – 20

  Number of live rows fetched by index scans

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.last_analyzepg_stat_user_tables10 – 20

  Last time at which this table was manually analyzed

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.last_autoanalyzepg_stat_user_tables10 – 20

  Last time at which this table was analyzed by the autovacuum daemon

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.last_autovacuumpg_stat_user_tables10 – 20

  Last time at which this table was vacuumed by the autovacuum daemon

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.last_idx_scanpg_stat_user_tables16 – 20

  The time of the last index scan on this table, based on the most recent transaction stop time

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.last_seq_scanpg_stat_user_tables16 – 20

  The time of the last sequential scan on this table, based on the most recent transaction stop time

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.last_vacuumpg_stat_user_tables10 – 20

  Last time at which this table was manually vacuumed (not counting VACUUM FULL)

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.n_dead_tuppg_stat_user_tables10 – 20

  Estimated number of dead rows

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.n_ins_since_vacuumpg_stat_user_tables13 – 20

  Estimated number of rows inserted since this table was last vacuumed (not counting VACUUM FULL)

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.n_live_tuppg_stat_user_tables10 – 20

  Estimated number of live rows

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.n_mod_since_analyzepg_stat_user_tables10 – 20

  Estimated number of rows modified since this table was last analyzed

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.n_tup_delpg_stat_user_tables10 – 20

  Total number of rows deleted

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.n_tup_hot_updpg_stat_user_tables10 – 20

  Number of rows HOT updated. These are updates where no successor versions are required in indexes.

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.n_tup_inspg_stat_user_tables10 – 20

  Total number of rows inserted

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.n_tup_newpage_updpg_stat_user_tables16 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.n_tup_updpg_stat_user_tables10 – 20

  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.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.relidpg_stat_user_tables10 – 20

  OID of a table

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.relnamepg_stat_user_tables10 – 20

  Name of this table

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.schemanamepg_stat_user_tables10 – 20

  Name of the schema that this table is in

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.seq_scanpg_stat_user_tables10 – 20

  Number of sequential scans initiated on this table

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.seq_tup_readpg_stat_user_tables10 – 20

  Number of live rows fetched by sequential scans

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.total_analyze_timepg_stat_user_tables18 – 20

  Total time this table has been manually analyzed, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.total_autoanalyze_timepg_stat_user_tables18 – 20

  Total time this table has been analyzed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.total_autovacuum_timepg_stat_user_tables18 – 20

  Total time this table has been vacuumed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.total_vacuum_timepg_stat_user_tables18 – 20

  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.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_user_tables.vacuum_countpg_stat_user_tables10 – 20

  Number of times this table has been manually vacuumed (not counting VACUUM FULL)

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal.stats_resetpg_stat_wal14 – 20

  Time at which these statistics were last reset

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal.wal_buffers_fullpg_stat_wal14 – 20

  Number of times WAL data was written to disk because WAL buffers became full

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal.wal_bytespg_stat_wal14 – 20

  Total amount of WAL generated in bytes

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal.wal_fpipg_stat_wal14 – 20

  Total number of WAL full page images generated

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal.wal_recordspg_stat_wal14 – 20

  Total number of WAL records generated

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.conninfopg_stat_wal_receiver10 – 20

  Connection string used by this WAL receiver, with security-sensitive fields obfuscated.

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.flushed_lsnpg_stat_wal_receiver13 – 20

  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

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.last_msg_receipt_timepg_stat_wal_receiver10 – 20

  Receipt time of last message received from origin WAL sender

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.last_msg_send_timepg_stat_wal_receiver10 – 20

  Send time of last message received from origin WAL sender

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.latest_end_lsnpg_stat_wal_receiver10 – 20

  Last write-ahead log location reported to origin WAL sender

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.latest_end_timepg_stat_wal_receiver10 – 20

  Time of last write-ahead log location reported to origin WAL sender

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.pidpg_stat_wal_receiver10 – 20

  Process ID of the WAL receiver process

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.receive_start_lsnpg_stat_wal_receiver10 – 20

  First write-ahead log location used when WAL receiver is started

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.receive_start_tlipg_stat_wal_receiver10 – 20

  First timeline number used when WAL receiver is started

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.received_tlipg_stat_wal_receiver10 – 20

  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

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.sender_hostpg_stat_wal_receiver11 – 20

  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 /.)

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.sender_portpg_stat_wal_receiver11 – 20

  Port number of the PostgreSQL instance this WAL receiver is connected to.

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.slot_namepg_stat_wal_receiver10 – 20

  Replication slot name used by this WAL receiver

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.statuspg_stat_wal_receiver10 – 20

  Activity status of the WAL receiver process

  此定义以英文显示

  1011121314151617181920
• pg_stat_wal_receiver.written_lsnpg_stat_wal_receiver13 – 20

  Last write-ahead log location already received and written to disk, but not flushed. This should not be used for data integrity checks.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_all_tables.idx_scanpg_stat_xact_all_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_all_tables.idx_tup_fetchpg_stat_xact_all_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_all_tables.n_tup_delpg_stat_xact_all_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_all_tables.n_tup_hot_updpg_stat_xact_all_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_all_tables.n_tup_inspg_stat_xact_all_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_all_tables.n_tup_newpage_updpg_stat_xact_all_tables16 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_all_tables.n_tup_updpg_stat_xact_all_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_all_tables.relidpg_stat_xact_all_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_all_tables.relnamepg_stat_xact_all_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_all_tables.schemanamepg_stat_xact_all_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_all_tables.seq_scanpg_stat_xact_all_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_all_tables.seq_tup_readpg_stat_xact_all_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_sys_tables.idx_scanpg_stat_xact_sys_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_sys_tables.idx_tup_fetchpg_stat_xact_sys_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_sys_tables.n_tup_delpg_stat_xact_sys_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_sys_tables.n_tup_hot_updpg_stat_xact_sys_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_sys_tables.n_tup_inspg_stat_xact_sys_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_sys_tables.n_tup_newpage_updpg_stat_xact_sys_tables16 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_sys_tables.n_tup_updpg_stat_xact_sys_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_sys_tables.relidpg_stat_xact_sys_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_sys_tables.relnamepg_stat_xact_sys_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_sys_tables.schemanamepg_stat_xact_sys_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_sys_tables.seq_scanpg_stat_xact_sys_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_sys_tables.seq_tup_readpg_stat_xact_sys_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_functions.callspg_stat_xact_user_functions10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_functions.funcidpg_stat_xact_user_functions10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_functions.funcnamepg_stat_xact_user_functions10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_functions.schemanamepg_stat_xact_user_functions10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_functions.self_timepg_stat_xact_user_functions10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_functions.total_timepg_stat_xact_user_functions10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_tables.idx_scanpg_stat_xact_user_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_tables.idx_tup_fetchpg_stat_xact_user_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_tables.n_tup_delpg_stat_xact_user_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_tables.n_tup_hot_updpg_stat_xact_user_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_tables.n_tup_inspg_stat_xact_user_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_tables.n_tup_newpage_updpg_stat_xact_user_tables16 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_tables.n_tup_updpg_stat_xact_user_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_tables.relidpg_stat_xact_user_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_tables.relnamepg_stat_xact_user_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_tables.schemanamepg_stat_xact_user_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_tables.seq_scanpg_stat_xact_user_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_stat_xact_user_tables.seq_tup_readpg_stat_xact_user_tables10 – 20

  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.

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_indexes.idx_blks_hitpg_statio_all_indexes10 – 20

  Number of buffer hits in this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_indexes.idx_blks_readpg_statio_all_indexes10 – 20

  Number of disk blocks read from this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_indexes.indexrelidpg_statio_all_indexes10 – 20

  OID of this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_indexes.indexrelnamepg_statio_all_indexes10 – 20

  Name of this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_indexes.relidpg_statio_all_indexes10 – 20

  OID of the table for this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_indexes.relnamepg_statio_all_indexes10 – 20

  Name of the table for this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_indexes.schemanamepg_statio_all_indexes10 – 20

  Name of the schema this index is in

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_sequences.blks_hitpg_statio_all_sequences10 – 20

  Number of buffer hits in this sequence

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_sequences.blks_readpg_statio_all_sequences10 – 20

  Number of disk blocks read from this sequence

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_sequences.relidpg_statio_all_sequences10 – 20

  OID of a sequence

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_sequences.relnamepg_statio_all_sequences10 – 20

  Name of this sequence

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_sequences.schemanamepg_statio_all_sequences10 – 20

  Name of the schema this sequence is in

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_tables.heap_blks_hitpg_statio_all_tables10 – 20

  Number of buffer hits in this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_tables.heap_blks_readpg_statio_all_tables10 – 20

  Number of disk blocks read from this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_tables.idx_blks_hitpg_statio_all_tables10 – 20

  Number of buffer hits in all indexes on this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_tables.idx_blks_readpg_statio_all_tables10 – 20

  Number of disk blocks read from all indexes on this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_tables.relidpg_statio_all_tables10 – 20

  OID of a table

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_tables.relnamepg_statio_all_tables10 – 20

  Name of this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_tables.schemanamepg_statio_all_tables10 – 20

  Name of the schema that this table is in

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_tables.tidx_blks_hitpg_statio_all_tables10 – 20

  Number of buffer hits in this table's TOAST table indexes (if any)

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_tables.tidx_blks_readpg_statio_all_tables10 – 20

  Number of disk blocks read from this table's TOAST table indexes (if any)

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_tables.toast_blks_hitpg_statio_all_tables10 – 20

  Number of buffer hits in this table's TOAST table (if any)

  此定义以英文显示

  1011121314151617181920
• pg_statio_all_tables.toast_blks_readpg_statio_all_tables10 – 20

  Number of disk blocks read from this table's TOAST table (if any)

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_indexes.idx_blks_hitpg_statio_sys_indexes10 – 20

  Number of buffer hits in this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_indexes.idx_blks_readpg_statio_sys_indexes10 – 20

  Number of disk blocks read from this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_indexes.indexrelidpg_statio_sys_indexes10 – 20

  OID of this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_indexes.indexrelnamepg_statio_sys_indexes10 – 20

  Name of this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_indexes.relidpg_statio_sys_indexes10 – 20

  OID of the table for this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_indexes.relnamepg_statio_sys_indexes10 – 20

  Name of the table for this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_indexes.schemanamepg_statio_sys_indexes10 – 20

  Name of the schema this index is in

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_sequences.blks_hitpg_statio_sys_sequences10 – 20

  Number of buffer hits in this sequence

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_sequences.blks_readpg_statio_sys_sequences10 – 20

  Number of disk blocks read from this sequence

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_sequences.relidpg_statio_sys_sequences10 – 20

  OID of a sequence

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_sequences.relnamepg_statio_sys_sequences10 – 20

  Name of this sequence

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_sequences.schemanamepg_statio_sys_sequences10 – 20

  Name of the schema this sequence is in

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_tables.heap_blks_hitpg_statio_sys_tables10 – 20

  Number of buffer hits in this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_tables.heap_blks_readpg_statio_sys_tables10 – 20

  Number of disk blocks read from this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_tables.idx_blks_hitpg_statio_sys_tables10 – 20

  Number of buffer hits in all indexes on this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_tables.idx_blks_readpg_statio_sys_tables10 – 20

  Number of disk blocks read from all indexes on this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_tables.relidpg_statio_sys_tables10 – 20

  OID of a table

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_tables.relnamepg_statio_sys_tables10 – 20

  Name of this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_tables.schemanamepg_statio_sys_tables10 – 20

  Name of the schema that this table is in

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_tables.tidx_blks_hitpg_statio_sys_tables10 – 20

  Number of buffer hits in this table's TOAST table indexes (if any)

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_tables.tidx_blks_readpg_statio_sys_tables10 – 20

  Number of disk blocks read from this table's TOAST table indexes (if any)

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_tables.toast_blks_hitpg_statio_sys_tables10 – 20

  Number of buffer hits in this table's TOAST table (if any)

  此定义以英文显示

  1011121314151617181920
• pg_statio_sys_tables.toast_blks_readpg_statio_sys_tables10 – 20

  Number of disk blocks read from this table's TOAST table (if any)

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_indexes.idx_blks_hitpg_statio_user_indexes10 – 20

  Number of buffer hits in this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_indexes.idx_blks_readpg_statio_user_indexes10 – 20

  Number of disk blocks read from this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_indexes.indexrelidpg_statio_user_indexes10 – 20

  OID of this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_indexes.indexrelnamepg_statio_user_indexes10 – 20

  Name of this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_indexes.relidpg_statio_user_indexes10 – 20

  OID of the table for this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_indexes.relnamepg_statio_user_indexes10 – 20

  Name of the table for this index

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_indexes.schemanamepg_statio_user_indexes10 – 20

  Name of the schema this index is in

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_sequences.blks_hitpg_statio_user_sequences10 – 20

  Number of buffer hits in this sequence

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_sequences.blks_readpg_statio_user_sequences10 – 20

  Number of disk blocks read from this sequence

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_sequences.relidpg_statio_user_sequences10 – 20

  OID of a sequence

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_sequences.relnamepg_statio_user_sequences10 – 20

  Name of this sequence

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_sequences.schemanamepg_statio_user_sequences10 – 20

  Name of the schema this sequence is in

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_tables.heap_blks_hitpg_statio_user_tables10 – 20

  Number of buffer hits in this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_tables.heap_blks_readpg_statio_user_tables10 – 20

  Number of disk blocks read from this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_tables.idx_blks_hitpg_statio_user_tables10 – 20

  Number of buffer hits in all indexes on this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_tables.idx_blks_readpg_statio_user_tables10 – 20

  Number of disk blocks read from all indexes on this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_tables.relidpg_statio_user_tables10 – 20

  OID of a table

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_tables.relnamepg_statio_user_tables10 – 20

  Name of this table

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_tables.schemanamepg_statio_user_tables10 – 20

  Name of the schema that this table is in

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_tables.tidx_blks_hitpg_statio_user_tables10 – 20

  Number of buffer hits in this table's TOAST table indexes (if any)

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_tables.tidx_blks_readpg_statio_user_tables10 – 20

  Number of disk blocks read from this table's TOAST table indexes (if any)

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_tables.toast_blks_hitpg_statio_user_tables10 – 20

  Number of buffer hits in this table's TOAST table (if any)

  此定义以英文显示

  1011121314151617181920
• pg_statio_user_tables.toast_blks_readpg_statio_user_tables10 – 20

  Number of disk blocks read from this table's TOAST table (if any)

  此定义以英文显示

  1011121314151617181920