Search PostgreSQL documentation

pg_stat_activity.application_nameStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityName of the application that is connected to this backend pg_stat_activity SELECT application_name FROM pg_catalog.pg_stat_activity; View pg_stat_activity Field application_name SQL type te… pg_stat_activity.backend_startStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityTime when this process was started. For client backends, this is the time the client connected to the server. pg_stat_activity SELECT backend_start FROM pg_catalog.pg_stat_activity; View pg… pg_stat_activity.backend_typeStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityType of current backend. Possible types are: archiver: The WAL archiver, active when archive_mode is enabled. autovacuum launcher: The background process that launches autovacuum workers, a… pg_stat_activity.backend_xidStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityTop-level transaction identifier of this backend, if any; see Section 67.1. pg_stat_activity Top-level transaction identifier of this backend, if any. SELECT backend_xid FROM pg_catalog.pg_… pg_stat_activity.backend_xminStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityThe current backend's xmin horizon. pg_stat_activity SELECT backend_xmin FROM pg_catalog.pg_stat_activity; View pg_stat_activity Field backend_xmin SQL type xid Units named in the field def… pg_stat_activity.client_addrStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityIP 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 interna… pg_stat_activity.client_hostnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityHost 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. pg_stat_ac… pg_stat_activity.client_portStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityTCP 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. pg… pg_stat_activity.datidStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityOID of the database this backend is connected to pg_stat_activity SELECT datid FROM pg_catalog.pg_stat_activity; View pg_stat_activity Field datid SQL type oid Units named in the field defi… pg_stat_activity.datnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityName of the database this backend is connected to pg_stat_activity SELECT datname FROM pg_catalog.pg_stat_activity; View pg_stat_activity Field datname SQL type name Units named in the fiel… pg_stat_activity.leader_pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityProcess 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 t… pg_stat_activity.pidStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityProcess ID of this backend pg_stat_activity SELECT pid FROM pg_catalog.pg_stat_activity; View pg_stat_activity Field pid SQL type integer Units named in the field definition Not specified R… pg_stat_activity.queryStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityText 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 qu… pg_stat_activity.query_idStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityIdentifier 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 quer… pg_stat_activity.query_startStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityTime when the currently active query was started, or if state is not active, when the last query was started pg_stat_activity SELECT query_start FROM pg_catalog.pg_stat_activity; View pg_st… pg_stat_activity.stateStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityCurrent 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 executi… pg_stat_activity.state_changeStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityTime when the state was last changed pg_stat_activity SELECT state_change FROM pg_catalog.pg_stat_activity; View pg_stat_activity Field state_change SQL type timestamp with time zone Units … pg_stat_activity.usenameStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityName of the user logged into this backend pg_stat_activity SELECT usename FROM pg_catalog.pg_stat_activity; View pg_stat_activity Field usename SQL type name Units named in the field defini… pg_stat_activity.usesysidStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityOID of the user logged into this backend pg_stat_activity SELECT usesysid FROM pg_catalog.pg_stat_activity; View pg_stat_activity Field usesysid SQL type oid Units named in the field defini… pg_stat_activity.wait_eventStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityWait event name if backend is currently waiting, otherwise NULL. See Table 27.5 through Table 27.13. pg_stat_activity Wait event name if backend is currently waiting, otherwise NULL. See Ta… pg_stat_activity.wait_event_typeStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityThe type of event for which the backend is waiting, if any; otherwise NULL. See Table 27.4. pg_stat_activity The type of event for which the backend is waiting, if any; otherwise NULL. Poss… pg_stat_activity.xact_startStatistics & MetricsWikiStatistics & Metrics · pg_stat_activityTime 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 co… pg_stat_all_indexes.idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_indexesNumber of index scans initiated on this index pg_stat_all_indexes SELECT idx_scan FROM pg_catalog.pg_stat_all_indexes; View pg_stat_all_indexes Field idx_scan SQL type bigint Units named in… pg_stat_all_indexes.idx_tup_fetchStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_indexesNumber of live table rows fetched by simple index scans using this index pg_stat_all_indexes SELECT idx_tup_fetch FROM pg_catalog.pg_stat_all_indexes; View pg_stat_all_indexes Field idx_tup… pg_stat_all_indexes.idx_tup_readStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_indexesNumber of index entries returned by scans on this index pg_stat_all_indexes SELECT idx_tup_read FROM pg_catalog.pg_stat_all_indexes; View pg_stat_all_indexes Field idx_tup_read SQL type big… pg_stat_all_indexes.indexrelidStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_indexesOID of this index pg_stat_all_indexes SELECT indexrelid FROM pg_catalog.pg_stat_all_indexes; View pg_stat_all_indexes Field indexrelid SQL type oid Units named in the field definition Not s… pg_stat_all_indexes.indexrelnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_indexesName of this index pg_stat_all_indexes SELECT indexrelname FROM pg_catalog.pg_stat_all_indexes; View pg_stat_all_indexes Field indexrelname SQL type name Units named in the field definition… pg_stat_all_indexes.last_idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_indexesThe time of the last scan on this index, based on the most recent transaction stop time pg_stat_all_indexes SELECT last_idx_scan FROM pg_catalog.pg_stat_all_indexes; View pg_stat_all_indexe… pg_stat_all_indexes.relidStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_indexesOID of the table for this index pg_stat_all_indexes SELECT relid FROM pg_catalog.pg_stat_all_indexes; View pg_stat_all_indexes Field relid SQL type oid Units named in the field definition N… pg_stat_all_indexes.relnameStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_indexesName of the table for this index pg_stat_all_indexes SELECT relname FROM pg_catalog.pg_stat_all_indexes; View pg_stat_all_indexes Field relname SQL type name Units named in the field defini… pg_stat_all_indexes.schemanameStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_indexesName of the schema this index is in pg_stat_all_indexes SELECT schemaname FROM pg_catalog.pg_stat_all_indexes; View pg_stat_all_indexes Field schemaname SQL type name Units named in the fie… pg_stat_all_indexes.stats_resetStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_indexesTime at which these statistics were last reset pg_stat_all_indexes SELECT stats_reset FROM pg_catalog.pg_stat_all_indexes; View pg_stat_all_indexes Field stats_reset SQL type timestamp with… pg_stat_all_tables.analyze_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesNumber of times this table has been manually analyzed pg_stat_all_tables SELECT analyze_count FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field analyze_count SQL type bigint… pg_stat_all_tables.autoanalyze_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesNumber of times this table has been analyzed by the autovacuum daemon pg_stat_all_tables SELECT autoanalyze_count FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field autoanaly… pg_stat_all_tables.autovacuum_countStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesNumber of times this table has been vacuumed by the autovacuum daemon pg_stat_all_tables SELECT autovacuum_count FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field autovacuum… pg_stat_all_tables.idx_scanStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesNumber of index scans initiated on this table pg_stat_all_tables SELECT idx_scan FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field idx_scan SQL type bigint Units named in th… pg_stat_all_tables.idx_tup_fetchStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesNumber of live rows fetched by index scans pg_stat_all_tables SELECT idx_tup_fetch FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field idx_tup_fetch SQL type bigint Units name… pg_stat_all_tables.last_analyzeStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesLast time at which this table was manually analyzed pg_stat_all_tables SELECT last_analyze FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field last_analyze SQL type timestamp … pg_stat_all_tables.last_autoanalyzeStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesLast time at which this table was analyzed by the autovacuum daemon pg_stat_all_tables SELECT last_autoanalyze FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field last_autoana… pg_stat_all_tables.last_autovacuumStatistics & MetricsWikiStatistics & Metrics · pg_stat_all_tablesLast time at which this table was vacuumed by the autovacuum daemon pg_stat_all_tables SELECT last_autovacuum FROM pg_catalog.pg_stat_all_tables; View pg_stat_all_tables Field last_autovacu…